Questions / CareFirst BlueCross BlueShield 1 Diagnose a Metric Drop After Launch Written 467× 2 Common Pitfalls in Experiment Results Written 247× 3 Statistical Significance in Hypothesis Testing Stats D 210× 4 Explain SQL Join Types SQL 75× 5 Choosing Model Evaluation Techniques Written T 71× 6 Feature Selection for ML Models Written 57× 7 Build Versus Buy Decision Written 21× 8 Approaching an Integration Challenge Written 1× 9 Preparing Inconsistent Data for Dashboards SQL 14× 10 Healthcare Pricing Models Written 1× 11 Gathering Requirements From Business Written 1× 12 Measuring Project Success Written 1× Show all 50 questions ↓ Show fewer ↑ 13 Use Window Functions Written B 57× 14 Portfolio Management and Expectations Written 1× 15 Cost Estimate for Pharmacy Initiative Written 16 Variance Analysis for Overspend Written 17 Explaining Technical Issues Clearly Written C 945× 18 Coordinating Technical and Business Teams Written 1× 19 SQL for Data Extraction Written 20 Agile in a Non-Agile Setting Written 1× 21 Loss Reserving Triangles in Excel Written 22 Risk Identification and Mitigation Written 1× 23 Validating Dataset Integrity Written C 24 Prioritizing Conflicting High-Stakes Work Written 3919× 25 Recovering an Unresponsive Critical App Written 1× 26 Protecting Data Integrity Written 27 Troubleshooting Multi-Tier Bottlenecks Written 1× 28 Troubleshooting DB Performance Written 29 Mapping Business Needs to Specs Written 1× 30 Optimize a Slow SQL Query Written 31 Gathering and Documenting Requirements Written 32 Resolving a Difficult Stakeholder Written 2269× 33 UAT for New System Features Written 34 Prioritizing Clinical and User Feedback Written 35 Measuring Success of a Launch Written 36 Explaining Complex Analysis to Nontechnical Stakeholders Written 993× 37 Comparing Technologies in Production Written 1× 38 High Availability and DR Design Written 39 Automating Routine Maintenance Written 40 Prioritizing Across Competing Projects Written 790× 41 Adapting to Mid-Project Requirement Changes Written 721× 42 Persuading a Resistant Stakeholder Group Written D 697× 43 Prioritizing Competing Data Requests Written 642× 44 Prioritizing Under a Tight Deadline Written 590× 45 Leading a Team Through Ambiguity Written 576× 46 Explaining Finance to Non-Experts Written 554× 47 Managing Conflicting Stakeholder Expectations Written 533× 48 Missing a Critical Project Deadline Written 490× 49 Pivoting Strategy Mid-Execution Written D 383× 50 Prioritizing Conflicting Cross-Functional Deadlines Written 380× 