Salesforce Certified Data Architecture and Management Designer Guides

dumps2022-02-22T02:44:04+08:00

dumps Salesforce Certified Data Architecture and Management Designer exam guides, Salesforce Certified Data Architecture and Management Designer exam 0 Comments

To take Salesforce Certified Data Architecture and Management Designer exam, the online guides are the best preparation material. In real Salesforce Certified Data Architecture and Management Designer exam, there are 60 multiple-choice and multiple-select questions, and you have 105 minutes to take. The required passing score is 58%. Free Salesforce Certified Data Architecture and Management Designer exam guides are below.

Page 1 of 5

1. Patients: They are individuals who need care.

A data architect needs to map the actor to Sf objects.

What should be the optimal selection by the data architect?

Patients as Contacts, Payment providers as Accounts, & Doctors as Accounts

Patients as Person Accounts, Payment providers as Accounts, & Doctors as Contacts

Patients as Person Accounts, Payment providers as Accounts, & Doctors as Person Account

Patients as Accounts, Payment providers as Accounts, & Doctors as Person Accounts

2. A data architect has been tasked with optimizing a data stewardship engagement for a Salesforce instance.

Which three areas of Salesforce should the architect review before proposing any design recommendation? Choose 3 answers

Review the metadata xml files for redundant fields to consolidate.

Determine if any integration points create records in Salesforce.

Run key reports to determine what fields should be required.

Export the setup audit trail to review what fields are being used.

Review the sharing model to determine impact on duplicate records.

3. Universal Containers wishes to maintain Lead data from Leads even after they are deleted and cleared from the Recycle Bin.

What approach should be implemented to achieve this solution?

Use a Lead standard report and filter on the IsDeleted standard field.

Use a Converted Lead report to display data on Leads that have been deleted.

Query Salesforce with the queryAll API method or using the ALL ROWS SOQL keywords.

Send data to a Data Warehouse and mark Leads as deleted in that system.

4. An architect has been asked to provide error messages when a future date is detected in a custom Birthdate _c field on the Contact object. The client wants the ability to translate the error messages.

What are two approaches the architect should use to achieve this solution? Choose 2 answers

Implement a third -party validation process with translate functionality.

Create a trigger on Contact and add an error to the record with a custom label.

Create a workflow field update to set the standard ErrorMessage field.

Create a validation rule and translate the error message with translation workbench.

5. Due to security requirements, Universal Containers needs to capture specific user actions, such as login, logout, file attachment download, package install, etc.

What is the recommended approach for defining a solution for this requirement?

Use a field audit trail to capture field changes.

Use a custom object and trigger to capture changes.

Use Event Monitoring to capture these changes.

Use a third-party AppExchange app to capture changes.

6. Universal Containers (UC) owns a complex Salesforce org with many Apex classes, triggers, and automated processes that will modify records if available. UC has identified that, in its current development state, UC runs change of encountering race condition on the same record.

What should a data architect recommend to guarantee that records are not being updated at the same time?

Embed the keywords FOR UPDATE after SOQL statements.

Disable classes or triggers that have the potential to obtain the same record.

Migrate programmatic logic to processes and flows.

Refactor or optimize classes and trigger for maximum CPU performance.

7. 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 be considered to resolve query timeout?

Tooling API

PK Chunking

Metadata API

Streaming API

8. Universal containers is implementing Salesforce lead management. UC Precure lead data from multiple sources and would like to make sure lead 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

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

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

Leverage external data providers populate company profile and location data

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

9. 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?

Use the Name field values to sort batches.

Order batches by Auto-number field.

Create indexes on Opportunity object text fields.

Group batches by the AccountId field.

10. Universal Containers (UC) is planning to move away from legacy CRM to Salesforce. As part of one-time data migration, UC will need to keep the original date when a contact was created in the legacy system.

How should an Architect design the data migration solution to meet this requirement?

After the data is migrated, perform an update on all records to set the original date in a standard CreatedDate field.

Create a new field on Contact object to capture the Created Date. Hide the standard CreatedDate field using Field -Level Security.

Enable "Set Audit Fields" and assign the permission to the user loading the data for the duration of the migration.

Write an Apex trigger on the Contact object, before insert event to set the original value in a standard CreatedDate field.

Page 2 of 5

11. 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?

Remove description from the requested field set.

Change query to SOS

Add limit 100 to the query.

Change the where clause to filter by a deterministic defined value.

12. As part of addressing general data protection regulation (GDPR) requirements, UC plans to implement a data classification policy for all its internal systems that stores customer information including salesforce.

What should a data architect recommend so that UC can easily classify consumer information maintained in salesforce under both standard and custom objects?

Use App Exchange products to classify fields based on policy.

Use data classification metadata fields available in field definition.

Create a custom picklist field to capture classification of information on customer.

Build reports for customer information and validate.

13. Universal Containers has successfully migrated 50 million records into five different objects multiple times in a full copy sandbox. The Integration Engineer wants to re-run the test again a month before it goes live into Production.

What is the recommended approach to re-run the test?

Truncate all 5 objects quickly and re-run the data migration test.

Refresh the full copy sandbox and re-run the data migration test.

Hard delete all 5 objects’ data and re-run the data migration test.

Truncate all 5 objects and hard delete before running the migration test.

14. Universal Containers (UC) is a business that works directly with individual consumers (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?

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

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

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

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

15. For a production cutover, a large number of Account records will be loaded into Salesforce 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?

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

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

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

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

16. Universal Containers (UC) is implementing a formal, cross -business -unit data governance program As part of the program, UC will implement a team to make decisions on enterprise -wide data governance.

Which two roles are appropriate as members of this team? Choose 2 answers

Analytics/BI Owners

Data Domain Stewards

Salesforce Administrators

Operational Data Users

17. Universal Containers (UC) wants to capture information on how data entities are stored within the different applications and systems used within the company. For that purpose, the architecture team decided to create a data dictionary covering the main business domains within UC.

Which two common techniques are used building a data dictionary to store information on how business entities are defined?

Use Salesforce Object Query Language.

Use a data definition language.

Use an entity relationship diagram.

Use the Salesforce Metadata AP

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

Using leading % wildcards.

Using trailing % wildcards.

Performing large loads and deletions.

Using NOT and != operators.

Using a custom index on a deterministic formula field.

19. A customer is operating in a highly reputated industry and is planning to implement SF.

The customer information maintained in SF, includes the following:

✑ Personally, identifiable information (PII)

✑ IP restrictions on profiles organized by Geographic location

✑ Financial records that need to be private and accessible only by the assigned Sales associate.

✑ User should not be allowed to export information from Salesforce.

Enterprise security has mandate access to be restricted to users within a specific geography and detail monitoring of user activity.

Which 3 Salesforce shield capabilities should a data architect recommend? Choose 3 answers:

Event monitoring to monitor all user activities

Restrict access to SF from users outside specific geography

Prevent Sales users access to customer PII information

Transaction security policies to prevent export of SF Data.

Encrypt Sensitive Customer information maintained in S

20. UC is trying to switch from legacy CRM to salesforce and wants to keep legacy CRM and salesforce in place till all the functionality is deployed in salesforce. The want to keep data in synch b/w Salesforce, legacy CRM and SAP.

What is the recommendation.

Integrate legacy CRM to salesforce and keep data in synch till new functionality is in place

Do not integrate legacy CRM to Salesforce, but integrate salesforce to SAP

Integrate SAP with Salesforce, SAP to legacy CRM but not legacy CRM to Salesforce

Suggest MDM solution and link MDM to salesforce and SAP

Page 3 of 5

21. Universal Container is using Salesforce for Opportunity management and enterprise resource planning (ERP) for order management. Sales reps do not have access to the ERP and have no visibility into order status.

What solution a data architect recommend to give the sales team visibility into order status?

Leverage Canvas to bring the order management UI in to the Salesforce tab.

Build batch jobs to push order line items to salesforce.

leverage Salesforce Connect top bring the order line item from the legacy system to Salesforce.

Build real-time integration to pull order line items into Salesforce when viewing orders.

22. 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?

Use Salesforce Soap API in parallel mode.

Use Salesforce Bulk API in serial mode.

Use Salesforce Bulk API in parallel mode.

Use Salesforce Soap API in serial mode.

23. Which two best practices should be followed when using SOSL for searching?

Use searches against single Objects for greater speed and accuracy.

Keep searches specific and avoid wildcards where possible.

Use SOSL option to ignore custom indexes as search fields are pre-indexed.

Use Find in “ALL FIELDS” for faster searches.

24. Universal Containers (UC) requires 2 years of customer related cases to be available on SF for operational reporting. Any cases older than 2 years and upto 7 years need to be available on demand to the Service agents. UC creates 5 million cases per yr.

Which 2 data archiving strategies should a data architect recommend? Choose 2 options:

Use custom objects for cases older than 2 years and use nightly batch to move them.

Sync cases older than 2 years to an external database, and provide access to Service agents to the database

Use Big objects for cases older than 2 years, and use nightly batch to move them.

Use Heroku and external objects to display cases older than 2 years and bulk API to hard delete from Salesforce.

25. There is no need for more than 10 custom objects or additional file storage.

Which community cloud license type should a data architect recommend to meet the portal requirements?

Customer community.

Lightning external apps starter.

Customer community plus.

Partner community.

26. NTO has decided to franchise its brand. Upon implementation, 1000 franchisees will be able to access BTO’s product information and track large customer sales and opportunities through a portal. The Franchisees will also be able to run monthly and quarterly sales reports and projections as well as view the reports in dashboards.

Which licenses does NTO need to provide these features to the Franchisees?

Salesforce Sales Cloud license

Lightning Platform license

Customer Community license

Partner Community license

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

Data completeness

Data loss and recovery

Data duplication

Data accuracy and quality

Data standardization

28. Universal Containers is integrating a new Opportunity engagement system with Salesforce. According to their Master Data Management strategy, Salesforce is the system of record for Account, Contact, and Opportunity data. However, there does seem to be valuable Opportunity data in the new system that potentially conflicts with what is stored in Salesforce.

What is the recommended course of action to appropriately integrate this new system?

The MDM strategy defines Salesforce as the system of record, so Salesforce Opportunity values prevail in all conflicts.

A policy should be adopted so that the system whose record was most recently updated should prevail in conflicts.

The Opportunity engagement system should become the system of record for Opportunity records.

Stakeholders should be brought together to discuss the appropriate data strategy moving forward.

29. Each contact may attend multiple conferences and each conference may be related to multiple contacts.

How should a data architect model the relationship between the contact and conference objects?

Implement a Contact Conference junction object with master detail relationship to both contact and conference__c.

Create a master detail relationship field on the Contact object.

Create a master detail relationship field on the Conference object.

Create a lookup relationship field on contact object.

30. NTO uses salesforce to manage relationships and track sales opportunities. It has 10 million customers and 100 million opportunities. The CEO has been complaining 10 minutes to run and sometimes failed to load, throwing a time out error.

Which 3 options should help improve the dashboard performance? Choose 3 answers:

Use selective queries to reduce the amount of data being returned.

De-normalize the data by reducing the number of joins.

Remove widgets from the dashboard to reduce the number of graphics loaded.

Run the dashboard for CEO and send it via email.

Reduce the amount of data queried by archiving unused opportunity records.

Page 4 of 5

31. Universal Containers (UC) has multi -level account hierarchies that represent departments within their major Accounts. Users are creating duplicate Contacts across multiple departments. UC wants to clean the data so as to have a single Contact across departments.

What two solutions should UC implement to cleanse their data? Choose 2 answers

Make use of a third -party tool to help merge duplicate Contacts across Accounts.

Use Data.com to standardize Contact address information to help identify duplicates.

Use Workflow rules to standardize Contact information to identify and prevent duplicates.

Make use of the Merge Contacts feature of Salesforce to merge duplicates for an Account.

32. A customer needs a sales model that allows the following:

✑ Opportunities need to be assigned to sales people based on the zip code.

✑ Each sales person can be assigned to multiple zip codes.

✑ Each zip code is assigned to a sales area definition. Sales is aggregated by sales area for reporting.

What should a data architect recommend?

Assign opportunities using list views using zip code.

Add custom fields in opportunities for zip code and use assignment rules.

Allow sales users to manually assign opportunity ownership based on zip code.

Configure territory management feature to support opportunity assignment.

33. DreamHouse Realty has a data model as shown in the image. The Project object has a private sharing model, and it has Roll-Up summary fields to calculate the number of resources assigned to the project, total hours for the project, and the number of work items associated to the project.

There will be a large amount of time entry records to be loaded regularly from an external system into Salesforce.

What should the Architect consider in this situation?

Load all data after deferring sharing calculations.

Calculate summary values instead of Roll-Up by using workflow.

Calculate summary values instead of Roll-Up by using triggers.

Load all data using external IDs to link to parent records.

34. (NTO) has multiple salesforce orgs based on geographical reports (AMER, EMEA, APAC). NTO products are in the AMER org and need to be created in the EMEA and APAC after the products are approved.

Which two features should a data architect recommend to share records between salesforce orgs? Choose 2.

Change data capture (CDC)

Salesforce connect.

Federation search

Salesforce 2 Salesforce

35. NTO has been using salesforce for sales and service for 10 years. For the past 2 years, the marketing group has noticed a raise from 0 to 35 % in returned mail when sending mail using the contact information stored in salesforce.

Which solution should the data architect use to reduce the amount of returned mails?

Use a 3rd party data source to update contact information in salesforce.

Email all customer and asked them to verify their information and to call NTO if their address is incorrect.

Delete contacts when the mail is returned to save postal cost to NT

Have the sales team to call all existing customers and ask to verify the contact details.

36. 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?

validation Rule

required Fields

Apex Class

Process Builder

37. 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?

Do client-side validation of phone number and email field formats.

Prefer picklist form fields over free text fields, where possible.

Ensure the website visitor is browsing using an HTTPS connection.

Use cookies to track when visitors submit multiple forms.

38. Marketing solution

What should a data architect recommend that would help upgrade uniquely identify customer across multiple systems:

Store the salesforce id in all the solutions to identify the customer.

Create a custom object that will serve as a cross reference for the customer id.

Create a customer data base and use this id in all systems.

Create a custom field as external id to maintain the customer Id from the MDM solution.

39. UC has large amount of orders coming in from its online portal. Historically all order are assigned to a generic user.

Which 2 measures should data architect recommend to avoid any performance issues while working with large number of order records? Choose 2 answers:

Clear the role field in the generic user record.

Salesforce handles the assignment of orders automatically and there is no performance impact.

Create a role at top of role hierarchy and assign the role to the generic user.

Create a pool of generic users and distribute the assignment of memory to the pool of users.

40. 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?

Import Account records first followed by order records after sorting order by OrderI

Import Account records first followed by order records after sorting orders by AccountI

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

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

Page 5 of 5

41. Universal Container has a Sales Cloud implementation for a sales team and an enterprise resource planning (ERP) as a customer master Sales team are complaining about duplicate account and data quality issues with account data.

Which two solution should a data architect recommend to resolve the complaints?

Build a nightly batch job to de-dupe data, and merge account records.

Integrate Salesforce with ERP, and make ERP as system of truth.

Build a nightly sync job from ERP to Salesforce.

Implement a de-dupe solution and establish account ownership in Salesforce

42. As part of a phased Salesforce rollout. there will be 3 deployments spread out over the year. The requirements have been carefully documented.

Which two methods should an architect use to trace back configuration changes to the detailed requirements? Choose 2 answers

Review the setup audit trail for configuration changes.

Put the business purpose in the Description of each field.

Maintain a data dictionary with the justification for each field.

Use the Force.com IDE to save the metadata files in source control.

43. Universal Containers (UC) has implemented Sales Cloud for its entire sales organization, UC has built a custom object called projects_c that stores customers project detail and employee bitable hours.

The following requirements are needed:

A subnet of individuals from the finance team will need to access to the projects object for reporting and adjusting employee utilization.

The finance users will not access to any sales objects, but they will need to interact with the custom object.

Which license type a data architect recommend for the finance team that best meets the requirements?

Service Cloud

Sales Cloud

Light Platform Start

Lighting platform plus

44. What makes Skinny tables fast? Choose three answers.

They do not include soft-deleted records

They avoid resource intensive joins

Their tables are kept in sync with their source tables when the source tables are modified

They can contain fields from other objects

They support up to a max of 100 of columns

45. UC is migrating data from legacy system to SF.

UC would like to preserve the following information on records being migrated:

✑ Date time stamps for created date and last modified date.

✑ Ownership of records belonging to inactive users being migrated to Salesforce.

Which 2 solutions should a data architect recommends to preserve the date timestamps and ownership on records? Choose 2 answers.

Log a case with SF to update these fields

Enable update records with Inactive Owners Permission

Enable Set Audit fields upon Record Creation Permission

Enable modify all and view all permission.

46. Sales Orders will not be updated in Salesforce.

What should a data architect recommend for maintaining Sales Orders in salesforce?

Us custom objects to maintain Sales Orders in Salesforce.

Use custom big objects to maintain Sales Orders in Salesforce.

Use external objects to maintain Sales Order in Salesforce.

Use Standard order object to maintain Sale Orders in Salesforce

47. The program generates 100 million records each month.

NTO customer support would like to see a summary of a customer’s recent transaction and reward level(s) they have attained.

Which solution should the data architect use to provide the information within the salesforce for the customer support agents?

Create a custom object in salesforce to capture and store all reward program. Populate nightly from the point-of-scale system, and present on the customer record.

Capture the reward program data in an external data store and present the 12 months trailing summary in salesforce using salesforce connect and then external object.

Provide a button so that the agent can quickly open the point of sales system displaying the customer history.

Create a custom big object to capture the reward program data and display it on the contact record and update nightly from the point-of-scale system.

48. UC migrating 100,000 Accounts from an enterprise resource planning (ERP) to salesforce and is concerned about ownership skew and performance.

Which 3 recommendations should a data architect provide to prevent ownership skew? Choose 3 answers:

Assigned a default user as owner of accounts, and assign role in hierarchy.

Keep users out of public groups that can be used as the source for sharing rules.

Assign a default user as owner of account and do not assign any role to default user.

Assign “view all” permission on profile to give access to account.

Assign a default user as owner of accounts and assigned top most role in hierarchy.

49. Universal Containers has a large volume of Contact data going into Salesforce.com. There are 100,000 existing contact records. 200,000 new contacts will be loaded. The Contact object has an external ID field that is unique and must be populated for all existing records.

What should the architect recommend to reduce data load processing time?

Load Contact records together using the Streaming API via the Upsert operation.

Delete all existing records, and then load all records together via the Insert operation.

Load all records via the Upsert operation to determine new records vs. existing records.

Load new records via the Insert operation and existing records via the Update operation.

Salesforce Certified Data Architecture and Management Designer Guides

Salesforce Certified Data Architecture and Management Designer Guides

Share this post

Leave a Reply Cancel reply

Related Posts