Summer Sale - Special Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: dpt65

Data-Architecture-And-Management-Designer Questions and Answers

Note! Following Data-Architecture-And-Management-Designer Exam is Retired now. Please select the alternative replacement for your Exam Certification. The new exam code is Data-Architect

Data-Architecture-And-Management-Designer Questions and Answers

Question # 6

Universal Container require all customers to provide either a phone number of an email address when registering for an account.

What should the data architect use to ensure this requirement is met?

A.

validation Rule

B.

required Fields

C.

Apex Class

D.

Process Builder

Full Access
Question # 7

Universal Containers (UC) hasa Salesforce instance with over 10.000 Account records. They have noticed similar, but not identical. Account names and addresses. What should UC do to ensure proper data quality?

A.

Use a service to standardize Account addresses, then use a 3rd -party tool to merge Accounts based on rules.

B.

Run a report, find Accounts whose name starts with the same five characters, then merge those Accounts.

C.

Enable Account de -duplication by creating matching rules in Salesforce, which will mass merge duplicate Accounts.

D.

Make the Account Owner clean their Accounts' addresses, then merge Accounts with the same address.

Full Access
Question # 8

A manager at Cloud Kicks is importing Leads into Salesforce and needs to avoid creating duplicate records.

Which two approaches should the manager take to achievethis goal? (Choose two.)

A.

Acquire an AppExchange Lead de-duplication application.

B.

Implement Salesforce Matching and Duplicate Rules.

C.

Run the Salesforce Lead Mass de-duplication tool.

D.

Create a Workflow Rule to check for duplicate records.

Full Access
Question # 9

Universal Containers (UC) is a business that works directly with individualconsumers (B2C). They are moving from a current home-grown CRM system to Salesforce. UC has about one million consumer records. What should the architect recommend for optimal use of Salesforce functionality and also to avoid data loading issues?

A.

Create a Custom Object Individual Consumer c to load all individual consumers.

B.

Load all individual consumers as Account records and avoid using the Contact object.

C.

Load one Account record and one Contact record for each individual consumer.

D.

Create oneAccount and load individual consumers as Contacts linked to that one Account.

Full Access
Question # 10

Universal Containers (UC) is migrating from an on-premise homegrown customer relationshipmanagement (CRM) system- During analysis, UC users highlight a pain point that there are multiple versions of many customers.

What should the data architect do for a successful migration to mitigate the pain point?

A.

Hire an intern manually de-duplicate the records after migrating to Salesforce.

B.

Migrate the data as is, and use Salesforce's de-duplicating feature.

C.

Have the users manually clean the data in the old system prior to migration.

D.

Store the data in a staging database, and de-duplicate identical records.

Full Access
Question # 11

Universal Container (UC) has around 200,000 Customers (stored in Account object). They get 1 or 2 Orders every month from each Customer. Orders are stored in a custom object called "Order c"; this has about 50 fields. UC is expecting a growth of 10% year -over -year. What are two considerations an architect should consider to improve the performance of SOQL queries that retrieve data from the Order _c object? Choose2 answers

A.

Use SOQL queries without WHERE conditions.

B.

Work with Salesforce Support to enable Skinny Tables.

C.

Reduce the number of triggers on Order _c object.

D.

Make the queries more selective using indexed fields.

Full Access
Question # 12

Universal Containers (UC) is implementing its new Internet of Things technology, which consists of smart containers that provide information on container temperature and humidity updated every 10 minutes back to UC. There are roughly 10,000 containers equipped with this technology with the number expected to increase to 50,000 across the next five years. It is essential that Salesforce user have access to current and historical temperature and humidity data for each container. What is the recommended solution?

A.

Create new custom fields for temperature and humidity in the existing Container custom object, as well as an external ID field that is unique for each container. These custom fields are updated when a new measure is received.

B.

Create a new Container Reading custom object, which is created when a new measure is received for a specific container. The Container Reading custom object has a master-detail relationship to the container object.

C.

Create a new Lightning Component that displays last humidity and temperature data for a specific container and can also display historical trends obtaining relevant data from UC’s existing data warehouse.

D.

Create a new Container Reading custom object with a master-detail relationship to Container which is created when a new measureis received for a specific container. Implement an archiving process that runs every hour.

Full Access
Question # 13

Universal Containers has more than 10 million records in the Order_c object. The query has timed out when running a bulk query. What should beconsidered to resolve query timeout?

A.

Tooling API

B.

PK Chunking

C.

Metadata API

D.

Streaming API

Full Access
Question # 14

Universal Containers has a large number of Opportunity fields (100) that they want to track field history on. Which two actions should an architectperform in order to meet this requirement? Choose 2 answers

A.

Create a custom object to store a copy of the record when changed.

B.

Create a custom object to store the previous and new field values.

C.

Use Analytic Snapshots to store a copy of the record when changed.

D.

Select the 100 fields in the Opportunity Set History Tracking page.

Full Access
Question # 15

The head of sales at Get Cloudy Consulting wants to understand key relevant performance figures and helpmanagers take corrective actions where appropriate.

What is one reporting option Get Cloudy Consulting should consider?

A.

Case SLA performance report

B.

Sales KPI Dashboard

C.

Opportunity analytic snapshot

D.

Lead conversion rate report

Full Access
Question # 16

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.)

A.

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

B.

Contact Salesforce to activate indexing before uploading the data.

C.

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

D.

Defer sharing calculations until the data has finished uploading.

Full Access
Question # 17

Universal Containers (UC) is implementing a Salesforce project with large volumes of data and daily transactions. The solution includes both real-time web service integrations and Visualforce mash -ups with back -end systems. The Salesforce Full sandbox used by the project integrates with full-scale back -end testing systems. What two types of performance testing are appropriate for this project? 

Choose 2 answers

A.

Pre -go -live automated page -load testing against the Salesforce Full sandbox.

B.

Post go -live automated page -load testing against the Salesforce Production org.

C.

Pre -go -live unit testing in the Salesforce Full sandbox.

D.

Stress testing against the web services hosted by the integration middleware.

Full Access
Question # 18

Cloud Kicks currently has a Public Read/Write sharing model for the company's Contacts. Cloud Kicks management team requests that only the owner of a contact record be allowed to delete that contact.

What should an Architect do to meet these requirements?

A.

Set the profile of the users to remove delete permission from the Contact object.

B.

Check if the current user is NOT the owner by creating a "before delete" trigger.

C.

Set the Sharing settings as Public Read Only forthe Contact object.

D.

Check if the current user is NOT the owner by creating a validation rule on the Contact object.

Full Access
Question # 19

Universal Containers (UC) is implementing a new customer categorization process where customers should be assigned to a Gold, Silver, or Bronze category if they've purchased UC's new support service. Customersare expected to be evenly distributed across all three categories. Currently, UC has around 500,000 customers, and is expecting 1% of existing non-categorized customers to purchase UC's new support service every month over the next five years. What is the recommended solution to ensure long-term performance, bearing in mind the above requirements?

A.

Implement a new global picklist custom field with Gold, Silver, and Bronze values and enable it in Account.

B.

Implement a new picklist custom field in theAccount object with Gold, Silver, and Bronze values.

C.

Implement a new Categories custom object and a master-detail relationship from Account to Category.

D.

Implement a new Categories custom object and create a lookup field from Account to Category.

Full Access
Question # 20

A large automobile company has implemented Salesforce for its sales associates. Leads flow from its website to Salesforce using a batch integration in Salesforce. The batch job converts the leads to Accounts in Salesforce. Customers visiting their retail stores are also created in Salesforce as Accounts.

The company has noticed a large number of duplicate Accounts in Salesforce. On analysis, it was found that certain customers could interact with its website and also visitthe store. The sales associates use Global Search to search for customers in Salesforce before they create the customers.

Which option should a data architect choose to implement to avoid duplicates?

A.

leverage duplicate rules in Salesforce to validate duplicates during the account creation process.

B.

Develop an Apex class that searches for duplicates and removes them nightly.

C.

Implement an MDM solution to validate the customer information before creating Salesforce.

D.

Build a custom search functionality that allows sales associates to search for customer in real time upon visiting their retail stores.

Full Access
Question # 21

A customer wishes to migrate 700,000 Account records in a single migration into Salesforce. What is the recommended solution to migrate these records while minimizing migration time?

A.

Use Salesforce Soap API in parallel mode.

B.

Use Salesforce Bulk API in serial mode.

C.

Use Salesforce Bulk API in parallel mode.

D.

Use Salesforce Soap API in serial mode.

Full Access
Question # 22

Universal containers is implementing Salesforce lead management.  UC Procure lead data from multiple sources and would like to make surelead data as company profile and location information. Which solution should a data architect recommend to make sure lead data has both profile and location information? Option

A.

Ask sales people to search for populating company profile and location data

B.

Run reports to identify records which does not have company profile and location data

C.

Leverage external data providers populate company profile and location data

D.

Export data out of Salesforce and send to another team to populate company profileand location data

Full Access
Question # 23

Universal Containers (UC) has implemented Sales Cloud and it has been noticed that Sales reps are not entering enough data to run insightful reports and dashboards. UC executives would like to monitor and measure data quality metrics. What solution addresses this requirement?

A.

Use third-party AppExchange tools to monitor and measure data quality.

B.

Generate reports to view the quality of sample data.

C.

Use custom objects and fields to calculate data quality.

D.

Export the datato an enterprise data warehouse and use BI tools for data quality.

Full Access
Question # 24

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?

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.

Full Access
Question # 25

DreamHouse Realty has a Salesforce org that is used to manage Contacts.

What are two things an Architect should consider using to maintain data quality in this situation? (Choose two.)

A.

Use the private sharing model.

B.

Use Salesforce duplicate management.

C.

Use validation rules on new record create and edit.

D.

Use workflow to delete duplicate records.

Full Access
Question # 26

DreamHouse Realty has a Salesforce deployment that manages Sales, Support, and Marketing efforts in a multi-system ERP environment. The company recently reached the limits of native reports and dashboards and needs options for providing more analytical insights.

What are two approaches an Architect should recommend? (Choose two.)

A.

Weekly Snapshots

B.

Einstein Analytics

C.

Setup Audit Trails

D.

AppExchange Apps

Full Access
Question # 27

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 order by OrderID.

B.

Import Account records firstfollowed by order records after sorting orders by AccountID.

C.

Change the relationship to Lookup and update the relationship to master-detail after import.

D.

Import Order records and Account records separately and populate AccountID in orders using batchApex.

Full Access
Question # 28

Universal Containers (UC) has implemented Salesforce, UC is running out of storage and needs to have an archiving solution, UC would like to maintaintwo years of data in Saleforce and archive older data out of Salesforce.

Which solution should a data architect recommend as an archiving solution?

A.

Use a third-party backup solution to backup all data off platform.

B.

Build a batch join move all recordsoff platform, and delete all records from Salesforce.

C.

Build a batch join to move two-year-old records off platform, and delete records from Salesforce.

D.

Build a batch job to move all restore off platform, and delete old records from Salesforce.

Full Access
Question # 29

UC has to built a B2C ecommerce site on Heroku that shares customer and order data with a Heroku Postgres database. UC is currently utilizing Postgres as the single source of truth for both customers and orders. UC has asked a data architect to replicate the data into salesforce so that salesforce can now act as the system of record.

What are the 3 considerations that data architect should weigh before implementing this requirement? Choose 23 answers:

A.

Consider whether the data is required for sales reports, dashboards and KPI’s.

B.

Determine if the data is driver of key process implemented within salesforce.

C.

Ensure there isa tight relationship between order data and an enterprise resource plaining (ERP) application.

D.

Ensure the data is CRM center and able to populate standard of custom objects.

E.

A selection of the tool required to replicate the data.

F.

– Heroku Connectis required but this is confusing

Full Access
Question # 30

For a production cutover, a large number of Account records will be loaded intoSalesforce from a legacy system. The legacy system does not have enough information to determine the Ownership for these Accounts upon initial load. Which two recommended options assign Account ownership to mitigate potential performance problems?

A.

Let a “system user” own all the Account records without assigning any role to this user in Role Hierarchy.

B.

Let a “system user” own the Account records and assign this user to the lowest-level role in the Role Hierarchy.

C.

Let the VP of the Sales department, who will report directly to the senior VP, own all the Account records.

D.

Let a “system user” own all the Account records and make this user part of the highest-level role in the Role Hierarchy.

Full Access
Question # 31

Universal Containers (UC) has three systems: Salesforce, a cloud -based ERP system, and an on -premise Order Management System (OMS). An architect has been tasked with creating a solution that uses Salesforce as the system of record for Leads and the OMS as the system of record for Account and Contacts. UC wants Accounts and Contacts to be able to maintain their names in each system (i.e., "John Doe" in the OMS and "Johnny Doe" in Salesforce), but wants to have a consolidated data store which links referenced records across the systems. What approach should an architect suggest so the requirements are met?

A.

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

B.

Implement an integration tool to send OMS Accounts and Contacts to Salesforce.

C.

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

D.

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

Full Access
Question # 32

UC needs to load a large volume of leads into salesforce on a weekly basis. During this process the validation rules are disabled.

What should a data architect recommend to ensure dataquality is maintained in salesforce.

A.

Activate validation rules once the leads are loaded into salesforce to maintain quality.

B.

Allow validation rules to be activated during the load of leads into salesforce.

C.

Develop custom APEX batch process to improve quality once the load is completed.

D.

Ensure the lead data is preprocessed for quality before loading into salesforce.

Full Access
Question # 33

Salesforce is being deployed in Ursa Major Solar's disparate, multi-system ERP environment.Ursa major Solar wants to maintain data synchronization between systems.

Which two techniques should be used to achieve this goal? (Choose two.)

A.

Integrate Salesforce with the ERP environment.

B.

Utilize workbench to update files within systems.

C.

Utilize an MDM strategy to outline a single source of truth.

D.

Build synchronization reports and dashboards.

Full Access