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

Universal Containers is setting up an external Business Intelligence (BI) system and wants to extract 1,000,000 Contact records. What should be recommended to avoid timeouts during the export process?

• Use the SOAP API to export data.
• Utilize the Bulk API to export the data.
• Use GZIP compression to export the data.
• Schedule a Batch Apex job to export the data.

UC migrating 100,000 Accounts from an enterprise resource planning (ERP) to salesforce and is concerned about ownership skew and performance.Which 3 recommendations should a data architect provide to prevent ownership skew?Choose 3 answers:

• Assigned a default user as owner of accounts, and assign role in hierarchy.
• Keep users out of public groups that can be used as the source for sharing rules.
• Assign a default user as owner of account and do not assign any role to default user.
• Assign ''view all'' permission on profile to give access to account.
• Assign a default user as owner of accounts and assigned top most role in hierarchy.

Universal Containers (UC) is transitioning from Classic to Lightning Experience.What does UC need to do to ensure users have access to its notices and attachments in Lightning Experience?

• Add Notes and Attachments Related List to page Layout in Lighting Experience.
• Manually upload Notes in Lighting Experience.
• Migrate Notes and Attachment to Enhanced Notes and Files a migration tool
• Manually upload Attachments in Lighting Experience.

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?

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

The data architect for UC has written a SOQL query that will return all records from the Task object that do not have a value in the WhatId field:Select id, description, Subject from Task where WhatId != NULLWhen the data architect usages the query to select values for a process a time out error occurs.What does the data architect need to change to make this query more performant?

• Remove description from the requested field set.
• Change query to SOSL. ??
• Add limit 100 to the query.
• Change the where clause to filter by a deterministic defined value.

Universal Containers has a rollup summary field on account to calculate the number of contacts associated with an account. During the account load, Salesforce is throwing an 'UNABLE _TO_LOCK_ROW' error.Which solution should a data architect recommend to resolve the error?

• Defer rollup summary field calculation during data migration.
• Perform a batch job in serial mode and reduce the batch size.
• Perform a batch job in parallel mode and reduce the batch size.
• Leverage Data Loader's platform API to load data.

Universal Containers (UC) has deployed Salesforce to manage Marketing. Sales, and Support efforts in a multi -system ERP environment After reaching the limits of native reports & dashboards. UC leadership is looking to understand what options can be used to provide more analytical insights. What two approaches should an architect recommend? Choose 2 answers

• AppExchange Apps
• Wave Analytics
• Weekly Snapshots
• Setup Audit Trails

Universal Containers wants to develop a dashboard in Salesforce that will allow Sales Managers to do data exploration using their mobile device (i.e., drill down into sales-related data) and have the possibility of adding ad-hoc filters while on the move. What is a recommended solution for building data exploration dashboards in Salesforce?

• Create a Dashboard in an external reporting tool, export data to the tool, and add link to the dashboard in Salesforce.
• Create a Dashboard in an external reporting tool, export data to the tool, and embed the dashboard in Salesforce using the Canval toolkit.
• Create a standard Salesforce Dashboard and connect it to reports with the appropriate filters.
• Create a Dashboard using Analytics Cloud that will allow the user to create ad-hoc lenses and drill down.

What makes Skinny tables fast? Choose three answers.

• They do not include soft-deleted records
• They avoid resource intensive joins
• Their tables are kept in sync with their source tables when the source tables are modified
• They can contain fields from other objects
• They support up to a max of 100 of columns

Universal Containers has a public website with several forms that create Lead records in Salesforce using the REST API. When designing these forms, which two techniques will help maintain a high level of data quality?

• Do client-side validation of phone number and email field formats.
• Prefer picklist form fields over free text fields, where possible.
• Ensure the website visitor is browsing using an HTTPS connection.
• Use cookies to track when visitors submit multiple forms.