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 3)

Questions 11–15

1. 11application · medium

   A sales operations manager wants to monitor data quality on an ongoing basis. The team has a weekly cadence to review key metrics, and the manager wants a visual overview that can be shared with executives. The data quality issues are primarily around incomplete fields and duplicate accounts. Which approach should a data architect recommend?

   • ACreate a dashboard with tiles for completeness and uniqueness KPIs, and schedule a weekly email to executives.
   • BBuild a custom report for each data quality metric and share the report links in a weekly email.
   • CImplement a third-party data quality tool to automatically clean incomplete fields and merge duplicates.
   • DRun a weekly data export and analyze the data in a spreadsheet to identify trends.
   Reveal Solution Discussion Select an answer first
2. 12application · medium

   A nonprofit organization tracks donor records. They want to measure how many donor records have a valid email address and how many have a valid phone number. They also want to see these metrics side by side for each campaign. What should a data architect recommend?

   • ACreate a dashboard with two separate reports, one for email validity and one for phone validity.
   • BUse a third-party tool to validate email and phone formats in real time.
   • CCreate a custom object to store email and phone validity scores.
   • DCreate a report with formula fields to calculate email and phone validity, grouped by campaign.
   Reveal Solution Discussion Select an answer first
4. 13application · medium

   A manufacturing company has a data quality issue with duplicate supplier records. They have tried using standard Salesforce duplicate rules, but the duplicates are not exact matches (e.g., 'Acme Corp' vs 'Acme Corporation'). They need a solution that can identify these fuzzy duplicates and merge them. What should a data architect recommend?

   • AImplement a third-party data quality tool that supports fuzzy matching and merging.
   • BManually review all supplier records to identify duplicates.
   • CCreate a custom Apex class to find fuzzy duplicates and merge them.
   • DUse Salesforce duplicate rules with a custom matching rule that includes partial matching.
   Reveal Solution Discussion Select an answer first
5. 14expert · hard

   A data architect is evaluating options for ongoing data quality monitoring for a retail chain. The company has a limited budget and a small IT team. They need to monitor data quality of customer records, including completeness, validity, and uniqueness. They also want to receive alerts when data quality drops below a certain threshold. The company currently uses Salesforce and has no other data platforms. Which solution should the data architect recommend?

   • AUse Salesforce CRM Analytics to build a data quality dashboard and set up alerts.
   • BBuild a custom Apex solution to monitor data quality and send alerts.
   • CUse native Salesforce reports and dashboards, and set up scheduled email alerts for key metrics.
   • DImplement a third-party data quality tool that provides advanced monitoring and alerting.
   Reveal Solution Discussion Select an answer first
6. 15application · medium

   A financial services company needs to ensure that all account records have a valid tax ID and that the tax ID is unique across the system. They also want to know how many records are missing the tax ID. Which metrics should a data architect include in a data quality report?

   • AValidity (format check) and uniqueness (duplicate count) of tax ID, plus completeness (missing count).
   • BCompleteness (missing count) and accuracy (compare to external source).
   • CAccuracy (compare to external source) and timeliness (last update date).
   • DConsistency (same format across records) and validity (format check).
   Reveal Solution Discussion Select an answer first