Salesforce Certified Data Architect — Question 44

Northern Trail Outfitters has implemented Salesforce for its sales associates nationwide. Senior management is concerned that the executive dashboards are not reliable for their real-time decision-making. On analysis, the team found the following issues with data entered in
Salesforce:
1. Information in certain records is incomplete.
2. Incorrect entry in certain fields causes records to be excluded in report filters.
3. Duplicate entries cause incorrect counts.
Which three steps should a data architect recommend to address the issues? (Choose three.)

Answer options

• A. Explore third-party data providers to enrich and augment information entered in Salesforce.
• B. Build a sales data warehouse with purpose-built data marts for dashboards and senior management reporting.
• C. Design and implement data-quality dashboard to monitor and act on records that are incomplete or incorrect.
• D. Periodically export data to cleanse data and import them back into Salesforce for executive reports.
• E. Leverage Salesforce features, such as validation rules, to avoid incomplete and incorrect records.

Correct answer: A, C, E

Explanation

The correct answers are A, C, and E because they directly address the data quality issues identified. Option A helps to enrich data that may be lacking, option C provides ongoing monitoring and management of data quality, and option E utilizes Salesforce's built-in features to prevent errors at the point of entry. Option B, while potentially useful, does not directly resolve the immediate data quality problems, and option D is a reactive approach rather than a proactive solution.