Which scenario is an example of a data integrity issue?

Two Account records exist for the same company with different names

A Lead record has a null value in the Company field

A Case record is associated with a Contact that has been deleted, leaving an orphaned reference

A Contact record has a phone number that is not in the correct format

What is the most likely business impact of incomplete data in a customer database?

Increased risk of duplicate records being created

Inability to fully segment and target customers for marketing campaigns

Improved data integrity due to fewer populated fields

Higher likelihood of data being inaccurate

A company has a Salesforce org with a custom object 'Project' that has a 'Project Manager' field. They find that the field is blank on 30% of records. The company wants to improve data completeness, but they are concerned that making the field required will block users from creating records in certain scenarios. Which approach is MOST appropriate to improve completeness without blocking record creation?

Make the field required on the page layout

Use a validation rule that requires the field only when the record is in a certain status

Use a workflow rule to populate the field with a default value

Leave the field as is and accept the incompleteness

SalesforceCertified Data Architect

Domain 2Objective 1

Given a Customer Scenario, Identify the Issues Impacting Data Quality Along Key Dimensions (such as Data Duplication, Completeness, Accuracy, Integrity, Etc.). DATA-ARCHITECT Practice Questions (Page 3)

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

20questions here

4free pages

6concepts

15%of the exam

Questions 11–15

11foundation · easy
Which scenario is an example of a data integrity issue?
Select an answer first
12foundation · easy
What is the most likely business impact of incomplete data in a customer database?
Select an answer first
13expert · hard
A company has a Salesforce org with a custom object 'Project' that has a 'Project Manager' field. They find that the field is blank on 30% of records. The company wants to improve data completeness, but they are concerned that making the field required will block users from creating records in certain scenarios. Which approach is MOST appropriate to improve completeness without blocking record creation?
Select an answer first
14foundation · easy
A data architect is comparing a list of customer email addresses in Salesforce against the company's official CRM source of truth. What data quality dimension is being evaluated?
Select an answer first
15foundation · easy
A data architect notices that many Lead records have a null value in the Phone field. Which data quality dimension is most directly affected?
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.

Given a Customer Scenario, Identify the Issues Impacting Data Quality Along Key Dimensions (such as Data Duplication, Completeness, Accuracy, Integrity, Etc.). DATA-ARCHITECT Practice Questions (Page 3)

Questions 11–15

Which scenario is an example of a data integrity issue?

What is the most likely business impact of incomplete data in a customer database?

A data architect is comparing a list of customer email addresses in Salesforce against the company's official CRM source of truth. What data quality dimension is being evaluated?

A data architect notices that many Lead records have a null value in the Phone field. Which data quality dimension is most directly affected?

Keep studying — CONCEPTUAL DESIGN