Implement and Manage Data Quality Constraints in Unity Catalog DP-750 Practice Questions (Page 2)

Questions 6–10

1. 6foundation · easy

   Which type of data quality check ensures that values in a column are within a specified minimum and maximum?

   • ARange check
   • BNullability check
   • CCardinality check
   • DSchema enforcement
   Reveal Solution Discussion Select an answer first
2. 7foundation · easy

   In Unity Catalog, which constraint type is used to enforce that a column cannot contain NULL values?

   • ANOT NULL constraint
   • BCHECK constraint
   • CUNIQUE constraint
   • DPRIMARY KEY constraint
   Reveal Solution Discussion Select an answer first
4. 8foundation · easy

   What is the purpose of schema enforcement in a Delta table?

   • ATo automatically add new columns to the table when data arrives
   • BTo encrypt data at rest
   • CTo compress data to reduce storage costs
   • DTo ensure that all writes conform to the table's defined schema
   Reveal Solution Discussion Select an answer first
5. 9foundation · easy

   Which of the following is a valid action that can be taken when a pipeline expectation fails?

   • AFail the pipeline
   • BAutomatically correct the data
   • CSend an email to the data engineer
   • DIgnore the failure and continue
   Reveal Solution Discussion Select an answer first
6. 10application · medium

   A retail company ingests daily point-of-sale (POS) transaction files from stores. The data quality team has observed that some files contain rows where the `transaction_id` is null, and other rows have `sale_amount` values that are negative. They want to enforce a rule so that any new data written to the `sales` table in Unity Catalog must have a non-null `transaction_id` and a `sale_amount` between 0 and 10000. Which approach should they use?

   • AUse a Delta Lake generated column to compute a hash of `transaction_id` and filter out nulls during reads.
   • BSet the table property `delta.appendOnly = true` to prevent updates that could introduce nulls.
   • CCreate a CHECK constraint on the table with `transaction_id IS NOT NULL AND sale_amount BETWEEN 0 AND 10000`.
   • DApply a `FILTER` transformation in every downstream query to exclude rows with null or negative values.
   Reveal Solution Discussion Select an answer first