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 questionsThe 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.
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.
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.
Keep practicing
Take the free DATA-ARCHITECT practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other DATA-ARCHITECT practice questions
- Question 1Which three characteristics of a skinny table help improve report and query performance?
- Question 2Universal Containers (UC) has built a custom application on Salesforce to help track ship…
- Question 3Universal Containers (UC) has lead assignment rules to assign leads to owners. Leads not …
- Question 4Universal Container (UC) has accumulated data over years and has never deleted data from …
- Question 5Universals Containers’ system administrators have been complaining that they are not able…
- Question 6Universal Containers is experiencing frequent and persistent group membership locking iss…
