Workbook: six exercises on the sample data
Map three legacy fields
Not startedThe legacy milestone export has three columns below. Pick the target field and the transform for each. The check runs on your mapping and shows what changes.
Row BRC-MS06: ms_dt="08/07/2028" gate_flg="Y" bl_dt="14/06/2028"
Find the broken dependency in Program Birch
Not startedFour finish-to-start links from Program Birch. One successor starts before its predecessor finishes plus lag. Pick the broken link.
| Link | Predecessor finish | Lag, days | Successor start |
|---|---|---|---|
| BRC-D001 | 2027-02-25 | 3 | 2027-03-01 |
| BRC-D005 | 2027-03-18 | 2 | 2027-03-12 |
| BRC-D002 | 2027-03-25 | 2 | 2027-03-29 |
| BRC-D003 | 2027-04-14 | 1 | 2027-04-15 |
Complete the SQL for rule R4
Not startedFill the JOIN condition so the query lists assignments whose resource code is missing from the resource master. Checking runs your query in SQLite (loads 0.66 MB on first use) and compares the row count with the rule.
SELECT 'assignment:' || a.id AS record_ref, a.id, a.resource_code
FROM assignment a
LEFT JOIN resource r ON ____________
WHERE r.code IS NULL;Decide the gate for Program Cedar
Not startedProgram Cedar carries the findings below in your session. Pick the gate verdict.
- Open BLOCK: 11
- Open REVIEW: 4
- Fixed or accepted: 0
Write a UAT scenario for rule R3
Not startedWrite one scenario in Given, When, Then form for the working calendar rule. The check looks for four required elements.
Choose the fix for a weekend milestone
Not startedMilestone BRC-MS06 "S.O.P." sits on Saturday 2028-07-08. The sample calendar policy moves non-working dates forward. Pick the fix.