Salesforce Data-Architecture-And-Management-Designer Exam Practice Test Instant Access

Question 1

A customer needs a sales model that allows the following:

Opportunities need to be assigned to sales people based on the zip code.

Each sales person can be assigned to multiple zip codes.

Each zip code is assigned to a sales area definition. Sales is aggregated by sales area for reporting.

What should a data architect recommend?

AAssign opportunities using list views using zip code.

BAdd custom fields in opportunities for zip code and use assignment rules.

CAllow sales users to manually assign opportunity ownership based on zip code.

DConfigure territory management feature to support opportunity assignment.

Answer : D

Question 2

UC has a roll-up summary field on Account to calculate the count of contacts associated with an account. During the account load, SF is throwing an ''Unable to lock a row'' error.

Which solution should a data architect recommend, to resolve the error?

ALeverage data loader platform API to load data.

BPerform Batch job in parallel mode and reduce Batch size

CPerform Batch job in serial mode and reduce batch size

DDefer roll-up summary fields calculation during data migration.

Answer : B

Question 3

Get Cloud Consulting needs to integrate two different systems with customer records into the Salesforce Account object. So that no duplicate records are created in Salesforce, Master Data Management will be used.

An Architect needs to determine which system is the system of record on a field level.

What should the Architect do to achieve this goal?

AMaster Data Management systems determine system of record, and the Architect doesn't have to think about what data is controlled by what system.

BKey stakeholders should review any fields that share the same purpose between systems to see how they will be used in Salesforce.

CThe database schema for each external system should be reviewed, and fields with different names should always be separate fields in Salesforce.

DAny field that is an input field in either external system will be overwritten by the last record integrated and can never have a system of record.

Answer : C

Question 4

Universal Containers (UC) is a business that works directly with individual consumers (B2C). They are moving from a current home-grown CRM system to Salesforce. UC has about one million consumer records. What should the architect recommend for optimal use of Salesforce functionality and also to avoid data loading issues?

ACreate a Custom Object Individual Consumer c to load all individual consumers.

BLoad all individual consumers as Account records and avoid using the Contact object.

CLoad one Account record and one Contact record for each individual consumer.

DCreate one Account and load individual consumers as Contacts linked to that one Account.

Answer : C

Question 5

A large insurance provider is looking to implement Salesforce. The following exist.

1. Multiple channel for lead acquisition

2. Duplication leads across channels

3. Poor customer experience and higher costs

On analysis, it found that there are duplicate leads that are resulting to mitigate the issues?

ABuild process is manually search and merge duplicates.

BStandard lead information across all channels.

CBuild a custom solution to identify and merge duplicate leads.

DImplement third-party solution to clean and event lead data.

EImplement de-duplication strategy to prevent duplicate leads

Answer : B, D, E

Question 6

DreamHouse Realty has 15 million records in the Order_c custom object. When running a bulk query, the query times out.

What should be considered to address this issue?

ATooling API

BPK Chunking

CMetadata API

DStreaming API

Answer : B

Question 7

NTO (Northern Trail Outlets) has a complex Salesforce org which has been developed over past 5 years. Internal users are complaining abt multiple data issues, including incomplete and duplicate data in the org. NTO has decided to engage a data architect to analyze and define data quality standards.

Which 3 key factors should a data architect consider while defining data quality standards? Choose 3 answers:

ADefine data duplication standards and rules

BDefine key fields in staging database for data cleansing

CMeasure data timeliness and consistency

DFinalize an extract transform load (ETL) tool for data migration

EMeasure data completeness and accuracy

Answer : A, C, E

Salesforce Data-Architecture-And-Management-Designer Data Architecture and Management Designer Exam Practice Test