Salesforce Data-Architecture-And-Management-Designer Exam Questions Instant Access

Question 1

For a production cutover, a large number of Account records will be loaded into Salesforce from a legacy system. The legacy system does not have enough information to determine the Ownership for these Accounts upon initial load. Which two recommended options assign Account ownership to mitigate potential performance problems?

ALet a ''system user'' own all the Account records without assigning any role to this user in Role Hierarchy.

BLet a ''system user'' own the Account records and assign this user to the lowest-level role in the Role Hierarchy.

CLet the VP of the Sales department, who will report directly to the senior VP, own all the Account records.

DLet a ''system user'' own all the Account records and make this user part of the highest-level role in the Role Hierarchy.

Answer : A, B

Question 2

Universal Containers (UC) is facing data quality issues where Sales Reps are creating duplicate customer accounts, contacts, and leads. UC wants to fix this issue immediately by prompting users about a record that possibly exists in Salesforce. UC wants a report regarding duplicate records. What would be the recommended approach to help UC start immediately?

ACreate an after insert and update trigger on the account, contact and lead, and send an error if a duplicate is found using a custom matching criteria.

BCreate a duplicate rule for account, lead, and contact, use standard matching rules for these objects, and set the action to report and alert for both creates and edits.

CCreate a duplicate rule for account, lead, and contact, use standard matching rules for these objects, and set the action to block for both creates and edits.

DCreate a before insert and update trigger on account, contact, and lead, and send an error if a duplicate is found using a custom matching criteria.

Answer : B

Question 3

Due to security requirements, Universal Containers needs to capture specific user actions, such as login, logout, file attachment download, package install, etc. What is the recommended approach for defining a solution for this requirement?

AUse a field audit trail to capture field changes.

BUse a custom object and trigger to capture changes.

CUse Event Monitoring to capture these changes.

DUse a third-party AppExchange app to capture changes.

Answer : C

Question 4

NTO processes orders from its website via an order management system (OMS). The OMS stores over 2 million historical records and is currently not integrated with SF. The Sales team at NTO using Sales cloud and would like visibility into related customer orders yet they do not want to persist millions of records directly in Salesforce. NTO has asked the data architect to evaluate SF connect and the concept of data verification. Which 3 considerations are needed prior to a SF Connect implementation?

Choose 3 answers:

ACreate a 2nd system Admin user for authentication to the external source.

BDevelop an object relationship strategy.

CIdentify the external tables to sync into external objects

DAssess whether the external data source is reachable via an ODATA endpoint.

EConfigure a middleware tool to poll external table data

Answer : B, C, D

Question 5

Universal Containers (UC) has users complaining about reports timing out or simply taking too long to run What two actions should the data architect recommend to improve the reporting experience? Choose 2 answers

AIndex key fields used in report criteria.

BEnable Divisions for large data objects.

CCreate one skinny table per report.

DShare each report with fewer users.

Answer : A, C

Question 6

Which three characteristics of a Skinny table help improve report and query performance?

ASkinny tables can contain frequently used fields and thereby help avoid joins.

BSkinny tables can be used to create custom indexes on multi-select picklist fields.

CSkinny tables provide a view across multiple objects for easy access to combined data.

DSkinny tables are kept in sync with changes to data in the source tables.

ESkinny tables do not include records that are available in the recycle bin.

Answer : A, C, D

Question 7

What 2 data management policies does the data classification feature allow customers to classify in salesforce? Choose 2 answers:

AReference data policy.

BData governance policy.

CData sensitivity policy.

DCompliance categorization policy.

Answer : C, D

Salesforce Data Architecture and Management Designer Data-Architecture-And-Management-Designer Exam Questions