Ultimate Guide to Prepare Free Salesforce Data-Architecture-And-Management-Designer Exam Questions & Answer [Q74-Q98]

Rate this post

Ultimate Guide to Prepare Free Salesforce Data-Architecture-And-Management-Designer Exam Questions and Answer

Pass Salesforce Data-Architecture-And-Management-Designer Tests Engine pdf – All Free Dumps

NEW QUESTION 74
Global Containers (GC) just acquired Universal Containers (UC). Both companies use Salesforce. and as part of the acquisition, all of the data for the UC Salesforce instance (source) must be migrated into the GC Salesforce instance (target). Universal Containers has over 5 million Case records. What should the architect consider when trying to optimize the data load time?

Use the Salesforce Org Migration Tool from the Setup Data Management menu.

Pre-process the data, then use Data Loader with SOAP API to upsert with zip compression enabled.

Load Case data directly leveraging Salesforce-to-Salesforce functionality.

Break the load into multiple sets of data to be loaded using Bulk API parallel processes.

NEW QUESTION 75
Universal Containers (UC) has an Application custom object, which has tens of millions of records created in the past 5 years. UC needs the last 5 years of data to exist in Salesforce at all times for reporting and queries. UC is currently encountering performance issues when reporting and running queries on this Object using date ranges as filters. Which two options can be used to improve report performance?

Ask support to create a skinny table for Application with the necessary reporting fields.

Add custom indexes to all fields on Application without a standard index.

Run multiple reports to get different pieces of the data and combine them.

Add custom indexes to the Date fields used for filtering the report.

NEW QUESTION 76
A phased Salesforce rollout is planned. Three deployments will be spread out over 12 months, and the requirements have been carefully documented.
An Architect needs to trace back configuration changes to the requirements.
Which two approaches should the Architect use? (Choose two.)

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

Analyze the setup audit trail for configuration changes.

Enter the business purpose into the Description of each field.

Maintain a data dictionary with the justification for each field.

NEW QUESTION 77
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.

NEW QUESTION 78
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

NEW QUESTION 79
Universal Containers (UC) is facing data quality issues where Sales Reps are creating duplicate customer accounts, contacts, and leads. UC wants to fix this issue immediately by prompting users about a record that possibly exists in Salesforce. UC wants a report regarding duplicate records. What would be the recommended approach to help UC start immediately?

Create an after insert and update trigger on the account, contact and lead, and send an error if a duplicate is found using a custom matching criteria.

Create a duplicate rule for account, lead, and contact, use standard matching rules for these objects, and set the action to report and alert for both creates and edits.

Create a duplicate rule for account, lead, and contact, use standard matching rules for these objects, and set the action to block for both creates and edits.

Create a before insert and update trigger on account, contact, and lead, and send an error if a duplicate is found using a custom matching criteria.

NEW QUESTION 80
Developers at Universal Containers need to build a report for the business which displays Accounts opened in the past year grouped by industry. This report will also include information from contacts, opportunities, and orders. There are several million Accounts in the system. Which two options should be recommended to make this report perform well and satisfy the business need?

Use triggers to populate denormalized related fields on the Account.

Use an indexed data field with bounded data filters.

Use Formula fields to surface information I related entities on the report.

Use unbounded date ranges to filter the report.

NEW QUESTION 81
To avoid creating duplicate Contacts, a customer frequently uses Data Loader to upsert Contact records into Salesforce. What common error should the data architect be aware of when using upsert?

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

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

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

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

NEW QUESTION 82
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.

NEW QUESTION 83
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.

NEW QUESTION 84
Universal Containers wants to automatically archive all inactive Account data that is older than 3 years. The information does not need to remain accessible within the application. Which two methods should be recommended to meet this requirement? Choose 2 answers

Use the Force.com Workbench to export the data.

Schedule a weekly export file from the Salesforce UI.

Schedule jobs to export and delete using an ETL tool.

Schedule jobs to export and delete using the Data Loader.

NEW QUESTION 85
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.

NEW QUESTION 86
A custom pricing engine for a Salesforce customer has to be decided by factors with the following hierarchy:
1. State in which the customer is located
2. City in which the customer is located if available
3. Zip code in which the customer is located if available
4. Changes to this information should have minimum code change
What should a data architect recommend to maintain this information for the custom pricing engine that is to be built in Salesforce?

Configure the pricing criteria in price books.

Assign the pricing criteria within custom pricing engine.

Maintain required pricing criteria in custom metadata types.

Create a custom object to maintain the pricing criteria.

NEW QUESTION 87
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.

NEW QUESTION 88
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

NEW QUESTION 89
Universal Containers (UC) has a Salesforce org with multiple automated processes defined for group membership processing. UC also has multiple admins on staff that perform manual adjustments to the role hierarchy. The automated tasks and manual tasks overlap daily, and UC is experiencing “lock errors” consistently.
What should a data architect recommend to mitigate these errors?

Enable granular locking

Ask Salesforce support for additional CPU power

Remove SOQL statements from Apex Loops

Enable sharing recalculations

NEW QUESTION 90
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.

NEW QUESTION 91
Universal Containers (UC) has over 10 million accounts with an average of 20 opportunities with each account. A Sales Executive at UC needs to generate a daily report for all opportunities in a specific opportunity stage.
Which two key considerations should be made to make sure the performance of the report is not degraded due to large data volume?

Number of queries running at a time.

Number of joins used in report query.

Number of records returned by report query.

Number of characters in report query.

NEW QUESTION 92
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.)

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

Contact Salesforce to activate indexing before uploading the data.

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

Defer sharing calculations until the data has finished uploading.

NEW QUESTION 93
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?

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

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

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

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

NEW QUESTION 94
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.

NEW QUESTION 95
Every year, Ursa Major Solar has more than 1 million orders. Each order contains an average of 10 line items. The Chief Executive Officer (CEO) needs the Sales Reps to see how much money each customer generates year-over-year. However, data storage is running low in Salesforce.
Which approach for data archiving is appropriate for this scenario?

1. Annually export and delete order line items.
2. Store them in a zip file in case the data is needed later.

1. Annually aggregate order amount data to store in a custom object.
2. Delete those orders and order line items.

1. Annually export and delete orders and order line items.
2. Store them in a zip file in case the data is needed later.

1. Annually delete orders and order line items.
2. Ensure the customer has order information in another system.

NEW QUESTION 96
Universal Containers (UC) is implementing Salesforce and will be using Salesforce to track customer complaints, provide white papers on products, and provide subscription (fee)-based support.
Which license type will UC users need to fulfill UC’s requirements?

Salesforce License

Lightning Platform Starter License

Service Cloud License

Sales Cloud License

NEW QUESTION 97
A customer is operating in a highly regulated industry and is planning to implement Salesforce. The customer information maintained in Salesforce, includes the following:
1. Personally identifiable information (PII)
2. IP restrictions on profiles organized by geographic location
3. Financial records that need to be private and accessible only by the assigned sales associate
4. Users should not be allowed to export information from Salesforce
Enterprise Security has mandated access to be restricted to users within a specific geography and detail monitoring of user activity.
Which three Salesforce Shield capabilities should a data architect recommend? (Choose three.)

Event monitoring to monitor all user activity

Prevent sales users access to customer PII information

Restrict access to Salesforce from users outside specific geography

Encrypt sensitive customer information maintained in Salesforce

Transaction Security policies to prevent export of Salesforce data

NEW QUESTION 98
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.

Salesforce Data-Architecture-And-Management-Designer certification exam is a challenging exam that requires extensive preparation, experience, and knowledge of the Salesforce platform. Data-Architecture-And-Management-Designer exam consists of 60 multiple-choice questions and has a duration of 120 minutes. Data-Architecture-And-Management-Designer exam covers various topics such as data management, data modeling, data integration, data governance, data security, and data quality. The passing score for Data-Architecture-And-Management-Designer exam is 63%, and the exam fee is $400.

Online Exam Practice Tests with detailed explanations!: https://www.testkingfree.com/Salesforce/Data-Architecture-And-Management-Designer-practice-exam-dumps.html