March Special Limited Time 60% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: 2493360325

Good News !!! Data-Architect Salesforce Certified Data Architect (WI24) is now Stable and With Pass Result

Data-Architect Practice Exam Questions and Answers

Salesforce Certified Data Architect (WI24)

Last Update 16 hours ago
Total Questions : 257

Data-Architect is stable now with all latest exam questions are added 16 hours ago. Just download our Full package and start your journey with Salesforce Certified Data Architect (WI24) certification. All these Salesforce Data-Architect practice exam questions are real and verified by our Experts in the related industry fields.

Data-Architect PDF

Data-Architect PDF (Printable)
$48
$119.99

Data-Architect Testing Engine

Data-Architect PDF (Printable)
$56
$139.99

Data-Architect PDF + Testing Engine

Data-Architect PDF (Printable)
$70.8
$176.99
Question # 1

To avoid creating duplicate Contacts, a customer frequently uses Data Loader to upsert Contact records into Salesforce. What common error should the data 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.

Discussion 0
Question # 2

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.

Discussion 0
Question # 3

UC is having issues using Informatica Cloud Louder to export +10MOrder records. Each Order record has 10 Order Line Items. What two steps can you take to help correct this? Choose two answers.

Options:

A.  

Export in multiple batches

B.  

Export Bulk API in parallel mode

C.  

Use PK Chunking

D.  

Limit Batch to 10K records

Discussion 0
Question # 4

UC has a requirement to migrate 100 million order records from a legacy ERP application into the salesforce platform. UC does not have any requirements around reporting on the migrated data.

What should a data architect recommend to reduce the performance degradation of the platform?

Options:

A.  

Create a custom object to store the data.

B.  

Use a standard big object defined by salesforce.

C.  

Use the standard “Order” object to store the data.

D.  

Implement a custom big object to store the data.

Discussion 0
Question # 5

Get Cloudy Consulting needs to evaluate the completeness 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 key fields 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.

Discussion 0
Question # 6

A customer needs a sales model that allows 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.

Discussion 0
Question # 7

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.

Discussion 0
Question # 8

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?

Options:

A.  

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

B.  

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

C.  

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

D.  

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

Discussion 0
Question # 9

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.  

Data sensitivity policy.

D.  

Compliance categorization policy.

Discussion 0
Question # 10

Universal Containers keeps its Account data in Salesforce and its Invoice data in a third -party ERP system. They have connected the Invoice data through a Salesforce external object. They want data from both Accounts and Invoices visible in one report in one place. What two approaches should an architect suggest for achieving this solution? Choose 2 answers

Options:

A.  

Create a report in an external system combining Salesforce Account data and Invoice data from the ERP.

B.  

Create a report combining data from the Account standard object and the Invoices external object.

C.  

Create a Visualforce page combining Salesforce Account data and Invoice external object data.

D.  

Create a separate Salesforce report for Accounts and Invoices and combine them in a dashboard.

Discussion 0
Question # 11

Universal Containers (UC) 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. What should the architect consider, knowing there will be a large amount of time entry records to be loaded regularly from an external

system into Salesforce.com?

Options:

A.  

Load all data using external IDs to link to parent records.

B.  

Use workflow to calculate summary values instead of Roll -Up.

C.  

Use triggers to calculate summary values instead of Roll -Up.

D.  

Load all data after deferring sharing calculations.

Discussion 0
Question # 12

Universal Containers (UC) requires 2 years of customer related cases to be available on SF for operational reporting. Any cases older than 2 years and upto 7 years need to be available on demand to the Service agents. UC creates 5 million cases per yr.

Which 2 data archiving strategies should a data architect recommend? Choose 2 options:

Options:

A.  

Use custom objects for cases older than 2 years and use nightly batch to move them.

B.  

Sync cases older than 2 years to an external database, and provide access to Service agents to the database

C.  

Use Big objects for cases older than 2 years, and use nightly batch to move them.

D.  

Use Heroku and external objects to display cases older than 2 years and bulk API to hard delete from Salesforce.

Discussion 0
Question # 13

The head of sales at Get Cloudy Consulting wants to understand key relevant performance figures and help managers 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

Discussion 0
Question # 14

Universal Containers (UC) has 1,000 accounts and 50,000 opportunities. UC has an enterprise security requirement to export all sales data outside of Salesforce on a weekly basis. The security requirement also calls for exporting key operational data that includes events such as file downloads, logins, logouts, etc. Which two recommended approaches would address the above requirement?

Options:

A.  

Use Field Audit History to capture operational data and extract it to on-premise systems.

B.  

Use Weekly Export to extract transactional data to on-premise systems.

C.  

Use a custom built extract job to extract operational data to on-premise systems.

D.  

Use Event Monitoring to extract event data to on-premise systems.

Discussion 0
Question # 15

Universal Containers wants to automatically archive all inactive Account data that is older than 3 years. The information does not need to remain accessible within the application. Which two methods should be recommended to meet this requirement? Choose 2 answers

Options:

A.  

Use the Force.com Workbench to export the data.

B.  

Schedule a weekly export file from the Salesforce UI.

C.  

Schedule jobs to export and delete using an ETL tool.

D.  

Schedule jobs to export and delete using the Data Loader.

Discussion 0
Question # 16

Universal Containers wishes to maintain Lead data from Leads even after they are deleted and cleared from the Recycle Bin. What approach should be implemented to achieve this solution?

Options:

A.  

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

B.  

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

C.  

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

D.  

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

Discussion 0
Question # 17

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

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.

Discussion 0
Question # 18

Universal Containers (UC) is concerned that data is being corrupted daily either through negligence or maliciousness. They want to implement a backup strategy to help recover any corrupted data or data mistakenly changed or even deleted. What should the data architect consider when designing a field -level audit and recovery plan?

Options:

A.  

Reduce data storage by purging old data.

B.  

Implement an AppExchange package.

C.  

Review projected data storage needs.

D.  

Schedule a weekly export file.

Discussion 0
Question # 19

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

Options:

A.  

Set up a Validation Rule to prevent blank values.

B.  

Create a Workflow to default a value into this field.

C.  

Mark the field required in setup at the field level.

D.  

Blame the customer's external system for bad data.

Discussion 0
Question # 20

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.

Discussion 0
Question # 21

Universal Containers has a requirement to store more than 100 million records in salesforce and needs to create a custom big object to support this business requirement.

Which two tools should a data architect use to build custom object?

Options:

A.  

Use DX to create big object.

B.  

Use Metadata API to create big object.

C.  

Go to Big Object In setup select new to create big object.

D.  

Go to Object manager In setup and select new to create big object.

Discussion 0
Question # 22

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 opportunity stage.

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.

Discussion 0
Question # 23

Universal Containers is setting up an external Business Intelligence (BI) system and wants to extract 1,000,000 Contact records. What should be recommended to avoid timeouts during the export process?

Options:

A.  

Use the SOAP API to export data.

B.  

Utilize the Bulk API to export the data.

C.  

Use GZIP compression to export the data.

D.  

Schedule a Batch Apex job to export the data.

Discussion 0
Question # 24

NTO has been using salesforce for sales and service for 10 years. For the past 2 years, the marketing group has noticed a raise from 0 to 35 % in returned mail when sending mail using the contact information stored in salesforce.

Which solution should the data architect use to reduce the amount of returned mails?

Options:

A.  

Use a 3rd-party data source to update contact information in salesforce.

B.  

Email all customer and asked them to verify their information and to call NTO if their address is incorrect.

C.  

Delete contacts when the mail is returned to save postal cost to NTO.

D.  

Have the sales team to call all existing customers and ask to verify the contact details.

Discussion 0
Question # 25

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 a custom 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 Product Family standard picklist field on the Product object.

Discussion 0
Question # 26

Universal Containers (UC) has adopted Salesforce as its primary sales automated tool. UC has 100,00 customers with a growth rate of 10% a year, UC uses an on-premise web-based billing and invoice system that generates over 1 million invoices a year supporting a monthly billing cycle.

The UC sales team needs to be able to pull a customer record and view their account status, Invoice history, and opportunities without navigating outside of Salesforce.

What should a data architect use to provide the sales team with the required functionality?

Options:

A.  

Create a custom object and migrate the last 12 months of Invoice data into Salesforce so it can be displayed on the Account layout.

B.  

Write an Apex callout and populate a related list to display on the account record.

C.  

Create a mashup page that will present the billing system records within Salesforce.

D.  

Create a visual force tab with the billing system encapsulated within an iframe.

Discussion 0
Question # 27

Universal Containers has more than 10 million records in the Order_c object. The query has timed out when running a bulk query. What should be considered to resolve query timeout?

Options:

A.  

Tooling API

B.  

PK Chunking

C.  

Metadata API

D.  

Streaming API

Discussion 0
Question # 28

Universal Containers (UC) is going thought major reorganization of their sales team. This would require changes to a large a number of group members and sharing rules. UCs administrator is concerned about long processing time and failure during the process.

What should a Data architect implement to make changes efficiently?

Options:

A.  

Log a case with salesforce to make sharing rule changes.

B.  

Enable Defer Sharing Calculation prior to making sharing rule changes.

C.  

Delete old sharing rules and build new sharing rules

D.  

Log out all users and make changes to sharing rules.

Discussion 0
Question # 29

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.

Discussion 0
Question # 30

Universal Containers (UC) is implementing a Salesforce project with large volumes of data and daily transactions. The solution includes both real-time web service integrations and Visualforce mash -ups with back -end systems. The Salesforce Full sandbox used by the project integrates with full-scale back -end testing systems. What two types of performance testing are appropriate for this project? 

Choose 2 answers

Options:

A.  

Pre -go -live automated page -load testing against the Salesforce Full sandbox.

B.  

Post go -live automated page -load testing against the Salesforce Production org.

C.  

Pre -go -live unit testing in the Salesforce Full sandbox.

D.  

Stress testing against the web services hosted by the integration middleware.

Discussion 0
Question # 31

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

Discussion 0
Question # 32

UC has the following system:

  • Billing system.
  • Customer support system.
  • CRM system.

US has been having trouble with business intelligence across the different systems. Recently US implemented a master data management (MDM) solution that will be the system of truth for the customer records.

Which MDM data element is needed to allow reporting across these systems?

Options:

A.  

Global unique customer number.

B.  

Email address.

C.  

Phone number.

D.  

Full name.

Discussion 0
Question # 33

UC has one SF org (Org A) and recently acquired a secondary company with its own Salesforce org (Org B). UC has decided to keep the orgs running separately but would like to bidirectionally share opportunities between the orgs in near-real time.

Which 3 options should a data architect recommend to share data between Org A and Org B?

Choose 3 answers.

Options:

A.  

Leverage Heroku Connect and Heroku Postgres to bidirectionally sync Opportunities.

B.  

Install a 3rd party AppExchange tool to handle the data sharing

C.  

Develop an Apex class that pushes opportunity data between orgs daily via the Apex schedule.

D.  

Leverage middleware tools to bidirectionally send Opportunity data across orgs.

E.  

Use Salesforce Connect and the cross-org adapter to visualize Opportunities into external objects

Discussion 0
Get Data-Architect dumps and pass your exam in 24 hours!

Free Exams Sample Questions