Upskill for free · Practice & test yourself
Top 100 interview questions
For AI Product Management, Data Science & AI, and GenAI & Agents, with model answers and the lesson that teaches each topic.
01What is your favourite product and why?
“Google Maps for commuting. My job is ‘get to work on time with least stress.’ It works because (1) live traffic turns uncertainty into an ETA I trust, (2) it re-routes proactively, (3) it combines modes. A weakness for me: on crowded metro lines it doesn't tell me how full trains are, so I can't choose a less crowded one. I'd test showing crowding levels from anonymised, aggregated data, measuring route-choice changes and satisfaction, with privacy as a guardrail.”
Learn it: Product sense →
Learn it: Product sense →
02What makes a product great?
“A great product reliably helps a specific user make progress on an important job, with as little effort and risk as possible, in a way the business can sustain. Signals: users return without being pushed (retention curves flatten), they recommend it, and the economics improve with scale. Example: a payments flow that just works at checkout — invisible reliability is a feature.”
Learn it: Product sense →
Learn it: Product sense →
03Critique the onboarding of an app you used recently.
“A budgeting app asked for bank linking, notifications and goals before showing anything useful. Heuristic: visibility and user control — I had no idea what value I'd get. Biggest fix: show a sample dashboard immediately and ask for bank linking in context when I tap ‘see my spending’. Metric: activation (first budget created within 3 days); guardrails: permission grant rate, privacy complaints.”
Learn it: Product sense →
Learn it: Product sense →
04Which product do you think is badly designed, and how would you fix it?
“Many parking-payment apps: you must register, add a card and find a zone code while standing in the street. Constraint: municipalities require identification and payment records. Fix: a QR on the meter that opens a lightweight web flow with wallet payment, with optional account creation later. Trade-off: less data capture; mitigate with optional emailed receipts.”
Learn it: Product sense →
Learn it: Product sense →
05How would you improve YouTube Shorts?
“I'd focus on new viewers whose first Shorts feel irrelevant — they leave before personalisation kicks in. Ideas: a lightweight topic picker after the first few swipes; a ‘not interested’ that visibly teaches the feed; separation of short vs long results in search. I'd A/B the topic picker; primary: day-7 return rate of new viewers; guardrails: session-satisfaction surveys and time-spent spikes among younger users.”
Learn it: Product sense →
Learn it: Product sense →
06Should Netflix let users stop a title from leaving the catalogue?
“The need is real — losing a show mid-watch is frustrating — but licences expire contractually, so a ‘keep’ button is usually infeasible. Better: warn earlier (‘leaving in 14 days’), a ‘finish before it leaves’ row, and use the count of mid-watch members as a signal in licence negotiations.”
Learn it: Product sense →
Learn it: Product sense →
07What product would you build for elderly users to manage medicines?
“Start with a caregiver-set schedule and a very simple ‘taken’ confirmation (large button, voice option); missed-dose alerts to a caregiver after a grace period; pharmacy refill reminders. Avoid medical advice; partner with pharmacists for dose data. Metrics: doses confirmed on time; caregiver alerts resolved. Guardrails: false alarms, privacy consent.”
Learn it: Product sense →
Learn it: Product sense →
08What is a product you think will fail, and why?
“I'd question standalone AI gadgets that duplicate phone capabilities: the job (quick answers) is already served by phones; the device adds cost and charging burden; switching costs favour phones. It could succeed only if it serves a job phones do badly — hands-free contexts or accessibility. I'd watch day-30 retention and daily use versus phone usage.”
Learn it: Product sense →
Learn it: Product sense →
09Design a search engine for children under 14.
“Focus on 8–12-year-olds doing homework. Needs: readable results, trustworthy sources, no unsuitable content, parents' reassurance. Design: curated educational sources first, reading-level summaries, image search with strict filtering, ‘ask a grown-up’ prompts for sensitive topics, a parent dashboard with privacy-preserving summaries. Filtering is imperfect — don't promise complete safety; add a report button; no personalised ads. Metrics: task success (found an answer); parent trust score; guardrail: unsafe-content reports.”
Learn it: Product sense →
Learn it: Product sense →
10Help a professional regain control of an overflowing inbox after a holiday.
“Job: find what's urgent and relevant without reading everything. Design: a ‘Catch-up’ view grouped by people I work with, deadlines and mentions; AI thread summaries with links to originals; bulk actions with preview and undo. Risks: misclassifying an important email, wrongly auto-archiving, exposing confidential data to AI — keep human review for bulk actions, test accuracy, respect permissions. Metric: time to clear important items; guardrail: ‘missed important email’ reports.”
Learn it: Product sense →
Learn it: Product sense →
11Design a feature to reduce food-delivery checkout abandonment.
“First confirm where users drop — say, the payment step. If research shows fee surprise, show an estimated total in the cart with ‘est.’ labels, refresh on address change, and an honest ‘Estimate unavailable’ fallback if the fee service fails. A/B test with checkout completion as primary; complaints and payment errors as guardrails.” *(See Modules 5 and 7.)*
Learn it: Product sense →
Learn it: Product sense →
12Design a dating feature for a large social network.
“Segment by intention (serious vs casual). Core: opt-in profile separate from the main profile, verified identity, mutual-interest reveal, events-based matching. Safety: consent, harassment reporting, location fuzzing, age verification, no exposure of private conversations. Monetisation: freemium features that don't compromise safety (no paying to message strangers). Metric: mutual matches that lead to conversations; guardrails: reports per 1,000 users, blocks.”
Learn it: Product sense →
Learn it: Product sense →
13Design an ATM for the visually impaired.
“Audio guidance via a headphone jack, a tactile keypad with raised markers, phone-based pre-staging (set the withdrawal in the app, then tap card/phone), screen blanking for privacy, consistent layouts and generous timeouts. Test with visually impaired users; measure task success and time; guardrail: fraud and shoulder-surfing incidents.”
Learn it: Product sense →
Learn it: Product sense →
14Design a parking app for a busy city.
“Users: daily commuters vs occasional visitors. Jobs: find a spot quickly, pay easily, avoid fines. Features: live availability (sensors/partner garages), reserve and pay, extend remotely, reminders before expiry. Metrics: time to park, successful reservations, fine reduction (self-reported). Risks: inaccurate availability → show confidence levels.”
Learn it: Product sense →
Learn it: Product sense →
15Design a product to help small restaurants reduce food waste.
“Job: prepare and order the right quantities. Start with a simple demand forecast from past sales + weather + local events, giving suggested prep quantities; later add a marketplace for end-of-day surplus. Low integration first (POS export/CSV). Metrics: waste % by weight, margin; guardrail: stock-outs.”
Learn it: Product sense →
Learn it: Product sense →
16Design a feature to increase channel-creation quality in a team-chat tool.
“Suggest similar existing channels when someone types a new channel name; offer naming templates and pre-filled purposes; improve directory search. Primary metric: duplicate-channel rate; secondary: channel-message share. Randomise by workspace to avoid contamination.” *(See Case 7 and Project 3.)*
Learn it: Product sense →
Learn it: Product sense →
17Design an emergency feature for a ride-hailing app.
“Users: rider, driver, emergency contacts, safety operations. Features: an SOS button that shares live location with emergency services/contacts per local rules, trip sharing, unusual-stop detection with a check-in prompt, and a safety centre. Design for false positives without delaying urgent calls; offline/poor-network fallback (SMS). Metrics: time to response, check-in resolution; guardrails: false alarms, privacy.”
Learn it: Product sense →
Learn it: Product sense →
18Should a food-delivery company launch grocery delivery?
“It's product development in an existing market (Ansoff). Assets: customer base, courier network, app. Need: fast top-ups for urban households. Economics differ: lower AOV and margin, inventory and dark stores. I'd pilot in two dense neighbourhoods with a limited assortment, measure repeat rate, contribution per order and cannibalisation of food orders, and scale only if contribution turns positive within ~6 months.”
Learn it: Product strategy →
Learn it: Product strategy →
19How should a travel marketplace respond to a sudden collapse in travel (e.g., a pandemic)?
“Focus on demand that still exists — nearby getaways and long stays for remote workers; adapt search to flexible destinations and monthly stays; strengthen trust with cleaning standards and flexible cancellation; support hosts with clear refund rules. Measure booking recovery by segment, host retention and refund disputes.”
Learn it: Product strategy →
Learn it: Product strategy →
20How would you enter a new country with a fintech product?
“Scan regulation, payments infrastructure and trust (PESTLE); choose a beachhead segment; partner with a licensed local bank first rather than seeking a licence; localise language, KYC documents and payment methods; pilot in one city. Key risks: regulatory timelines and new fraud patterns. Metrics: activation, fraud rate, CAC payback.”
Learn it: Product strategy →
Learn it: Product strategy →
21A competitor launched a cheaper version of our product. What do you do?
“Don't react instantly. Check churn and win/loss by segment, interview switchers, and see whether price or features drive it. Options: hold price and sharpen value messaging; launch a lighter tier for price-sensitive users; bundle; raise switching value ethically. Choose based on margin impact and which segment matters strategically.”
Learn it: Product strategy →
Learn it: Product strategy →
22Should a music-streaming service expand into podcasts or audiobooks?
“Frame it as expanding from ‘music’ to ‘audio companionship’. Benefits: more listening time, differentiation, ad inventory. Costs: content and rights, discovery complexity. Strategy: invest in discovery and creator tools rather than only exclusives. Measure incremental listening time and retention, not catalogue size.”
Learn it: Product strategy →
Learn it: Product strategy →
23Build, buy or partner for identity verification?
“Buy or partner: identity verification is regulated and commodity-like, and speed matters. Keep control of the onboarding UX and data handling, check vendor compliance and uptime, build an abstraction layer to switch vendors, and revisit building only if scale economics or differentiation justify it.”
Learn it: Product strategy →
Learn it: Product strategy →
24What is the moat for a ride-hailing company?
“Local network effects (density cuts wait times), brand trust and safety record, data for pricing and ETAs, and driver relationships. Weaknesses: riders and drivers multi-home, and regulation. So the moat is local and must be continuously defended with reliability and driver economics.”
Learn it: Product strategy →
Learn it: Product strategy →
25How would you set a 3-year vision and strategy for a B2B SaaS product?
“Vision: the customer future (e.g., ‘every team closes the loop on decisions’). Strategy: win a beachhead, then adjacent segments; three product pillars; integrations as a platform; GTM from PLG to sales-assist; pricing evolution; an NSM with guardrails; explicit ‘won't do’ list. Validate yearly with retention, NRR and win/loss.”
Learn it: Product strategy →
Learn it: Product strategy →
26Your launch is slipping by three weeks. What do you do?
“Find out why — scope growth, a dependency or quality issues. Options: cut scope to keep the date, add people (rarely helps late), or move the date. Choose by cost of delay and quality risk. Tell stakeholders immediately with impact and the new plan; update the decision log.”
Learn it: Product strategy →
Learn it: Product strategy →
27How do you write good user stories and acceptance criteria?
“Stories describe user value: ‘As a first-time buyer, I want to see my estimated total in the cart so I can decide before paying.’ Criteria cover the happy path, edge cases, errors, accessibility and analytics events, in Given/When/Then form. I review them with engineering and QA before sprint planning.” *(Module 6.)*
Learn it: Product strategy →
Learn it: Product strategy →
28Engineering says a feature will take 3 months; leadership wants it in 1.
“Understand what drives the estimate; find the smallest valuable slice; defer non-essential risk behind a flag; present options (1-month slice, 3-month full) with trade-offs; never commit dates on engineers' behalf. If needed, escalate jointly with an options paper.”
Learn it: Product strategy →
Learn it: Product strategy →
29A production incident is causing payment failures. What is your role as PM?
“Engineering leads the fix. I quantify user and business impact, coordinate communications (support, status page, leadership), decide customer remediation (refunds, messaging), and ensure a blameless post-incident review whose prevention items get prioritised.” *(Extra topic 13: don't declare it over just because the dashboard looks better briefly.)*
Learn it: Product strategy →
Learn it: Product strategy →
30How do you decide when a feature is ready to launch?
“Acceptance criteria met; QA/UAT, performance, accessibility, security and privacy reviews done; tracking validated; support ready; rollout plan with flag and rollback owner; success and guardrail thresholds defined.”
Learn it: Product strategy →
Learn it: Product strategy →
31How do you manage dependencies across teams?
“Map dependencies with owners, dates and risks; agree interface contracts; track them on a shared board; sequence work to unblock the critical path; hold short syncs; escalate early with options when blocked.”
Learn it: Product strategy →
Learn it: Product strategy →
32What is the difference between Definition of Ready and Definition of Done?
“Ready = criteria a team may use before starting an item (clear, estimated, testable). Done = shared quality criteria for completed work (tested, reviewed, documented, deployed per team rules).” *(Lecture 22.)*
Learn it: Product strategy →
Learn it: Product strategy →
33After launch, adoption is low. What do you do?
“Check tracking; check exposure (did people even see it?); segment by user type; interview users who saw it but didn't use it; compare with the original hypothesis. Then improve onboarding or placement, iterate on value, or sunset. Low use alone isn't enough to remove a feature — persistent low value is.”
Learn it: Product strategy →
Learn it: Product strategy →
34What metrics would you track for a food-delivery app?
“North Star: completed, problem-free orders per active customer per month. Inputs: activation, order frequency, cart conversion, payment success, on-time delivery. Economics: AOV, contribution per order, CAC payback. Guardrails: refunds, complaints, cancellations.” *(Module 7.)*
Learn it: Analytics →
Learn it: Analytics →
35Define activation for a team-collaboration product.
“An event reflecting team value that predicts retention, e.g., ‘a workspace with ≥ 3 members exchanging messages in a channel within 7 days.’ Validate by comparing retention of activated vs not, then run an experiment to see whether helping teams reach it improves retention.”
Learn it: Analytics →
Learn it: Analytics →
36An A/B test shows +3% conversion with p = 0.04. Ship?
“Check: was this the pre-registered primary metric? Adequate power and full weeks? Any sample ratio mismatch? Guardrails flat? Does the low end of the confidence interval still justify the cost? Is there a novelty risk or a segment that reverses? If all good, ship with a holdout; if not, extend or rerun.”
Learn it: Analytics →
Learn it: Analytics →
37Explain p-value and confidence interval to a non-technical stakeholder.
“The p-value tells us how surprising our result would be if the change actually did nothing — small means unlikely to be pure chance. The confidence interval gives the range of effect sizes consistent with our data, like ‘between +1 and +4 points’. It's the range that matters for the business decision.”
Learn it: Analytics →
Learn it: Analytics →
38How would you calculate retention and what pitfalls exist?
“Group users by signup week; define ‘active’ as a meaningful action; retention in week k = active users in week k ÷ cohort size. Pitfalls: mixed definitions, small cohorts, survivorship bias, seasonality, counting any app open as active.”
Learn it: Analytics →
Learn it: Analytics →
39DAU grew 10% but revenue fell 5%. Explain possible reasons.
“Mix shift (new users are free or low spenders), pricing/promotion changes, payment failures, lower conversion of engaged users, refunds, or measurement changes. Decompose revenue = active users × payer conversion × ARPPU and check each component by segment and date.”
Learn it: Analytics →
Learn it: Analytics →
40Write SQL for conversion from checkout start to payment.
SELECT ROUND(100.0 * COUNT(DISTINCT CASE WHEN event_name='payment_success' THEN user_id END) / COUNT(DISTINCT CASE WHEN event_name='checkout_start' THEN user_id END), 1) AS pct FROM events;
Learn it: Analytics →
Learn it: Analytics →
41Correlation vs causation — give a product example.
“Users of feature X retain better, but power users may both use X and retain for other reasons (confounding). Test with a randomised experiment or a credible quasi-experiment. Simpson's paradox shows how an uneven traffic mix can reverse conclusions.”
Learn it: Analytics →
Learn it: Analytics →
42How would you measure the success of a recommendation system?
“Offline: precision/recall@k on historical data. Online: click-through and, more importantly, downstream outcomes (purchases, listening time, satisfaction) via A/B tests; diversity and novelty; long-term retention via holdout. Guardrails: complaints, returns, filter bubbles, creator/seller fairness.”
Learn it: Analytics →
Learn it: Analytics →
43What would you put on a PM dashboard for a new feature?
“Exposure (who saw it), adoption (who used it), the primary outcome, guardrails, segment cuts, release annotations, data freshness and metric definitions.”
Learn it: Analytics →
Learn it: Analytics →
44Estimate daily ride-hailing trips in a large Indian metro.
“Top-down: 20M population → 14M adults → 8% weekly users = 1.12M × 3 trips/week ≈ 480k/day. Bottom-up: 55,000 active drivers × 9 trips ≈ 495k/day. Range 450k–500k; sanity check ≈ 3.4% of adults ride daily.” *(Module 3; course Lecture 7 — practice figures, not company data.)*
Learn it: Analytics →
Learn it: Analytics →
45How many food-delivery orders happen per day in a city of 10 million?
“10M ÷ 4 = 2.5M households; 60% with smartphones in delivery zones = 1.5M; 30% order at least weekly = 450k; 2.5 orders/week = 1.125M/week ≈ 160k/day; +20% for offices/single residents ≈ 190k/day. Range 150k–250k. Supply check: 15,000 couriers × 12 orders/day = 180k ✓.”
Learn it: Analytics →
Learn it: Analytics →
46How many school lunches are bought daily at a 1,000-student school?
“1,000 × 60% at school × 50% buying = 300 lunches (course example). Discuss day-of-week and seasonal variation.”
Learn it: Analytics →
Learn it: Analytics →
47Estimate the annual revenue of a coffee chain with 200 outlets.
“400 cups/day × ₹220 average ticket = ₹88,000; + 25% food ≈ ₹1.1 lakh/day; × 360 days ≈ ₹3.96 crore per outlet; × 200 ≈ ₹790 crore/year. Range ₹600–950 crore.”
Learn it: Analytics →
Learn it: Analytics →
48How many smartphones are sold in India per year?
“Assume ~700M users; ~3-year replacement → ~230M; + ~15M new users ≈ 245M; −30% for second-hand and multi-device effects ≈ 170M new devices (range 140–190M). Check against industry reports in real life.”
Learn it: Analytics →
Learn it: Analytics →
49Estimate yearly image storage for a messaging app.
“100M DAU × 20% sending × 5 images × 0.2 MB = 20 TB/day ≈ 7.3 PB/year before replication; ×3 replication ≈ 22 PB. Retention and deletion policies matter.”
Learn it: Analytics →
Learn it: Analytics →
50How many EV chargers does a city need?
“Example: 100,000 EVs × 40% without home charging × 2 sessions/week = 80,000 sessions/week; one fast charger can handle ~10 sessions/day ≈ 70/week → ~1,150 chargers; add 30% for peaks and geography ≈ 1,500 (range 1,200–2,000).”
Learn it: Analytics →
Learn it: Analytics →
51Estimate the number of piano tuners in a city.
“A city of 5M with 2M households; 2% with pianos = 40,000 + 2,000 institutional; tuned once a year = 42,000 tunings; a tuner does ~4/day × 250 days = 1,000/year → about 40–45 tuners.”
Learn it: Analytics →
Learn it: Analytics →
52Daily orders dropped 15% yesterday. What do you do?
“First confirm it's real — did order *events* fall but the orders table didn't? Compare with the same day last week. Segment by platform, city, new/returning, payment method and restaurant. If only Android in one city dropped, check the latest release and payment-gateway logs there. Rank hypotheses by likelihood × impact and check the cheapest first.” *(Lecture 22: ask exactly which metric fell before an RCA.)*
Learn it: Analytics →
Learn it: Analytics →
53The app-store rating fell from 4.4 to 4.1. Why?
“Tag reviews by date and app version; correlate with releases; check crash rates; check whether a policy change (e.g., fees) triggered anger; check whether rating prompts changed (sampling bias). Fix the top cause and monitor.”
Learn it: Analytics →
Learn it: Analytics →
54Sign-ups up 20%, activation down 8 points. Explain.
“Likely mix shift — a new channel bringing lower-intent users; or an onboarding change; or a change to the activation event's tracking; or a bug for one segment. If a new channel explains it, the funnel isn't broken — the traffic is different, and channel ROI should be judged on activated users.”
Learn it: Analytics →
Learn it: Analytics →
55Session length increased but retention decreased. Is that good?
“Not necessarily. Users may be struggling (tasks taking longer), or a minority binges while others leave. Check task success, segment by cohort, look at satisfaction and support tickets.”
Learn it: Analytics →
Learn it: Analytics →
56Ride cancellations spiked in one city.
“Check drivers online vs demand, local events or weather, pricing changes, driver-app bugs, ETA accuracy and payment-mode mismatches; segment by time and area; talk to operations.”
Learn it: Analytics →
Learn it: Analytics →
57Payment success rate fell from 95% to 91%.
“Split by card/UPI/wallet, issuer/bank, error code and app version; check the gateway status and recent changes (3-D Secure flow, SDK update); contact the provider; mitigate with routing or retries; communicate with support.”
Learn it: Analytics →
Learn it: Analytics →
58In a community product, group creation is down. Diagnose.
“Define the metric (new groups that become active?), check measurement, segment by country, platform and entry point; examine discovery changes, spam/moderation enforcement changes, and competition. Test hypotheses with data and interviews.” *(Course Lecture 36 case — hypotheses, not facts about any company.)*
Learn it: Analytics →
Learn it: Analytics →
59Customer complaints doubled after a redesign.
“Tag complaints to flows; run a quick usability test on the new design; check for accessibility regressions; consider rollback or targeted fixes; compare task success before and after.”
Learn it: Analytics →
Learn it: Analytics →
60Which prioritisation frameworks do you use?
“It depends on the decision: RICE for comparable features, MoSCoW for release scope, WSJF when timing matters, Kano for customer expectations, weighted scoring for strategic bets. I always add a sensitivity check and dependencies, and take mandatory work first.”
Learn it: Prioritization →
Learn it: Prioritization →
61You have 10 feature requests and capacity for 3. Walk me through it.
“Clarify the goal; group requests by underlying problem (often 10 requests are 4 problems); size reach and impact with data; get effort estimates from engineering; score with RICE; check dependencies, risks and strategy; pick three; tell requesters what's not happening and why, with a review date.”
Learn it: Prioritization →
Learn it: Prioritization →
62Compute RICE: reach 5,000, impact 2, confidence 50%, effort 2.
“5,000 × 2 × 0.5 ÷ 2 = 2,500. I'd confirm reach is per quarter and consider a cheap test to raise confidence before committing two person-months.”
Learn it: Prioritization →
Learn it: Prioritization →
63Tech debt vs new features: how do you decide?
“Quantify tech debt's cost — incident frequency, slower delivery, error rates, features blocked. Reserve baseline capacity for reliability, and treat large debt items as investments with expected outcomes (e.g., halve checkout incidents). If SLOs are breached and the error budget is spent, reliability work takes priority.”
Learn it: Prioritization →
Learn it: Prioritization →
64A big customer threatens to churn unless you build X.
“Understand the need and the ARR at risk; check how many other customers need it; explore workarounds, smaller scope or a timeline; compare with the cost of delaying displaced work; decide with leadership, avoiding one-off features that fragment the product.”
Learn it: Prioritization →
Learn it: Prioritization →
65How do you prioritise bugs?
“Rank by severity (impact on users, data, money, safety) × frequency × reach; security and data-loss bugs first; agree SLAs per severity; batch low-severity fixes; track escaped defects to improve testing.”
Learn it: Prioritization →
Learn it: Prioritization →
66How do you decide what goes into an MVP?
“Identify the riskiest assumption; define what we need to learn and the success threshold; include only what's needed to test it safely; label what's simulated; plan the decision the result will drive. An MVP is not the same as a prototype or a public launch.”
Learn it: Prioritization →
Learn it: Prioritization →
67What is an API? Explain to a non-technical person.
“An API is like a restaurant menu and waiter: it lists what you can ask for, you place a request in a standard format, and the kitchen sends back the dish — or an error if it's unavailable. Apps use APIs to ask other systems for data or actions, like a weather app requesting today's forecast.”
Learn it: Prioritization →
Learn it: Prioritization →
68What happens when you type a URL and press Enter?
“DNS resolves the name to an IP; the browser opens a TCP connection and TLS handshake; sends an HTTP request that may be served by a CDN or reach a load balancer and app servers, which query databases or services; the response returns with a status code; the browser renders and fetches assets.” *(Module 9.)*
Learn it: Prioritization →
Learn it: Prioritization →
69REST vs GraphQL — when would you choose each?
“REST for simple, cacheable resource APIs and public integrations; GraphQL for complex UIs that need flexible data from many sources in one request. Consider caching, rate limiting and query-cost control.”
Learn it: Prioritization →
Learn it: Prioritization →
70SQL vs NoSQL for an orders system?
“Relational (SQL) for orders and payments — transactions and consistency matter. NoSQL can suit catalogues or event logs at huge scale. Choose by access pattern and consistency needs, not fashion.”
Learn it: Prioritization →
Learn it: Prioritization →
71Design a notification system.
“Producers publish events to a queue; a notification service applies preferences, frequency caps, templates and quiet hours; channel providers (push/SMS/email) deliver; receipts flow back. Add dedup, retries with back-off and fallbacks for critical messages; respect consent; measure delivery, opt-outs and complaints.” *(Module 9.)*
Learn it: Prioritization →
Learn it: Prioritization →
72How do you prevent double charges when a payment request is retried?
“Send an idempotency key with each charge so retries return the original result; dedupe webhooks by event ID; reconcile with the provider daily; show ‘payment pending’ honestly when status is unknown.”
Learn it: Prioritization →
Learn it: Prioritization →
73Authentication vs authorisation?
“Authentication is who you are (login, OTP, passkeys); authorisation is what you're allowed to do (roles, scopes). A logged-in user is authenticated but still not authorised to see another user's order — the API should return 403 (or 404 to avoid revealing it exists).”
Learn it: Prioritization →
Learn it: Prioritization →
74API p95 latency doubled. How do you approach it as a PM?
“Confirm which endpoints and regions; correlate with releases and traffic; check dependencies (DB, third parties); quantify user impact (conversion by latency bucket); work with engineering on mitigation (rollback, cache, scale); communicate; run a post-incident review.”
Learn it: Prioritization →
Learn it: Prioritization →
75Explain your product's architecture in an interview.
“Walk the core journey through each component, say where failures happen and how we handle them, and separate what I decided (fallbacks, events, SLAs) from what engineering owned.” *(Lectures 30 and 52: distinguish knowledge from assumptions; protect sensitive details.)*
Learn it: Prioritization →
Learn it: Prioritization →
76When should you NOT use AI for a feature?
“When a simple rule or search works reliably; when errors are costly and can't be caught; when we lack authorised data; when latency or cost exceeds the value; when we can't evaluate quality. Always compare with a non-AI baseline.”
Learn it: Prioritization →
Learn it: Prioritization →
77Explain RAG vs fine-tuning.
“RAG retrieves current, permitted knowledge at answer time — good for facts, citations and fast updates. Fine-tuning adjusts behaviour or format using training examples — good for consistent style or specialised tasks. Neither guarantees truth; they can be combined.” *(Module 10.)*
Learn it: Prioritization →
Learn it: Prioritization →
78How would you evaluate an LLM-powered support bot before launch?
“Build a curated eval set (common, edge, adversarial, escalation cases); score correctness, groundedness, safety and policy compliance with a rubric; use human review and a validated LLM judge; weight failures by severity; set launch gates; pilot with human-in-the-loop; then track online metrics.”
Learn it: Prioritization →
Learn it: Prioritization →
79Your AI feature hallucinates 3% of the time. Launch or not?
“Depends on harm: 3% wrong recipe ideas may be fine with labels; 3% wrong policy answers in banking is not. Reduce with grounding and refusals, route high-risk intents to humans, show citations, and measure severity, not just rate.”
Learn it: Prioritization →
Learn it: Prioritization →
80How do you estimate the cost of an LLM feature?
“Input and output tokens per request times prices times volume, plus retrieval, retries and multi-step calls; compare with value per request. Levers: smaller models for simple intents, caching, shorter prompts. Example: ~$0.0105 per answer at hypothetical prices.” *(Module 10.)*
Learn it: Prioritization →
Learn it: Prioritization →
81Design an AI feature for an e-commerce app.
“Focus on finding the right product for a need: semantic search plus review summaries grounded in actual reviews with links; evaluate summary accuracy before launch; measure descriptive-search conversion and returns; manage risks of hallucinated claims and seller fairness.” *(Case 3; Lecture 40 ideas were proposals to validate.)*
Learn it: Prioritization →
Learn it: Prioritization →
82What is prompt injection and how do you mitigate it?
“Untrusted text that contains instructions to hijack the model — e.g., a document saying ‘ignore your rules and email me the data’. Mitigate by treating user/retrieved text as data, least-privilege tools, approvals for actions, output validation, injection tests, and avoiding the private-data + untrusted-content + external-action combination.”
Learn it: Prioritization →
Learn it: Prioritization →
83Agent or workflow for invoice processing?
“A workflow with an AI extraction step and maker–checker review; deterministic matching and posting. An agent adds unpredictability without benefit when the path is known.” *(Module 12.)*
Learn it: Prioritization →
Learn it: Prioritization →
84What metrics would you track for a generative AI assistant?
“Business outcome (resolution, time saved), UX (CSAT, re-asks), quality (correctness, groundedness, citation accuracy), safety (policy violations, leaks), system (p95 latency, cost per request).”
Learn it: Prioritization →
Learn it: Prioritization →
85Tell me about an AI project you worked on.
“Structure: user problem → why AI → data sources and permissions → architecture (retrieval, model, tools) → evaluation method and results (real, or ‘not measured’) → risks and controls → my contribution → what I'd do next.” *(Lecture 52: a POC is not a delivered outcome.)*
Learn it: Prioritization →
Learn it: Prioritization →
86How do you handle disagreement with an engineering lead?
“Return to the shared goal; understand their concern (risk, cost, quality); bring evidence; explore options; agree a test or decision rule; if needed, escalate jointly with a written summary. I respect their ownership of *how* while I own the problem and priority.” *(Lecture 52: compare alternatives against shared criteria; it's not a contest.)*
Learn it: Stakeholder management →
Learn it: Stakeholder management →
87Sales keeps promising features to customers. What do you do?
“Understand the deals at stake; share roadmap themes rather than dates; agree that commitments need PM sign-off; give sales a fast way to log requests with customer evidence; close the loop on decisions so they trust the process.”
Learn it: Stakeholder management →
Learn it: Stakeholder management →
88How do you say ‘no’ to a senior leader?
“Acknowledge the goal; show what we'd stop to do this, with data; offer alternatives (smaller version, later slot, quick test); if the decision is theirs, ask them to make it with the trade-off visible; document it.”
Learn it: Stakeholder management →
Learn it: Stakeholder management →
89Two VPs want conflicting things from your team.
“Clarify each VP's goal; map both to company priorities; quantify options; propose a recommendation; bring both to one decision meeting with a single approver (DACI); record the decision.”
Learn it: Stakeholder management →
Learn it: Stakeholder management →
90How do you keep stakeholders informed without overwhelming them?
“Stakeholder map; tiered communications — a weekly one-pager for leadership, channel updates for partners, release notes for the wider organisation; and early warnings on risks.”
Learn it: Stakeholder management →
Learn it: Stakeholder management →
91How do you work with designers?
“Bring problems and evidence, not solutions; involve designers in discovery; agree success metrics; give specific, user-centred feedback; protect time for edge states and accessibility; decide together what to test.” *(Module 5.)*
Learn it: Stakeholder management →
Learn it: Stakeholder management →
92How do you handle a stakeholder who keeps changing requirements?
“Understand why (new information or an unclear goal); agree a change process with a decision log and impact assessment; timebox discovery to settle unknowns; protect the current sprint's scope; renegotiate dates transparently.”
Learn it: Stakeholder management →
Learn it: Stakeholder management →
93Why product management?
“Connect a real pattern from your work — noticing customer problems, coordinating teams, using data — to what PMs do; show you understand the hard parts (trade-offs, saying no, ambiguity); and tie it to this product.”
Learn it: Stakeholder management →
Learn it: Stakeholder management →
94How do you set a vision for your team?
“Describe a customer-centred future state, tied to company strategy, co-created with the team; translate it into strategy, outcomes and a roadmap; revisit it when evidence changes.”
Learn it: Stakeholder management →
Learn it: Stakeholder management →
95How do you build an outcome-focused culture in a feature-factory organisation?
“Start with one team and one outcome, show results, change rituals (review outcomes, not outputs), introduce OKRs with guardrails, share learnings including failures, and enlist an executive sponsor.”
Learn it: Stakeholder management →
Learn it: Stakeholder management →
96How do you develop junior PMs?
“Set clear expectations; give ownership of a problem area; regular SBI feedback; pair on discovery and stakeholder meetings; review their writing; grow scope gradually.”
Learn it: Stakeholder management →
Learn it: Stakeholder management →
97How do you make a high-stakes, irreversible decision?
“Separate reversible from irreversible decisions; gather diverse input; quantify scenarios; run a pre-mortem; set decision criteria in advance; decide; communicate the rationale; define checkpoints.”
Learn it: Stakeholder management →
Learn it: Stakeholder management →
98Your team is burnt out before a critical launch.
“Cut scope, adjust the date if possible, remove distractions, rotate on-call, be honest with leadership about trade-offs, and run a planning retro afterwards.”
Learn it: Stakeholder management →
Learn it: Stakeholder management →
99What would you do in your first 90 days as a PM here?
“Days 1–30: learn users, data, team, strategy and stakeholders. Days 31–60: identify the top problem and a quick win; build relationships and rituals. Days 61–90: propose an outcome-based plan, deliver one improvement, share learnings.”
Learn it: Stakeholder management →
Learn it: Stakeholder management →
100How would you decide whether to build an AI feature at all?
Start from a user problem and its value; check that AI is better than rules or UX fixes, that data and quality are achievable, that errors are acceptable or reviewable, and that cost per use fits the business model; then prototype and test with users.
Learn it: Extra →
Learn it: Extra →
01What is the difference between a formula and a function?
A formula is any expression that starts with
Learn it: Advanced Excel →
= (for example =A2*B2). A function is a named, built-in calculation used inside formulas (for example SUM, VLOOKUP). Every function is used in a formula, but not every formula uses a function.Learn it: Advanced Excel →
02How does Excel store dates, and why does it matter?
As serial numbers (days since 1-Jan-1900; times are fractions of a day). It means you can subtract dates to get durations, add days to a date, and sort dates correctly. If a date is stored as text, none of that works.
Learn it: Advanced Excel →
Learn it: Advanced Excel →
03What makes data "analysis-ready"?
One header row, one record per row, one data type per column, no blank rows or merged cells, no subtotals mixed into the data, and consistent spelling of categories.
Learn it: Advanced Excel →
Learn it: Advanced Excel →
04How would you stop users from entering invalid data in a shared tracker?
Use Data Validation (drop-down lists from a Table, number and date limits, custom formulas for uniqueness), add input messages, set error alerts to Stop, and protect the sheet so the rules cannot be removed. Check older data with Circle Invalid Data.
Learn it: Advanced Excel →
Learn it: Advanced Excel →
05How do you remove duplicates without losing information?
First flag them with
Learn it: Advanced Excel →
COUNTIF or conditional formatting and review which record to keep; decide the key columns that define a duplicate; work on a copy; then use Remove Duplicates (or UNIQUE) on those columns.Learn it: Advanced Excel →
06What is the difference between TRIM and CLEAN?
TRIM removes extra spaces; CLEAN removes non-printing characters such as line breaks. Web data often needs both, plus
Learn it: Advanced Excel →
SUBSTITUTE(…,CHAR(160)," ") for non-breaking spaces.Learn it: Advanced Excel →
07What is the difference between formatting a number and rounding it?
Formatting changes only how the value looks; the full value is used in calculations.
Learn it: Advanced Excel →
ROUND changes the stored value. Use ROUND when the rounded figure must flow into other calculations, such as invoices.Learn it: Advanced Excel →
08How would you highlight the top 10% of customers by revenue?
Conditional Formatting → Top/Bottom Rules → Top 10% (change 10 to any value), or a formula rule
Learn it: Advanced Excel →
=C2>=PERCENTILE.INC($C$2:$C$500,0.9) for more control.Learn it: Advanced Excel →
09Why might a conditional format highlight the wrong rows?
The formula was written for a different starting row than the active cell of the selection, or the
Learn it: Advanced Excel →
$ signs are wrong.Learn it: Advanced Excel →
10What is the difference between COUNT, COUNTA and COUNTBLANK?
COUNT counts numeric cells, COUNTA counts every non-empty cell (including text and formulas returning ""), COUNTBLANK counts empty cells and cells containing "".
Learn it: Advanced Excel →
Learn it: Advanced Excel →
11When would you use a mixed reference?
When a formula is copied in two directions and must keep either the row or the column fixed, for example a price × quantity grid or a commission table:
Learn it: Advanced Excel →
=$A2*B$1.Learn it: Advanced Excel →
12Why use SUMIFS instead of SUMIF?
SUMIFS supports multiple conditions, has a consistent argument order (sum range first), and works for one condition too, so one pattern covers every case.
Learn it: Advanced Excel →
Learn it: Advanced Excel →
13How do you total only visible rows after filtering?
Use
Learn it: Advanced Excel →
SUBTOTAL(109, range) or AGGREGATE(9, 5, range); the Table Total Row does this automatically.Learn it: Advanced Excel →
14Difference between FIND and SEARCH?
FIND is case-sensitive and does not allow wildcards; SEARCH is not case-sensitive and supports
Learn it: Advanced Excel →
* and ?. Both return #VALUE! when the text is not found.Learn it: Advanced Excel →
15How would you extract the domain from an email address?
16Nested IF or IFS?
IFS for readability when testing several conditions in order; SWITCH for exact matches of one value; a lookup table when the mapping is long or changes often.
Learn it: Advanced Excel →
Learn it: Advanced Excel →
17How would you get a list of unique values in Excel?
UNIQUE in Microsoft 365; otherwise Remove Duplicates on a copy, Advanced Filter with "Unique records only", or a pivot table.Learn it: Advanced Excel →
18Explain AND/OR logic in FILTER or SUMPRODUCT.
Each condition becomes an array of TRUE/FALSE. Multiplying arrays gives 1 only when all are TRUE (AND); adding gives at least 1 when any is TRUE (OR).
Learn it: Advanced Excel →
Learn it: Advanced Excel →
19How do you sort by a custom order such as High, Medium, Low?
Sort dialog → Order → Custom List, and add the list; or use
Learn it: Advanced Excel →
SORTBY with MATCH(range,{"High","Medium","Low"},0) as the sort key.Learn it: Advanced Excel →
20What are the limitations of VLOOKUP and how do you overcome them?
It cannot look left, it defaults to approximate match, it breaks when columns are inserted (hard-coded index), and it returns only the first match. Use XLOOKUP or INDEX + MATCH, and FILTER for multiple matches.
Learn it: Advanced Excel →
Learn it: Advanced Excel →
21Why is INDEX + MATCH considered more flexible than VLOOKUP?
The lookup and return ranges are separate, so it can look left, it is not affected by inserted columns, it supports two-way lookups, and it can be faster on large sheets because it only reads the columns it needs.
Learn it: Advanced Excel →
Learn it: Advanced Excel →
22How would you look up a value using two criteria?
XLOOKUP(1,(range1=x)*(range2=y),return_range), INDEX/MATCH with the same multiplied condition, or a helper column that concatenates the two keys.Learn it: Advanced Excel →
23What is a pivot cache and why does it matter?
A hidden copy of the source data that pivots read from. It makes pivots fast and lets several pivots share data, but pivots only update on refresh, and many separate caches make files large.
Learn it: Advanced Excel →
Learn it: Advanced Excel →
24How do you show each item's share of the total in a pivot?
Value Field Settings → Show Values As → % of Grand Total (or % of Column/Row Total).
Learn it: Advanced Excel →
Learn it: Advanced Excel →
25How would you count unique customers in a pivot?
Create the pivot with "Add this data to the Data Model" ticked, then choose Distinct Count in Value Field Settings.
Learn it: Advanced Excel →
Learn it: Advanced Excel →
26When would you use formulas (SUMIFS) instead of a pivot?
When the report needs a fixed layout, mixes data from several sources, or must update without refreshing; pivots are better for exploration and flexible summaries.
Learn it: Advanced Excel →
Learn it: Advanced Excel →
27How does Excel store dates and times?
Dates as serial numbers counting days from 1-Jan-1900; times as fractions of a day. This makes arithmetic, sorting and formatting consistent.
Learn it: Advanced Excel →
Learn it: Advanced Excel →
28How do you count working days between two dates excluding holidays?
NETWORKDAYS(start, end, holidays) or NETWORKDAYS.INTL with a custom weekend code.Learn it: Advanced Excel →
29What is a dynamic named range and when do you need one?
A name whose range grows with the data, built with an Excel Table,
Learn it: Advanced Excel →
INDEX/COUNTA or OFFSET/COUNTA. It keeps charts, validation lists and formulas current as data is added.Learn it: Advanced Excel →
30How do you choose a chart type?
From the question: comparison, trend, composition, relationship, distribution or contribution. Then simplify: remove clutter, highlight the key point and write an insight title.
Learn it: Advanced Excel →
Learn it: Advanced Excel →
31What is a Pareto analysis used for?
To find the vital few causes (products, customers, complaint types) that produce most of the effect, so that effort is focused where it matters.
Learn it: Advanced Excel →
Learn it: Advanced Excel →
32How would you show actual vs target for 10 sales reps?
A bar chart of actuals with a target marker (a line or a thin overlapping bar per rep), or a bullet chart; a thermometer works for one overall target.
Learn it: Advanced Excel →
Learn it: Advanced Excel →
33Walk me through how you would build an Excel dashboard.
Clarify the audience and questions; define KPIs; clean and structure the data as a Table; create one pivot per visual; build pivot charts; connect slicers and a timeline; add KPI cards with GETPIVOTDATA; design the layout; validate numbers against the source; protect and share.
Learn it: Advanced Excel →
Learn it: Advanced Excel →
34How do you make sure dashboard numbers are correct?
Reconcile totals with the raw data (SUM vs pivot), test filters, check distinct counts, use Evaluate Formula and trace precedents for KPI formulas, and have a second person review.
Learn it: Advanced Excel →
Learn it: Advanced Excel →
35Excel dashboard or Power BI?
Excel for small data, quick turnaround and audiences who live in Excel; Power BI for larger data, many users, scheduled refresh, row-level security and richer interactivity.
Learn it: Advanced Excel →
Learn it: Advanced Excel →
36What is Power Query and why use it?
Excel's (and Power BI's) ETL tool. It connects to many sources, applies recorded, repeatable transformations (types, splits, merges, unpivot, grouping) and refreshes with one click, which reduces manual errors.
Learn it: Advanced Excel →
Learn it: Advanced Excel →
37What is the difference between Merge and Append?
Merge adds columns from another table by matching keys (a join); Append adds rows from tables with the same structure (a union).
Learn it: Advanced Excel →
Learn it: Advanced Excel →
38What is the Data Model and when do you need it?
An in-memory columnar database inside Excel for related tables and large data. Use it when you have several tables, need distinct counts, or exceed normal sheet limits; it also supports DAX measures.
Learn it: Advanced Excel →
Learn it: Advanced Excel →
39How would you find the break-even price?
Build the profit formula and use Goal Seek to set profit to 0 by changing price, or solve algebraically: price = variable cost + fixed costs ÷ units.
Learn it: Advanced Excel →
Learn it: Advanced Excel →
40Mean vs median: when do you report each?
Median for skewed data or outliers (income, house prices, delivery times); mean for symmetric data or when totals matter.
Learn it: Statistics & Machine Learning →
Learn it: Statistics & Machine Learning →
41What does a standard deviation of 0 mean?
All values are identical.
Learn it: Statistics & Machine Learning →
Learn it: Statistics & Machine Learning →
42Correlation is 0. Are the variables independent?
Not necessarily: Pearson only captures linear relationships; a perfect U-shape can have r = 0.
Learn it: Statistics & Machine Learning →
Learn it: Statistics & Machine Learning →
43Explain Bayes' theorem with an example.
It updates a prior probability with new evidence. For a rare disease with an accurate test, a positive result can still be more likely a false positive because healthy people vastly outnumber sick ones.
Learn it: Statistics & Machine Learning →
Learn it: Statistics & Machine Learning →
44When would you use a Poisson distribution?
For counts of independent events in a fixed time or space with a constant average rate, such as orders per minute, defects per batch or calls per hour.
Learn it: Statistics & Machine Learning →
Learn it: Statistics & Machine Learning →
45What is the difference between pdf and cdf?
The pdf gives density at a point (probability for discrete pmf); the cdf gives the cumulative probability P(X ≤ x).
Learn it: Statistics & Machine Learning →
Learn it: Statistics & Machine Learning →
46Explain the Central Limit Theorem to a non-technical manager.
If we average enough randomly chosen customers, those averages behave predictably (a bell curve) even when individual spending is wildly uneven, so we can say how confident we are in an average.
Learn it: Statistics & Machine Learning →
Learn it: Statistics & Machine Learning →
47What is the difference between standard deviation and standard error?
Standard deviation measures spread of individual values; standard error measures spread of a statistic (like the mean) across samples: SE = sd/√n.
Learn it: Statistics & Machine Learning →
Learn it: Statistics & Machine Learning →
48How would you choose a sample size for a survey?
Decide the margin of error and confidence level, estimate variability (use p = 0.5 for proportions if unknown), compute n, then inflate for expected non-response.
Learn it: Statistics & Machine Learning →
Learn it: Statistics & Machine Learning →
49Explain a p-value to a business stakeholder.
If there were truly no difference, how surprising would our data be? A p-value of 0.01 means a result this extreme would happen only 1% of the time by chance alone.
Learn it: Statistics & Machine Learning →
Learn it: Statistics & Machine Learning →
50What is the difference between statistical and practical significance?
Statistical significance says an effect is unlikely to be zero; practical significance asks whether it is large enough to matter (effect size, cost, revenue).
Learn it: Statistics & Machine Learning →
Learn it: Statistics & Machine Learning →
51How do you choose α?
By the cost of errors: 0.05 by convention; lower (0.01) when false positives are expensive (medical, financial launches); sometimes higher for early exploration.
Learn it: Statistics & Machine Learning →
Learn it: Statistics & Machine Learning →
52When would you use a non-parametric test?
Small samples that are clearly non-normal, ordinal data (ratings), or heavy outliers; for large samples the CLT usually makes parametric tests fine.
Learn it: Statistics & Machine Learning →
Learn it: Statistics & Machine Learning →
53What does a chi-square test tell you and what does it not?
Whether two categorical variables are associated; not the direction, strength (use Cramér's V) or causation.
Learn it: Statistics & Machine Learning →
Learn it: Statistics & Machine Learning →
54Explain ANOVA's F-statistic.
The ratio of variation between group means to variation within groups; large values mean group differences exceed what noise explains.
Learn it: Statistics & Machine Learning →
Learn it: Statistics & Machine Learning →
55How would you design an A/B test for a new recommendation widget?
State the hypothesis and primary metric (e.g. revenue per user), guardrails (latency, returns), randomise by user, size it with power analysis, run full weeks, check SRM, analyse with CIs, and decide with business impact.
Learn it: Statistics & Machine Learning →
Learn it: Statistics & Machine Learning →
56Your test is significant on day 3. Do you stop?
No: stopping early inflates false positives and novelty effects can fade; finish the planned duration or use a sequential design.
Learn it: Statistics & Machine Learning →
Learn it: Statistics & Machine Learning →
57What if you cannot randomise?
Use quasi-experimental methods: difference-in-differences with a comparison group, synthetic control, regression discontinuity or matching, and state the assumptions.
Learn it: Statistics & Machine Learning →
Learn it: Statistics & Machine Learning →
58Explain machine learning to a non-technical person.
Instead of writing rules ourselves, we show the computer many past examples with the right answers, and it learns patterns it can apply to new cases, like an employee learning from experience.
Learn it: Statistics & Machine Learning →
Learn it: Statistics & Machine Learning →
59Supervised vs unsupervised learning?
Supervised learning uses labelled examples to predict a target; unsupervised learning finds structure such as groups or compressed representations without labels.
Learn it: Statistics & Machine Learning →
Learn it: Statistics & Machine Learning →
60How do you start an ML project?
Clarify the business decision and success metric, define the target and prediction time, check data availability and leakage, set a simple baseline, then iterate on models.
Learn it: Statistics & Machine Learning →
Learn it: Statistics & Machine Learning →
61Why do we need a train/test split?
To estimate how the model performs on new, unseen data; training performance is optimistic because the model has seen those examples.
Learn it: Statistics & Machine Learning →
Learn it: Statistics & Machine Learning →
62What is a pipeline and why use one?
A chain of preprocessing steps and a model trained and applied as one object; it prevents leakage, simplifies tuning and makes deployment reliable.
Learn it: Statistics & Machine Learning →
Learn it: Statistics & Machine Learning →
63What is the difference between fit_transform and transform?
fit_transform learns parameters (e.g. mean, categories) and applies them, used on training data; transform applies already-learned parameters, used on validation, test and new data.Learn it: Statistics & Machine Learning →
64How do you handle categorical variables with 1,000 levels?
Target encoding (cross-fitted), frequency encoding, grouping rare levels into "Other", hashing, or learned embeddings; tree-based libraries like CatBoost handle them natively.
Learn it: Statistics & Machine Learning →
Learn it: Statistics & Machine Learning →
65Normalisation vs standardisation?
Normalisation (min-max) rescales to 0–1; standardisation centres to mean 0 and sd 1. Use standardisation by default; min-max for bounded inputs.
Learn it: Statistics & Machine Learning →
Learn it: Statistics & Machine Learning →
66Give an example of a feature you engineered that helped.
Use STAR: e.g. "days since last purchase" and "spend in the last 30 days vs previous 30" for churn, which raised recall in the top decile from X to Y.
Learn it: Statistics & Machine Learning →
Learn it: Statistics & Machine Learning →
67What are the assumptions of linear regression?
Linearity, independence of errors, normality of residuals (for inference), equal variance of residuals, and no perfect multicollinearity.
Learn it: Statistics & Machine Learning →
Learn it: Statistics & Machine Learning →
68R² vs adjusted R²?
R² never decreases when you add features; adjusted R² penalises the number of features, so it can drop when a feature adds little.
Learn it: Statistics & Machine Learning →
Learn it: Statistics & Machine Learning →
69How do you interpret a coefficient in a log-log model?
As an elasticity: a 1% change in x is associated with a β% change in y.
Learn it: Statistics & Machine Learning →
Learn it: Statistics & Machine Learning →
70Explain gradient descent intuitively.
Start with random weights, compute how wrong the model is, find the direction that reduces the error fastest (the negative gradient), take a small step, and repeat until the error stops falling.
Learn it: Statistics & Machine Learning →
Learn it: Statistics & Machine Learning →
71Batch vs stochastic gradient descent?
Batch uses all data per step (stable, slow); stochastic uses one example (fast, noisy); mini-batch is the practical compromise.
Learn it: Statistics & Machine Learning →
Learn it: Statistics & Machine Learning →
72Can gradient descent get stuck?
For convex costs like linear and logistic regression there is one global minimum. For neural networks it can land in local minima or saddle points; momentum, Adam and random restarts help.
Learn it: Statistics & Machine Learning →
Learn it: Statistics & Machine Learning →
73Explain the bias-variance trade-off.
Simple models have high bias (systematic error) and low variance; complex models have low bias but high variance (sensitivity to the training sample). We choose complexity that minimises total error on new data.
Learn it: Statistics & Machine Learning →
Learn it: Statistics & Machine Learning →
74L1 vs L2 regularisation?
L2 shrinks coefficients towards zero and handles correlated features; L1 can set coefficients exactly to zero, selecting features; Elastic Net combines both.
Learn it: Statistics & Machine Learning →
Learn it: Statistics & Machine Learning →
75How do you detect overfitting?
Compare training and validation/test performance (large gap), use cross-validation, and inspect learning curves.
Learn it: Statistics & Machine Learning →
Learn it: Statistics & Machine Learning →
76Why is it called regression if it classifies?
It regresses the log-odds on the features; classification happens when you apply a threshold to the predicted probability.
Learn it: Statistics & Machine Learning →
Learn it: Statistics & Machine Learning →
77How do you interpret a logistic regression coefficient?
A one-unit increase in the feature changes the log-odds by β, i.e. multiplies the odds by e^β, holding other features constant.
Learn it: Statistics & Machine Learning →
Learn it: Statistics & Machine Learning →
78What are the assumptions of logistic regression?
Independent observations, a linear relationship between features and log-odds, little multicollinearity, no extreme outliers, and enough events per variable.
Learn it: Statistics & Machine Learning →
Learn it: Statistics & Machine Learning →
79Precision vs recall: give an example where each matters more.
Recall for disease screening or fraud (missing a case is costly); precision for spam filtering or expensive manual reviews (false alarms are costly).
Learn it: Statistics & Machine Learning →
Learn it: Statistics & Machine Learning →
80Why can a model with 95% accuracy be bad?
With 95% negatives, predicting all negatives gives 95% accuracy and catches no positives; look at recall, precision, PR-AUC and the confusion matrix.
Learn it: Statistics & Machine Learning →
Learn it: Statistics & Machine Learning →
81How do you choose a classification threshold?
From business costs and constraints: expected profit, team capacity (top-k), or a required recall/precision, validated on held-out data.
Learn it: Statistics & Machine Learning →
Learn it: Statistics & Machine Learning →
82Explain k-fold cross-validation.
Split the training data into k folds; train on k − 1 and validate on the remaining one, k times; average the scores. It uses all data for both training and validation and reduces variance of the estimate.
Learn it: Statistics & Machine Learning →
Learn it: Statistics & Machine Learning →
83Grid search vs random search vs Bayesian optimisation?
Grid tries every combination (exhaustive, expensive); random samples combinations (efficient in high dimensions); Bayesian optimisation models the score surface to choose promising settings next.
Learn it: Statistics & Machine Learning →
Learn it: Statistics & Machine Learning →
84How would you validate a churn model that will score customers monthly?
Time-based validation: train on earlier months and validate on later months, mimicking deployment; also group by customer to avoid leakage.
Learn it: Statistics & Machine Learning →
Learn it: Statistics & Machine Learning →
85How does KNN work and how do you choose k?
It finds the k closest training points by a distance metric and votes or averages; choose k (and weighting, metric) by cross-validation, balancing overfitting (small k) and oversmoothing (large k).
Learn it: Statistics & Machine Learning →
Learn it: Statistics & Machine Learning →
86What are the disadvantages of KNN?
Slow and memory-heavy predictions, sensitivity to scaling and irrelevant features, poor performance in high dimensions, and imbalanced classes skew votes.
Learn it: Statistics & Machine Learning →
Learn it: Statistics & Machine Learning →
87How would you speed up nearest-neighbour search on millions of points?
KD-trees or ball trees for low dimensions, and approximate nearest-neighbour indexes (HNSW, FAISS, ScaNN) for high-dimensional embeddings.
Learn it: Statistics & Machine Learning →
Learn it: Statistics & Machine Learning →
88How does a decision tree choose a split?
It evaluates candidate thresholds on every feature and picks the one with the largest impurity reduction (Gini or entropy for classification, variance for regression), then repeats recursively.
Learn it: Statistics & Machine Learning →
Learn it: Statistics & Machine Learning →
89Gini vs entropy?
Both measure impurity and usually give similar trees; Gini is slightly faster, entropy comes from information theory.
Learn it: Statistics & Machine Learning →
Learn it: Statistics & Machine Learning →
90How do you prevent a tree from overfitting?
Limit depth, require minimum samples per leaf/split, cap leaves, prune with cost-complexity, or use ensembles.
Learn it: Statistics & Machine Learning →
Learn it: Statistics & Machine Learning →
91How does a random forest reduce overfitting compared with a single tree?
Each tree sees a different bootstrap sample and random feature subsets, so trees make different errors; averaging them reduces variance while keeping low bias.
Learn it: Statistics & Machine Learning →
Learn it: Statistics & Machine Learning →
92Bagging vs boosting?
Bagging trains models independently in parallel on bootstrap samples and averages them (reduces variance); boosting trains models sequentially, each correcting the previous errors (reduces bias).
Learn it: Statistics & Machine Learning →
Learn it: Statistics & Machine Learning →
93How do you get feature importance from a random forest, and what is the caveat?
Impurity-based importance from training splits (biased toward high-cardinality features) or permutation importance on held-out data (more reliable); neither shows the direction of the effect.
Learn it: Statistics & Machine Learning →
Learn it: Statistics & Machine Learning →
94Explain gradient boosting in simple terms.
Start with a simple prediction, look at the errors, train a small tree to predict those errors, add a fraction of it, and repeat; the ensemble gradually corrects itself.
Learn it: Statistics & Machine Learning →
Learn it: Statistics & Machine Learning →
95XGBoost vs LightGBM vs random forest?
Random forests average independent deep trees (robust, little tuning); XGBoost and LightGBM build trees sequentially with regularisation and histogram speed-ups; LightGBM grows leaf-wise and is usually fastest on large data.
Learn it: Statistics & Machine Learning →
Learn it: Statistics & Machine Learning →
96How do you prevent overfitting in boosting?
Lower learning rate with early stopping, shallow trees, minimum leaf size, row and column subsampling, and L1/L2 regularisation.
Learn it: Statistics & Machine Learning →
Learn it: Statistics & Machine Learning →
97Explain the kernel trick.
It lets an algorithm that depends only on dot products work in a high-dimensional feature space by computing a similarity function (kernel) directly in the original space.
Learn it: Statistics & Machine Learning →
Learn it: Statistics & Machine Learning →
98SVM vs logistic regression?
Both can learn linear boundaries; logistic regression gives probabilities and optimises log loss; SVMs maximise the margin with hinge loss and extend to non-linear boundaries with kernels, but scale worse to large datasets.
Learn it: Statistics & Machine Learning →
Learn it: Statistics & Machine Learning →
99Why does Naive Bayes work well for spam detection despite its assumption?
Classification only needs the correct class to have the highest score; with many weakly informative words, the independence errors largely cancel out, and the model is fast and robust with little data.
Learn it: Statistics & Machine Learning →
Learn it: Statistics & Machine Learning →
100How do you handle imbalanced classes?
Use suitable metrics (PR-AUC, recall at precision), stratified validation, class weights or resampling inside the pipeline, strong models (boosting), and a business-driven threshold; collect more positive examples if possible.
Learn it: Statistics & Machine Learning →
Learn it: Statistics & Machine Learning →
01Explain an API to a non-technical stakeholder.
It is a menu and a waiter: the menu (documentation) lists what you can ask for, you place an order (request), and the kitchen (server) returns your dish (response) or a reason it cannot.
Learn it: AI Agents, MCP & APIs for PMs and BAs →
Learn it: AI Agents, MCP & APIs for PMs and BAs →
02REST vs webhooks?
REST is request-response: you ask when you want data. Webhooks are event notifications: the other system calls you when something happens.
Learn it: AI Agents, MCP & APIs for PMs and BAs →
Learn it: AI Agents, MCP & APIs for PMs and BAs →
03What would you check before committing to a third-party API?
Coverage of the needed endpoints, authentication, rate limits and pricing, uptime/SLA and status page, webhooks, sandbox, data residency and privacy, versioning and deprecation policy, and support.
Learn it: AI Agents, MCP & APIs for PMs and BAs →
Learn it: AI Agents, MCP & APIs for PMs and BAs →
04How do you write acceptance criteria for an integration?
Specify the trigger, the exact data mapping, success latency, error handling and retries, duplicates, logging, and measurable pass conditions in test and production.
Learn it: AI Agents, MCP & APIs for PMs and BAs →
Learn it: AI Agents, MCP & APIs for PMs and BAs →
05What is OpenAPI?
A standard machine-readable description of a REST API (endpoints, parameters, schemas) used to generate docs, test pages, SDKs and tool definitions for AI agents.
Learn it: AI Agents, MCP & APIs for PMs and BAs →
Learn it: AI Agents, MCP & APIs for PMs and BAs →
06What is MCP and why does it matter for product teams?
An open protocol that lets AI assistants use tools and data through standard servers. It shortens integration work, lets one connector serve many AI apps and gives a consistent permission model, so teams can safely add AI to existing workflows.
Learn it: AI Agents, MCP & APIs for PMs and BAs →
Learn it: AI Agents, MCP & APIs for PMs and BAs →
07Tools vs resources vs prompts?
Tools are actions the model invokes; resources are data the app attaches as context; prompts are reusable templates exposed by the server.
Learn it: AI Agents, MCP & APIs for PMs and BAs →
Learn it: AI Agents, MCP & APIs for PMs and BAs →
08How would you roll out MCP connectors in an enterprise?
Start with read-only connectors for internal knowledge, admin-approved servers only, SSO/OAuth, logging, human approval on write actions, a red-team test for prompt injection, and a clear data policy; then expand by use case.
Learn it: AI Agents, MCP & APIs for PMs and BAs →
Learn it: AI Agents, MCP & APIs for PMs and BAs →
09MCP vs a plain API?
An API is a system's interface; an MCP server wraps APIs into tools with descriptions and schemas that AI models can discover and call consistently across hosts.
Learn it: AI Agents, MCP & APIs for PMs and BAs →
Learn it: AI Agents, MCP & APIs for PMs and BAs →
10How do you measure the success of an AI integration?
Task completion rate, time saved per workflow, error and override rate, adoption, and incidents, compared with the manual baseline.
Learn it: AI Agents, MCP & APIs for PMs and BAs →
Learn it: AI Agents, MCP & APIs for PMs and BAs →
11When would you not use an agent?
When the steps are fixed, accuracy must be deterministic, latency or cost is tight, or the action is high risk without a review step. A workflow, rules or a form is simpler and more reliable.
Learn it: AI Agents, MCP & APIs for PMs and BAs →
Learn it: AI Agents, MCP & APIs for PMs and BAs →
12How do you design human-in-the-loop for an agent?
Classify actions by risk; auto-run read-only and low-risk actions; require approval for writes that affect customers, money or data; show the agent's reasoning and proposed action; log decisions; and feed overrides into evaluation.
Learn it: AI Agents, MCP & APIs for PMs and BAs →
Learn it: AI Agents, MCP & APIs for PMs and BAs →
13What metrics would you track for an AI support agent?
Resolution and deflection rate, escalation accuracy, CSAT, handling time, cost per conversation, safety incidents and the percentage of answers with correct sources.
Learn it: AI Agents, MCP & APIs for PMs and BAs →
Learn it: AI Agents, MCP & APIs for PMs and BAs →
14Single agent or multi-agent?
Start with one agent and good tools; split into specialists only when tasks are clearly separable or the context gets too large, because coordination adds cost and failure modes.
Learn it: AI Agents, MCP & APIs for PMs and BAs →
Learn it: AI Agents, MCP & APIs for PMs and BAs →
15How do you write a good tool description?
Say exactly when to use the tool, what each parameter means with allowed values, what it returns, and when not to use it; then test with realistic prompts.
Learn it: AI Agents, MCP & APIs for PMs and BAs →
Learn it: AI Agents, MCP & APIs for PMs and BAs →
16How would you decide between Zapier, Make and n8n for a client?
By team skills, volume and cost model, need for self-hosting and code, complexity of branching, required apps, and governance. Prototype the riskiest step on the shortlisted tool.
Learn it: AI Agents, MCP & APIs for PMs and BAs →
Learn it: AI Agents, MCP & APIs for PMs and BAs →
17How do you make AI steps in automations reliable?
Structured JSON output with a schema, validation and retries, deterministic settings, small focused prompts, fallbacks, human review for high-impact outputs, and monitoring of error rates.
Learn it: AI Agents, MCP & APIs for PMs and BAs →
Learn it: AI Agents, MCP & APIs for PMs and BAs →
18What goes into an integration's documentation?
Owner, purpose, trigger, systems and endpoints, data mapping, error handling and alerts, credentials and scopes, cost, and a test checklist.
Learn it: AI Agents, MCP & APIs for PMs and BAs →
Learn it: AI Agents, MCP & APIs for PMs and BAs →
19How can Claude help a BA who does not code?
It turns requirements into flows and mappings, writes formulas and small code steps, explains API docs and error logs, and generates test data and acceptance criteria.
Learn it: AI Agents, MCP & APIs for PMs and BAs →
Learn it: AI Agents, MCP & APIs for PMs and BAs →
20What risks come with letting AI act in business systems?
Wrong or duplicate actions, data leakage, prompt injection, cost overruns and unclear accountability; mitigate with scopes, approvals, validation, logs and budgets.
Learn it: AI Agents, MCP & APIs for PMs and BAs →
Learn it: AI Agents, MCP & APIs for PMs and BAs →
21How do you keep an AI coding agent safe in a real codebase?
Permissions and allowlists, plan mode for big changes, branches and PR reviews, tests in CI, no secrets in context, hooks that block sensitive files, and least-privilege MCP servers.
Learn it: AI Agents, MCP & APIs for PMs and BAs →
Learn it: AI Agents, MCP & APIs for PMs and BAs →
22How would a PM use Claude Code?
Prototype features, answer "how does it work today" questions from the codebase, analyse data, write scripts that automate reporting, and review changes in plain language.
Learn it: AI Agents, MCP & APIs for PMs and BAs →
Learn it: AI Agents, MCP & APIs for PMs and BAs →
23Subagents vs Skills?
Subagents are separate agents with their own context and tools for delegated tasks; Skills are packaged instructions and scripts that the main agent loads when a task needs them.
Learn it: AI Agents, MCP & APIs for PMs and BAs →
Learn it: AI Agents, MCP & APIs for PMs and BAs →
24What is headless mode used for?
Running Claude Code non-interactively from scripts, scheduled jobs and CI, with structured output.
Learn it: AI Agents, MCP & APIs for PMs and BAs →
Learn it: AI Agents, MCP & APIs for PMs and BAs →
25How do you measure the impact of AI coding tools on a team?
Lead time for changes, PR throughput and review time, defect and rollback rates, test coverage, and developer satisfaction, compared with a baseline.
Learn it: AI Agents, MCP & APIs for PMs and BAs →
Learn it: AI Agents, MCP & APIs for PMs and BAs →
26How would you launch a voice agent for customer support?
Pick a narrow, high-volume use case; design the conversation, knowledge and tools; set transfer rules; test with scripted and real calls; launch to a small share of calls; monitor containment, CSAT and errors; iterate weekly.
Learn it: AI Agents, MCP & APIs for PMs and BAs →
Learn it: AI Agents, MCP & APIs for PMs and BAs →
27Speech-to-speech model or a pipeline?
Speech-to-speech gives the lowest latency and natural prosody; a pipeline gives more control over each component, language choices, and tool use. Many teams start with a platform that manages the pipeline.
Learn it: AI Agents, MCP & APIs for PMs and BAs →
Learn it: AI Agents, MCP & APIs for PMs and BAs →
28What are the risks of voice cloning?
Impersonation and fraud, consent and IP issues, regulatory problems with undisclosed AI calls, and reputational damage; mitigate with consent, verification, disclosure and watermarking.
Learn it: AI Agents, MCP & APIs for PMs and BAs →
Learn it: AI Agents, MCP & APIs for PMs and BAs →
29How do you support Indian languages?
Choose STT and TTS that handle Hindi, Hinglish and regional languages, test accents, allow code-switching, and keep prompts and knowledge in the caller's language.
Learn it: AI Agents, MCP & APIs for PMs and BAs →
Learn it: AI Agents, MCP & APIs for PMs and BAs →
30What is the business case for a voice agent?
Cost per resolved call vs human agents, 24x7 availability, faster answer times, conversion uplift, minus platform, telephony and maintenance costs, with quality guardrails.
Learn it: AI Agents, MCP & APIs for PMs and BAs →
Learn it: AI Agents, MCP & APIs for PMs and BAs →
31Difference between AI, ML and generative AI?
AI is the broad field; ML learns patterns from data to predict or classify; generative AI (a deep-learning subset) creates new content such as text, code and images.
Learn it: AI for Data Analysis →
Learn it: AI for Data Analysis →
32What is a hallucination and how do you reduce it?
Confident but false output. Reduce it by grounding answers in provided documents or data (RAG), using tools that compute results, lowering temperature, asking for sources and assumptions, and verifying independently.
Learn it: AI for Data Analysis →
Learn it: AI for Data Analysis →
33How do you write a good prompt for a data task?
State the role, context (schema, grain, definitions), a single clear task, the required output format, and constraints (use only given data, state assumptions); give examples; iterate.
Learn it: AI for Data Analysis →
Learn it: AI for Data Analysis →
34What is agentic AI?
Systems where an LLM plans and executes multi-step tasks using tools, observes results and continues until a goal is met, with human oversight for risky actions.
Learn it: AI for Data Analysis →
Learn it: AI for Data Analysis →
35How would you use AI to speed up SQL work safely?
Provide schema, definitions and dialect; generate and explain queries; review for grain, filters and definitions; run read-only with limits; reconcile totals; keep verified queries in a library.
Learn it: AI for Data Analysis →
Learn it: AI for Data Analysis →
36What is Docker and why is it useful for data tools?
A container platform that packages apps with their dependencies so the same setup runs anywhere; useful to spin up Metabase, databases or Jupyter in one command and share reproducible environments.
Learn it: AI for Data Analysis →
Learn it: AI for Data Analysis →
37What are the risks of connecting an AI assistant to a database?
Data exposure to a model provider, destructive queries, wrong answers presented as facts, and prompt injection; mitigate with read-only access to curated views, masking, review and logging.
Learn it: AI for Data Analysis →
Learn it: AI for Data Analysis →
38What is Metabase?
An open-source BI tool where users can ask questions with a visual builder or SQL, build dashboards and share them, with permission control by group.
Learn it: AI for Data Analysis →
Learn it: AI for Data Analysis →
39How would you use AI tools to speed up Excel analysis responsibly?
Prepare structured data, ask specific questions, review generated formulas and pivots, reconcile totals, document assumptions, keep sensitive data out of unapproved tools, and keep a human sign-off.
Learn it: AI for Data Analysis →
Learn it: AI for Data Analysis →
40What is Python in Excel?
A feature that runs Python (pandas, matplotlib, scikit-learn) in cells via
Learn it: AI for Data Analysis →
=PY(), in a secure cloud, reading Excel ranges with xl(), useful for analysis and charts that are hard with formulas.Learn it: AI for Data Analysis →
41What is an AI agent in an office context and what are its risks?
A system that plans and executes multi-step tasks using apps and files; risks include wrong actions, data leakage, prompt injection and lack of audit; mitigate with scoped permissions, approvals, copies and logs.
Learn it: AI for Data Analysis →
Learn it: AI for Data Analysis →
42How do you check an AI-generated formula?
Test on a few rows including edge cases, compare totals with a simple independent calculation, read the formula's explanation, and make sure references and units are right.
Learn it: AI for Data Analysis →
Learn it: AI for Data Analysis →
43Walk me through how you use AI in your analysis workflow.
I frame the decision, give the AI a clear brief with schema and definitions, use it to draft and explain SQL or Python, run everything myself, reconcile totals and cross-check with a second method, use AI for chart and narrative drafts, then I validate each number and take responsibility for the recommendation.
Learn it: AI for Data Analysis →
Learn it: AI for Data Analysis →
44What is an AI agent and how is it different from a chatbot?
A chatbot responds once to a prompt; an agent pursues a goal across multiple steps by calling tools, observing results and deciding what to do next, so it needs stronger guardrails and evaluation.
Learn it: AI for Data Analysis →
Learn it: AI for Data Analysis →
45How do you stop an AI analytics tool from giving wrong numbers?
Governed semantic layer, read-only access to curated data, golden-question tests, execution-based evaluation, human review of important outputs, and logging.
Learn it: AI for Data Analysis →
Learn it: AI for Data Analysis →
46A model says "contract type drives churn". What do you say?
The data shows an association; to claim causation we would need an experiment or a causal method, controlling for tenure and other factors.
Learn it: AI for Data Analysis →
Learn it: AI for Data Analysis →
47Explain how ChatGPT or Claude works to a business audience.
It is a model trained on vast text to predict the next word-piece; that teaches it language and knowledge. Further training with example conversations and human feedback makes it follow instructions helpfully and safely. It does not look things up unless connected to tools or documents.
Learn it: Generative AI & Agentic AI →
Learn it: Generative AI & Agentic AI →
48What is a context window?
The maximum number of tokens (prompt, history, documents, output) the model can consider in one request.
Learn it: Generative AI & Agentic AI →
Learn it: Generative AI & Agentic AI →
49How do you reduce hallucinations in a business application?
Retrieval-augmented generation with citations, tool use for facts and numbers, instructions to say "I don't know", structured outputs with validation, evaluation sets and human review for high-stakes outputs.
Learn it: Generative AI & Agentic AI →
Learn it: Generative AI & Agentic AI →
50How do you make an LLM output reliable enough for production?
Specific prompts with examples, structured outputs with schema validation, low randomness, retries on validation failure, grounding in provided data, evaluation sets, and monitoring.
Learn it: Generative AI & Agentic AI →
Learn it: Generative AI & Agentic AI →
51What is prompt injection and how do you mitigate it?
User-supplied or retrieved text that tries to override instructions. Mitigate by separating data from instructions, limiting tool permissions, validating outputs, filtering inputs, and never letting the model take irreversible actions without checks.
Learn it: Generative AI & Agentic AI →
Learn it: Generative AI & Agentic AI →
52Zero-shot vs few-shot prompting?
Zero-shot gives only instructions; few-shot adds worked examples, which usually improves consistency on format and edge cases.
Learn it: Generative AI & Agentic AI →
Learn it: Generative AI & Agentic AI →
53How would you estimate the cost of an LLM feature?
Requests per day × (input tokens × input price + output tokens × output price), measured on real samples with token counting, then reduced with model choice, caching, batching and shorter outputs.
Learn it: Generative AI & Agentic AI →
Learn it: Generative AI & Agentic AI →
54How do you make LLM API calls robust?
Timeouts, retries with exponential backoff for 429/5xx, validation of outputs, checking stop reasons, fallbacks (another model or a rule), idempotent processing and logging.
Learn it: Generative AI & Agentic AI →
Learn it: Generative AI & Agentic AI →
55How do you keep a long chatbot conversation within budget?
Trim or summarise older turns, cache the stable system prompt, retrieve only relevant documents, and cap output length.
Learn it: Generative AI & Agentic AI →
Learn it: Generative AI & Agentic AI →
56What is an embedding and how is it used in search?
A dense vector representing meaning. Documents are embedded once and stored; a query is embedded at search time, and the nearest document vectors (by cosine similarity) are returned, often combined with keyword search.
Learn it: Generative AI & Agentic AI →
Learn it: Generative AI & Agentic AI →
57How does HNSW work at a high level?
It builds a layered graph where each vector links to near neighbours; search starts at a coarse top layer and greedily moves closer to the query through lower layers, visiting only a small part of the data.
Learn it: Generative AI & Agentic AI →
Learn it: Generative AI & Agentic AI →
58How do you evaluate a semantic search system?
A labelled set of queries with relevant documents; measure recall@k, precision@k, MRR or nDCG, plus latency and cost, and compare keyword, vector and hybrid configurations.
Learn it: Generative AI & Agentic AI →
Learn it: Generative AI & Agentic AI →
59Explain RAG and when you would use it instead of fine-tuning.
RAG retrieves relevant documents at question time and has the model answer from them; use it when knowledge is large, private or changing and you need citations. Fine-tuning suits behaviour, style or format, not frequently updated facts.
Learn it: Generative AI & Agentic AI →
Learn it: Generative AI & Agentic AI →
60How do you evaluate a RAG system?
Separately: retrieval (hit rate, MRR, recall on labelled questions) and generation (correctness, faithfulness to sources, citation accuracy, abstention), plus latency and cost; use human review and LLM judges calibrated against humans.
Learn it: Generative AI & Agentic AI →
Learn it: Generative AI & Agentic AI →
61Your RAG bot gives wrong answers. How do you debug it?
Inspect retrieved chunks for failing questions: if the right chunk is missing, fix chunking, retrieval or query rewriting; if present but the answer is wrong, re-rank, reduce noise, and tighten the prompt; add the cases to the test set.
Learn it: Generative AI & Agentic AI →
Learn it: Generative AI & Agentic AI →
62How does function calling work?
You describe tools with JSON schemas; the model returns a structured tool call instead of text when it needs one; your code executes it and sends the result back; the model continues until it can answer.
Learn it: Generative AI & Agentic AI →
Learn it: Generative AI & Agentic AI →
63How do you stop an LLM agent from doing something harmful with tools?
Least-privilege credentials, input validation and allow-lists, amount/rate limits, human approval for side effects, sandboxing, audit logs, and treating retrieved content as untrusted data.
Learn it: Generative AI & Agentic AI →
Learn it: Generative AI & Agentic AI →
64Tool use vs RAG?
RAG retrieves text to read; tool use performs computations or actions and fetches live structured data. Many assistants combine both, with retrieval itself exposed as a tool.
Learn it: Generative AI & Agentic AI →
Learn it: Generative AI & Agentic AI →
65What is agentic AI and how is it different from generative AI?
Generative AI produces content in response to a prompt; agentic AI uses models in a loop with tools and memory to pursue a goal across multiple steps, deciding what to do next.
Learn it: Generative AI & Agentic AI →
Learn it: Generative AI & Agentic AI →
66How would you design a reliable agent for business reporting?
Narrow tools with read-only data access, a planning step, required tool-sourced numbers, an automated checker, human approval before distribution, step and cost limits, tracing, and an evaluation suite of past questions.
Learn it: Generative AI & Agentic AI →
Learn it: Generative AI & Agentic AI →
67When would you not use an agent?
When a fixed workflow or single call solves the task, when errors are costly and hard to detect, or when latency and cost budgets are tight.
Learn it: Generative AI & Agentic AI →
Learn it: Generative AI & Agentic AI →
68Explain MCP and why it matters.
An open protocol that standardises how AI assistants discover and call external tools and read data. Organisations build a server once and make internal systems available to any compliant assistant, with consistent security and governance.
Learn it: Generative AI & Agentic AI →
Learn it: Generative AI & Agentic AI →
69Tools vs resources in MCP?
Tools perform actions or computations and are chosen by the model; resources are read-only data the application or user attaches as context.
Learn it: Generative AI & Agentic AI →
Learn it: Generative AI & Agentic AI →
70What are the main security risks of MCP and how do you mitigate them?
Untrusted servers, tool poisoning, prompt injection via returned content, and over-privileged credentials; mitigate with vetted servers, least privilege, OAuth, user approval for side effects, input validation and audit logging.
Learn it: Generative AI & Agentic AI →
Learn it: Generative AI & Agentic AI →
71How do you evaluate a generative AI application?
Define success criteria per task; build a representative and adversarial test set; use automated metrics where possible (exact match, execution accuracy, schema validity), rubric-based human or LLM-judge scores for open text, calibrate judges against humans, and run regressions on every change plus production monitoring.
Learn it: Generative AI & Agentic AI →
Learn it: Generative AI & Agentic AI →
72What guardrails would you put on a customer-facing chatbot?
Input checks (length, scope, PII, injection), retrieval restricted to approved content, least-privilege tools with approval for refunds or account changes, output validation (schema, policy, grounded facts), refusal handling, logging with PII redaction, and human escalation.
Learn it: Generative AI & Agentic AI →
Learn it: Generative AI & Agentic AI →
73What is prompt injection and why is it hard to solve completely?
Instructions hidden in user or retrieved content that hijack the model. Models process instructions and data in the same channel, so filters can be evaded; robust systems limit what a compromised model can do.
Learn it: Generative AI & Agentic AI →
Learn it: Generative AI & Agentic AI →
74RAG or fine-tuning?
RAG for knowledge that changes or needs citations; fine-tuning for consistent behaviour, format, tone or narrow tasks at scale. They combine well: a fine-tuned model can still use RAG.
Learn it: Generative AI & Agentic AI →
Learn it: Generative AI & Agentic AI →
75Explain LoRA in one minute.
Instead of updating a huge weight matrix, LoRA learns two small matrices whose product approximates the needed change; the original weights stay frozen, so training is cheap and adapters are small and swappable.
Learn it: Generative AI & Agentic AI →
Learn it: Generative AI & Agentic AI →
76How would you decide between an API model and a self-hosted model?
Evaluate quality on the task, total monthly cost including engineering, latency, data-privacy and residency requirements, licence terms and the team's ability to operate GPUs.
Learn it: Generative AI & Agentic AI →
Learn it: Generative AI & Agentic AI →
77How would you build a "chat with your data" tool safely?
Curated read-only views with documented columns and metric definitions, schema-aware prompts, guarded execution with timeouts and row limits, show the SQL and results to the user, evaluate with a gold question set, log queries, and route ambiguous questions to analysts.
Learn it: Generative AI & Agentic AI →
Learn it: Generative AI & Agentic AI →
78What are the risks of AI-generated analysis code?
Silent logic errors, wrong joins and definitions, security issues, and data leakage to external tools; mitigate with tests, reconciliation checks, code review and approved tools.
Learn it: Generative AI & Agentic AI →
Learn it: Generative AI & Agentic AI →
79How can LLMs help with data cleaning?
Normalising categories and entity names, extracting structured fields from text, detecting anomalies in descriptions, and generating cleaning code, always with validation against allowed values and source data.
Learn it: Generative AI & Agentic AI →
Learn it: Generative AI & Agentic AI →
80How would you take an LLM prototype to production?
Add evaluation and regression tests, guardrails, authentication and rate limits, observability, cost and latency budgets, privacy compliance, gradual rollout with monitoring, and clear human escalation.
Learn it: Generative AI & Agentic AI →
Learn it: Generative AI & Agentic AI →
81How do you control the cost of a chatbot?
Model routing, prompt caching, concise retrieval, output limits, summarised history, batching offline work and dashboards with alerts on cost per conversation.
Learn it: Generative AI & Agentic AI →
Learn it: Generative AI & Agentic AI →
82What would you monitor after launch?
Quality (feedback, judge scores), safety (guardrail hits, refusals), cost, latency, errors and drift in user questions.
Learn it: Generative AI & Agentic AI →
Learn it: Generative AI & Agentic AI →
83How do you keep designs consistent across a large product?
A shared library of components with variants and properties, styles and variables (tokens) with modes, documentation pages, and Dev Mode / Code Connect so code uses the same tokens.
Learn it: AI & No-Code Tools Lab →
Learn it: AI & No-Code Tools Lab →
84Auto layout vs constraints?
Auto layout arranges children in a flow (direction, gap, padding, hug/fill), like flexbox; constraints pin a layer to its parent's edges when the parent is resized, for frames without auto layout.
Learn it: AI & No-Code Tools Lab →
Learn it: AI & No-Code Tools Lab →
85How do you use Figma as a PM or analyst?
Wireframe flows and dashboards, run FigJam workshops, review prototypes with users before building, comment on designs, and prototype quickly with Figma Make.
Learn it: AI & No-Code Tools Lab →
Learn it: AI & No-Code Tools Lab →
86n8n vs Zapier vs Make?
Zapier is the simplest for app-to-app automations; Make adds visual branching and data mapping; n8n adds self-hosting, full code steps, sub-workflows and strong AI-agent features, which suits data and AI teams.
Learn it: AI & No-Code Tools Lab →
Learn it: AI & No-Code Tools Lab →
87How do you make an automation reliable?
Retries with backoff, error branches and an error workflow with alerts, idempotent steps (check before creating), rate-limit batching, logging executions, separate test and production, and secrets in credentials.
Learn it: AI & No-Code Tools Lab →
Learn it: AI & No-Code Tools Lab →
88How would you build a support bot on company documents in n8n?
An indexing workflow that loads documents, splits them, embeds them and stores them in a vector store; a chat workflow with Chat Trigger, an AI Agent with a chat model, memory and the vector store as a retrieval tool, with sources in answers and a human-handover path.
Learn it: AI & No-Code Tools Lab →
Learn it: AI & No-Code Tools Lab →
89When should you NOT use AI for a feature?
“When a simple rule or search works reliably; when errors are costly and can't be caught; when we lack authorised data; when latency or cost exceeds the value; when we can't evaluate quality. Always compare with a non-AI baseline.”
Learn it: AI product questions →
Learn it: AI product questions →
90Explain RAG vs fine-tuning.
“RAG retrieves current, permitted knowledge at answer time — good for facts, citations and fast updates. Fine-tuning adjusts behaviour or format using training examples — good for consistent style or specialised tasks. Neither guarantees truth; they can be combined.” *(Module 10.)*
Learn it: AI product questions →
Learn it: AI product questions →
91How would you evaluate an LLM-powered support bot before launch?
“Build a curated eval set (common, edge, adversarial, escalation cases); score correctness, groundedness, safety and policy compliance with a rubric; use human review and a validated LLM judge; weight failures by severity; set launch gates; pilot with human-in-the-loop; then track online metrics.”
Learn it: AI product questions →
Learn it: AI product questions →
92Your AI feature hallucinates 3% of the time. Launch or not?
“Depends on harm: 3% wrong recipe ideas may be fine with labels; 3% wrong policy answers in banking is not. Reduce with grounding and refusals, route high-risk intents to humans, show citations, and measure severity, not just rate.”
Learn it: AI product questions →
Learn it: AI product questions →
93How do you estimate the cost of an LLM feature?
“Input and output tokens per request times prices times volume, plus retrieval, retries and multi-step calls; compare with value per request. Levers: smaller models for simple intents, caching, shorter prompts. Example: ~$0.0105 per answer at hypothetical prices.” *(Module 10.)*
Learn it: AI product questions →
Learn it: AI product questions →
94Design an AI feature for an e-commerce app.
“Focus on finding the right product for a need: semantic search plus review summaries grounded in actual reviews with links; evaluate summary accuracy before launch; measure descriptive-search conversion and returns; manage risks of hallucinated claims and seller fairness.” *(Case 3; Lecture 40 ideas were proposals to validate.)*
Learn it: AI product questions →
Learn it: AI product questions →
95What metrics would you track for a generative AI assistant?
“Business outcome (resolution, time saved), UX (CSAT, re-asks), quality (correctness, groundedness, citation accuracy), safety (policy violations, leaks), system (p95 latency, cost per request).”
Learn it: AI product questions →
Learn it: AI product questions →
96Tell me about an AI project you worked on.
“Structure: user problem → why AI → data sources and permissions → architecture (retrieval, model, tools) → evaluation method and results (real, or ‘not measured’) → risks and controls → my contribution → what I'd do next.” *(Lecture 52: a POC is not a delivered outcome.)*
Learn it: AI product questions →
Learn it: AI product questions →
97What is the difference between an LLM, a chatbot and an AI agent?
An LLM is the model that predicts text; a chatbot is an interface that lets people talk to it; an agent wraps a model with instructions, tools, memory and a loop so it can take multi-step actions toward a goal.
Learn it: Extra →
Learn it: Extra →
98How do you reduce hallucinations in a production AI feature?
Ground answers in retrieved sources (RAG) with citations, ask for 'I don't know' when context is missing, constrain outputs with schemas, evaluate on a labelled test set, and add human review for high-impact answers.
Learn it: Extra →
Learn it: Extra →
99How would you estimate the monthly cost of an LLM feature?
Requests per month x (input tokens x input price + output tokens x output price), plus embeddings and infrastructure; reduce with caching, smaller models for simple turns, shorter prompts and output limits.
Learn it: Extra →
Learn it: Extra →
100What is the role of evaluation sets in GenAI products?
They are the regression tests of AI: real, labelled examples that measure accuracy, groundedness, safety and tone before every prompt, model or data change ships.
Learn it: Extra →
Learn it: Extra →
01How would you grow a brand's LinkedIn presence?
Founder- and employee-led posts with stories and lessons, a consistent weekly cadence, carousels and short videos, engaging with relevant creators, employee advocacy, and measuring follower growth, engagement and inbound leads.
Learn it: Content Creation →
Learn it: Content Creation →
02How do you decide what content to make next?
Audience questions (comments, DMs, search data), top-performing past posts, competitor gaps, and the business goal for the month.
Learn it: Content Creation →
Learn it: Content Creation →
03Short-form or long-form?
Short builds reach and discovery; long builds trust and depth; most creators use short to bring people to long and to owned channels like newsletters.
Learn it: Content Creation →
Learn it: Content Creation →
04How do you use AI without sounding generic?
Feed it your own examples and voice, use it for structure and editing, add personal stories and data, and always edit the final version yourself.
Learn it: Content Creation →
Learn it: Content Creation →
05How do you price a brand deal?
Based on average views/reach, engagement, niche value, deliverables, usage rights and exclusivity, with a media kit and a written agreement.
Learn it: Content Creation →
Learn it: Content Creation →
06Why do you want to be an FDE?
Show that you enjoy owning real outcomes, working with customers and building end to end, with a story where you solved a messy real-world problem.
Learn it: Forward Deployed Engineer (FDE) →
Learn it: Forward Deployed Engineer (FDE) →
07A customer's data is messy and access is delayed. What do you do?
Get a representative sample under an NDA or in a secure environment, build a thin slice with synthetic or masked data, document blockers with owners and dates, and escalate early with the business impact.
Learn it: Forward Deployed Engineer (FDE) →
Learn it: Forward Deployed Engineer (FDE) →
08How do you decide whether to build custom or wait for the product?
Weigh customer value and urgency, how many other customers need it, maintenance cost, and whether it can be built as a reusable component; agree with the product team.
Learn it: Forward Deployed Engineer (FDE) →
Learn it: Forward Deployed Engineer (FDE) →
09Design an AI assistant for a support team with strict compliance.
Read-only tools first, RAG with citations, PII redaction, human approval for outgoing messages, audit logs, evaluation on labelled cases, data residency and provider data policies, and a staged rollout.
Learn it: Forward Deployed Engineer (FDE) →
Learn it: Forward Deployed Engineer (FDE) →
10How do you show the value of a deployment?
Agree baseline and target metrics upfront, instrument usage and outcomes, report weekly, and translate improvements into money, time or risk reduced.
Learn it: Forward Deployed Engineer (FDE) →
Learn it: Forward Deployed Engineer (FDE) →
11Your CPL doubled last week. What do you check?
Tracking changes, auction/competition and CPMs, creative fatigue (frequency, CTR drop), audience or budget changes, landing page speed or errors, and seasonality; then fix the biggest driver.
Learn it: Digital Marketing →
Learn it: Digital Marketing →
12SEO vs paid search?
SEO builds compounding, lower-cost traffic over months; paid search buys immediate, controllable intent. Most brands run both and share keyword insights.
Learn it: Digital Marketing →
Learn it: Digital Marketing →
13How do you measure brand campaigns?
Reach and frequency, brand-search lift, direct traffic, brand-lift studies, and incrementality or MMM, not last-click conversions alone.
Learn it: Digital Marketing →
Learn it: Digital Marketing →
14What is a good landing page?
Message match with the ad, one goal, clear value and proof, simple form, fast mobile load, and a tested CTA.
Learn it: Digital Marketing →
Learn it: Digital Marketing →
15How do you use AI responsibly in marketing?
For research, drafts and variants with human review, fact-checking, brand and legal compliance, consent-based data, and disclosure of synthetic media.
Learn it: Digital Marketing →
Learn it: Digital Marketing →
16Data extension vs list?
Lists hold subscribers with basic attributes and are simple; data extensions are custom tables with your own fields and keys, faster at scale and needed for SQL, relational data and most journeys.
Learn it: Salesforce Marketing Cloud (SFMC) →
Learn it: Salesforce Marketing Cloud (SFMC) →
17How do you prevent sending to the wrong audience?
Use verified SQL with counts, a Verification activity, suppression/exclusion DEs, test sends against testable DEs, approvals, and send classifications that respect unsubscribes.
Learn it: Salesforce Marketing Cloud (SFMC) →
Learn it: Salesforce Marketing Cloud (SFMC) →
18How do you improve deliverability?
Authenticate the domain (SPF, DKIM, DMARC), warm up IPs, clean lists, segment for engagement, honour unsubscribes quickly, keep complaint rates low and monitor bounces.
Learn it: Salesforce Marketing Cloud (SFMC) →
Learn it: Salesforce Marketing Cloud (SFMC) →
19Journey Builder entry sources?
Data extension, API event, Salesforce data via Marketing Cloud Connect, CloudPages forms, and audiences from Data Cloud.
Learn it: Salesforce Marketing Cloud (SFMC) →
Learn it: Salesforce Marketing Cloud (SFMC) →
20How would you measure a journey?
Entry volume, step conversion, goal completion, revenue per contact, time to convert, unsubscribe and complaint rates, compared with a hold-out group.
Learn it: Salesforce Marketing Cloud (SFMC) →
Learn it: Salesforce Marketing Cloud (SFMC) →
