Level 1: Newcomer
0 points
Sign in to save your progress across devices.
Work in the tool while you explain your decisions.
Choose a role and level. Each interview has a new task, follow-up questions and a report that checks your work and your explanation.
Speak or type. Sign in to save your results across devices.
Questions are drawn from a bank of 36. Your report includes a skill breakdown and lessons to practice next.
Junior tasks cover the fundamentals. Mid and senior tasks add debugging, changing requirements and review decisions.
10 interviews
Quarry Cycleworks needs orders whose Status is Open and DaysLate is at least 340. Return the original fields for those orders only. Keep the boundary order and exclude closed work.
Plover Dispatch treats a blank Returned value as zero for this shipping export. Add NetUnits as Double, equal to Shipped minus Returned under that rule. Preserve every original field and row, including zero and negative net units.
Morrow Printworks receives revised charges. Keep the row with the greatest Revision for each Ticket. Revisions are unique within a ticket. Preserve Ticket, Revision and Charge. An existing all-field Unique doesn't remove old revisions.
Quarry Cycleworks reconciles dispatch receipts to acknowledgments. Match both Receipt and Site. Return only unmatched dispatch records from the left source, preserving its three fields. A receipt can exist at more than one site.
Plover Dispatch exports two batches with Branch and Charge in different column orders. Stack all records by field name, then return one Branch row with TotalCharge as Double. Keep repeat transactions; these are different batches.
Morrow Printworks supplies DateText in day/month/year format. Parse it into Posted as DateTime and keep records from February 1 through February 3, 2027, inclusive. Keep DateText, Units and Posted. Don't interpret the source as month/day/year.
Quarry Cycleworks needs one row per Desk and one numeric column per Shift. Cross-tab Hours using Sum. Multiple observations for the same Desk and Shift must add together. An absent combination contributes zero hours.
Plover Dispatch needs one row per CostCenter with TotalHours as Double and Region from the reference file. Aggregate Hours before enriching on CostCenter. The reference has one row per center. Return only CostCenter, TotalHours and Region. All work centers in this task have a reference.
Morrow Printworks needs contribution by Channel. Exclude Status Canceled, calculate Contribution as Revenue minus Cost, then sum it as TotalContribution. Return only Channel and TotalContribution as Double. Keep zero and negative contribution from completed work.
Quarry Cycleworks has a draft balance that follows file order. Sort by Account ascending and Sequence ascending, then calculate RunTot_Movement separately per Account. Preserve every source field. Negative movements reduce the balance; each account starts at zero.
The Interview Hub is included in All Access. Choose a plan or sign in to your account to continue.