← Back to exam page

Certified-Data-Architecture-and-Management-Designer – Certified Data Architecture and Management Designer

Loading demo links...

Showing 1–3 of 15 questions

Question 1

UC is rolling out Sales App globally to bring sales teams together on one platform. UC expects millions of opportunities and accounts to be creates and is concerned about the performance of the application.

Which 3 recommendations should the data architect make to avoid the data skew? Choose

3 answers.

Select all that apply, then click Submit answer.

  • ○

    Use picklist fields rather than lookup to custom object.

  • ○

    Limit assigning one user 10000 records ownership.

  • ○

    Assign 10000 opportunities to one account.

  • ○

    Limit associating 10000 opportunities to one account.

  • ○

    Limit associating 10000 records looking up to same records.


Question 2

Northern Trail Outfitters (NTO) has the following systems:

Customer master-source of truth for customer information

Service cloud-customer support

Marketing cloud-marketing support

Enterprise data warehouse—business reporting

The customer data is duplicated across all these system and are not kept in sync. Customers are also complaining that they get repeated marketing emails and have to call into update their information.

NTO is planning to implement master data management (MDM) solution across the enterprise.

Which three data will an MDM tool solve?

Choose 3 answers

Select all that apply, then click Submit answer.

  • ○

    Data completeness

  • ○

    Data loss and recovery

  • ○

    Data duplication

  • ○

    Data accuracy and quality

  • ○

    Data standardization


Question 3

Get Cloudy Consulting is migrating their legacy system's users and data to Salesforce. They will be creating 15,000 users, 1.5 million Account records, and 15 million Invoice records. The visibility of these records is controlled by a 50 owner and criteria-based sharing rules.

Get Cloudy Consulting needs to minimize data loading time during this migration to a new organization.

Which two approaches will accomplish this goal? (Choose two.)

Select all that apply, then click Submit answer.

  • ○

    Create the users, upload all data, and then deploy the sharing rules.

  • ○

    Contact Salesforce to activate indexing before uploading the data.

  • ○

    First, load all account records, and then load all user records.

  • ○

    Defer sharing calculations until the data has finished uploading.