Online Access Free Data-Architect Practice Test

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

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

Universal Containers (UC) owns several Salesforce orgs across a variety of business units. UC management has declared that it needs the ability to report on Accounts and Opportunities from each org in one place.
Once the data is brought together into a global view, management would like to use advanced Al-driven analytics on the dataset.
Which tool should a data architect recommend to accomplish this reporting requirement?

• A.Run standard reports and dashboards.
• B.Install a third-party AppExchange tool for multi-org reporting.
• C.Use Einstein Analytics for multi-org.
• D.Write a Python script to aggregate and visualize the data.

Universal Containers (UC) manages Vehicle and Service History in Salesforce. Vehicle (Vehicle__ c) and Service History (Service-History__ c) are both custom objects related through a lookup relationship.
Every week a batch synchronization process updates the Vehicle and Service History records in Salesforce.
UC has two hours of migration window every week and is facing locking issues as part of the data migration process.
What should a data architect recommend to avoid locking issues without affecting performance of data migration?

• A.Insert the order in another custom object and use Batch Apex to move the records to Service_ Order__ c object.
• B.Use Bulk API parallel mode for data migration
• C.Use Bulk API serial mode for data migration
• D.Change the lookup configuration to " Clear the value of this field " when lookup record is deleted.

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?

• A.Defer roll-up summary fields calculation during data migration.
• B.Leverage data loader platform API to load data.
• C.Perform Batch job in parallel mode and reduce Batch size
• D.Perform Batch job in serial mode and reduce batch size

UC is migrating data from legacy system to SF. UC would like to preserve the following information on records being migrated:
* Date time stamps for created date and last modified date.
* Ownership of records belonging to inactive users being migrated to Salesforce.
Which 2 solutions should a data architect recommends to preserve the date timestamps and ownership on records? Choose 2 answers.

• A.Enable Set Audit fields upon Record Creation Permission
• B.Enable update records with Inactive Owners Permission
• C.Enable modify all and view all permission.
• D.Log a case with SF to update these fields