Data-Architecture-And-Management-Designer Free Practice Test

Northern Trail Outfitters (NTO) has the following systems: Customer master-source of truth for customer information Service cloud-customer support
Marketing cloud-marketing support
Enterprise data warehouse—business reporting
The customer data is duplicated across all these system and are not kept in sync. Customers are also
complaining that they get repeated marketing emails and have to call into update their information. NTO is planning to implement master data management (MDM) solution across the enterprise. Which three data will an MDM tool solve?
Choose 3 answers

1. A. Data completeness
2. B. Data loss and recovery
3. C. Data duplication
4. D. Data accuracy and quality
5. E. Data standardization

Correct Answer: CDE

UC is implementing sales cloud for patient management and would like to encrypt sensitive patient records being stored in files.
Which solution should a data architect recommend to solve this requirement?

1. A. Implement shield platform encryption to encrypt files.
2. B. Use classic encryption to encrypt files.
3. C. Implement 3rd party App Exchange app to encrypt files.
4. D. Store files outside of salesforce and access them to real time.

Correct Answer: A

Universal Containers (UC) has a Salesforce instance with over 10.000 Account records. They have noticed similar, but not identical. Account names and addresses. What should UC do to ensure proper data quality?

1. A. Use a service to standardize Account addresses, then use a 3rd -party tool to merge Accounts based on rules.
2. B. Run a report, find Accounts whose name starts with the same five characters, then merge those Accounts.
3. C. Enable Account de -duplication by creating matching rules in Salesforce, which will mass merge duplicate Accounts.
4. D. Make the Account Owner clean their Accounts' addresses, then merge Accounts with the same address.

Correct Answer: C

Universal Containers has more than 10 million records in the Order_c object. The query has timed out when running a bulk query. What should be considered to resolve query timeout?

1. A. Tooling API
2. B. PK Chunking
3. C. Metadata API
4. D. Streaming API

Correct Answer: B

Universal Containers (UC) is in the process of selling half of its company. As part of this split, UC's main Salesforce org will be divided into two org:org A and org B, UC has delivered these requirements to its data architect
* 1. The data model for Org B will drastically change with different objects, fields, and picklist values.
* 2. Three million records will need to be migrated from org A to org B for compliance reasons.
* 3. The migrate will need occur within the next two month, prior to be split.
Which migrate strategy should a data architect use to successfully migrate the date?

1. A. use as ETL tool to orchestrate the migration.
2. B. Use Data Loader for export and Data Import Wizard for import
3. C. Write a script to use the Bulk API
4. D. Use the Salesforces CLI to query, export, and import

Correct Answer: C