[Solved] What will this dbt test return if the 'customers' table contains duplicate 'phone_number' entries? select phone_number, count(*) from {{ ref('customers') }} group by phone_number having count(*) > 1 | dbt

dbt - Advanced Testing

What will this dbt test return if the 'customers' table contains duplicate 'phone_number' entries?

select phone_number, count(*) from {{ ref('customers') }} group by phone_number having count(*) > 1

AIt will list all phone numbers that appear more than once along with their counts

BIt will return an empty result because duplicates are ignored

CIt will throw a syntax error due to missing WHERE clause

DIt will return all phone numbers regardless of duplication

Step-by-Step Solution

Solution:

Step 1: Analyze the SQL query
The query groups by phone_number and filters groups with count > 1.
Step 2: Understand output
It returns phone numbers that have duplicates and their counts.
Final Answer:
It will list all phone numbers that appear more than once along with their counts -> Option A
Quick Check:
HAVING count(*) > 1 filters duplicates [OK]

Quick Trick: HAVING count(*) > 1 finds duplicates [OK]

Common Mistakes:

MISTAKES

Master "Advanced Testing" in dbt

9 interactive learning modes - each teaches the same concept differently

More dbt Quizzes

What will this dbt test return if the 'customers' table contains duplicate 'phone_number' entries?