ROLE
Data engineering
Compare this role’s stage expectations →
These are the same questions found in the library, grouped here by the capability each one mainly examines.
453 questions
Extended questions 151–200 of 453 on this page.
A · Professional problem solving and implementation20
- A critical end-to-end test fails intermittently: it passes alone but fails in a parallel suite, and the team has started rerunning it until it passes. How would you determine whether it exposes product risk, isolate shared state, resource contention, clock or ordering dependencies, and improve the test workflow?
- A service has stable average latency but periodic p99 spikes near allocation peaks. How would you determine whether garbage collection is responsible and distinguish it from other pauses?
- A high-traffic service must move a critical table to a new model without pausing reads or writes. How would you organize the migration stages and verify a safe cutover?
- A request starts several async tasks. After the client disconnects or the request times out, some downstream work still uses threads and connections. How would you propagate cancellation and release those resources?
- A set of asynchronous callbacks prints the same loop variable or a value different from what was expected. Using a language you know, explain binding and closure capture, then give a verifiable correction.
- An object overrides equality but keeps the default hash implementation, causing failed lookups in a hash collection. Explain the equality/hash contract and how you would test it.
- A product needs to send transactional and optional marketing notifications to tens of millions of users, who can change channel preferences at any time. How would you design the sending process?
- A service’s resident memory is stable, but major page faults, disk I/O, and tail latency rise together. How would you distinguish changes in the working set, mapping behavior, memory pressure, and application access patterns?
- A global service must enable different features and retention rules by region while headquarters still needs an overall operational view. How would you divide configuration, enforcement, and aggregation?
- A search service must change tokenization and ranking features without long result gaps or a major increase in write latency. How would you evolve the index?
- A subscription product includes trials, renewals, grace periods, refunds, and family sharing. How would you design entitlement checks so several services receive consistent, traceable results?
- Several teams copy de-identified data into development, staging, and performance environments with different refresh schedules. How would you design access, lifecycle, and reproducibility?
- A usage-based API product must combine request events from multiple regions into customer bills and allow later corrections. How would you design the usage-data processing flow?
- Two processes both access address 0x1000. Why do they usually not read or write the same physical memory? Explain the address translation and operating-system responsibilities.
- A multi-tenant platform must send event notifications (webhooks) to customer systems. How would you design delivery and retries when a client is unavailable for a long time?
- After changing an embedding model, old and new vectors are not directly comparable, while a full rebuild takes days. How would you design migration and query cutover?
- A team discovers that a model may have seen some internal evaluation prompts in public corpora or fine-tuning data. How would you determine what offline scores still mean and rebuild a trustworthy evaluation?
- A team fine-tunes on user feedback, human labels, and synthetic samples, then receives a request to delete some source data. How would you trace impact and decide the scope of retraining?
- A new model improves offline evaluation, but answer quality may fall for a small set of high-value users. How would you stage a canary, observe it, and decide when to expand traffic?
- Users say answers sound plausible but omit a critical constraint present in the documents. How would you locate whether parsing, chunking, retrieval, ranking, or generation caused the failure?
No questions in this section match your target. ·
B · Business understanding and domain modeling17
- An enterprise product charges a monthly subscription, overage usage, and a minimum-spend true-up. How would you define billing periods, usage attribution, price effective time, and invoice explanations so a customer can reconcile the charges?
- A promotion increases sales volume, but new customers’ first orders remain unprofitable after discounts, channel fees, and fulfillment costs. How would you isolate the loss and decide whether to change the offer threshold, audience, channel, or stop the promotion?
- A user orders through a channel and later receives a refund, chargeback, or cancellation. How would you define order value, attribution window, and channel cost so marketing analysis and finance settlement can both explain the same outcome?
- A new plan makes more users willing to try the product, but some customers who would have bought a higher-priced plan switch to the cheaper option. What commercial model and observation window would you use to judge whether the plan portfolio creates incremental value?
- Map the value flow among users, suppliers, the platform, and payers in a two-sided marketplace you know. Explain how value and responsibility change when a service is not fulfilled.
- After a promotion ends, operations considers the campaign complete, product sees orders still being fulfilled, and finance says settlement is not yet possible. How would you define each party’s objects, states, and state transitions?
- The same person may encounter a product through ads, an agency, a partner, and a self-serve channel, and different parties may pay. How would you distinguish customer, buyer, user, and acquisition touchpoint in the business model?
- An enterprise customer has multiple organizations, departments, and members, and a member may act for different organizations. When designing customer activity analysis, how would you define the grain and relationships among customer, account, organization, and user?
- Support agents merge duplicate tickets and sometimes split a complex issue into several cases. When modeling service-quality data, how would you define the issue, ticket, contact, and resolution?
- Partner settlement must connect external order IDs, internal orders, payments, and refunds, but systems use different keys and update times. How would you build the mappings and reconciliation process?
- Business units use an “active customer” metric, but some define it by payment, others by usage, and others by likelihood to renew. How would you decide which definitions should be standardized and which should remain distinct concepts?
- Recommendation and risk teams both need a “spend in the last 30 days” feature, but one uses calendar days and the other a rolling hour window, and refund handling differs. How would you decide whether the definition can be shared?
- A risk value is usually present in training data, but live serving often substitutes a default and model performance fluctuates. How would you find whether the cause is data collection, timing, missing-value handling, or implementation differences?
- Models, operational rules, and reports share a core feature, but the upstream business definition has changed and some consumers cannot migrate yet. How would you manage old and new definitions, ownership, and migration order?
- An upstream dependency change will increase refresh latency for a costly feature set from seconds to ten minutes. How would you determine which decisions are affected, which features must remain real time, and when a fallback value is acceptable?
- The commercial rule for a service changes from a free trial to a refund after conditions are met, while historical orders were signed under the old terms. How would you evolve the model and workflow so both old and new transactions remain explainable?
- A supplier API replaces one “delivered” status with “dispatched” and “received,” but historical data has no basis for distinguishing them. How would you update the domain model, external contract, and related reporting?
No questions in this section match your target. ·
C · Value judgment and direction setting7
- An acquisition campaign drives many registrations, but some regions cannot yet be served, reducing the share of new users who can actually receive the service. How would you define and report the campaign result?
- Brand advertising, search, and affiliate channels reach overlapping prospects, while the attribution platform assigns most conversions to the last click. How would you estimate each channel’s incremental contribution and state the limits of the conclusion?
- A checkout experiment improves payment completion, but complaints and refunds also increase. How would you judge whether the experiment succeeded, and how long would you wait before deciding?
- Product, operations, and sales reports all say “retention,” but refer to return visits, key-feature use, and renewal. How would you clarify the measures so each name maps to a user behavior and business decision?
- A membership program increases repeat-purchase frequency, but average order value and margin both decline. How would you distinguish a healthy habit change from purchases pulled forward or low-quality, promotion-driven growth?
- A new automated workflow doubles processing speed and reduces human review, but errors have a greater impact on a small group of high-value customers. How would you assess net value and decide whether to expand it?
- A major customer will pay a high price for a custom feature, but reuse by other customers is uncertain. Ongoing maintenance, permissions, and data rules add cost, and sales has promised a delivery date. How would you compare a one-off build, productizing it, a service, or declining—and decide whether to invest?
No questions in this section match your target. ·
D · Delivery and ongoing operations6
- An onboarding experiment does not change overall signup-to-activation conversion, but activated users complete their first key task sooner. How would you decide whether to roll it out and revise the definition of success?
- During a major promotion, landing-page traffic meets expectations but add-to-cart and order rates are far below target. How would you quickly distinguish traffic quality, page information, pricing rules, inventory, and fulfillment issues?
- A limited-time promotion launches, but popular products run short. Some channels have already promised availability while others continue sending traffic. How would you adjust promotion, page promises, replenishment, and customer communication?
- A brand campaign has delivered its planned total impressions, but actual reach among the core target audience is below expectation, and one-third of the budget remains. How would you decide whether to continue, change the media mix, or revise the objective?
- A community event has strong registration and interaction numbers, but participants rarely continue using the product or contributing content afterward. How would you locate where the connection to product value breaks and design the next operating cycle?
- To meet a quarterly goal, a partner asks to expand promotion delivery at short notice. An initial check suggests the new audience may exceed agreed authorization and brand boundaries. How would you move the decision forward within the deadline?
No questions in this section match your target. ·