Salesforce Certified Data Architecture and Management Designer Practice Exam

Write down the full name *

Write down the phone number
*

Write down the E-mail address
*

QUESTION NO: 1 The leadership team at Get Cloudy Consulting has identified a total of ten text fields on the Contact object as critical. The team wants to capture any changes made to these fields, including the following: • who made the change • when they made the change • what is the old value • what is the new value Get Cloudy Consulting needs to be able to report on these field data changes within Salesforce for the past 3 months. Which two approaches will meet this requirement? (Choose two.)
*

1 point

A. Create a workflow to evaluate the rule when a record is created and use field update actions to store previous values for these ten fields in ten new fields.

B. Create a Contact report including these ten fields and Salesforce Id, then schedule the report to run once a day and send email to the admin.

C. Write an Apex trigger on Contact after insert event and after update events and store the old values in another custom object.

D. Turn on field Contact object history tracking for these ten fields, then create reports on contact history.

QUESTION NO: 2 Cloud Kicks often uses Data Loader to upsert Contact records into Salesforce to avoid creating duplicate Contacts. Salesforce Certified Data Architecture and Management Designer Exam Which is a common error to be aware of when using upsert?
*

1 point

A. Errors with records being updated and inserted in the same CSV file.

B. Errors with using the wrong external Id will cause the load to fail.

C. Errors when a duplicate Contact name is found cause upsert to fail.

D. Errors with duplicate external Id values within the same CSV file.

QUESTION NO: 3 Ursa Major Solar's legacy system has a quarterly accounts receivable report that compiles data from the following: - Accounts - Contacts - Opportunities - Orders - Order Line Items Which issue will an architect have when implementing this in Salesforce?
*

1 point

A. Custom report types CANNOT contain Opportunity data.

B. Salesforce does NOT support Orders or Order Line Items.

C. Salesforce does NOT allow more than four objects in a single report type.

D. A report CANNOT contain data from Accounts and Contacts.

QUESTION NO: 4 A company uses Salesforce, a cloud-based ERP system, and an on-premise Order Management System (OMS). This company requires a solution that uses Salesforce as the system of record for Leads and the OMS as the system of record for Account and Contacts. Additionally, the company wants Accounts and Contacts to be able to maintain their names in each system (i.e., ""Jane Doe""; in the OMS and ""Jannie Doe""' in Salesforce), but wants to have a consolidated data store which links referenced records across the systems. Which suggestion should the Architect provide to the company to meet this goal?
*

1 point

A. Have Salesforce poll the OMS nightly and bring in the desired Accounts and Contacts.

B. Use an integration tool to send OMS Accounts and Contacts to Salesforce.

C. Utilize the Streaming API to send Account and Contact data from Salesforce to the OMS.

D. Use a Master Data Management strategy to reconcile Leads, Accounts, and Contacts.

QUESTION NO: 5 Get Cloudy Consulting is introducing a data governance program that has a formal, crossbusiness-unit structure. The company is creating a team that will make decisions on enterprisewide data governance Which two roles are appropriate as members of this team? (Choose two.)
*

1 point

A. Data Domain Stewards

B. Analytics/BI Owners

C. Salesforce Administrators

D. Operational Data Users

QUESTION NO: 6 Two million Opportunities need to be loaded in different batches into Salesforce using the Bulk API in parallel mode. What should an Architect consider when loading the Opportunity records?
*

1 point

A. Use the Name field values to sort batches.

B. Order batches by Auto-number field.

C. Create indexes on Opportunity object text fields.

D. Group batches by the AccountId field.

QUESTION NO: 7 Ursa Major Solar has defined a new Data Quality Plan for their Salesforce data. Which two approaches should an Architect recommend to enforce the plan throughout the organization? (Choose two.)
*

1 point

A. Ensure all data is stored in an external system and set up an integration to Salesforce for viewonly access.

B. Schedule reports that will automatically catch duplicates and merge or delete the records every week.

C. Enforce critical business processes by using Workflow, Validation Rules, and Apex code.

D. Schedule a weekly dashboard displaying records that are missing information to be sent to managers for review.

QUESTION NO: 8 Get Cloudy Consulting uses Salesforce for tracking opportunities (Opportunity) and currently has the following environment: • An internal ERP system is in place for tracking services and invoicing. • The ERP system supports SOAP API and CData for bi-directional integration between Salesforce and the ERP system. • 950,000 opportunities exist; for each opportunity, the company sends one invoice per month during a 12-month period. Get Cloudy Consulting sales reps must view current invoice status and invoice amount from the opportunity page. When creating an object to model invoices, what should the Architect suggest, considering performance and data storage space?
*

1 point

A. Create an external object Invoice_x with a Lookup relationship with Opportunity.

B. Create a custom object Invoice_c with a Lookup relationship with Opportunity.

C. Retrieve the current status from the ERP by using Streaming API, and display on the Opportunity page.

D. Create a custom object Invoice_c with a master-detail relationship with Opportunity.

QUESTION NO: 9 Universal Containers has a custom object with millions of rows of data. When executing SOQL queries, which three options prevent a query from being selective? (Choose three.)
*

1 point

A. Utilizing NOT and != operators.

B. Utilizing a custom index on a deterministic formula field.

C. Using leading % wildcards.

D. Performing large loads and deletions.

E. Using trailing % wildcards.

QUESTION NO: 10 Get Cloudy Consulting has the following environment: • All accounts and opportunities are created in Salesforce. • Salesforce is integrated with three systems: - An ERP system feeds order data into Salesforce and updates both Account and Opportunity records. - An accounting system feeds invoice data into Salesforce and updates both Account and Opportunity records. - A commission system feeds commission data into Salesforce and updates both Account and Opportunity records. How should an Architect determine which of these systems is the system of record?
*

1 point

A. Account and opportunity data originates in Salesforce, and therefore Salesforce is the system of record.

B. By default, the system of record is determined by the last integration process that runs.

C. Whichever system updates the attribute or object should be the system of record for that field or object.

D. Data flows should be reviewed with the business users to determine the system of record per object or field.