Given a Customer Scenario, Recommend Approaches for Improving Data Quality Along Key Dimensions (e.g., Data Duplication, Completeness, Accuracy, Integrity Etc.) Using Various Techniques (e.g., Data Assessment/profiling, Cleansing, Standardization/normalization, Matching & Merging, Declarative Components) in Salesforce (e.g., Validation Rules, Visual Indicators, Dependent Pick Lists, Etc.). DATA-ARCHITECT Practice Questions (Page 5)

Questions 21–25

1. 21foundation · easy

   Which technique ensures that all phone numbers in a Salesforce field follow the same format, such as (555) 123-4567?

   • AStandardization
   • BDeduplication
   • CProfiling
   • DImputation
   Reveal Solution Discussion Select an answer first
2. 22foundation · easy

   What is the primary purpose of a dependent picklist in Salesforce?

   • ATo restrict the values in one picklist based on the value selected in another picklist
   • BTo validate that a field is not empty
   • CTo automatically fill in field values
   • DTo merge duplicate records
   Reveal Solution Discussion Select an answer first
4. 23application · medium

   A marketing agency uses Salesforce to manage leads. They suspect that many leads have incomplete information, such as missing industry or company size. They want to quantify the extent of the problem before deciding on a data quality initiative. Which technique should the architect recommend?

   • ARun a data profiling report that shows the percentage of leads with missing values for key fields like Industry and Company Size.
   • BCreate a validation rule that requires Industry and Company Size to be populated on all leads.
   • CCreate a visual indicator that highlights leads with missing Industry or Company Size.
   • DUse a data cleansing tool to automatically fill in missing Industry and Company Size values.
   Reveal Solution Discussion Select an answer first
5. 24foundation · easy

   What is the primary purpose of a visual indicator in Salesforce?

   • ATo merge duplicate records
   • BTo prevent invalid data entry
   • CTo draw attention to data quality issues on a record
   • DTo automatically clean data
   Reveal Solution Discussion Select an answer first
6. 25foundation · easy

   What is the primary purpose of a data audit in the context of data quality assessment?

   • ATo enforce data entry rules
   • BTo merge duplicate records
   • CTo systematically review data against defined quality criteria
   • DTo automatically correct all data errors
   Reveal Solution Discussion Select an answer first