[2023] Use Valid Data-Architecture-And-Management-Designer Exam - Actual Exam Question & Answer [Q66-Q90]

Rate this post

[2023] Use Valid Data-Architecture-And-Management-Designer Exam – Actual Exam Question & Answer

Test Engine to Practice Data-Architecture-And-Management-Designer Test Questions

Q66. DreamHouse Realty has an integration that creates records in a Salesforce Custom Object. The Custom Object has a field marked as required on the page layout.
DreamHouse Realty has noticed that many of the records coming from the external system are missing data in this field.
The Architect needs to ensure this field always contains data coming from the source system.
Which two approaches should the Architect take? Choose 2 answers

Set up a Validation Rule to prevent blank values.

Create a Workflow to default a value into this field.

Mark the field required in setup at the field level.

Blame the customer’s external system for bad data.

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

Q68. Northern Trail Outfitters has these simple requirements for a data export process:
1. File format should be in CSV.
2. Process should be scheduled and run once per week.
3. The export should be configurable through the Salesforce UI.
Which tool should a data architect leverage to accomplish these requirements?

Data loader

Bulk API

Data export wizard

Third-party ETL tool

Q69. Northern Trail Outfitters has these simple requirements for a data export process:
File format should be in CSV.
Process should be scheduled and run once per week.
The expert should be configurable through the Salesforce UI.
Which tool should a data architect leverage to accomplish these requirements?

Bulk API

Data export wizard

Third-party ETL tool

Data loader

Q70. NTO would like to retrieve their SF orgs meta data programmatically for backup within a various external. Which API is the best fit for accomplishing this task?

Metadata API

Tooling API

Bulk API in serial mode

SOAP API

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

Q72. Universal Containers wants their Shipment custom object to always relate to a Container, a Sender, and a Receiver (all separate custom objects). If a Shipment is currently associated with a Container, Sender, or Receiver, deletion of those records should not be allowed.
They also want separate sharing models on each custom object. What approach should an architect take to fulfill these requirements?

Create a required Lookup relationship to each of the three parent records.

Create two Master -Detail and one Lookup relationship to the parent records.

Create a Master -Detail relationship to each of the three parent records.

Use a VLOOKUP formula field to associate the Shipment to each parent record.

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

Q74. DreamHouse Realty recently implemented a Sales Cloud. Managers have noticed that sales reps are entering an insufficient amount of data to run insightful reports and dashboards. The managers would like to monitor and measure data quality metrics.
Which solution addresses this requirement?

Use custom objects and fields to calculate data quality.

Utilize third-party AppExchange tools to measure and monitor data quality.

Run and generate reports to view the quality of sample data.

Export the data to an enterprise data warehouse and use BI tools for data quality.

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

Q76. Universal Containers (UC) is in the process of selling half of its company. As part of this split, UC’s main Salesforce org will be divided into two org:org A and org B, UC has delivered these requirements to its data architect
1. The data model for Org B will drastically change with different objects, fields, and picklist values.
2. Three million records will need to be migrated from org A to org B for compliance reasons.
3. The migrate will need occur within the next two month, prior to be split.
Which migrate strategy should a data architect use to successfully migrate the date?

use as ETL tool to orchestrate the migration.

Use Data Loader for export and Data Import Wizard for import

Write a script to use the Bulk API

Use the Salesforces CLI to query, export, and import

Q77. UC 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?

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

Enable and use the query plan tool in the developer console.

Use salesforce’s query optimizer to analyze the query in the developer console.

Open a ticket with salesforce support to retrieve transaction logs to e analyzed for processing time.

Q78. What 2 data management policies does the data classification feature allow customers to classify in salesforce? Choose 2 answers:

Reference data policy.

Data governance policy.

Data sensitivity policy.

Compliance categorization policy.

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

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

Q81. NTO would like to retrieve their SF orgs meta data programmatically for backup within a various external.
Which API is the best fit for accomplishing this task?

Metadata API

Tooling API

Bulk API in serial mode

SOAP API

Q82. UC has a salesforce org with multiple automated processes defined for group membership process. UC also have multiple admins on staff that perform manual adjustments to the role hierarchy. The automated task and manual task overlap daily and UC is experiencing “Lock errors” consistently.
What should a data architect recommend mitigate these errors?

Ask salesforce support for addition CPU power.

Enable granular locking.

Remove SOQL statements from APEX loops.

Enable sharing recalculations

Q83. An architect is planning on having different batches to load one million Opportunities into Salesforce using the Bulk API in parallel mode. What should be considered when loading the Opportunity records?

Create indexes on Opportunity object text fields.

Group batches by the AccountId field.

Sort batches by Name field values.

Order batches by Auto -number field.

Q84. Northern trail Outfitters (NTO) uses Sales Cloud and service Cloud to manage sales and support processes. Some of NTOs team are complaining they see new fields on their page unsure of which values need be input. NTO is concerned about lack of governance in making changes to Salesforce.
Which governance measure should a data architect recommend to solve this issue?

Add description fields to explain why the field is used, and mark the field as required.

Create and manage a data dictionary and ups a governance process for changes made to common objects.

Create reports to identify which users are leaving blank, and use external data sources o agreement the missing data.

Create validation rules with error messages to explain why the fields is used

Q85. A customer wishes to migrate 700,000 Account records in a single migration into Salesforce. What is the recommended solution to migrate these records while minimizing migration time?

Use Salesforce Soap API in parallel mode.

Use Salesforce Bulk API in serial mode.

Use Salesforce Bulk API in parallel mode.

Use Salesforce Soap API in serial mode.

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

Q87. Members of DreamHouse Realty sales team are reporting that searches are yielding too many irrelevant, outdated records. Management requires that data for historical reporting. DreamHouse Realty has enough data storage.
In this situation, which strategy should a data architect use to ensure a better user experience for the Sales Reps?

Hide old data from Sales Reps by setting data access to Private.

Archive and purge old data from Salesforce on a monthly basis.

Use Batch Apex to archive old data on a rolling nightly basis.

Hide old data from Sales Reps by creating a Permission Set.

Q88. Universal containers is implementing Salesforce lead management. UC Procure 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

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

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