Labour Day Special Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: suredis

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

Salesforce Certified Data Architect (WI23) Questions and Answers

Testing Engine

  • Product Type: Testing Engine
$42  $119.99

PDF Study Guide

  • Product Type: PDF Study Guide
$36.75  $104.99
Question 1

Universal Containers (UC) uses Salesforce for tracking opportunities (Opportunity). UC uses an internal ERP system for tracking deliveries and invoicing. The ERP system supports SOAP API and OData for bi-directional integration between Salesforce and the ERP system. UC has about one million opportunities. For each opportunity, UC sends 12 invoices, one per month.UC sales reps have requirements to view current invoice status and invoice amount from the opportunity page. When creating an object to model invoices, what should the architect recommend, considering performance and data storage space?

Options:

A.

Use StreamingAPI to get the current status from the ERP and display on the Opportunity page.

B.

Create an external object Invoice _x with a Lookup relationship with Opportunity.

C.

Create a custom object Invoice _c with a master -detail relationship with Opportunity.

D.

Create a custom object Invoice _c with a Lookup relationship with Opportunity.

Question 2

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

Options:

A.

Metadata API

B.

Tooling API

C.

Bulk API in serial mode

D.

SOAP API

Question 3

UC is trying to switch from legacy CRM to salesforce and wants to keep legacy CRM and salesforce in place till all the functionality is deployed in salesforce. The want to keep data in synch b/w Salesforce, legacy CRM and SAP. What is the recommendation.

Options:

A.

Integrate legacy CRM to salesforce and keepdata in synch till new functionality is in place

B.

Do not integrate legacy CRM to Salesforce, but integrate salesforce to SAP

C.

Integrate SAP with Salesforce, SAP to legacy CRM but not legacy CRM to Salesforce

D.

Suggest MDM solution and link MDM to salesforce and SAP

Question 4

Get Cloudy Consulting needs to evaluate thecompleteness and consistency of contact information in Salesforce. Their sales reps often have incomplete information about their accounts and contacts. Additionally, they are not able to interpret the information in a consistent manner. Get Cloudy Consulting has identified certain ""key"" fields which are important to their sales reps.

What are two actions Get Cloudy Consulting can take to review their data for completeness and consistency? (Choose two.)

Options:

A.

Run a report which shows the last time the keyfields were updated.

B.

Run one report per key field, grouped by that field, to understand its data variability.

C.

Run a report that shows the percentage of blanks for the important fields.

D.

Run a process that can fill in default values for blank fields.

Question 5

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 6

Which two bestpractices should be followed when using SOSL for searching?

Options:

A.

Use searches against single Objects for greater speed and accuracy.

B.

Keep searches specific and avoid wildcards where possible.

C.

Use SOSL option to ignore custom indexes as search fieldsare pre-indexed.

D.

Use Find in “ALL FIELDS” for faster searches.

Question 7

Universal Containers has a public website with several forms that create Lead records in Salesforce using the REST API. When designing these forms, which two techniques will help maintaina high level of data quality?

Options:

A.

Do client-side validation of phone number and email field formats.

B.

Prefer picklist form fields over free text fields, where possible.

C.

Ensure the website visitor is browsing using an HTTPS connection.

D.

Use cookies to track when visitors submit multiple forms.

Question 8

A customer needs a sales model thatallows the following:

  • Opportunities need to be assigned to sales people based on the zip code.
  • Each sales person can be assigned to multiple zip codes.
  • Each zip code is assigned to a sales area definition. Sales is aggregated by sales area for reporting.

What should a data architect recommend?

Options:

A.

Assign opportunities using list views using zip code.

B.

Add custom fields in opportunities for zip code and use assignment rules.

C.

Allow sales users to manually assign opportunity ownership based on zip code.

D.

Configure territory management feature to support opportunity assignment.

Question 9

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 10

UC has a variety of systems across its technology landscape, including SF, legacy enterprise resource planning (ERP) applications and homegrown CRM tools. UC has decided that they would like to consolidate all customer, opportunity and order data into Salesforce as part of its master data management (MDM) strategy.

What are the 3 key steps that a data architect should take when merging data from multiple systems into Salesforce? Choose 3 answers:

Options:

A.

Create new fieldsto store additional values from all the systems.

B.

Install a 3rd party AppExchange tool to handle the merger

C.

Analyze each system’s data model and perform gap analysis

D.

Utilize an ETL tool to merge, transform and de-duplicate data.

E.

Work with Stakeholders to define record and field survivorship rules

Question 11

UC is rolling out Sales App globally to bring sales teams together on one platform. UC expects millions of opportunities and accounts to be creates and is concerned about the performance of the application.

Which 3 recommendationsshould the data architect make to avoid the data skew? Choose 3 answers.

Options:

A.

Use picklist fields rather than lookup to custom object.

B.

Limit assigning one user 10000 records ownership.

C.

Assign 10000 opportunities to one account.

D.

Limit associating10000 opportunities to one account.

E.

Limit associating 10000 records looking up to same records.

Question 12

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?

Options:

A.

Virtualize the remaining set of data with salesforce connect and external objects.

B.

Use Heroku connect to bi-directional, sync all data between systems.

C.

As needed, make call outs into Heroku postgres and persist the data in salesforce.

D.

Migrate the data to big objects and leverage async SOQL with custom objects.

Question 13

Northern trail Outfitters (NTO) runs its entire out of an enterprise data warehouse (EDW), NTD’s sales team starting to use Salesforce after a recent implementation, but currently lacks data required to advanced and opportunity to the next stage.

NTO’s management has research Salesforce Connect and would like to use It to virtualize and report on data from the EDW within Salesforce. NTO will be running thousands of reports per day across 10 to 15 external objects.

What should a data architect consider before implementing Salesforce Connect for reporting?

Options:

A.

Maximum number for records returned

B.

OData callout limits per day

C.

Maximum page size for server-driven paging

D.

Maximum external objects per org

Question 14

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 15

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 16

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 17

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 18

Universal Containers (UC) has users complaining about reports timing out or simply taking too long to run What two actions should the data architect recommend to improve the reporting experience? Choose 2 answers

Options:

A.

Index key fields used in report criteria.

B.

Enable Divisions for large data objects.

C.

Create one skinny table per report.

D.

Share each report with fewer users.

Question 19

Universal Containers (UC) owns a complex Salesforce org with many Apex classes, triggers, and automated processes that will modify records if available. UC has identified that, in its current development state, UC runs change of encountering race condition on the same record.

What should a data architect recommend to guarantee that records are not being updated at the same time?

Options:

A.

Embed the keywords FOR UPDATE after SOQL statements.

B.

Disable classes or triggers that have the potential to obtain thesame record.

C.

Migrate programmatic logic to processes and flows.

D.

Refactor or optimize classes and trigger for maximum CPU performance.

Question 20

DreamHouse Realty has a legacy system that captures Branch Offices and Transactions. DreamHouse Realty has 15 Branch Offices. Transactions can relate to any Branch Office. DreamHouse Realty has created hundreds of thousands of Transactions per year.

A Data Architect needs to denormalize this data model into a single Transaction object with a Branch Office picklist.

What are two important considerations for the Data Architect in this scenario? (Choose two.)

Options:

A.

Standard list view in-line editing.

B.

Limitations on Org data storage.

C.

Bulk API limitations on picklist fields.

D.

Limitations on master-detail relationships.

Question 21

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 22

Universal Containers (UC) has implemented Salesforce, UC is running out of storage and needs to have an archiving solution, UC would like to maintaintwo years of data in Saleforce and archive older data out of Salesforce.

Which solution should a data architect recommend as an archiving solution?

Options:

A.

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

B.

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

C.

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

D.

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

Question 23

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?

Options:

A.

Create indexes on Opportunity object text fields.

B.

Group batches by the AccountId field.

C.

Sort batches by Name field values.

D.

Order batches by Auto -number field.

Question 24

Acompany has 12 million records, and a nightly integration queries these records.

Which two areas should a Data Architect investigate during troubleshooting if queries are timing out? (Choose two.)

Options:

A.

Make sure the query doesn't contain NULL in any filter criteria.

B.

Create a formula field instead of having multiple filter criteria.

C.

Create custom indexes on the fields used in the filter criteria.

D.

Modify the integration users' profile to have View All Data.

Question 25

Due to security requirements, Universal Containers needs to capture specific user actions, such as login, logout, file attachment download, package install, etc. What is the recommended approach for defining a solution for this requirement?

Options:

A.

Use a field audit trail to capture fieldchanges.

B.

Use a custom object and trigger to capture changes.

C.

Use Event Monitoring to capture these changes.

D.

Use a third-party AppExchange app to capture changes.

Question 26

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 27

A customer is operating in a highly reputated industry and is planning to implement SF. The customer information maintained in SF, includes the following:

  • Personally, identifiable information (PII)
  • IP restrictions on profiles organized by Geographic location
  • Financial records that need to be private and accessible only by the assigned Sales associate.
  • User should not be allowed to export information from Salesforce.

Enterprise security has mandate access to be restricted to users within a specific geography and detail monitoring of user activity. Which 3 Salesforce shield capabilities should a data architect recommend? Choose 3 answers:

Options:

A.

Event monitoring to monitor all user activities

B.

Restrict access to SF from users outside specific geography

C.

Prevent Sales users access to customer PII information

D.

Transaction security policies to prevent export of SF Data.

E.

Encrypt Sensitive Customer information maintained in SF.

Question 28

NTO uses salesforce to manage relationships and tracksales opportunities. It has 10 million customers and 100 million opportunities. The CEO has been complaining 10 minutes to run and sometimes failed to load, throwing a time out error.

Which 3 options should help improve the dashboard performance?

Choose 3answers:

Options:

A.

Use selective queries to reduce the amount of data being returned.

B.

De-normalize the data by reducing the number of joins.

C.

Remove widgets from the dashboard to reduce the number of graphics loaded.

D.

Run the dashboard for CEO and send itvia email.

E.

Reduce the amount of data queried by archiving unused opportunity records.

Question 29

Universal Container (UC) has accumulated data over years and has never deleted data from its Salesforce org. UC is now exceeding the storage allocations in the org. UC is now looking for option to delete unused from the org.

Which three recommendations should a data architect make is order to reduce the number of records from the org?

Choose 3 answers

Options:

A.

Use hard delete in Bulk API to permanently delete records from Salesforce.

B.

Use hard delete in batch Apex to permanently delete records from Salesforce.

C.

Identify records in objects that have not been modified or used In last 3 years.

D.

Use Rest API to permanently delete records from the Salesforce org.

E.

Archive the records in enterprise data warehouse (EDW) before deleting from Salesforce.

Question 30

Cloud Kicks has the followingrequirements:

• Their Shipment custom object must always relate to a Product, a Sender, and a Receiver (all separate custom objects).

• If a Shipment is currently associated with a Product, Sender, or Receiver, deletion of those records should not be allowed.

• Each custom object must have separate sharing models.

What should an Architect do to fulfill these requirements?

Options:

A.

Associate the Shipment to each parent record by using a VLOOKUP formula field.

B.

Create a required Lookup relationship to each ofthe three parent records.

C.

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

D.

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

Question 31

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 32

Universal Containers (UC) provides shipping services to its customers. They use Opportunities to track customer shipments. At any given time, shipping status can be one of the 10 values. UC has 200,000 Opportunity records. When creating a new field to trackshipping status on opportunity, what should the architect do to improve data quality and avoid data skew?

Options:

A.

Create a picklist field, values sorted alphabetically.

B.

Create a Master -Detail to custom object ShippingStatus c.

C.

Create a Lookup to customobject ShippingStatus c.

D.

Create a text field and make it an external ID.

Question 33

A casino is implementing salesforce and is planning to build a customer 360 view for a customer who visits its resorts. The casino currently maintained the following systems that records customer activity:

1.Point ofsales system: All purchases for a customer.

2.Salesforce: All customer service activity and sales activity for a customer.

3.Mobile app: All bookings, preferences and browser activity for a customer.

4.Marketing: All email, SMS and social campaigns fora customer.

Customer service agents using salesforce would like to view the activities from all system to provide supports to customers. The information has to be current and real time.

What strategy should the data architect implement to satisfy this requirement?

Options:

A.

Explore external data sources in salesforce to build 360 view of customer.

B.

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

C.

Migrate customer activities from all 4 systems into salesforce.

D.

Periodically upload summary information in salesforce to build 360 view.