Databricks Certified Data Engineer - Professional

Explanation

For creating inverted rules for a quarantine table, we need to negate the original rules. The correct approach is:

• Option C uses NOT({' OR '.join(rules.values())}) which correctly implements De Morgan's Law:
  • The original rules are likely AND conditions (e.g., rule1 AND rule2 AND rule3)
  • To invert AND conditions, we use OR with NOT: NOT(rule1 OR rule2 OR rule3)
  • This is equivalent to NOT rule1 AND NOT rule2 AND NOT rule3

Why other options are incorrect:

• Option A: NOT({' AND '.join(rules.values())}) would create NOT(rule1 AND rule2 AND rule3) which is equivalent to NOT rule1 OR NOT rule2 OR NOT rule3 - this is not the correct inversion for quarantine rules.

• Option B: Uses invalid syntax with & and ! which are not standard SQL operators for this purpose.

• Option D: Uses IF and NULL which doesn't make logical sense for inverting rules.

In quarantine scenarios, we typically want to identify records that violate ANY of the validation rules, so we need to invert the original validation logic using the correct logical operators.