Free Salesforce Certified Data Architect (WI23) Exam Data-Architect Exam Practice Test

Universal Containers (UC) is implementing Salesforce and will be using Salesforce to track customer complaints, provide white papers on products, and provide subscription based support.Which license type will UC users need to fulfill UC's requirements?

• Sales Cloud License
• Lightning Platform Starter License
• Service Cloud License
• Salesforce License

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

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

Universal Containers has millions of rows of data in Salesforce that are being used in reports to evaluate historical trends. Performance has become an issue, as well as data storage limits. Which two strategies should be recommended when talking with stakeholders?

• Use scheduled batch Apex to copy aggregate information into a custom object and delete the original records.
• Combine Analytics Snapshots with a purging plan by reporting on the snapshot data and deleting the original records.
• Use Data Loader to extract data, aggregate it, and write it back to a custom object, then delete the original records.
• Configure the Salesforce Archiving feature to archive older records and remove them from the data storage limits.

Universal Containers (UC) manages Vehicle and Service History in Salesforce. Vehicle (Vehicle__ c) andService 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?

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

DreamHouse Realty has a legacy system that captures Branch Offices and Transactions. DreamHouse Realty has 15 Branch Offices. Transactions can relate to any Branch Office. DreamHouse Realty has created hundreds of thousands of Transactions per year.A Data Architect needs to denormalize this data model into a single Transaction object with a Branch Office picklist.What are two important considerations for the Data Architect in this scenario? (Choose two.)

• Standard list view in-line editing.
• Limitations on Org data storage.
• Bulk API limitations on picklist fields.
• Limitations on master-detail relationships.

Based on government regulations, a Salesforce customer plans to implement the following in Salesforce for compliance:Access to customer information based on record ownershipAbility for customers to request removal of their information from SalesforcePrevent users from accessing Salesforce from outside company network (virtual private network, or VPN)What should a data architect recommend to address these requirements?

• Contact Salesforce support to restrict access only with VPN and other requirements
• Allow users access to Salesforce through a custom web application hosted within VPN.
• Implement IP restrictions, sharing settings, and custom Apex to support customer requests.
• Implement Salesforce shield with Event Monitoring to address the requirement.

Universal Containers is exporting 40 million Account records from Salesforce using Informatica Cloud. The ETL tool fails and the query log indicates a full table scan time-out failure. What is the recommended solution?

• Modify the export job header to specify Export-in-Parallel.
• Modify the export job header to specify Sforce-Enable-PKChunking.
• Modify the export query that includes standard index fields(s).
• Modify the export query with LIMIT clause with Batch size 10,000.

Universal Containers (UC) wants to store product data in Salesforce, but the standard Product object does not support the more complex hierarchical structure which is currently being used in the product master system. How can UC modify the standard Product object model to support a hierarchical data structure in order to synchronize product data from the source system to Salesforce?

• Create a custom lookup filed on the standard Product to reference the child record in the hierarchy.
• Create a custom lookup field on the standard Product to reference the parent record in the hierarchy.
• Create a custom master-detail field on the standard Product to reference the child record in the hierarchy.
• Create an Apex trigger to synchronize the Product Family standard picklist field on the Product object.

Universal Container (US) is replacing a home grown CRM solution with Salesforce, UC has decided to migrate operational (Open and active) records to Salesforce, while keeping historical records in legacy system, UC would like historical records to be available in Salesforce on an as needed basis.Which solution should a data architect recommend to meet business requirement?

• Leverage real-time integration to pull records into Salesforce.
• Bring all data Salesforce, and delete it after a year.
• Leverage mashup to display historical records in Salesforce.
• Build a chair solution to go the legacy system and display records.

A data architect has been tasked with optimizing a data stewardship engagement for a Salesforce instance Which three areas of Salesforce should the architect review before proposing any design recommendation? Choose 3 answers

• Review the metadata xml files for redundant fields to consolidate.
• Determine if any integration points create records in Salesforce.
• Run key reports to determine what fields should be required.
• Export the setup audit trail to review what fields are being used.
• Review the sharing model to determine impact on duplicate records.