⚡️ Pass with Confidence Sale - 40% off ALL packages! ⚡️

1 day, 22 hours remaining!
Crucial Exams

CompTIA Data+ DA0-002 (V2) Practice Question

During an initial exploration of a CRM export that will feed a data warehouse, you notice the staging table contains two seemingly identical columns-Customer_ID and CRM_Customer_GUID. To test whether one column is a redundant copy of the other, you execute:

SELECT COUNT()
FROM   staging.crm_sales
WHERE  Customer_ID IS DISTINCT FROM CRM_Customer_GUID;

The query returns 0 rows. Based solely on this result, which conclusion is most appropriate?

  • The two columns store the same values in every record, so keeping both is redundant and one can be dropped.

  • Because there are no mismatches, Customer_ID must be a foreign key that references CRM_Customer_GUID, so both columns should remain.

  • The test shows that each column is unique but represents a different business key, so no redundancy exists.

  • Zero mismatches prove the table contains duplicate rows, so both columns are needed to remove those duplicates later.

CompTIA Data+ DA0-002 (V2)
Data Acquisition and Preparation
Your Score:
Settings & Objectives
Random Mixed
Questions are selected randomly from all chosen topics, with a preference for those you haven’t seen before. You may see several questions from the same objective or domain in a row.
Rotate by Objective
Questions cycle through each objective or domain in turn, helping you avoid long streaks of questions from the same area. You may see some repeat questions, but the distribution will be more balanced across topics.

Check or uncheck an objective to set which questions you will receive.

Wipe Score
Bash, the Crucial Exams Chat Bot
AI Bot