Easter Sale 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: save70

Free and Premium Salesforce Data-Architecture-And-Management-Designer Dumps Questions Answers

Salesforce Certified Data Architect (WI23) Questions and Answers

Question 1

A large automobile company has implemented Salesforce for its sales associates. Leads flow from its website to Salesforce using a batch integration in Salesforce. The batch job converts the leads to Accounts in Salesforce. Customers visiting their retail stores are also created in Salesforce as Accounts.

The company has noticed a large number of duplicate Accounts in Salesforce. On analysis, it was found that certain customers could interact with its website and also visitthe store. The sales associates use Global Search to search for customers in Salesforce before they create the customers.

Which option should a data architect choose to implement to avoid duplicates?

Options:

A.

leverage duplicate rules in Salesforce to validate duplicates during the account creation process.

B.

Develop an Apex class that searches for duplicates and removes them nightly.

C.

Implement an MDM solution to validate the customer information before creating Salesforce.

D.

Build a custom search functionality that allows sales associates to search for customer in real time upon visiting their retail stores.

Buy Now
Question 2

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

Options:

A.

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

B.

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

C.

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

D.

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

Question 3

UC is using SF CRM. UC sales managers are complaining about data quality and would like to monitor and measure data quality.

Which 2 solutions should a data architect recommend to monitor and measure data quality?

Choose 2 answers.

Options:

A.

Use custom objectsand fields to identify issues.

B.

Review data quality reports and dashboards.

C.

Install and run data quality analysis dashboard app

D.

Export data and check for data completeness outside of Salesforce.

Question 4

Ursa Major Solar's legacy system has a quarterly accounts receivable report that compiles data from the following:

- Accounts

- Contacts

- Opportunities

- Orders

- Order Line Items

Which issue will an architect have whenimplementing this in Salesforce?

Options:

A.

Custom report types CANNOT contain Opportunity data.

B.

Salesforce does NOT support Orders or Order Line Items.

C.

Salesforce does NOT allow more than four objects in a single report type.

D.

A report CANNOT contain data from Accounts and Contacts.

Question 5

NTO need to extract 50 million records from a custom object everyday from its Salesforce org. NTO is facing query timeout issues while extracting these records.

What should a data architect recommend in order to get around the time out issue?

Options:

A.

Use a custom auto number and formula field and use that to chunk records while extracting data.

B.

The REST API to extract data as it automatically chunks records by 200.

C.

Use ETL tool for extraction of records.

D.

Ask SF support to increase the query timeoutvalue.

Question 6

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

Options:

A.

Review the setup audit trail for configuration changes.

B.

Put the business purpose in the Description of each field.

C.

Maintain a data dictionary with the justification for each field.

D.

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

Question 7

Company S was recently acquired by Company T. As part of the acquisition, all of the data for the Company S's Salesforce instance (source) must be migrated into the Company T's Salesforce instance (target). Company S has 6 million Case records.

An Architect has been tasked with optimizing the data load time.

What should the Architect consider to achieve this goal?

Options:

A.

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

B.

Directly leverage Salesforce-to-Salesforce functionality to load Case data.

C.

Load the data in multiple sets using Bulk API parallel processes.

D.

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

Question 8

Universal Containers would like to remove data silos and connect their legacy CRM together with their ERP and with Salesforce. Most of their sales team has already migrated to Salesforce for daily use, although a few users are still on the old CRM until some functionality they require is completed. Which two techniques should be used for smooth interoperability now and in the future.

Options:

A.

Replicate ongoing changes in the legacy CRM to Salesforce to facilitate a smooth transition when the legacy CRM iseventually retired.

B.

Specify the legacy CRM as the system of record during transition until it is removed from operation and fully replaced by Salesforce.

C.

Work with stakeholders to establish a Master Data Management plan for the system of record for specific objects, records, and fields.

D.

Do not connect Salesforce and the legacy CRM to each other during this transition period, but do allow both to interact with the ERP.

Question 9

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 locka row” error.

Which solution should a data architect recommend, to resolve the error?

Options:

A.

Leverage data loader platform API to load data.

B.

Perform Batch job in parallel mode and reduce Batch size

C.

Perform Batch job in serial mode and reduce batch size

D.

Defer roll-up summary fields calculation during data migration.

Question 10

Universal container (UC) would like to build a Human resources application on Salesforce to manage employee details, payroll, and hiring efforts. To adequately and store the relevant data, the application will need to leverage 45 custom objects. In addition to this, UC expects roughly 20,00 API calls into Salesfoce from an n-premises application daily.

Which license type should a data architect recommend that best fits these requirements?

Options:

A.

Service Cloud

B.

Lightning platform Start

C.

Lightning Platform plus

D.

Lightning External Apps Starts

Question 11

Universal Containers would like to have a Service-Level Agreement (SLA) of 1 day for any data loss due to unintentional or malicious updates of records in Salesforce. What approach should be suggested to address this requirement?

Options:

A.

Build a daily extract job and extract data to on-premise systems for long-term backup and archival purposes.

B.

Schedule a Weekly Extract Service for key objects and extract data in XL sheets to on-premise systems.

C.

Store all data in shadow custom objects on any updates and deletes, and extract them as needed .

D.

Evaluate a third-party AppExchange app, such as OwnBackup or Spanning, etc., for backup and archival purposes.

Question 12

NTO has a loyalty program to reward repeat customers. The following conditions exists:

1.Reward levels are earned based on the amount spent during the previous 12 months.

2.The program will track every item a customer has bought and grant them points for discount.

3.The program generates 100 million records each month.

NTO customer support would like to see a summary of a customer’s recent transaction and reward level(s) they have attained.

Which solution should the data architect use to provide the information within the salesforce for the customer support agents?

Options:

A.

Create a custom object in salesforce to capture and store all reward program. Populate nightly from the point-of-scale system, and present on the customer record.

B.

Capture the reward program data in an external data store and present the 12 months trailing summary in salesforce using salesforce connect and then external object.

C.

Provide a button so that the agent can quickly open the point of sales system displaying the customer history.

D.

Create a custom big object to capturethe reward program data and display it on the contact record and update nightly from the point-of-scale system.

Question 13

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?

Options:

A.

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

B.

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

C.

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

D.

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

Question 14

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?

Options:

A.

Use triggers to populate denormalized related fields on the Account.

B.

Use an indexed data field with bounded data filters.

C.

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

D.

Use unbounded date ranges to filter the report.

Question 15

Universal Containers (UC) wants to store product data in Salesforce, but the standard Product object does not support the more complex hierarchical structure which is currently being used in the product master system. How can UC modify the standard Product object model to support a hierarchical data structure in order to synchronize product data from the source system to Salesforce?

Options:

A.

Create a custom lookup filed on the standard Product to reference the child record in the hierarchy.

B.

Create acustom lookup field on the standard Product to reference the parent record in the hierarchy.

C.

Create a custom master-detail field on the standard Product to reference the child record in the hierarchy.

D.

Create an Apex trigger to synchronize the ProductFamily standard picklist field on the Product object.

Question 16

Universal Containers (UC) has multi -level account hierarchies that represent departments within their major Accounts. Users are creating duplicate Contacts across multiple departments. UC wants to clean the data so as to have a single Contact across departments. What two solutions should UC implement to cleanse their data? Choose2 answers

Options:

A.

Make use of a third -party tool to help merge duplicate Contacts across Accounts.

B.

Use Data.com to standardize Contact address information to help identify duplicates.

C.

Use Workflow rules to standardize Contact information to identify and prevent duplicates.

D.

Make use of the Merge Contacts feature of Salesforce to merge duplicates for an Account.

Question 17

Universal Containers (UC) is implementing its new Internet of Things technology, which consists of smart containers that provide information on container temperature and humidity updated every 10 minutes back to UC. There are roughly 10,000 containers equipped with this technology with the number expected to increase to 50,000 across the next five years. It is essential that Salesforce user have access to current and historical temperature and humidity data for each container. What is the recommended solution?

Options:

A.

Create new custom fields for temperature and humidity in the existing Container custom object, as well as an external ID field that is unique for each container. These custom fields are updated when a new measure is received.

B.

Create a new Container Reading custom object, which is created when a new measure is received for a specific container. The Container Reading custom object has a master-detail relationship to the container object.

C.

Create a new Lightning Component that displays last humidity and temperature data for a specific container and can also display historical trends obtaining relevant data from UC’s existing data warehouse.

D.

Create a new Container Reading custom object with a master-detail relationship to Container which is created when a new measureis received for a specific container. Implement an archiving process that runs every hour.

Question 18

The architect is planning a large data migration for Universal Containers from their legacy CRM system to Salesforce. What three things should the architect consider to optimize performance of the data migration? Choose 3 answers

Options:

A.

Review the time zones of the User loading the data.

B.

Remove custom indexes on the data being loaded.

C.

Determine if the legacy system is still in use.

D.

Defer sharing calculations of the Salesforce Org.

E.

Deactivate approval processes and workflow rules.

Question 19

Universal Containers (UC) is planning to moveaway from legacy CRM to Salesforce. As part of one-time data migration, UC will need to keep the original date when a contact was created in the legacy system. How should an Architect design the data migration solution to meet this requirement?

Options:

A.

Afterthe data is migrated, perform an update on all records to set the original date in a standard CreatedDate field.

B.

Create a new field on Contact object to capture the Created Date. Hide the standard CreatedDate field using Field -Level Security.

C.

Enable"Set Audit Fields" and assign the permission to the user loading the data for the duration of the migration.

D.

Write an Apex trigger on the Contact object, before insert event to set the original value in a standard CreatedDate field.

Question 20

Universal Containers has received complaints that customers are being called by multiple Sales Reps where the second Sales Rep that calls is unaware of the previous call by their coworker. What is a data quality problem that could cause this?

Options:

A.

Missing phone number on the Contact record.

B.

Customer phone number has changed on the Contact record.

C.

Duplicate Contact records exist in the system.

D.

Duplicate Activity records on a Contact.

Question 21

Universal Containers has a large number of Opportunity fields (100) that they want to track field history on. Which two actions should an architectperform in order to meet this requirement? Choose 2 answers

Options:

A.

Create a custom object to store a copy of the record when changed.

B.

Create a custom object to store the previous and new field values.

C.

Use Analytic Snapshots to store a copy of the record when changed.

D.

Select the 100 fields in the Opportunity Set History Tracking page.

Question 22

UC has migrated its Back-office data into an on-premisedatabase with REST API access. UC recently implemented Sales cloud for its sales organization. But users are complaining about a lack of order data inside SF.

UC is concerned about SF storage limits but would still like Sales cloud to have access to the data.

Which design patterns should a data architect select to satisfy the requirement?

Options:

A.

Migrate and persist the data in SF to take advantage of native functionality.

B.

Use SF Connect to virtualize the data in SF and avoid storage limits.

C.

Develop a bidirectional integration between the on-premise system and Salesforce.

D.

Build a UI for the on-premise system and iframe it in Salesforce

Question 23

Which three characteristics of a Skinny table help improve report and query performance?

Options:

A.

Skinny tables can contain frequently used fields and thereby help avoid joins.

B.

Skinny tables can be used to create custom indexes on multi-select picklist fields.

C.

Skinny tables provide a view across multiple objects for easy access to combined data.

D.

Skinny tables are kept in sync with changes to data in the source tables.

E.

Skinny tables do not include records that are available in the recycle bin.

Question 24

Universal containers is implementing Salesforce lead management.  UC Procure lead data from multiple sources and would like to make surelead 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

Options:

A.

Ask sales people to search for populating company profile and location data

B.

Run reports to identify records which does not have company profile and location data

C.

Leverage external data providers populate company profile and location data

D.

Export data out of Salesforce and send to another team to populate company profileand location data

Question 25

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

Which two key considerations should be made to make sure the performance of the report is not degraded due to large data volume?

Options:

A.

Number of queries running at a time.

B.

Number of joins used in report query.

C.

Number of records returned by report query.

D.

Number of characters in report query.

Question 26

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 configurablethrough the Salesforce UI.

Which tool should a data architect leverage to accomplish these requirements?

Options:

A.

Bulk API

B.

Data export wizard

C.

Third-party ETL tool

D.

Data loader

Question 27

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 isexperiencing "lock errors" consistently.

What should a data architect recommend to mitigate these errors?

Options:

A.

Enable granular locking.

B.

Remove SOQL statements from Apex Loops.

C.

Enable sharing recalculations.

D.

Ask Salesforce support for additional CPUpower.

Question 28

Universal Containers (UC) has a very large and complex Salesforce org with hundreds of validation rules and triggers. The triggers are responsible for system updates and data manipulation as records are created or updatesby users. A majority of the automation tool within UC’’ org were not designed to run during a data load. UC is importing 100,000 records into Salesforce across several objects over the weekend.

What should a data architect do to mitigate any unwanted results during the import?

Options:

A.

Ensure validation rules, triggers and other automation tools are disabled.

B.

Ensure duplication and matching rules and defined.

C.

Import the data in smaller batches over a 24-hour period.

D.

Bulkily the trigger to handle importleads.

Question 29

Universal Containers has two systems. Salesforce andan on -premise ERP system. An architect has been tasked with copying Opportunity records to the ERP once they reach a Closed/Won Stage. The Opportunity record in the ERP system will be read-only for all fields copied in from Salesforce. What is the optimal real-time approach that achieves this solution?

Options:

A.

Implement a Master Data Management system to determine system of record.

B.

Implement a workflow rule that sends Opportunity data through Outbound Messaging.

C.

Have the ERP poll Salesforce nightly andbring in the desired Opportunities.

D.

Implement an hourly integration to send Salesforce Opportunities to the ERP system.

Question 30

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

Options:

A.

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

B.

Contact Salesforce to activate indexing before uploading the data.

C.

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

D.

Defer sharing calculations until the data has finished uploading.

Question 31

Universal Containers (UC) is transitioning from Classic to Lightning Experience.

What does UC need to do to ensure users have access to its notices and attachments in Lightning Experience?

Options:

A.

Add Notes and Attachments Related List to page Layout in Lighting Experience.

B.

Manually upload Notes in Lighting Experience.

C.

Migrate Notes and Attachment to Enhanced Notes and Files a migration tool

D.

Manually upload Attachments in Lighting Experience.

Question 32

Universal Containers wants to develop a dashboard in Salesforce that will allow Sales Managers to do data exploration using their mobile device (i.e., drill down into sales-related data) and have the possibility of addingad-hoc filters while on the move. What is a recommended solution for building data exploration dashboards in Salesforce?

Options:

A.

Create a Dashboard in an external reporting tool, export data to the tool, and add link to the dashboard in Salesforce.

B.

Createa Dashboard in an external reporting tool, export data to the tool, and embed the dashboard in Salesforce using the Canval toolkit.

C.

Create a standard Salesforce Dashboard and connect it to reports with the appropriate filters.

D.

Create a Dashboardusing Analytics Cloud that will allow the user to create ad-hoc lenses and drill down.

Question 33

A Salesforce customer has plenty of data storage. Sales Reps are complaining thatsearches are bringing back old records that aren't relevant any longer. Sales Managers need the data for their historical reporting.What strategy should a data architect use to ensure a better user experience for the Sales Reps?

Options:

A.

Create a Permission Set to hide old data from Sales Reps.

B.

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

C.

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

D.

Set data access to Private to hide old data from Sales Reps.