2023 Realistic Data-Architecture-And-Management-Designer Dumps Latest Salesforce Practice Tests Dumps [Q129-Q152]

Rate this post

2023 Realistic Data-Architecture-And-Management-Designer Dumps Latest Salesforce Practice Tests Dumps

Data-Architecture-And-Management-Designer Dumps PDF – Data-Architecture-And-Management-Designer Real Exam Questions Answers

Salesforce Data-Architecture-And-Management-Designer exam is a challenging and rewarding certification that validates an individual’s expertise in Salesforce data architecture and management. It is a valuable credential for professionals who want to advance their careers in the Salesforce ecosystem and gain recognition for their skills and knowledge. With the high demand for Salesforce expertise, passing Data-Architecture-And-Management-Designer exam can open up many exciting opportunities for career growth and advancement.

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

Q130. Which three options can prevent your SOQL queries from being selective?

Using leading % wildcards.

Using trailing % wildcards.

Performing large loads and deletions.

Using NOT and != operators.

Using a custom index on a deterministic formula field.

Q131. In a Salesforce org used to manage Contacts, what two options should be considered to maintain data quality? Choose 2 answers

Use the private sharing model.

Use Salesforce duplicate management.

Use validation rules on new record create and edit.

Use workflow to delete duplicate records.

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

Q133. NTO has a loyalty program to reward repeat customers. The following conditions exists:
1. Reward levels are earned based on the amount spent during the previous 12 months.
2. The program will track every item a customer has bought and grant them points for discount.
3. 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.

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

Q135. Universal Containers is creating a new B2C service offering for consumers to ship goods across continents.
This is in addition to their well-established B2B offering. Their current Salesforce org uses the standard Account object to track B2B customers. They are expecting to have over 50,000,000 consumers over the next five years across their 50 business regions. B2C customers will be individuals. Household data is not required to be stored. What is the recommended data model for consumer account data to be stored in Salesforce?

Use the Account object with Person Accounts and a new B2C page layout.

Use the Account object with a newly created Record Type for B2C customers.

Create a new picklist value for B2C customers on the Account Type field.

Use 50 umbrella Accounts for each region, with customers as associated Contacts.

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

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

Q138. A customer wants to maintain geographic location information including latitude and longitude in a custom object.
What would a data architect recommend to satisfy this requirement?

Recommend AppExchange packages to support this requirement

Create formula fields with geolocation function for this requirement

Create a geolocation custom field to maintain this requirement

Create custom fields to maintain latitude and longitude information

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

Q140. Universal Containers has 30 million case records. The Case object has 80 fields. Agents are reporting performance issues and time-outs while running case reports in the Salesforce org.
Which solution should a data architect recommend to improve reporting performance?

Create a custom object to store aggregate data and run reports.

Contact Salesforce support to enable skinny table for cases.

Move data off of the platform and run reporting outside Salesforce, and give access to reports.

Build reports using custom Lightning components.

Q141. Universal Containers wants to develop a dashboard in Salesforce that will allow Sales Managers to do data exploration using their mobile device (i.e., drill down into sales-related data) and have the possibility of adding ad-hoc filters while on the move. What is a recommended solution for building data exploration dashboards in Salesforce?

Create a Dashboard in an external reporting tool, export data to the tool, and add link to the dashboard in Salesforce.

Create a Dashboard in an external reporting tool, export data to the tool, and embed the dashboard in Salesforce using the Canval toolkit.

Create a standard Salesforce Dashboard and connect it to reports with the appropriate filters.

Create a Dashboard using Analytics Cloud that will allow the user to create ad-hoc lenses and drill down.

Q142. Universal Containers (UC) is migrating from a legacy system to Salesforce CRM, UC is concerned about the quality of data being entered by users and through external integrations.
Which two solution should a data architect recommend to mitigate data quality issues?

Leverage picklist and lookup fields where possible

Leverage Apex to validate the format of data being entered via a mobile device.

Leverage validation rules and workflows.

Leverage third-party- AppExchange tools

Q143. Cloud Kicks needs to optimize data stewardship engagement for a Salesforce instance.
Before proposing design recommendations, the Data Architect is first assessing relevant areas of Salesforce.
Which three areas are appropriate to assess? (Choose three.)

Assess the metadata xml files for redundant fields to consolidate.

Determine if any integration points create records in Salesforce.

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

Run key reports to determine what fields should be required.

Assess the sharing model to determine impact on duplicate records.

Q144. Universal Containers keeps its Account data in Salesforce and its Invoice data in a third -party ERP system.
They have connected the Invoice data through a Salesforce external object. They want data from both Accounts and Invoices visible in one report in one place. What two approaches should an architect suggest for achieving this solution? Choose 2 answers

Create a report in an external system combining Salesforce Account data and Invoice data from the ERP.

Create a report combining data from the Account standard object and the Invoices external object.

Create a Visualforce page combining Salesforce Account data and Invoice external object data.

Create a separate Salesforce report for Accounts and Invoices and combine them in a dashboard.

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

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

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

Q148. An architect has been asked by a client to develop a solution that will integrate data and resolve duplicates and discrepancies between Salesforce and one or more external systems. What two factors should the architect take into consideration when deciding whether or not to use a Master Data Management system to achieve this solution?
Choose 2 answers

Whether the systems are cloud -based or on -premise.

Whether or not Salesforce replaced a legacy CRM.

Whether the system of record changes for different tables.

The number of systems that are integrating with each other.

Q149. Universal Containers (UC) has an open sharing model for its Salesforce users to allow all its Salesforce internal users to edit all contacts, regardless of who owns the contact. However, UC management wants to allow only the owner of a contact record to delete that contact. If a user does not own the contact, then the user should not be allowed to delete the record. How should the architect approach the project so that the requirements are met?

Create a “before delete” trigger to check if the current user is not the owner.

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

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

Create a validation rule on the Contact object to check if the current user is not the owner.

Q150. DreamHouse Realty has a legacy system that captures Branch Offices and Transactions. DreamHouse Realty has 15 Branch Offices. Transactions can relate to any Branch Office. DreamHouse Realty has created hundreds of thousands of Transactions per year.
A Data Architect needs to denormalize this data model into a single Transaction object with a Branch Office picklist.
What are two important considerations for the Data Architect in this scenario? (Choose two.)

Standard list view in-line editing.

Limitations on Org data storage.

Bulk API limitations on picklist fields.

Limitations on master-detail relationships.

Q151. NTO has outgrown its current salesforce org and will be migrating to new org shortly. As part of this process NTO will be migrating all of its metadata and dat a. NTO’s data model in the source org has a complex relationship hierarchy with several master detail and lookup relationships across objects, which should be maintained in target org.
What 3 things should a data architect do to maintain the relationship hierarchy during migration?
Choose 3 answers:

Use data loader to export the data from source org and then import or Upsert into the target org in sequential order.

Create a external id field for each object in the target org and map source record ID’s to this field.

Redefine the master detail relationship fields to lookup relationship fields in the target org.

Replace source record ID’s with new record ID’s from the target org in the import file.

Keep the relationship fields populated with the source record ID’s in the import file.

Q152. Universal Containers (UC) management has identified a total of ten text fields on the Contact object as important to capture any changes made to these fields, such as who made the change, when they made the change, what is the old value, and what is the new value. UC needs to be able to report on these field data changes within Salesforce for the past 3 months. What are two approaches that will meet this requirement? Choose 2 answers

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.

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

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

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.