New 2022 Data-Architecture-And-Management-Designer Dumps for Salesforce Application Architect Certified Exam Questions & Answer [Q27-Q48]

Rate this post

New 2022 Data-Architecture-And-Management-Designer Dumps for Salesforce Application Architect Certified Exam Questions and Answer

Realistic Verified Data-Architecture-And-Management-Designer exam dumps Q&As – Data-Architecture-And-Management-Designer Free Update

How much Data-Architecture-And-Management-Designer Exam Cost

The price of the Salesforce Data-Architecture-And-Management-Designer exam is $400 USD and exam retake fee is $200 USD.

NO.27 What makes Skinny tables fast? Choose three answers.

They do not include soft-deleted records

They avoid resource intensive joins

Their tables are kept in sync with their source tables when the source tables are modified

They can contain fields from other objects

They support up to a max of 100 of columns

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

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

NO.30 Universal Containers (UC) is implementing a formal, cross -business -unit data governance program As part of the program, UC will implement a team to make decisions on enterprise -wide data governance. Which two roles are appropriate as members of this team? Choose 2 answers

Analytics/BI Owners

Data Domain Stewards

Salesforce Administrators

Operational Data Users

NO.31 An architect has been asked to provide error messages when a future date is detected in a custom Birthdate _c field on the Contact object. The client wants the ability to translate the error messages. What are two approaches the architect should use to achieve this solution? Choose 2 answers

Implement a third -party validation process with translate functionality.

Create a trigger on Contact and add an error to the record with a custom label.

Create a workflow field update to set the standard ErrorMessage field.

Create a validation rule and translate the error message with translation workbench.

NO.32 Ursa Major Solar provides home installment services to its customers. To track these home installments, the company uses Opportunities. At any given time, the status of the home installments can be one of the
10 values. Currently, Ursa Major Solar has 189,000 Opportunity records.
An Architect needs to create a new field to track home installment status opportunity while also improving data quality and avoiding data skew.
What should the Architect do?

Create a picklist field, values sorted alphabetically.

Create a Master-Detail to custom object InstallmentStatus_c.

Create a text field and make it an external ID.

Create a Lookup to custom object InstallmentStatus_c.

NO.33 An Architect needs to assist Get Cloudy Consulting to maintain Lead data, even after Lead records are deleted and the Recycle Bin emptied.
What should the Architect do to implement this solution?

Send data to a Data Warehouse and mark Leads as deleted in that system.

Use a Converted Lead report to display data on Leads that have been deleted.

Use a Lead standard report and filter on the IsDeleted standard field.

Query Salesforce with the queryAll API method or using the ALL ROWS SOQL keywords.

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

NO.35 A large Automobile company has implemented SF for its Sales Associates. Leads flow from its website to SF using a batch integration in SF. The Batch job connects the leads to Accounts in SF. Customer visiting their retail stores are also created in SF as Accounts.
The company has noticed a large number of duplicate accounts in SF. On analysis, it was found that certain customers could interact with its website and also visit the store. The Sales associates use Global Search to search for customers in Salesforce before they create the customers.
Which scalable option should a data Architect choose to implement to avoid duplicates?

Create duplicate rules in SF to validate duplicates during the account creation process

Implement a MDM solution to validate the customer information before creating Accounts in SF.

Build Custom search based on fields on Accounts which can be matched with customer when they visit the store

Customize Account creation process to search if customer exists before creating an Account.

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

NO.37 Managers at Universal Containers (UC) have noticed that shipment records (a custom object) are being sent to the shipping department with bad address data Specifically, addresses have missing data like City and poorly formatted Postal codes. Which two approaches will solve this issue? Choose 2 answers

Edit each of the page layouts to require that each address field contains data.

Use a Validation Rule using CONTAINS to ensure address fields contain data.

Use a Validation Rule using REGEX to ensure proper Postal Code formatting.

Write an Apex Trigger to require all of the fields on the page layouts.

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

NO.39 Universal Containers (UC) has a Salesforce instance with over 10.000 Account records. They have noticed similar, but not identical. Account names and addresses. What should UC do to ensure proper data quality?

Use a service to standardize Account addresses, then use a 3rd -party tool to merge Accounts based on rules.

Run a report, find Accounts whose name starts with the same five characters, then merge those Accounts.

Enable Account de -duplication by creating matching rules in Salesforce, which will mass merge duplicate Accounts.

Make the Account Owner clean their Accounts’ addresses, then merge Accounts with the same address.

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

NO.41 Universal Containers (UC) has implemented Salesforce, UC is running out of storage and needs to have an archiving solution, UC would like to maintain two years of data in Saleforce and archive older data out of Salesforce.
Which solution should a data architect recommend as an archiving solution?

Use a third-party backup solution to backup all data off platform.

Build a batch join move all records off platform, and delete all records from Salesforce.

Build a batch join to move two-year-old records off platform, and delete records from Salesforce.

Build a batch job to move all restore off platform, and delete old records from Salesforce.

NO.42 Universal Containers is migrating individual customers (B2C) data from legacy systems to Salesforce. There are millions of customers stored as account and contacts in the legacy database.
Which object model should a data architect configure within Salesforce?

Leverage person account object in Salesforce

Leverage standard account and contact object in Salesforce

Leverage custom account and contact object in Salesforce

Leverage custom person account object in Salesforce

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

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

NO.45 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?

Create formula fields with geolocation function for this requirement.

Create custom fields to maintain latitude and longitude information

Create a geolocation custom field to maintain this requirement

Recommend app exchange packages to support this requirement.

NO.46 NTO has implemented salesforce for its sales users. The opportunity management in salesforce is implemented as follows:
1. Sales users enter their opportunities in salesforce for forecasting and reporting purposes.
2. NTO has a product pricing system (PPS) that is used to update opportunity amount field on opportunities on a daily basis.
3. PPS is the trusted source within the NTO for opportunity amount.
4. 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 NULL.

NO.47 Cloud Kicks has a system environment that is complex, and they plan on creating a data governance program for the first time.
What are two initial actions Cloud Kicks should take to initiate an assessment of data architecture? (Choose two.)

Work with database administrators to assess current database performance metrics.

Work with executive sponsorship to assess enterprise data strategy and goals.

Work with IT program managers to assess current velocity of projects in the pipeline.

Work with business units and IT to assess current operational systems and data models.

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