March Sale - Special Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: dpm65

Data-Architect Salesforce Certified Data Architect (WI24) Questions and Answers

Questions 4

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.

Buy Now
Questions 5

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?

Options:

A.

Truncate all 5 objects quickly and re-run the data migration test.

B.

Refresh the full copy sandbox and re-run the data migration test.

C.

Hard delete all 5 objects’ data and re-run the data migration test.

D.

Truncate all 5 objects and hard delete before running the migration test.

Buy Now
Questions 6

Every year, Ursa Major Solar has more than 1 million orders. Each order contains an average of 10 line items. The Chief Executive Officer (CEO) needs the Sales Reps to see how much money each customer generates year-over-year. However, data storage is running low in Salesforce.

Which approach for data archiving is appropriate for this scenario?

Options:

A.

1. Annually export and delete order line items. 2. Store them in a zip file in case the data is needed later.

B.

1. Annually aggregate order amount data to store in a custom object. 2. Delete those orders and order line items.

C.

1. Annually export and delete orders and order line items. 2. Store them in a zip file in case the data is needed later.

D.

1. Annually delete orders and order line items. 2. Ensure the customer has order information in another system.

Buy Now
Questions 7

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?

Options:

A.

Bulk API

B.

Data export wizard

C.

Third-party ETL tool

D.

Data loader

Buy Now
Questions 8

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.

Salesforce License

Buy Now
Questions 9

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.

Buy Now
Questions 10

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.

Buy Now
Questions 11

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.

Buy Now
Questions 12

UC is migrating data from legacy system to SF. UC would like to preserve the following information on records being migrated:

  • Date time stamps for created date and last modified date.
  • Ownership of records belonging to inactive users being migrated to Salesforce.

Which 2 solutions should a data architect recommends to preserve the date timestamps and ownership on records? Choose 2 answers.

Options:

A.

Log a case with SF to update these fields

B.

Enable update records with Inactive Owners Permission

C.

Enable Set Audit fields upon Record Creation Permission

D.

Enable modify all and view all permission.

Buy Now
Questions 13

A casino is implementing Salesforce and is planning to build a customer 360 degree view for a customer who visits its resorts. The casino currently maintains the following systems that record customer activity: L Point-of-sale system: All purchases for a customer

2. Salesforce; All customer service activity and sales activities for a customer

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

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

Customer service agents using Salesforee would like to view the activities from all four systems to provide support 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 a 360 degree view of the customer.

B.

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

C.

Periodically upload summary information in Salesforce to build a 360 degree view.

D.

Migrate customer activities fro, all four system into Salesforce.

Buy Now
Questions 14

Northern Trail Outfitters (NTO) wants to implement backup and restore for Salesforce data, Currently, it has data backup processes that runs weekly, which back up all Salesforce data to an enterprise data warehouse (EDW). NTO wants to move to daily backups and provide restore capability to avoid any data loss in case of outage.

What should a data architect recommend for a daily backup and restore solution?

Options:

A.

Use AppExchange package for backup and restore.

B.

Use ETL for backup and restore from EDW.

C.

Use Bulk API to extract data on daily basis to EDW and REST API for restore.

D.

Change weekly backup process to daily backup, and implement a custom restore solution.

Buy Now
Questions 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.

Buy Now
Questions 16

How can an architect find information about who is creating, changing, or deleting certain 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 setup audit trail and find the fields in question.

Buy Now
Questions 17

North Trail Outfitters (NTD) is in the process of evaluating big objects to store large amounts of asset data from an external system. NTO will need to report on this asset data weekly.

Which two native tools should a data architect recommend to achieve this reporting requirement?

Options:

A.

Standard reports and dashboards

B.

Async SOQL with a custom object

C.

Standard SOQL queries

D.

Einstein Analytics

Buy Now
Questions 18

As part of addressing general data protection regulation (GDPR) requirements, UC plans to implement a data classification policy for all its internal systems that stores customer information including salesforce.

What should a data architect recommend so that UC can easily classify consumer information maintained in salesforce under both standard and custom objects?

Options:

A.

Use App Exchange products to classify fields based on policy.

B.

Use data classification metadata fields available in field definition.

C.

Create a custom picklist field to capture classification of information on customer.

D.

Build reports for customer information and validate.

Buy Now
Questions 19

UC is migrating individual customers (B2C) data from legacy systems to SF. There are millions of customers stored as accounts and contacts in legacy database.

Which object model should a data architect configure within SF ?

Options:

A.

Leverage person account object in Salesforce

B.

Leverage custom person account object in SF

C.

Leverage custom account and contact object in SF

D.

Leverage standard account and contact object in SF

Buy Now
Questions 20

UC has migrated its Back-office data into an on-premise database 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

Buy Now
Questions 21

UC migrating 100,000 Accounts from an enterprise resource planning (ERP) to salesforce and is concerned about ownership skew and performance.

Which 3 recommendations should a data architect provide to prevent ownership skew?

Choose 3 answers:

Options:

A.

Assigned a default user as owner of accounts, and assign role in hierarchy.

B.

Keep users out of public groups that can be used as the source for sharing rules.

C.

Assign a default user as owner of account and do not assign any role to default user.

D.

Assign “view all” permission on profile to give access to account.

E.

Assign a default user as owner of accounts and assigned top most role in hierarchy.

Buy Now
Questions 22

Universal Containers (UC) management has identified a total of ten text fields on the Contact object as important to capture any changes made to these fields, such as who made the change, when they made the change, what is the old value, and what is the new value. UC needs to be able to report on these field data changes within Salesforce for the past 3 months. What are two approaches that will meet this requirement? Choose 2 answers

Options:

A.

Create a workflow to evaluate the rule when a record is created and use field update actions to store previous values for these ten fields in ten new fields.

B.

Write an Apex trigger on Contact after insert event and after update events and store the old values in another custom object.

C.

Turn on field Contact object history tracking for these ten fields, then create reports on contact history.

D.

Create a Contact report including these ten fields and Salesforce Id, then schedule the report to run once a day and send email to the admin.

Buy Now
Questions 23

UC has multiple SF orgs that are distributed across regional branches. Each branch stores local customer data inside its org’s Account and Contact objects. This creates a scenario where UC is unable to view customers across all orgs.

UC has an initiative to create a 360-degree view of the customer, as UC would like to see Account and Contact data from all orgs in one place.

What should a data architect suggest to achieve this 360-degree view of the customer?

Options:

A.

Consolidate the data from each org into a centralized datastore

B.

Use Salesforce Connect’s cross-org adapter.

C.

Build a bidirectional integration between all orgs.

D.

Use an ETL tool to migrate gap Accounts and Contacts into each org.

Buy Now
Questions 24

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.

Buy Now
Questions 25

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.

Buy Now
Questions 26

Universal Containers (UC) maintains a collection of several million Account records that represent business in the United Sates. As a logistics company, this list is one of the most valuable and important components of UC's business, and the accuracy of shipping addresses is paramount. Recently it has been noticed that too many of the addresses of these businesses are inaccurate, or the businesses don't exist. Which two scalable strategies should UC consider to improve the quality of their Account addresses?

Options:

A.

Contact each business on the list and ask them to review and update their address information.

B.

Build a team of employees that validate Accounts by searching the web and making phone calls.

C.

Integrate with a third-party database or services for address validation and enrichment.

D.

Leverage Data.com Clean to clean up Account address fields with the D&B database.

Buy Now
Questions 27

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

Options:

A.

Analytics/BI Owners

B.

Data Domain Stewards

C.

Salesforce Administrators

D.

Operational Data Users

Buy Now
Questions 28

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.

Buy Now
Questions 29

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.

Buy Now
Questions 30

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 Streaming API 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.

Buy Now
Questions 31

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

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 profile and location data

Buy Now
Questions 32

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.

Buy Now
Questions 33

Two million Opportunities need to be loaded in different batches into Salesforce using the Bulk API in parallel mode.

What should an Architect consider when loading the Opportunity records?

Options:

A.

Use the Name field values to sort batches.

B.

Order batches by Auto-number field.

C.

Create indexes on Opportunity object text fields.

D.

Group batches by the AccountId field.

Buy Now
Exam Code: Data-Architect
Exam Name: Salesforce Certified Data Architect (WI24)
Last Update: Mar 25, 2024
Questions: 257

PDF + Testing Engine

$75.95  $216.99

Testing Engine

$53.2  $151.99
buy now Data-Architect testing engine

PDF (Q&A)

$49  $139.99
buy now Data-Architect pdf
dumpsmate guaranteed to pass
24/7 Customer Support

DumpsMate's team of experts is always available to respond your queries on exam preparation. Get professional answers on any topic of the certification syllabus. Our experts will thoroughly satisfy you.

Site Secure

mcafee secure

TESTED 28 Mar 2024