ROLE
Data engineering
Compare expectations across career stages →
These are the same questions found in the library, grouped here by the capability each one mainly examines.
453 questions
Extended questions 201–250 of 453 on this page.
A · Professional problem solving and implementation14
- After deployment on a multi-socket machine, threads move across NUMA nodes and memory latency varies. How would you investigate using CPU affinity, memory placement, and scheduling behavior?
- After certificate rotation, short connections work, but some clients fail a handshake when reconnecting or resuming after a long-lived connection closes. How would you distinguish certificate-chain, resumption, connection-pool, and client-cache effects?
- When a mobile device switches from Wi-Fi to cellular, some HTTP/3 requests fail while the session still appears online. How would you investigate path migration, timeouts, and middlebox behavior?
- A program writes a data file before updating its index, but after a power loss the index points to incomplete content. How would you analyze write ordering, flush semantics, and recovery?
- Average latency is stable while p99 worsens, with large differences across tenants. How would you narrow the cause to queuing, lock contention, downstream fan-out, or resource isolation?
- At peak load, the entry service records a request but downstream events are missing, while retries amplify traffic. How would you trace the request through each service to locate loss and duplication?
- Several tenants share an asynchronous job platform, and some submit many long-running tasks. How would you design scheduling, isolation, quotas, and use logs, metrics, and call records to understand queue behavior?
- Some objects become hot, degrading reads while writes must remain ordered. How would you divide caching, partitioning, and write coordination?
- The business needs every state change to be traceable and safely replayable, but some old events lack fields. How would you design event versions, retention, and replay boundaries?
- A multi-region service must preserve critical functions during a regional outage, but some data cannot tolerate conflicting overwrites. How would you choose degradation, replication, and recovery policies?
- A real-time collaboration service has many long-lived connections, and slow clients accumulate updates. How would you choose between dropping, combining, limiting updates to slow clients, and resynchronizing?
- Teams share a repository but release at different cadences; shared package changes often block unrelated teams. How would you design boundaries, impact analysis, and release agreements?
- The same release behaves differently across clusters, and configuration changes are not fully audited. How would you establish configuration sources, drift detection, and rollback?
- Offline evaluations keep improving while a specific user segment regresses online. Which data leakage, slice coverage, and deployment differences would you investigate?
No questions in this section match your target. ·
B · Business understanding and domain modeling4
- Customers upgrade, downgrade, or pause subscriptions mid-cycle, while sales and finance disagree on revenue recognition. How would you express the rules and handle historical invoices?
- Business reports mix orders, order lines, and payment attempts, so metrics disagree across pages. How would you establish fact-table grain and validate aggregation semantics?
- The source database has deleted a customer, but a change data capture (CDC) pipeline and downstream summary views still show the old record. How would you trace the deletion event, update dependent views, and verify cleanup?
- Two models call a feature with the same name but receive different values due to defaults and missing-data handling. How would you establish a contract and compatibility checks? Follow-up: If a critical feature refresh misses the real-time decision window, how would you choose among stale values, fallbacks, or refusing the decision?
No questions in this section match your target. ·
C · Value judgment and direction setting20
- A feature is used often but has not improved retention or payment. How would you determine whether it creates core value, reflects habit, or rewards the wrong behavior?
- The annual conversion target depends on an untested channel assumption. How would you separate current commitments, assumptions to validate, and checkpoints for continuing, changing, or stopping?
- Overall conversion improves, but new users and low-connectivity regions worsen. How would you examine segmentation, selection bias, and problems hidden by the aggregate?
- After several teams optimize the same north-star metric, duplicate content and low-quality interactions appear. How would you diagnose metric distortion and adjust guardrails?
- One section of a community has stayed quiet for a long time. How do you judge whether it deserves continued investment or should be shrunk or merged?
- As the industry enters a stock era, the company demands a complete shift from thinking in transaction volume to thinking in net profit. How do you raise net profit by adjusting the take rate and optimizing supply-chain operating costs without triggering large-scale exits or protests from merchants or creators?
- A design-research team has two researchers, while three product lines want critical interviews this month. One decision is irreversible; another can start with low-cost data. How would you allocate capacity?
- How would you calculate a product direction’s return on investment? How would you account for labor, cost, and revenue, use annual recurring revenue (ARR), and identify where the calculation might overstate value?
- A free feature attracts many active users, but inference and support costs rise too. How would you evaluate the business role of the free tier?
- Marketplace subsidies increase transactions, but supply and demand fall back when subsidies stop. How would you judge whether the subsidies created sustainable value?
- During a brand campaign, organic search and direct visits rise, while search-ad spend also increases. How would you estimate brand contribution without counting conversions intercepted by performance ads as brand outcomes?
- A campaign randomly holds out 10% of users, but they may still receive sales outreach and organic recommendations. Conversion is higher in treatment, and the channel team wants more budget. How would you assess contamination and results?
- Orders rise 30% during a discount campaign, but many come from existing customers who would have bought anyway, and product mix changes. How would you estimate incremental gross margin?
- The algorithm team expects an upgraded recommendation model to lift conversion by 3%, but operations would lose the ability to adjust key placements manually. How would you design an experiment and decision rules while accounting for value the experiment cannot measure?
- After the bot upgrade, sessions with no handoff to a human are counted as resolved, and the rate went from 72% to 91%. In the same week the handoff button moved into a submenu and the denominator changed. How do you respond today to the proposal to cancel weekend human coverage?
- What business result did your project bring? How do you confirm it came from this project and not from something else?
- Retention rose during a marketing campaign, and the team credits the channel, but a new product flow also launched and participants may already have been more active. How would you establish a credible comparison, estimate the campaign’s net lift, and state the limits of the conclusion?
- Who you compare against changes the conclusion directly. Why did you choose these comparisons, and how would your conclusion change with a different one?
- When you benchmark against a competitor's data, how do you decide what is comparable and what is not? What decision did you finally use it for?
- The completion rate of a key task fell this week. Before explaining why, in what order do you confirm that the change is real, where it is concentrated, and what cost users bear?
No questions in this section match your target. ·
D · Delivery and ongoing operations7
- A campaign creative gets high engagement on social channels but almost no conversion in search or stores. Another version has ordinary engagement but stronger sales. How would you decide on creative iteration and channel allocation?
- A broad discount meets the overall sales target, but valuable existing customers view it as unfair, and some users delay purchases they would have made anyway. How would you adjust future audiences and offers?
- A discount briefly increases volume, competitors follow, and category prices and margins decline. How would you decide whether to keep matching, change the value proposition, or exit the promotion?
- A new product misses its first-week sales target, yet trial users show strong usage depth and referral intent. How would you determine whether the issue is reach, a longer purchase cycle, price threshold, or positioning, and decide what to invest in next?
- A new-customer offer generates many registrations, but most users do not complete the first key action and the discount cost has already been incurred. How would you plan follow-up and decide which users merit further investment?
- A channel has a low acquisition cost in a small test, but lead quality and conversion fall as spend increases. How would you validate the cost definition and true incrementality, distinguish channel saturation from audience or sales-capacity changes, and set a limit for additional spend?
- A campaign brings in many new users, but support, moderation, and plans for following up with users and helping them complete a key action are not ready. How would you design ownership and capacity before and after the campaign?
No questions in this section match your target. ·
G · Learning, adaptation, and sustained growth3
- You completed structured learning, but your judgment and project outcomes did not change. How would you determine whether practice, feedback, or context is the issue?
- A new role has no clear first-quarter goals, and the team is busy with routine work. How would you identify a problem worth owning and calibrate with your manager?
- You set a long-term capability goal, but urgent daily work keeps displacing learning and improvement. How would you create a sustainable way to make progress?
No questions in this section match your target. ·
H · Professional responsibility and work style2
- You realize your status report omitted a risk that could change the decision, and executives have already relied on it. How would you correct it?
- A leader asks you to show only favorable segments and describe an insignificant result as a trend. How would you respond and preserve factual accuracy?
No questions in this section match your target. ·