Bird
0
0

What is the output of this test result if expect_column_values_to_be_unique is run on a column with duplicate values?

medium📝 Predict Output Q5 of 15
dbt - Advanced Testing
What is the output of this test result if expect_column_values_to_be_unique is run on a column with duplicate values?
ATest fails indicating duplicates found
BTest passes ignoring duplicates
CTest throws a runtime error
DTest skips duplicates silently
Step-by-Step Solution
Solution:

  1. Step 1: Understand uniqueness test behavior

    This test checks if all values in a column are unique without duplicates.

  2. Step 2: Analyze effect of duplicates

    Presence of duplicates violates uniqueness, so test fails reporting duplicates.

  3. Final Answer:

    Test fails indicating duplicates found -> Option A

  4. Quick Check:

    Duplicates present = uniqueness test fails [OK]
Quick Trick: Duplicates cause uniqueness test failure [OK]
Common Mistakes:
MISTAKES
  • Assuming duplicates pass uniqueness test
  • Expecting runtime errors instead of failure
  • Thinking duplicates are ignored

Want More Practice?

15+ quiz questions · All difficulty levels · Free

Free Signup - Practice All Questions
More dbt Quizzes
Incremental Models - Why incremental models save time and cost - Quiz 7medium Incremental Models - Unique key for merge behavior - Quiz 14medium Incremental Models - is_incremental() macro - Quiz 3easy Packages and Reusability - dbt-date for date spine - Quiz 11easy Packages and Reusability - Installing packages with packages.yml - Quiz 13medium Project Organization - Staging, intermediate, and marts pattern - Quiz 2easy Project Organization - Staging, intermediate, and marts pattern - Quiz 10hard Project Organization - Staging, intermediate, and marts pattern - Quiz 4medium Project Organization - Naming conventions at scale - Quiz 2easy Project Organization - Naming conventions at scale - Quiz 1easy