A customer is facing locking issued when importing large data volumes of order records that are children in a master-detail relationship with the Account object. What is the recommended way to avoid locking issues during import?

• A.Import Account records first followed by order records after sorting orders by AccountID.
• B.Import Order records and Account records separately and populate AccountID in orders using batch Apex.
• C.Change the relationship to Lookup and update the relationship to master-detail after import.
• D.Import Account records first followed by order records after sorting order by OrderID.

Comment: *

Name: *

Email: *

Verification: *

The architect is planning a large data migration for Universal Containers from their legacy CRM system to Salesforce. What three things should the architect consider to optimize performance of the data migration?
Choose 3 answers

• A.Defer sharing calculations of the Salesforce Org.
• B.Remove custom indexes on the data being loaded.
• C.Deactivate approval processes and workflow rules.
• D.Review the time zones of the User loading the data.
• E.Determine if the legacy system is still in use.

Comment: *

Name: *

Email: *

Verification: *

A large retail company has recently chosen SF as its CRM solution. They have the following record counts:
2500000 accounts
25000000 contacts
When doing an initial performance test, the data architect noticed an extremely slow response for reports and list views.
What should a data architect do to solve the performance issue?

• A.Create a skinny table to represent account and contact objects.
• B.Add custom indexes on frequently searched account and contact objects fields
• C.Limit data loading to the 2000 most recently created records.
• D.Load only the data that the users is permitted to access

Comment: *

Name: *

Email: *

Verification: *

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?

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

Comment: *

Name: *

Email: *

Verification: *

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 != NULL
When 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?

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

Comment: *

Name: *

Email: *

Verification: *