Pass Your Data-Architecture-And-Management-Designer Exam at the First Try with 100% Real Exam Questions [Q46-Q66]

4.5/5 - (2 votes)

Pass Your Data-Architecture-And-Management-Designer Exam at the First Try with 100% Real Exam Questions

New Salesforce Data-Architecture-And-Management-Designer Dumps & Questions Updated on 2023

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

Use SOQL queries without WHERE conditions.

Work with Salesforce Support to enable Skinny Tables.

Reduce the number of triggers on Order _c object.

Make the queries more selective using indexed fields.

NEW QUESTION 47
A casino is implementing salesforce and is planning to build a customer 360 view for a customer who visits its resorts. The casino currently maintained the following systems that records customer activity:
1. Point of sales system: All purchases for a customer.
2. Salesforce: All customer service activity and sales activity for a customer.
3. Mobile app: All bookings, preferences and browser activity for a customer.
4. Marketing: All email, SMS and social campaigns for a customer.
Customer service agents using salesforce would like to view the activities from all system to provide supports to customers. The information has to be current and real time.
What strategy should the data architect implement to satisfy this requirement?

Explore external data sources in salesforce to build 360 view of customer.

Use a customer data mart to view the 360 view of customer.

Migrate customer activities from all 4 systems into salesforce.

Periodically upload summary information in salesforce to build 360 view.

NEW QUESTION 48
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 49
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.

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

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 51
A company is introducing a new data quality process and needs an Architect to recommend an appropriate approach. The new process will monitor the data that users are manually entering into the system through the Salesforce UI.
Which recommendation is correct?

Create data-quality dashboards by using an app from the AppExchange.

Enable users to import their data using the Salesforce Import tools.

Use a 3rd-party solution from the AppExchange for data uploads.

Validate the format of phone numbers and postal codes by using Apex.

NEW QUESTION 52
The leadership team at Get Cloudy Consulting has identified a total of ten text fields on the Contact object as critical. The team wants to capture any changes made to these fields, including the following:
* who made the change
* when they made the change
* what is the old value
* what is the new value
Get Cloudy Consulting needs to be able to report on these field data changes within Salesforce for the past 3 months.
Which two approaches will meet this requirement? (Choose two.)

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.

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.

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.

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

NEW QUESTION 54
Universal Containers has millions of rows of data in Salesforce that are being used in reports to evaluate historical trends. Performance has become an issue, as well as data storage limits. Which two strategies should be recommended when talking with stakeholders?

Use scheduled batch Apex to copy aggregate information into a custom object and delete the original records.

Combine Analytics Snapshots with a purging plan by reporting on the snapshot data and deleting the original records.

Use Data Loader to extract data, aggregate it, and write it back to a custom object, then delete the original records.

Configure the Salesforce Archiving feature to archive older records and remove them from the data storage limits.

NEW QUESTION 55
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 56
A Customer is migrating 10 million order and 30 million order lines into Salesforce using Bulk API. The Engineer is experiencing time-out errors or long delays querying parents order IDs in Salesforce before importing related order line items. What is the recommended solution?

Query only indexed ID field values on the imported order to import related order lines.

Leverage an External ID from source system orders to import related order lines.

Leverage Batch Apex to update order ID on related order lines after import.

Leverage a sequence of numbers on the imported orders to import related order lines.

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

NEW QUESTION 58
Universal Containers (UC) is a major supplier of office supplies. Some products are produced by UC and some by other manufacturers. Recently, a number of customers have complained that product descriptions on the invoices do not match the descriptions in the online catalog and on some of the order confirmations (e.g., “ballpoint pen” in the catalog and “pen” on the invoice, and item color labels are inconsistent: “what vs. “White” or “blk” vs. “Black”). All product data is consolidated in the company data warehouse and pushed to Salesforce to generate quotes and invoices. The online catalog and webshop is a Salesforce Customer Community solution. What is a correct technique UC should use to solve the data inconsistency?

Change integration to let product master systems update product data directly in Salesforce via the Salesforce API.

Add custom fields to the Product standard object in Salesforce to store data from the different source systems.

Define a data taxonomy for product data and apply the taxonomy to the product data in the data warehouse.

Build Apex Triggers in Salesforce that ensure products have the correct names and labels after data is loaded into salesforce.

NEW QUESTION 59
Northern Trail Outfitters (NTO) wants to implement backup and restore for Salesforce data, Currently, it has data backup processes that runs weekly, which back up all Salesforce data to an enterprise data warehouse (EDW). NTO wants to move to daily backups and provide restore capability to avoid any data loss in case of outage.
What should a data architect recommend for a daily backup and restore solution?

Use AppExchange package for backup and restore.

Use ETL for backup and restore from EDW.

Use Bulk API to extract data on daily basis to EDW and REST API for restore.

Change weekly backup process to daily backup, and implement a custom restore solution.

NEW QUESTION 60
Ursa Major Solar has 4 million rows of data in Salesforce that are used in reports to assess historical trends.
Both performance and data storage limits have become an issue.
Which two strategies are appropriate when discussing the issue with stakeholders? (Choose two.)

Utilize scheduled batch Apex to copy aggregate information into a custom object and delete the original records.

Combine Analytics Snapshots with a purging plan by reporting on the snapshot data and deleting the original records.

Utilize Data Loader to extract data, aggregate it, and write it back to a custom object, then delete the original records.

Configure the Salesforce Archiving feature to archive older records and remove them from the data storage limits.

NEW QUESTION 61
Ursa Major Solar plans to use Salesforce to manage their sales organization. However, the company has legacy account data from two aging systems that must be migrated into Salesforce. The Chief Technology Officer (CTO) at Ursa Major Solar is concerned about data duplication and needs it minimized.
What are two design considerations an Architect should take in this scenario? (Choose two.)

Before importing into Salesforce, clean the data.

Import the data concurrently.

Check and prevent duplicates by using a workflow.

Use Salesforce matching and duplicate rules.

NEW QUESTION 62
UC has a classic encryption for Custom fields and is leveraging weekly data reports for data backups. During the data validation of exported data UC discovered that encrypted field values are still being exported as part of data exported. What should a data architect recommend to make sure decrypted values are exported during data export?

Set a standard profile for Data Migration user, and assign view encrypted data

Create another field to copy data from encrypted field and use this field in export

Leverage Apex class to decrypt data before exporting it.

Set up a custom profile for data migration user and assign view encrypted data.

NEW QUESTION 63
Universal Containers has deployed Salesforce for case management The company is having difficulty understanding what percentage of cases are resolved from the initial call to their support organization. What first step is recommended to implement a reporting solution to measure the support reps case closure rates?

Enable field history tracking on the Case object.

Create a report on Case analytic snapshots.

Install AppExchange packages for available reports.

Create Contact and Opportunity Reports and Dashboards.

NEW QUESTION 64
UC recently migrated 1 Billion customer related records from a legacy data store to Heroku Postgres. A subset of the data need to be synchronized with salesforce so that service agents are able to support customers directly within the service console. The remaining non- synchronized set of data will need to be accessed by salesforce at any point in time, but UC management is concerned about storage limitations.
What should a data architect recommend to meet these requirements with minimal effort?

Virtualize the remaining set of data with salesforce connect and external objects.

Use Heroku connect to bi-directional, sync all data between systems.

As needed, make call outs into Heroku postgres and persist the data in salesforce.

Migrate the data to big objects and leverage async SOQL with custom objects.

NEW QUESTION 65
Universal Containers (UC) is concerned about the accuracy of their Customer information in Salesforce. They have recently created an enterprise-wide trusted source MDM for Customer data which they have certified to be accurate. UC has over 20 million unique customer records in the trusted source and Salesforce. What should an Architect recommend to ensure the data in Salesforce is identical to the MDM?

Extract the Salesforce data into Excel and manually compare this against the trusted source.

Load the Trusted Source data into Salesforce and run an Apex Batch job to find difference.

Use an AppExchange package for Data Quality to match Salesforce data against the Trusted source.

Leave the data in Salesforce alone and assume that it will auto-correct itself over time.

NEW QUESTION 66
DreamHouse Realty has a Salesforce org that is used to manage Contacts.
What are two things an Architect should consider using to maintain data quality in this situation? (Choose two.)

Utilize the private sharing model.

Use workflow to delete duplicate records.

Use validation rules on new record create and edit.

Utilize Salesforce duplicate management.

Updated Exam Data-Architecture-And-Management-Designer Dumps with New Questions: https://www.testbraindump.com/Data-Architecture-And-Management-Designer-exam-prep.html

Pass Your Data-Architecture-And-Management-Designer Exam at the First Try with 100% Real Exam Questions [Q46-Q66]

100% Free Marketing-Cloud-Administrator Files For passing the exam Quickly UPDATED Sep 22, 2025 [Q40-Q64]

[Jan 15, 2024] ADX-201E Test Engine files, ADX-201E Dumps PDF [Q84-Q102]

[Jul-2022] Free ADX-201E Exam Dumps to Improve Exam Score [Q269-Q291]

Leave a Reply Cancel reply

Related Posts

Leave a Reply Cancel reply