Summer Special Sale Limited Time 60% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: 713PS592

Note! The Data-Architecture-And-Management-Designer Exam is no longer available. Get in touch with our Live Chat or email us for more information about the Data-Architect Exam.

Data-Architecture-And-Management-Designer Salesforce Certified Data Architect (WI23) Questions and Answers

Questions 4

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.

Buy Now
Questions 5

Salesforce is being deployed in Ursa Major Solar's disparate, multi-system ERP environment.Ursa major Solar wants to maintain data synchronization between systems.

Which two techniques should be used to achieve this goal? (Choose two.)

Options:

A.

Integrate Salesforce with the ERP environment.

B.

Utilize workbench to update files within systems.

C.

Utilize an MDM strategy to outline a single source of truth.

D.

Build synchronization reports and dashboards.

Buy Now
Questions 6

Universal Containers is experiencing frequent and persistent group membership lockingissues that severely restricts its ability to manage manual and a automated updates at the same time.

What should a data architect do in order to restore the issue?

Options:

A.

Enable granular locking

B.

Enable parallel sharing rule calculation.

C.

Enable defer sharing calculation

D.

Enable implicit sharing

Buy Now
Questions 7

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.

Buy Now
Questions 8

Universal Containers (UC) hasa 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 9

UC has to built a B2C ecommerce site on Heroku that shares customer and order data with a Heroku Postgres database. UC is currently utilizing Postgres as the single source of truth for both customers and orders. UC has asked a data architect to replicate the data into salesforce so that salesforce can now act as the system of record.

What are the 3 considerations that data architect should weigh before implementing this requirement? Choose 23 answers:

Options:

A.

Consider whether the data is required for sales reports, dashboards and KPI’s.

B.

Determine if the data is driver of key process implemented within salesforce.

C.

Ensure there isa tight relationship between order data and an enterprise resource plaining (ERP) application.

D.

Ensure the data is CRM center and able to populate standard of custom objects.

E.

A selection of the tool required to replicate the data.

F.

– Heroku Connectis required but this is confusing

Buy Now
Questions 10

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.

Buy Now
Questions 11

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.

Buy Now
Questions 12

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

Buy Now
Questions 13

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.

Buy Now
Questions 14

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.

Buy Now
Questions 15

Universal Containers (UC) loads bulk leads and campaigns from third-party lead aggregators on a weekly and monthly basis. The expected lead record volume is 500K records per week, and the expected campaign records volume is 10K campaigns per week. After the upload, Lead records are shared with various sales agents via sharing rules and added as Campaign members via Apex triggers on Lead creation. UC agents work on leads for 6 months, but want to keep the records in the system for at least 1 year for reference.Compliance requires them to be stored for a minimum of 3 years. After that, data can be deleted. What statement is true with respect to a data archiving strategy for UC?

Options:

A.

UC can store long-term lead records in custom storage objects to avoid counting against storage limits.

B.

UC can leverage the Salesforce Data Backup and Recovery feature for data archival needs.

C.

UC can leverage recycle bin capability, which guarantees record storage for 15 days after deletion.

D.

UC can leverage a “tier”-basedapproach to classify the record storage need.

Buy Now
Questions 16

An Architect needs to document the data architecture for a multi-system, enterprise Salesforce implementation.

Which two key artifacts should the Architect use? (Choose two.)

Options:

A.

User stories

B.

Data model

C.

Integration specification

D.

Non-functional requirements

Buy Now
Questions 17

UC is preparing to implement sales cloud and would like to its users to have read only access to an account record if they have access to its child opportunity record. How would a data architect implement this sharing requirement between objects?

Options:

A.

Create a criteria-based sharing rule.

B.

Implicit sharing will automatically handle with standard functionality.

C.

Add appropriate users to the account team.

D.

Create an owner-based sharing rule.

Buy Now
Questions 18

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.

Buy Now
Questions 19

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.

Buy Now
Questions 20

Universal Container (US) is replacing a home grown CRM solution with Salesforce, UC has decided to migrateoperational (Open and active) records to Salesforce, while keeping historical records in legacy system, UC would like historical records to be available in Salesforce on an as needed basis.

Which solution should a data architect recommend to meet businessrequirement?

Options:

A.

Leverage real-time integration to pull records into Salesforce.

B.

Bring all data Salesforce, and delete it after a year.

C.

Leverage mashup to display historical records in Salesforce.

D.

Build a chair solution to go the legacy system anddisplay records.

Buy Now
Questions 21

(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

Buy Now
Questions 22

Universal Containers (UC) has deployed Salesforce to manage Marketing. Sales, and Support efforts in a multi -system ERP environment After reaching the limits of native reports & dashboards. UC leadership is looking to understand what options can be used to provide more analytical insights. What two approaches should an architect recommend? Choose 2 answers

Options:

A.

AppExchange Apps

B.

Wave Analytics

C.

Weekly Snapshots

D.

Setup Audit Trails

Buy Now
Questions 23

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.

Buy Now
Questions 24

The data architect for UC has written a SOQL query that will return all records from the Task object that do not have a value in the WhatId field:

Select id, description, Subject from Task where WhatId != NULL

When the data architect usages the query to select values for a process a time out error occurs.

What does thedata architect need to change to make this query more performant?

Options:

A.

Remove description from the requested field set.

B.

Change query to SOSL. ??

C.

Add limit 100 to the query.

D.

Change the where clause to filter by a deterministic defined value.

Buy Now
Questions 25

UC needs to load a large volume of leads into salesforce on a weekly basis. During this process the validation rules are disabled.

What should a data architect recommend to ensure dataquality is maintained in salesforce.

Options:

A.

Activate validation rules once the leads are loaded into salesforce to maintain quality.

B.

Allow validation rules to be activated during the load of leads into salesforce.

C.

Develop custom APEX batch process to improve quality once the load is completed.

D.

Ensure the lead data is preprocessed for quality before loading into salesforce.

Buy Now
Questions 26

Universal Containers (UC) management has identified a total of ten text fields on the Contact object as important to capture any changes made to thesefields, 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 thisrequirement? 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, thenschedule the report to run once a day and send email to the admin.

Buy Now
Questions 27

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.

Buy Now
Questions 28

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.

Buy Now
Questions 29

Universal Containers has a custom object with millions of rows of data.

When executing SOQL queries, which three options prevent a query frombeing selective? (Choose three.)

Options:

A.

Using leading % wildcards.

B.

Using trailing % wildcards.

C.

Performing large loads and deletions.

D.

Using NOT and != operators.

E.

Using a custom index on a deterministic formula field.

Buy Now
Questions 30

A data architect has been tasked with optimizing a data stewardship engagement for a Salesforce instance Which three areas of Salesforce should the architect review before proposing any design recommendation? Choose 3 answers

Options:

A.

Review themetadata xml files for redundant fields to consolidate.

B.

Determine if any integration points create records in Salesforce.

C.

Run key reports to determine what fields should be required.

D.

Export the setup audit trail to review what fields are being used.

E.

Review the sharing model to determine impact on duplicate records.

Buy Now
Questions 31

US has released a newdisaster recovery (DR)policy that states that cloud solutions need a business continuity plan in place separate from the cloud providers built in data recovery solution.

Which solution should a data architect use to comply with the DR policy?

Options:

A.

Leveragea 3rd party tool that extract salesforce data/metadata and stores the information in an external protected system.

B.

Leverage salesforce weekly exports, and store data in Flat files on a protected system.

C.

Utilize an ETL tool to migrate data to an on-premise archive solution.

D.

Write a custom batch job to extract data changes nightly, and store in an external protected system.

Buy Now
Questions 32

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.

Buy Now
Questions 33

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
Exam Name: Salesforce Certified Data Architect (WI23)
Last Update: Apr 14, 2023
Questions: 1