Data for AI →easyMultiple ChoiceObjective-mapped

AI Associate Data for AI Practice Question

Exhibit

SELECT Campaign__c, COUNT(*) as Records, COUNT(Response__c) as NonNullResponse
FROM UnifiedCustomer
GROUP BY Campaign__c

Results:
Campaign__c | Records | NonNullResponse
Summer Sale  | 1000    | 750
Spring Promo | 800     | 800
Fall Clearance | 600    | 0

Refer to the exhibit. What data quality issue does the exhibit reveal?

Answer choices

Why each option matters

Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.

Correct answer & explanation

✓

The Fall Clearance campaign has no response data.

The Fall Clearance campaign has zero non-null responses, indicating all response data is missing for that campaign.

Answer analysis

Option-by-option breakdown

For each option: why learners choose it and why it is or isn't the right answer here.

✗
The Summer Sale campaign has duplicate records.
Why it's wrong here
The query does not show duplicate counts.
✓
The Fall Clearance campaign has no response data.
Why this is correct
NonNullResponse is 0, meaning all responses are null.
✗
The query syntax is incorrect.
Why it's wrong here
The query executes and returns results.
✗
The data is not normalized.
Why it's wrong here
Normalization is not indicated by this query.

Go deeper

AI Associate Data for AI Practice Question

Exhibit

Why each option matters

Option-by-option breakdown

Related to this question