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

Universal Containers (UC) requires 2 years of customer related cases to be available on SF for operational reporting. Any cases older than 2 years and upto 7 years need to be available on demand to the Service agents. UC creates 5 million cases per yr.
Which 2 data archiving strategies should a data architect recommend? Choose 2 options:

1. A. Use custom objects for cases older than 2 years and use nightly batch to move them.
2. B. Sync cases older than 2 years to an external database, and provide access to Service agents to the database
3. C. Use Big objects for cases older than 2 years, and use nightly batch to move them.
4. D. Use Heroku and external objects to display cases older than 2 years and bulk API to hard delete from Salesforce.

Correct Answer: CD

Universal Containers has defined a new Data Quality Plan for their Salesforce data and wants to know how they can enforce it throughout the organization. Which two approaches should an architect recommend to enforce this new plan?
Choose 2 answers

1. A. Schedule a weekly dashboard displaying records that are missing information to be sent to managers for review.
2. B. Use Workflow, Validation Rules, and Force.com code (Apex) to enforce critical business processes.
3. C. Schedule reports that will automatically catch duplicates and merge or delete the records every week.
4. D. Store all data in an external system and set up an integration to Salesforce for view -only access.

Correct Answer: AB

To avoid creating duplicate Contacts, a customer frequently uses Data Loader to upsert Contact records into Salesforce. What common error should the data architect be aware of when using upsert?

1. A. Errors with duplicate external Id values within the same CSV file.
2. B. Errors with records being updated and inserted in the same CSV file.
3. C. Errors when a duplicate Contact name is found cause upsert to fail.
4. D. Errors with using the wrong external Id will cause the load to fail.

Correct Answer: A

Universal Containers (UC) has 1,000 accounts and 50,000 opportunities. UC has an enterprise security requirement to export all sales data outside of Salesforce on a weekly basis. The security requirement also calls for exporting key operational data that includes events such as file downloads, logins, logouts, etc. Which two recommended approaches would address the above requirement?

1. A. Use Field Audit History to capture operational data and extract it to on-premise systems.
2. B. Use Weekly Export to extract transactional data to on-premise systems.
3. C. Use a custom built extract job to extract operational data to on-premise systems.
4. D. Use Event Monitoring to extract event data to on-premise systems.

Correct Answer: C

Universal Containers (UC) maintains a collection of several million Account records that represent business in the United Sates. As a logistics company, this list is one of the most valuable and important components of UC's business, and the accuracy of shipping addresses is paramount. Recently it has been noticed that too many of the addresses of these businesses are inaccurate, or the businesses don't exist. Which two scalable strategies should UC consider to improve the quality of their Account addresses?

1. A. Contact each business on the list and ask them to review and update their address information.
2. B. Build a team of employees that validate Accounts by searching the web and making phone calls.
3. C. Integrate with a third-party database or services for address validation and enrichment.
4. D. Leverage Data.com Clean to clean up Account address fields with the D&B database.

Correct Answer: CD