DATA-ARCHITECT practice question 31 of 35

Get Cloudy Consulting needs to evaluate the completeness and consistency of contact information in Salesforce. Their sales reps often have incomplete…

Full set: 257 questions
Get Cloudy Consulting needs to evaluate the completeness and consistency of contact information in Salesforce. Their sales reps often have incomplete information about their accounts and contacts. Additionally, they are not able to interpret the information in a consistent manner. Get Cloudy Consulting has identified certain ""key"" fields which are important to their sales reps. What are two actions Get Cloudy Consulting can take to review their data for completeness and consistency? (Choose two.)
Answer options
A: Run a report which shows the last time the key fields were updated.
B: Run one report per key field, grouped by that field, to understand its data variability. Correct answer
C: Run a report that shows the percentage of blanks for the important fields. Correct answer
D: Run a process that can fill in default values for blank fields.
Correct Answer:
B. Run one report per key field, grouped by that field, to understand its data variability.; C. Run a report that shows the percentage of blanks for the important fields.
Explanation

The goal is to evaluate data for completeness and consistency. Completeness refers to the degree to which all required data is present. Running a report to show the percentage of blank fields (C) directly measures this dimension. Consistency refers to the degree to which data is uniform and free from contradiction. Running a report grouped by a key field (B) allows an analyst to see all the variations of the data entered for that field, making it easy to spot inconsistencies like "CA," "Calif.," and "California" for a state field.

Why Incorrect

A. This action measures data timeliness or currency, not its completeness or consistency. A field could be recently updated but still be incorrect or inconsistent.
D. This is a data remediation or cleansing step. The question asks how to review and evaluate the data, which must be done before any corrective action is taken.

References

1. Wang, R. Y., & Strong, D. M. (1996). Beyond accuracy: What data quality means to data consumers. Journal of Management Information Systems, 12(4), 5-33. https://doi.org/10.1080/07421222.1996.11518099. This foundational academic paper defines data quality dimensions, including "Completeness" (p. 14) and "Consistency" (p. 14), which align directly with the actions in the correct answers.

2. Salesforce Help. Build a Report in Lightning Experience. Retrieved from https://help.salesforce.com/s/articleView?id=sf.reportsbuilderlightning.htm&type=5. The documentation shows how to group rows and add summary formulas, which are the mechanisms used to perform the actions in options B and C.

3. Salesforce Trailhead. Assess Your Data Quality. Retrieved from https://trailhead.salesforce.com/content/learn/modules/dataquality/dataqualityassessment. This module recommends creating reports to "find out how many records have missing information" (completeness) and to "check for consistency" by reviewing values.

Scroll to Top