Try Salesforce Certified Data Architecture and Management Designer Exam Dumps

test2022-07-18T06:41:45+00:00

By test Certified Data Architecture and Management Designer Exam Dumps, Salesforce Certified Data Architecture and Management Designer exam questions 0 Comments

If you are preparing for Salesforce Certified Data Architecture and Management Designer exam, you should get FreeTestShare Certified Data Architecture and Management Designer Exam Dumps to pass in the first try. You may be perplexed about exam question types, exam patterns, and time allotted to attempt questions on the Salesforce Certified Data Architecture and Management Designer exam during your preparation. If you are preparing or planning on this exam, you can try these Salesforce Certified Data Architecture and Management Designer exam questions to see if you are ready for the real exam.

To help you prepare for the exam, take a free practice test.

Page 1 of 6

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

2. An Architect needs to document the data architecture for a multi-system, enterprise Salesforce implementation.

Which two key artifacts should the Architect use? (Choose two.)

User stories

Data model

Integration specification

Non-functional requirements

3. Northern Trail Outfitter has implemented Salesforce for its associates nationwide, Senior management is concerned that the executive dashboard are not reliable for their real-time decision-making. On analysis , the team the following issues with data entered in Salesforce.

Information in certain records is incomplete.

Incorrect entry in certain fields causes records to be excluded in report fitters.

Duplicate entries cause incorrect counts.

Which three steps should a data architect recommend to address the issues?

Periodically export data to cleanse data and import them back into Salesforce for executive reports.

Build a sales data warehouse with purpose-build data marts for dashboards and senior management reporting.

Explore third-party data providers to enrich and augment information entered in salesforce.

Leverage Salesforce features, such as validate rules, to avoid incomplete and incorrect records.

design and implement data-quality dashboard to monitor and act on records that are incomplete or incorrect

4. Northern Trail outfitters in migrating to salesforce from a legacy CRM system that identifies the agent relationships in a look-up table.

What should the data architect do in order to migrate the data to Salesfoce?

Create custom objects to store agent relationships.

Migrate to Salesforce without a record owner.

Assign record owner based on relationship.

Migrate the data and assign to a non-person system user.

5. UC is having issues using Informatica Cloud Louder to export +10MOrder records. Each Order record has 10 Order Line Items.

What two steps can you take to help correct this? Choose two answers.

Export in multiple batches

Export Bulk API in parallel mode

Use PK Chunking

Limit Batch to 10K records

6. UC is planning a massive SF implementation with large volumes of data. As part of the org’s implementation, several roles, territories, groups, and sharing rules have been configured. The data architect has been tasked with loading all of the required data, including user data, in a timely manner.

What should a data architect do to minimize data load times due to system calculations?

Enable defer sharing calculations, and suspend sharing rule calculations

Load the data through data loader, and turn on parallel processing.

Leverage the Bulk API and concurrent processing with multiple batches

Enable granular locking to avoid “UNABLE _TO_LOCK_ROW” error.

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

8. Cloud Kicks needs to purge detailed transactional records from Salesforce. The data should be aggregated at a summary level and available in Salesforce.

What are two automated approaches to fulfill this goal? (Choose two.)

Third-party Integration Tool (ETL)

Schedulable Batch Apex

Third-party Business Intelligence system

Apex Triggers

9. Cloud Kicks stores Invoice records in a custom object. Invoice records are being sent to the Accounting department with missing States and incorrectly formatted Postal Codes.

Which two actions should Cloud Kicks take to improve data quality? (Choose two.)

Change each address field to required on the Page Layout.

Write an Apex Trigger to require all fields to be populated.

Utilize a Validation Rule with a REGEX operator on Postal Code.

Utilize a Validation Rule with a CONTAINS operator on address fields.

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

Page 2 of 6

11. Universal Containers is setting up an external Business Intelligence (BI) system and wants to extract 1,000,000 Contact records.

What should be recommended to avoid timeouts during the export process?

Use the SOAP API to export data.

Utilize the Bulk API to export the data.

Use GZIP compression to export the data.

Schedule a Batch Apex job to export the data.

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

13. UC is migrating individual customers (B2C) data from legacy systems to SF. There are millions of customers stored as accounts and contacts in legacy database.

Which object model should a data architect configure within SF?

Leverage person account object in Salesforce

Leverage custom person account object in SF

Leverage custom account and contact object in SF

Leverage standard account and contact object in SF

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

15. Which two aspects of data does an Enterprise data governance program aim to improve?

Data integrity

Data distribution

Data usability

Data modeling

16. NTO has 1 million customer records spanning 25 years. As part of its new SF project, NTO would like to create a master data management strategy to help preserve the history and relevance of its customer data.

Which 3 activities will be required to identify a successful master data management strategy? Choose 3 answers:

Identify data to be replicated

Create a data archive strategy

Define the systems of record for critical data

Install a data warehouse

Choose a Business Intelligence tool.

17. North Trail Outfitters (NTO) operates a majority of its business from a central Salesforce org, NTO also owns several secondary orgs that the service, finance, and marketing teams work out of, At the moment, there is no integration between central and secondary orgs, leading to data-visibility issues.

Moving forward, NTO has identified that a hub-and-spoke model is the proper architect to manage its data, where the central org is the hub and the secondary orgs are the spokes.

Which tool should a data architect use to orchestrate data between the hub org and spoke orgs?

A middleware solution that extracts and distributes data across both the hub and spokes.

Develop custom APIs to poll the hub org for change data and push into the spoke orgs.

Develop custom APIs to poll the spoke for change data and push into the org.

A backup and archive solution that extracts and restores data across orgs.

18. Universal Container (US) is replacing a home grown CRM solution with Salesforce, UC has decided to migrate operational (Open and active) records to Salesforce, while keeping historical records in legacy system, UC would like historical records to be available in Salesforce on an as needed basis.

Which solution should a data architect recommend to meet business requirement?

Leverage real-time integration to pull records into Salesforce.

Bring all data Salesforce, and delete it after a year.

Leverage mashup to display historical records in Salesforce.

Build a chair solution to go the legacy system and display records.

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

20. NTO would like to retrieve their SF orgs meta data programmatically for backup within a various external.

Which API is the best fit for accomplishing this task?

Metadata API

Tooling API

Bulk API in serial mode

SOAP API

Page 3 of 6

21. 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 data quality is maintained in salesforce.

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

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

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

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

22. Universal Containers (CU) is in the process of implementing an enterprise data warehouse (EDW). UC needs to extract 100 million records from Salesforce for migration to the EDW.

What data extraction strategy should a data architect use for maximum performance?

Install a third-party AppExchange tool.

Call the REST API in successive queries.

Utilize PK Chunking with the Bulk AP

Use the Bulk API in parallel mode.

23. Universal Containers has received complaints that customers are being called by multiple Sales Reps where the second Sales Rep that calls is unaware of the previous call by their coworker.

What is a data quality problem that could cause this?

Missing phone number on the Contact record.

Customer phone number has changed on the Contact record.

Duplicate Contact records exist in the system.

Duplicate Activity records on a Contact.

24. UC has a roll-up summary field on Account to calculate the count of contacts associated with an account. During the account load, SF is throwing an “Unable to lock a row” error.

Which solution should a data architect recommend, to resolve the error?

Leverage data loader platform API to load data.

Perform Batch job in parallel mode and reduce Batch size

Perform Batch job in serial mode and reduce batch size

Defer roll-up summary fields calculation during data migration.

25. How can an architect find information about who is creating, changing, or deleting certain fields within the past two months?

Remove "customize application" permissions from everyone else.

Export the metadata and search it for the fields in question.

Create a field history report for the fields in question.

Export the setup audit trail and find the fields in question.

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

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

28. Universal Containers has a legacy system that captures Conferences and Venues. These Conferences can occur at any Venue. They create hundreds of thousands of Conferences per year. Historically, they have only used 20 Venues.

Which two things should the data architect consider when denormalizing this data model into a single Conference object with a Venue picklist? Choose 2 answers

Limitations on master -detail relationships.

Org data storage limitations.

Bulk API limitations on picklist fields.

Standard list view in -line editing.

29. A Salesforce customer has plenty of data storage. Sales Reps are complaining that searches are bringing back old records that aren't relevant any longer. Sales Managers need the data for their historical reporting.

What strategy should a data architect use to ensure a better user experience for the Sales Reps?

Create a Permission Set to hide old data from Sales Reps.

Use Batch Apex to archive old data on a rolling nightly basis.

Archive and purge old data from Salesforce on a monthly basis.

Set data access to Private to hide old data from Sales Reps.

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

Page 4 of 6

31. Universal Containers (UC) is transitioning from Classic to Lightning Experience.

What does UC need to do to ensure users have access to its notices and attachments in Lightning Experience?

Add Notes and Attachments Related List to page Layout in Lighting Experience.

Manually upload Notes in Lighting Experience.

Migrate Notes and Attachment to Enhanced Notes and Files a migration tool

Manually upload Attachments in Lighting Experience.

32. A large retail company has recently chosen SF as its CRM solution.

They have the following record counts:

✑ 2500000 accounts

✑ 25000000 contacts

When doing an initial performance test, the data architect noticed an extremely slow response for reports and list views.

What should a data architect do to solve the performance issue?

Load only the data that the users is permitted to access

Add custom indexes on frequently searched account and contact objects fields

Limit data loading to the 2000 most recently created records.

Create a skinny table to represent account and contact objects.

33. UC has multiple SF orgs that are distributed across regional branches. Each branch stores local customer data inside its org’s Account and Contact objects. This creates a scenario where UC is unable to view customers across all orgs.

UC has an initiative to create a 360-degree view of the customer, as UC would like to see Account and Contact data from all orgs in one place.

What should a data architect suggest to achieve this 360-degree view of the customer?

Consolidate the data from each org into a centralized datastore

Use Salesforce Connect’s cross-org adapter.

Build a bidirectional integration between all orgs.

Use an ETL tool to migrate gap Accounts and Contacts into each org.

34. An Architect needs information about who is creating, changing, or deleting certain fields within the past four months.

How can the Architect access this information?

Create a field history report for the fields in question.

After exporting the setup audit trail, find the fields in question.

After exporting the metadata, search it for the fields in question.

Remove "customize application" permissions from everyone else.

35. Universal Containers is exporting 40 million Account records from Salesforce using Informatica Cloud. The ETL tool fails and the query log indicates a full table scan time-out failure.

What is the recommended solution?

Modify the export job header to specify Export-in-Parallel.

Modify the export job header to specify Sforce-Enable-PKChunking.

Modify the export query that includes standard index fields(s).

Modify the export query with LIMIT clause with Batch size 10,000.

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

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

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

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

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

37. Which two statements are accurate with respect to performance testing a Force.com application?

All Force.com applications must be performance tested in a sandbox as well as production.

A performance test plan must be created and submitted to Salesforce customer support.

Applications with highly customized code or large volumes should be performance tested.

Application performance benchmarked in a sandbox can also be expected in production.

38. Universal Containers (UC) provides shipping services to its customers. They use Opportunities to track customer shipments. At any given time, shipping status can be one of the 10 values. UC has 200,000 Opportunity records.

When creating a new field to track shipping status on opportunity, what should the architect do to improve data quality and avoid data skew?

Create a picklist field, values sorted alphabetically.

Create a Master -Detail to custom object ShippingStatus c.

Create a Lookup to custom object ShippingStatus c.

Create a text field and make it an external I

39. UC has a salesforce org with multiple automated processes defined for group membership process. UC also have multiple admins on staff that perform manual adjustments to the role hierarchy. The automated task and manual task overlap daily and UC is experiencing “Lock errors” consistently.

What should a data architect recommend mitigate these errors?

Ask salesforce support for addition CPU power.

Enable granular locking.

Remove SOQL statements from APEX loops.

Enable sharing recalculations

40. Northern Trail Outfitters (NTO) has a variety of customers that include householder, businesses, and individuals.

The following conditions exist within its system:

NTO has a total of five million customers.

Duplicate records exist, which is replicated across many systems, including Salesforce.

Given these conditions, there is a lack of consistent presentation and clear identification of a customer record.

Which three option should a data architect perform to resolve the issues with the customer data?

Create a unique global customer ID for each customer and store that in all system for referential identity.

Use Salesforce CDC to sync customer data cross all systems to keep customer record in sync.

Invest in data duplicate tool to de-dupe and merge duplicate records across all systems.

Duplicate customer records across the system and provide a two-way sync of data between the systems.

Create a customer master database external to Salesforce as a system of truth and sync the customer data with all systems.

Page 5 of 6

41. Universal container (UC) would like to build a Human resources application on Salesforce to manage employee details, payroll, and hiring efforts. To adequately and store the relevant data, the application will need to leverage 45 custom objects. In addition to this, UC expects roughly 20,00 API calls into Salesfoce from an n-premises application daily.

Which license type should a data architect recommend that best fits these requirements?

Service Cloud

Lightning platform Start

Lightning Platform plus

Lightning External Apps Starts

42. NTO uses opportunity forecast for its sales planning and management.

Sales users have noticed that their updates to the opportunity amount field are overwritten when PPS updates their opportunities.

How should a data architect address this overriding issue?

Create a custom field for opportunity amount that sales users update separating the fields that PPS updates.

Create a custom field for opportunity amount that PPS updates separating the field that sales user updates.

Change opportunity amount field access to read only for sales users using field level security.

Change PPS integration to update only opportunity amount fields when values is NUL

43. Universal Containers has a large number of Opportunity fields (100) that they want to track field history on.

Which two actions should an architect perform in order to meet this requirement? Choose 2 answers

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

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

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

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

44. Get Cloudy Consulting needs to evaluate the completeness and consistency of contact information in Salesforce. Their sales reps often have incomplete information about their accounts and contacts. Additionally, they are not able to interpret the information in a consistent manner. Get Cloudy Consulting has identified certain ""key"" fields which are important to their sales reps.

What are two actions Get Cloudy Consulting can take to review their data for completeness and consistency? (Choose two.)

Run a report which shows the last time the key fields were updated.

Run one report per key field, grouped by that field, to understand its data variability.

Run a report that shows the percentage of blanks for the important fields.

Run a process that can fill in default values for blank fields.

45. Cloud Kicks has the following requirements:

- Data needs to be sent from Salesforce to an external system to generate invoices from their Order Management System (OMS).

- A Salesforce administrator must be able to customize which fields will be sent to the external system without changing code.

What are two approaches for fulfilling these requirements? (Choose two.)

A set<sobjectFieldset> to determine which fields to send in an HTTP callout.

An Outbound Message to determine which fields to send to the OM

A Field Set that determines which fields to send in an HTTP callout.

Enable the field -level security permissions for the fields to send.

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

47. (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

48. NTO (Northern Trail Outlets) has a complex Salesforce org which has been developed over past 5 years. Internal users are complaining abt multiple data issues, including incomplete and duplicate data in the org. NTO has decided to engage a data architect to analyze and define data quality standards.

Which 3 key factors should a data architect consider while defining data quality standards? Choose 3 answers:

Define data duplication standards and rules

Define key fields in staging database for data cleansing

Measure data timeliness and consistency

Finalize an extract transform load (ETL) tool for data migration

Measure data completeness and accuracy

49. Universal Containers is looking to use Salesforce to manage their sales organization. They will be migrating legacy account data from two aging systems into Salesforce.

Which two design considerations should an architect take to minimize data duplication? Choose 2 answers

Use a workflow to check and prevent duplicates.

Clean data before importing to Salesforce.

Use Salesforce matching and duplicate rules.

Import the data concurrently.

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

Page 6 of 6

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

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

Custom report types CANNOT contain Opportunity data.

Salesforce does NOT support Orders or Order Line Items.

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

A report CANNOT contain data from Accounts and Contacts.

53. Universal Containers (UC) has a multi-level master-detail relationship for opportunities, a custom opportunity line item object, and a custom discount request. UC has opportunity as master and custom line item object as detail in master-detail relationship. UC also has a custom line item object as master and a custom discount request object as detail in another master-detail relationship. UC has a requirement to show all sums of discounts across line items at an opportunity level.

What is the recommended solution to address these requirements?

Use roll-up for the line-item-level summary and a trigger for the opportunity amount summary, as only one level roll-up is allowed.

Update the master-detail relationships to lookup relationships in order to allow the discount amount to roll up.

Remove the master-detail relationships and rely completely on workflow/triggers to summarize the discount amount.

Roll-up discount request amount at the line-item-level and line-item-level summary discount at the opportunity level.

54. The MDM solution provides de-duplication features, so it acts as the single source of truth.

How should a data architect implement the storage of master key within salesforce?

Store the master key in Heroku postgres and use Heroku connect for synchronization.

Create a custom object to store the master key with a lookup field to contact.

Create an external object to store the master key with a lookup field to contact.

Store the master key on the contact object as an external ID (Field for referential imports)

55. Get Cloudy Consulting monitors 15,000 servers, and these servers automatically record their status every 10 minutes. Because of company policy, these status reports must be maintained for 5 years. Managers at Get Cloudy Consulting need access to up to one week's worth of these status reports with all of their details.

An Architect is recommending what data should be integrated into Salesforce and for how long it should be stored in Salesforce.

Which two limits should the Architect be aware of? (Choose two.)

Data storage limits

Workflow rule limits

API Request limits

Webservice callout limits