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

Question 1

DreamHouse Realty has an integration that creates records in a Salesforce Custom Object. The Custom Object has a field marked as required on the page layout.

DreamHouse Realty has noticed that many of the records coming from the external system are missing data in this field.

The Architect needs to ensure this field always contains data coming from the source system.

Which two approaches should the Architect take? Choose 2 answers

ASet up a Validation Rule to prevent blank values.

BCreate a Workflow to default a value into this field.

CMark the field required in setup at the field level.

DBlame the customer's external system for bad data.

Answer : A, C

Question 2

NTO need to extract 50 million records from a custom object everyday from its Salesforce org. NTO is facing query timeout issues while extracting these records.

What should a data architect recommend in order to get around the time out issue?

AUse a custom auto number and formula field and use that to chunk records while extracting data.

BThe REST API to extract data as it automatically chunks records by 200.

CUse ETL tool for extraction of records.

DAsk SF support to increase the query timeout value.

Answer : C

Question 3

Universal Container (UC) has around 200,000 Customers (stored in Account object). They get 1 or 2 Orders every month from each Customer. Orders are stored in a custom object called "Order c"; this has about 50 fields. UC is expecting a growth of 10% year -over -year. What are two considerations an architect should consider to improve the performance of SOQL queries that retrieve data from the Order _c object? Choose 2 answers

AUse SOQL queries without WHERE conditions.

BWork with Salesforce Support to enable Skinny Tables.

CReduce the number of triggers on Order _c object.

DMake the queries more selective using indexed fields.

Answer : B, D

Question 4

Ursa Major Solar has defined a new Data Quality Plan for their Salesforce data.

Which two approaches should an Architect recommend to enforce the plan throughout the organization? (Choose two.)

AEnsure all data is stored in an external system and set up an integration to Salesforce for view-only access.

BSchedule reports that will automatically catch duplicates and merge or delete the records every week.

CEnforce critical business processes by using Workflow, Validation Rules, and Apex code.

DSchedule a weekly dashboard displaying records that are missing information to be sent to managers for review.

Answer : C, D

Question 5

Cloud Kicks stores Invoice records in a custom object. Invoice records are being sent to the Accounting department with missing States and incorrectly formatted Postal Codes.

Which two actions should Cloud Kicks take to improve data quality? (Choose two.)

AChange each address field to required on the Page Layout.

BWrite an Apex Trigger to require all fields to be populated.

CUtilize a Validation Rule with a REGEX operator on Postal Code.

DUtilize a Validation Rule with a CONTAINS operator on address fields.

Answer : C, D

Question 6

Get Cloudy Consulting is migrating their legacy system's users and data to Salesforce. They will be creating 15,000 users, 1.5 million Account records, and 15 million Invoice records. The visibility of these records is controlled by a 50 owner and criteria-based sharing rules.

Get Cloudy Consulting needs to minimize data loading time during this migration to a new organization.

Which two approaches will accomplish this goal? (Choose two.)

ACreate the users, upload all data, and then deploy the sharing rules.

BContact Salesforce to activate indexing before uploading the data.

CFirst, load all account records, and then load all user records.

DDefer sharing calculations until the data has finished uploading.

Answer : A, D

Question 7

UC has a variety of systems across its technology landscape, including SF, legacy enterprise resource planning (ERP) applications and homegrown CRM tools. UC has decided that they would like to consolidate all customer, opportunity and order data into Salesforce as part of its master data management (MDM) strategy.

What are the 3 key steps that a data architect should take when merging data from multiple systems into Salesforce? Choose 3 answers:

ACreate new fields to store additional values from all the systems.

BInstall a 3rd party AppExchange tool to handle the merger

CAnalyze each system's data model and perform gap analysis

DUtilize an ETL tool to merge, transform and de-duplicate data.

EWork with Stakeholders to define record and field survivorship rules

Answer : C, D, E

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