Validation rules

Module 11 quiz

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

1. 1. Why check rules in a fixed order?

   It is fasterA row can fail several rules; a fixed order gives every row one reproducible first reasonOrder doesn't matterDatabases require it
   Check
2. 2. Rule: quantity between 1 and 500. Which values fail: 0, 1, 500, 501?

   0 and 501Only 5010, 1 and 501None
   Check
3. 3. A price of 0.00 appears. The rule says prices must be greater than zero. What do you do?

   Change it to 0.01Quarantine it with the range reasonKeep it; free items existDelete it
   Check
4. 4. What is a cross-field rule?

   A rule on one columnA rule comparing columns, e.g. end_date ≥ start_dateA rule across filesA formatting rule
   Check
5. 5. A rule fails for 40% of rows. What should you do before quarantining them?

   Quarantine and move onCheck whether the rule or the data changed; confirm with the ownerRelax the ruleDelete the rule
   Check
6. 6. Rules in order: missing_quantity, bad_quantity, quantity_out_of_range. A row has quantity "abc". Which reason?

   missing_quantitybad_quantityquantity_out_of_rangeAll three
   Check