Given a Customer Scenario, Recommend Appropriate Techniques and Tools to Monitor Data Quality on an Ongoing Basis (e.g., KPIs, Data Quality Reports, Dashboards, Metrics, Third-Party Solutions). DATA-ARCHITECT Practice Questions (Page 2)

Questions 6–10

1. 6foundation · easy

   A data architect wants to measure how current the data in a Salesforce org is by tracking the age of records since their last update. Which data quality dimension does this metric address?

   • AAccuracy
   • BConsistency
   • CTimeliness
   • DValidity
   Reveal Solution Discussion Select an answer first
2. 7application · medium

   A retail company wants to monitor data quality across their customer records. They have identified three key metrics: completeness of email addresses, validity of phone numbers, and consistency of country codes. They want a single view that shows all three metrics and allows drill-down to see underlying records. What should a data architect recommend?

   • ACreate a single report that includes all three metrics as columns.
   • BCreate a dashboard with three report components, each showing one metric, and make the components drillable to the underlying reports.
   • CUse a third-party tool to generate a data quality scorecard.
   • DCreate three separate dashboards, one for each metric.
   Reveal Solution Discussion Select an answer first
4. 8foundation · easy

   What is the primary purpose of a data quality dashboard in Salesforce?

   • ATo visualize data quality metrics for ongoing monitoring
   • BTo replace the need for data quality reports
   • CTo automatically correct data quality issues
   • DTo enforce data validation rules
   Reveal Solution Discussion Select an answer first
5. 9foundation · easy

   A data architect wants to create a report that shows the number of Account records missing a Billing Address. Which report type should be used to achieve this?

   • ACampaigns with Accounts
   • BAccounts with Contacts
   • CAccounts with Opportunities
   • DAccounts
   Reveal Solution Discussion Select an answer first
6. 10expert · hard

   A data architect is tasked with designing an ongoing data quality monitoring solution for a large insurance company. The company has the following requirements: - Monitor completeness of policy numbers and validity of email addresses. - Provide a weekly summary to the operations manager. - Allow the data quality team to drill into records that fail validation. - Minimize the number of custom objects. - The company uses Salesforce natively and does not want to purchase third-party tools. Which approach best meets these requirements?

   • ACreate a single report that lists all records with missing policy numbers or invalid emails.
   • BUse a third-party data quality tool to monitor and alert.
   • CCreate reports with formula fields for completeness and validity, and a dashboard with drillable components.
   • DCreate a custom object to store data quality scores and build reports from it.
   Reveal Solution Discussion Select an answer first