A telecommunications company has a large number of duplicate Contact records due to customers using different email addresses and phone numbers over time. The data architect needs to reduce duplicates while ensuring that the merged record retains the most recent contact information and that no active service subscriptions are lost. Which approach should the architect recommend?

Create a validation rule that prevents duplicate email addresses, and then manually merge all contacts that have the same name.

Use a matching rule based on a combination of first name, last name, and phone number to identify potential duplicates, then use the merge tool to merge them, selecting the record with the most recent activity as the master.

Delete all duplicate contacts that have no active service subscriptions, and keep only one record per customer.

Use a data cleansing tool to standardize all phone numbers, and then rely on the duplicate report to manually merge each pair.

Which activity is a primary technique used in data profiling to identify data quality issues?

Analyzing data patterns and distributions

Configuring dependent picklists

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

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 11–15

11foundation · easy
Which data quality dimension is most directly concerned with whether all required data is present in a record?
Select an answer first
12expert · hard
A telecommunications company has a large number of duplicate Contact records due to customers using different email addresses and phone numbers over time. The data architect needs to reduce duplicates while ensuring that the merged record retains the most recent contact information and that no active service subscriptions are lost. Which approach should the architect recommend?
Select an answer first
13foundation · easy
A data steward needs to correct a systematic error where the country field contains 'USA' instead of 'United States'. Which cleansing technique is most appropriate?
Select an answer first
14foundation · easy
A data architect notices that the same customer appears multiple times in the Account object with slightly different names. Which data quality dimension is most directly affected?
Select an answer first
15foundation · easy
Which activity is a primary technique used in data profiling to identify data quality issues?
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 11–15

Which data quality dimension is most directly concerned with whether all required data is present in a record?

A data steward needs to correct a systematic error where the country field contains 'USA' instead of 'United States'. Which cleansing technique is most appropriate?

A data architect notices that the same customer appears multiple times in the Account object with slightly different names. Which data quality dimension is most directly affected?

Which activity is a primary technique used in data profiling to identify data quality issues?

Keep studying — CONCEPTUAL DESIGN