[Mar 01, 2024] Data-Architecture-And-Management-Designer Exam Dumps PDF Updated Dump from DumpsReview Guaranteed Success [Q28-Q52]

4/5 - (2 votes)

[Mar 01, 2024] Data-Architecture-And-Management-Designer Exam Dumps PDF Updated Dump from DumpsReview Guaranteed Success

Pass Your Salesforce Exam with Data-Architecture-And-Management-Designer Exam Dumps

Who should take the Data-Architecture-And-Management-Designer exam

Salesforce Certified Data Architecture and Management Designer certification is an internationally-recognized validation that identifies persons who earn it as possessing skilled as a Salesforce Certified Data Architecture and Management Designer. If a candidate wants significant improvement in career growth needs enhanced knowledge, skills, and talents. The Salesforce Data-Architecture-And-Management-Designer Exam provides proof of this advanced knowledge and skill. If a candidate has knowledge of associated technologies and skills that are required to pass the Salesforce Data-Architecture-And-Management-Designer Exam then he should take this exam.

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

NEW QUESTION 29
Ursa Major Solar is performance testing a Lightning Platform application.
Which two statements are true about this testing? (Choose two.)

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

Every Lightning Platform application must be performance tested in a sandbox as well as production.

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

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

NEW QUESTION 30
Universal Containers developers have created a new Lightning component that uses an Apex controller using a SOQL query to populate a custom list view. Users are complaining that the component often fails to load and returns a time-out error.
What tool should a data architect use to identify why the query is taking too long?

Enable and use the Query Plan tool in the developer console

Use Splunk to query the system logs looking for transaction time and CPU usage

Use Salesforce’s query optimizer to analyze the query in the developer console

Open a ticket with Salesforce support to retrieve transaction logs to be analyzed for processing time

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

NEW QUESTION 32
Universal Containers (UC) recently migrated 1 billion customer related records from a legacy datastore to Heroku Postgres. A subnet of the data needs 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?

Use Heroku Connect to bidirectionally sync all data between systems

As needed, make callouts into Heroku Postgres and persist the data in Salesforce

Virtualize the remaining set of data with Salesforce Connect and external objects

Migrate the data to big objects and leverage Async SOQL with custom objects

NEW QUESTION 33
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 34
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.

NEW QUESTION 35
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 36
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 37
Ursa Major Solar has defined a new Data Quality Plan for their Salesforce data.
Which two approaches should an Architect recommend to enforce the plan throughout the organization?
(Choose two.)

Ensure all data is stored in an external system and set up an integration to Salesforce for view-only access.

Schedule reports that will automatically catch duplicates and merge or delete the records every week.

Enforce critical business processes by using Workflow, Validation Rules, and Apex code.

Schedule a weekly dashboard displaying records that are missing information to be sent to managers for review.

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

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

NEW QUESTION 40
Northern Trail Outfitters (NTO) is in the process of evaluating big objects to store large amounts of asset data from an external system. NTO will need to report on this asset data weekly.
Which two native tools should a data architect recommend to achieve this reporting requirement? (Choose two.)

Einstein Analytics

Standard reports and dashboards

Async SOQL with a custom object

Standard SOQL queries

NEW QUESTION 41
Northern Trail Outfitters is 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 Salesforce?

Migrate to Salesforce without a record owner.

Assign record owners based on relationship.

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

Create custom object to store agent relationships.

NEW QUESTION 42
A casino is implementing Salesforce and is planning to build a customer 360 degree view for a customer who visits its resorts. The casino currently maintains the following systems that record customer activity: L Point-of-sale system: All purchases for a customer
2. Salesforce; All customer service activity and sales activities 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 Salesforee would like to view the activities from all four systems to provide support 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 a 360 degree view of the customer.

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

Periodically upload summary information in Salesforce to build a 360 degree view.

Migrate customer activities fro, all four system into Salesforce.

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

NEW QUESTION 44
Universal Containers (UC) needs to run monthly and yearly reports on opportunities and orders for sales reporting. There are 5 million opportunities and 10 million orders. Sales users are complaining that the report will regularly timeout.
What is the fastest and most effective way for a data architect to solve the time-out issue?

Create custom fields on opportunity, and copy data from order into those custom fields and run all reports on Opportunity object.

Extract opportunity and order data from Salesforce, and use a third-party reporting tool to run reports outside of Salesforce.

Create a skinny table in Salesforce, and copy order and opportunity fields into the skinny table and create the required reports on It.

Create an aggregate custom object that summarizes the monthly and yearly values into the required format for the required reports.

NEW QUESTION 45
Which two aspects of data does an Enterprise data governance program aim to improve?

Data integrity

Data distribution

Data usability

Data modeling

NEW QUESTION 46
What are two valid metadata types that should be included to document the data architecture of a Salesforce org? Choose 2 answers

RecordType

Document

CustomField

SecuritySettings

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

NEW QUESTION 48
Universal Containers (UC) 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. What should the architect consider, knowing there will be a large amount of time entry records to be loaded regularly from an external system into Salesforce.com?

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

Use workflow to calculate summary values instead of Roll -Up.

Use triggers to calculate summary values instead of Roll -Up.

Load all data after deferring sharing calculations.

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

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

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

NEW QUESTION 51
What are two key artifacts used to document the data architecture for a multi -system enterprise Salesforce implementation? Choose 2 answers

User stories

Data model

Non-functional requirements

Integration specification

NEW QUESTION 52
NTO has multiple systems across its enterprise landscape including salesforce, with disparate version the customer records.
In salesforce, the customer is represented by the contact object.
NTO utilizes an MDM solution with these attributes:
1. The MDM solution keeps track of customer master with a master key.
2. The master key is a map to the record ID’s from each external system that customer data is stored within.
3. 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)