← Back to exam page

Data-Architecture-And-Management-Designer – Salesforce Certified Data Architecture and Management Designer (SU18)

Loading demo links...

Showing 1–3 of 15 questions

Question 1

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

Select all that apply, then click Submit answer.

  • ○

    Review the time zones of the User loading the data.

  • ○

    Remove custom indexes on the data being loaded.

  • ○

    Determine if the legacy system is still in use.

  • ○

    Defer sharing calculations of the Salesforce Org.

  • ○

    Deactivate approval processes and workflow rules.


Question 2

Universal Container (UC) has accumulated data over years and has never deleted data from its Salesforce org. UC is now exceeding the storage allocations in the org. UC is now looking for option to delete unused from the org.

Which three recommendations should a data architect make is order to reduce the number of records from the org?

Choose 3 answers

Select all that apply, then click Submit answer.

  • ○

    Use hard delete in Bulk API to permanently delete records from Salesforce.

  • ○

    Use hard delete in batch Apex to permanently delete records from Salesforce.

  • ○

    Identify records in objects that have not been modified or used In last 3 years.

  • ○

    Use Rest API to permanently delete records from the Salesforce org.

  • ○

    Archive the records in enterprise data warehouse (EDW) before deleting from
    Salesforce.


Question 3

Developers at Universal Containers need to build a report for the business which displays Accounts opened in the past year grouped by industry. This report will also include information from contacts, opportunities, and orders. There are several million Accounts in the system. Which two options should be recommended to make this report perform well and satisfy the business need?

Select all that apply, then click Submit answer.

  • ○

    Use triggers to populate denormalized related fields on the Account.

  • ○

    Use an indexed data field with bounded data filters.

  • ○

    Use Formula fields to surface information I related entities on the report.

  • ○

    Use unbounded date ranges to filter the report.