A sales team uses Salesforce to track leads. They want to quickly identify leads that have not been contacted in over 30 days, so they can prioritize follow-up. Which declarative solution should the architect recommend?

Create a dependent picklist on the Lead object to show a 'Follow-up Needed' option when the last activity is old.

Create a validation rule that prevents saving a lead if the last activity date is more than 30 days old.

Create a workflow rule that automatically deletes leads with no activity in 30 days.

Create a formula field that calculates the number of days since the last activity, and use a color rule on the field to highlight leads with more than 30 days.

What is the primary goal of data normalization in the context of data quality?

To increase the number of records

To reduce data redundancy and improve consistency

To delete all duplicate records

A healthcare provider uses Salesforce to manage patient records. They want to assess the accuracy of the data by comparing it to an external source of truth. Which technique should the architect recommend?

Run a data audit that compares a sample of records in Salesforce to the external source and calculates the percentage of mismatches.

Create a visual indicator that highlights records that may be inaccurate.

Use a data cleansing tool to automatically correct all mismatches.

Create a validation rule that checks if the data matches the external source.

A nonprofit organization uses Salesforce to track donations. They want to ensure that donation amounts are positive and that the donation date is not in the future. Which declarative solution should the architect recommend?

Create a validation rule on the Donation object that checks if Amount TODAY().

Create a workflow rule that sends an email alert to the user when the amount is negative or the date is in the future.

Create a formula field that displays a warning icon when the amount is negative, and rely on users to correct it.

Use a dependent picklist on the Donation object to restrict the amount to a predefined list of values.

SalesforceCertified Data Architect

Domain 2Objective 2

normalization, Matching & Merging, Declarative Components) in Salesforce (e.g., Validation Rules, Visual Indicators, Dependent Pick Lists, Etc.). DATA-ARCHITECT Practice Questions (Page 2)

Part of the CONCEPTUAL DESIGN domain, which accounts for 15% of the DATA-ARCHITECT exam.

30questions here

6free pages

10concepts

15%of the exam

10 Concepts in This Objective

Data Quality Dimensions
Data Assessment and Profiling
Data Cleansing Techniques
Data Standardization and Normalization
Matching and Merging Strategies
Declarative Components for Data Quality
Validation Rules
Visual Indicators
Dependent Picklists
Improving Data Quality in Scenarios

Questions 6–10

6application · medium
A sales team uses Salesforce to track leads. They want to quickly identify leads that have not been contacted in over 30 days, so they can prioritize follow-up. Which declarative solution should the architect recommend?
Select an answer first
7foundation · easy
What is the primary goal of data normalization in the context of data quality?
Select an answer first
8application · medium
A healthcare provider uses Salesforce to manage patient records. They want to assess the accuracy of the data by comparing it to an external source of truth. Which technique should the architect recommend?
Select an answer first
9application · medium
A nonprofit organization uses Salesforce to track donations. They want to ensure that donation amounts are positive and that the donation date is not in the future. Which declarative solution should the architect recommend?
Select an answer first
10foundation · easy
Which data cleansing technique is most appropriate for handling missing values in a Salesforce field?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to DATA-ARCHITECT

Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by Salesforce. “DATA-ARCHITECT” is a trademark of its owner, used for identification only.

Questions 6–10

A sales team uses Salesforce to track leads. They want to quickly identify leads that have not been contacted in over 30 days, so they can prioritize follow-up. Which declarative solution should the architect recommend?

What is the primary goal of data normalization in the context of data quality?

A healthcare provider uses Salesforce to manage patient records. They want to assess the accuracy of the data by comparing it to an external source of truth. Which technique should the architect recommend?

A nonprofit organization uses Salesforce to track donations. They want to ensure that donation amounts are positive and that the donation date is not in the future. Which declarative solution should the architect recommend?

Which data cleansing technique is most appropriate for handling missing values in a Salesforce field?

Keep studying — CONCEPTUAL DESIGN