Job-ready delivery

Module 20 quiz

Practice questions: choose an answer and check it to see the explanation. Nothing here is timed or graded.

1. 1. What does a reconciliation in a cleaning handoff show?

   The file's encodingThat input rows = clean + quarantined + filtered, so nothing disappearedThe average of each columnHow long the job took
   Check
2. 2. In a take-home task, the brief doesn't say which zone naive timestamps use. What should your write-up do?

   Silently assume UTCState the assumption or quarantine them, and list it as an open questionDelete the timestampsIgnore the issue
   Check
3. 3. Which deliverable best supports a reviewer checking your cleaning?

   The clean table onlyThe clean table, an exception report with reasons, and the rules appliedA chart of the clean dataThe raw file
   Check
4. 4. What belongs in a cleaning handoff note?

   Only the codeRules applied, assumptions, exception counts by reason, open questions and how to rerunOnly the final tableA screenshot
   Check
5. 5. In a take-home test the brief is silent about duplicates. What should you do?

   Ignore duplicatesState the assumption you made, apply it consistently and mention the alternativeDelete every repeated valueAsk for the answer key
   Check
6. 6. A report says "cleaned the data, removed bad rows". What is missing?

   NothingWhich rules, how many rows each removed and where the removed rows areThe file sizeThe tool version only
   Check
7. 7. How should you explain a trade-off to a stakeholder?

   Avoid mentioning itState the options, the impact of each on the numbers, and your recommendationUse jargonOnly show code
   Check
8. 8. You discover a cleaning bug after delivering a report. What do you do?

   Stay quietTell the recipients, quantify the impact, fix it and re-deliverWait for someone to noticeDelete the report
   Check
9. 9. What makes a cleaning project portfolio-ready?

   Lots of codeA brief, rules, reproducible code, exception report, reconciliation and a short write-up of decisionsCharts onlyA big dataset
   Check