Black Friday Special Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: 70percent

Salesforce Data-Architecture-And-Management-Designer Salesforce Certified Data Architect (WI23) Exam Practice Test

Salesforce Certified Data Architect (WI23) Questions and Answers

Question 1

Universal Containers (UC) has implemented Sales Cloud and it has been noticed that Sales reps are not entering enough data to run insightful reports and dashboards. UC executives would like to monitor and measure data quality metrics. What solution addresses this requirement?

Options:

A.

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

B.

Generate reports to view the quality of sample data.

C.

Use custom objects and fields to calculate data quality.

D.

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

Question 2

NTO has outgrown its current salesforce org and will be migrating to new org shortly. As part ofthis process NTO will be migrating all of its metadata and data. NTO’s data model in the source org has a complex relationship hierarchy with several master detail and lookup relationships across objects, which should be maintained in target org.

What 3 things should a data architect do to maintain the relationship hierarchy during migration?

Choose 3 answers:

Options:

A.

Use data loader to export the data from source org and then import or Upsert into the target org in sequential order.

B.

Create a external id field for each object in the target org and map source record ID’s to this field.

C.

Redefine the master detail relationship fields to lookup relationship fields in the target org.

D.

Replace source record ID’s with new record ID’s from the target org in the import file.

E.

Keep the relationship fields populated with the source record ID’s in the import file.

Question 3

Universal Containers is looking to use Salesforce to manage their sales organization. They will be migrating legacy account data from two aging systems into Salesforce. Which two design considerations should an architect take to minimize data duplication? Choose 2 answers

Options:

A.

Use a workflow to check and prevent duplicates.

B.

Clean data before importing to Salesforce.

C.

Use Salesforce matching and duplicate rules.

D.

Import the data concurrently.

Question 4

A large retail company has recently chosen SF as its CRM solution. They have the following record counts:

  • 2500000 accounts
  • 25000000 contacts

When doing an initial performance test, the data architect noticedan extremely slow response for reports and list views.

What should a data architect do to solve the performance issue?

Options:

A.

Load only the data that the users is permitted to access

B.

Add custom indexes on frequently searched account and contact objects fields

C.

Limit data loading to the 2000 most recently created records.

D.

Create a skinny table to represent account and contact objects.

Question 5

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

Options:

A.

Reference data policy.

B.

Data governance policy.

C.

Datasensitivity policy.

D.

Compliance categorization policy.

Question 6

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.

Question 7

Universal Containers (UC) has a requirement to create an Account plan object that is related to the Account object. Each Account plan needs to have an Account object, but the accessibility requirement of the Account plan is different from the Account object. What should an Architect recommend?

Options:

A.

Create a custom account plan object as detail with Account as mater in a master-detail relationship.

B.

Create a custom account plan objectas detail with Account as master with additional sharing rules to allow access.

C.

Create an account plan object with a lookup relations to Account without any validation rules to enforce the Account association.

D.

Create an account plan object with a lookup relationship to Account with validation rules to enforce the Account association.

Question 8

Universal Containers has defined a new Data Quality Plan for their Salesforce data and wants to know how they can enforce it throughout the organization. Which two approaches should an architect recommend to enforce this new plan?

Choose 2 answers

Options:

A.

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

B.

Use Workflow, Validation Rules, and Force.com code (Apex) to enforce critical business processes.

C.

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

D.

Store all data in an external system and set up anintegration to Salesforce for view -only access.

Question 9

UC has millions of case records with case history and SLA data. UC’s compliance team would like historical cases to be accessible for 10 years for Audit purpose.

What solution should a data architect recommend?

Options:

A.

Archive Case data using Salesforce Archiving process

B.

Purchase more data storage to support case object

C.

Use a custom object to store archived case data.

D.

Use a custom Big object to store archived case data.

Question 10

Universal Containers (UC) is implementing Salesforce and will be using Salesforce to track customer complaints, provide white papers on products, and provide subscription based support.

Which license type will UC users need to fulfill UC's requirements?

Options:

A.

Sales Cloud License

B.

Lightning Platform Starter License

C.

Service Cloud License

D.

SalesforceLicense

Question 11

NTO has decided to franchise its brand. Upon implementation, 1000 franchisees will be able to access BTO’s product information and track large customer sales and opportunities through a portal. The Franchisees will also be able to run monthly and quarterly sales reports and projections as well as view the reports in dashboards.

Which licenses does NTO need to provide these features to the Franchisees?

Options:

A.

Salesforce Sales Cloud license

B.

Lightning Platform license

C.

Customer Community license

D.

Partner Community license

Question 12

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 thisteam? Choose 2 answers

Options:

A.

Analytics/BI Owners

B.

Data Domain Stewards

C.

Salesforce Administrators

D.

Operational Data Users

Question 13

A manager at Cloud Kicks is importing Leads into Salesforce and needs to avoid creating duplicate records.

Which two approaches should the manager take to achievethis goal? (Choose two.)

Options:

A.

Acquire an AppExchange Lead de-duplication application.

B.

Implement Salesforce Matching and Duplicate Rules.

C.

Run the Salesforce Lead Mass de-duplication tool.

D.

Create a Workflow Rule to check for duplicate records.

Question 14

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

Options:

A.

Use the private sharing model.

B.

Use Salesforce duplicate management.

C.

Use validation rules on new record create and edit.

D.

Use workflow to delete duplicate records.

Question 15

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 16

The head of sales at Get Cloudy Consulting wants to understand key relevant performance figures and helpmanagers take corrective actions where appropriate.

What is one reporting option Get Cloudy Consulting should consider?

Options:

A.

Case SLA performance report

B.

Sales KPI Dashboard

C.

Opportunity analytic snapshot

D.

Lead conversion rate report

Question 17

Universal Containers (UC) is implementing Salesforce Sales Cloud and Service Cloud. As part of their implementation, they are planning to create a new custom object (Shipments), which will have a lookup relationship to Opportunities. When creating shipment records, Salesforce users need to manually input a customer reference, which is provided by customers, and will be stored in the Customer_Reference__c text custom field. Supportagents will likely use this customer reference to search for Shipment records when resolving shipping issues. UC is expecting to have around 5 million shipment records created per year. What is the recommended solution to ensure that support agents usingglobal search and reports can quickly find shipment records?

Options:

A.

Implement an archiving process for shipment records created after five years.

B.

Implement an archiving process for shipment records created after three years.

C.

Set Customer-Reference_c asan External ID (non-unique).

D.

Set Customer-Reference_c as an External ID (unique).

Question 18

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 19

How can an architect find information about who is creating, changing, or deletingcertain fields within the past two months?

Options:

A.

Remove "customize application" permissions from everyone else.

B.

Export the metadata and search it for the fields in question.

C.

Create a field history report for the fields in question.

D.

Export the setupaudit trail and find the fields in question.

Question 20

NTO (Northern Trail Outlets) has a complex Salesforce org which has been developed over past 5years. 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:

Options:

A.

Define data duplication standards and rules

B.

Define key fields in staging database for data cleansing

C.

Measure data timeliness and consistency

D.

Finalize an extract transform load (ETL) tool for data migration

E.

Measure data completeness and accuracy

Question 21

Universal Containers (UC) is facing data quality issues where Sales Reps are creating duplicate customer accounts, contacts, and leads. UC wants to fix this issue immediately by prompting users about a record that possibly exists in Salesforce. UC wants a report regarding duplicate records. What would be the recommended approach to help UC start immediately?

Options:

A.

Create an after insert and update trigger on the account, contact and lead, and send an error if a duplicate is found using a custom matching criteria.

B.

Create a duplicate rule for account, lead, and contact, use standard matching rules for these objects, and set the action to report and alert for both creates and edits.

C.

Create a duplicate rule for account, lead, and contact, use standard matching rules for these objects, and set the action to block for both creates and edits.

D.

Create a before insert and update trigger on account, contact, and lead, and send an error if a duplicate is found using a custom matching criteria.

Question 22

Universal Containers is planning out their archiving and purging plans going forward for their custom objects Topic__c and Comment__c. Several options are being considered, including analytics snapshots, offsite storage, scheduled purges, etc. Which three questions should be considered when designing an appropriate archiving strategy?

Options:

A.

How many fields are defined on the custom objectsthat need to be archived?

B.

Which profiles and users currently have access to these custom object records?

C.

If reporting is necessary, can the information be aggregated into fewer, summary records?

D.

Will the data being archived need to be reported onor accessed in any way in the future?

E.

Are there any regulatory restrictions that will influence the archiving and purging plans?

Question 23

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.

Question 24

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. Whichtwo things should the data architect consider when denormalizing this data model into a single Conference object with a Venue picklist? Choose 2 answers

Options:

A.

Limitations on master -detail relationships.

B.

Org data storage limitations.

C.

Bulk API limitations on picklist fields.

D.

Standard list view in -line editing.

Question 25

(NTO) has multiple salesforce orgs based on geographical reports (AMER, EMEA, APAC). NTO products are in the AMER org and need to be created in the EMEA and APAC after the products are approved.

Which two features should a data architect recommend to share records between salesforce orgs? Choose 2.

Options:

A.

Change data capture (CDC)

B.

Salesforce connect.

C.

Federation search

D.

Salesforce 2 Salesforce

Question 26

NTO processes orders from its website via an order management system (OMS). The OMS stores over 2 million historical records and is currently not integrated with SF. The Sales team at NTOusing Sales cloud and would like visibility into related customer orders yet they do not want to persist millions of records directly in Salesforce. NTO has asked the data architect to evaluate SF connect and the concept of data verification. Which 3 considerations are needed prior to a SF Connect implementation?

Choose 3 answers:

Options:

A.

Create a 2nd system Admin user for authentication to the external source.

B.

Develop an object relationship strategy.

C.

Identify the external tables to sync into external objects

D.

Assess whether the external data source is reachable via an ODATA endpoint.

E.

Configure a middleware tool to poll external table data

Question 27

A company wants to document the data architecture of a Salesforce organization.

What are two valid metadata types that should be included? (Choose two.)

Options:

A.

RecordType

B.

Document

C.

CustomField

D.

SecuritySettings

Question 28

NTO has multiple systems across its enterprise landscape including salesforce, with disparate version the customer records.

In salesforce, the customer is representedby 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?

Options:

A.

Store the master key in Heroku postgres and use Heroku connect for synchronization.

B.

Create a custom object to store the master key with a lookup field to contact.

C.

Create an external object to store the master key with a lookup field to contact.

D.

Store the master key on the contact object as an external ID (Field for referential imports)

Question 29

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?

Options:

A.

Create formula fields with geolocation function for this requirement.

B.

Create custom fields to maintain latitude and longitude information

C.

Create a geolocation custom field to maintain this requirement

D.

Recommend app exchange packages to support this requirement.

Question 30

Universal Containers (UC) is launching an RFP to acquire a new accounting product available on AppExchange. UC is expecting to issue 5 million invoices per year, with each invoice containing an average of 10 line items. What should UC's Data Architect recommend to ensure scalability?

Options:

A.

Ensure invoice line items simply reference existing Opportunity line items.

B.

Ensure the account product vendor includes Wave Analytics in their offering.

C.

Ensure the account product vendor provides a sound data archiving strategy.

D.

Ensurethe accounting product runs 100% natively on the Salesforce platform.

Question 31

Universal Containers (UC) is in the process of migrating lagacy inventory data from an enterprise resources planning (ERP) system into Sales Cloud with the following requirements:

Legacy inventory data will be stored in a custom childobjects called Inventory_c.

Inventory data should be related to the standard Account object.

The Inventory_c object should Inhent the same sharing rules as the Account object.

Anytime an Account record is deleted in Salesforce, the related Inventory_c record(s) should be deleted as well.

What type of relationship field should a data architect recommend in this scenario?

Options:

A.

Master-detail relationship filed on Account, related to Inventory_c

B.

Master-detail relationship filed on Inventory_c, related to Account

C.

Indirect lookup relationship field on Account, related to Inventory_c

D.

Lookup relationship fields on Inventory related to Account

Question 32

Universal Containers (UC) is using Salesforce Sales & Service Cloud for B2C sales and customer service but they are experiencing a lot of duplicate customers in the system. Which are two recommended approaches for UC to avoid duplicate data and increase the level of data quality?

Options:

A.

Use Duplicate Management.

B.

Use an Enterprise Service Bus.

C.

Use Data.com Clean

D.

Use a data wharehouse.

Question 33

Universal Containers (UC) has an open sharing model for its Salesforce users to allow all its Salesforce internal users to edit all contacts, regardless ofwho owns the contact. However, UC management wants to allow only the owner of a contact record to delete that contact. If a user does not own the contact, then the user should not be allowed to delete the record. How should the architect approach the project so that the requirements are met?

Options:

A.

Create a "before delete" trigger to check if the current user is not the owner.

B.

Set the Sharing settings as Public Read Only for the Contact object.

C.

Set the profile of the users to remove delete permission from the Contact object.

D.

Create a validation rule on the Contact object to check if the current user is not the owner.