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

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

Questions 4

Ursa Major Solar's legacy system has a quarterly accounts receivable report that compiles data from the following:

- Accounts

- Contacts

- Opportunities

- Orders

- Order Line Items

Which issue will an architect have when implementing this in Salesforce?

Options:

A.

Custom report types CANNOT contain Opportunity data.

B.

Salesforce does NOT support Orders or Order Line Items.

C.

Salesforce does NOT allow more than four objects in a single report type.

D.

A report CANNOT contain data from Accounts and Contacts.

Buy Now
Questions 5

UC is building a salesforce application to track contacts and their respective conferences that they have attended with the following requirements:

1.Contacts will be stored in the standard contact object.

2.Conferences will be stored in a custom conference__c object.

3.Each contact may attend multiple conferences and each conference may be related to multiple contacts.

How should a data architect model the relationship between the contact and conference objects?

Options:

A.

Implement a Contact Conference junction object with master detail relationship to both contact and conference__c.

B.

Create a master detail relationship field on the Contact object.

C.

Create a master detail relationship field on the Conference object.

D.

Create a lookup relationship field on contact object.

Buy Now
Questions 6

A large retail B2C customer wants to build a 360 view of its customer for its call center agents. The customer interaction is currently maintained in the following system:

1. Salesforce CRM

2. Custom billing solution

3. Customer Master Data management (MDM)

4. Contract Management system

5. Marketing solution

What should a data architect recommend that would help upgrade uniquely identify customer across multiple systems:

Options:

A.

Store the salesforce id in all the solutions to identify the customer.

B.

Create a custom object that will serve as a cross reference for the customer id.

C.

Create a customer data base and use this id in all systems.

D.

Create a custom field as external id to maintain the customer Id from the MDM solution.

Buy Now
Questions 7

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.

Buy Now
Questions 8

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 recommendations should 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 associating 10000 opportunities to one account.

E.

Limit associating 10000 records looking up to same records.

Buy Now
Questions 9

UC has a legacy client server app that as a relational data base that needs to be migrated to salesforce.

What are the 3 key actions that should be done when data modeling in salesforce?

Choose 3 answers:

Options:

A.

Identify data elements to be persisted in salesforce.

B.

Map legacy data to salesforce objects.

C.

Map legacy data to salesforce custom objects.

D.

Work with legacy application owner to analysis legacy data model.

E.

Implement legacy data model within salesforce using custom fields.

Buy Now
Questions 10

Universal Containers (UC) is migrating from a legacy system to Salesforce CRM, UC is concerned about the quality of data being entered by users and through external integrations.

Which two solution should a data architect recommend to mitigate data quality issues?

Options:

A.

Leverage picklist and lookup fields where possible

B.

Leverage Apex to validate the format of data being entered via a mobile device.

C.

Leverage validation rules and workflows.

D.

Leverage third-party- AppExchange tools

Buy Now
Questions 11

Universal Containers (UC) has an Application custom object, which has tens of millions of records created in the past 5 years. UC needs the last 5 years of data to exist in Salesforce at all times for reporting and queries. UC is currently encountering performance issues when reporting and running queries on this Object using date ranges as filters. Which two options can be used to improve report performance?

Options:

A.

Ask support to create a skinny table for Application with the necessary reporting fields.

B.

Add custom indexes to all fields on Application without a standard index.

C.

Run multiple reports to get different pieces of the data and combine them.

D.

Add custom indexes to the Date fields used for filtering the report.

Buy Now
Questions 12

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 13

NTO uses salesforce to manage relationships and track sales 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 3 answers:

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 it via email.

E.

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

Buy Now
Questions 14

A custom pricing engine for a Salesforce customer has to be decided by factors with the following hierarchy:

State in which the customer is located

City in which the customer is located if available

Zip code In which the customer is located if available

Changes to this information should have minimum code changes

What should a data architect recommend to maintain this information for the custom pricing engine that is to be built in Salesforce?

Options:

A.

Create a custom object to maintain the pricing criteria.

B.

Assign the pricing criteria within customer pricing engine.

C.

Maintain require pricing criteria in custom metadata types.

D.

Configure the pricing criteria in price books.

Buy Now
Questions 15

Universal container (UC) would like to build a Human resources application on Salesforce to manage employee details, payroll, and hiring efforts. To adequately and store the relevant data, the application will need to leverage 45 custom objects. In addition to this, UC expects roughly 20,00 API calls into Salesfoce from an n-premises application daily.

Which license type should a data architect recommend that best fits these requirements?

Options:

A.

Service Cloud

B.

Lightning platform Start

C.

Lightning Platform plus

D.

Lightning External Apps Starts

Buy Now
Questions 16

North Trail Outfitters (NTO) operates a majority of its business from a central Salesforce org, NTO also owns several secondary orgs that the service, finance, and marketing teams work out of, At the moment, there is no integration between central and secondary orgs, leading to data-visibility issues.

Moving forward, NTO has identified that a hub-and-spoke model is the proper architect to manage its data, where the central org is the hub and the secondary orgs are the spokes.

Which tool should a data architect use to orchestrate data between the hub org and spoke orgs?

Options:

A.

A middleware solution that extracts and distributes data across both the hub and spokes.

B.

Develop custom APIs to poll the hub org for change data and push into the spoke orgs.

C.

Develop custom APIs to poll the spoke for change data and push into the org.

D.

A backup and archive solution that extracts and restores data across orgs.

Buy Now
Questions 17

NTO has decided that it is going to build a channel sales portal with the following requirements:

1.External resellers are able to authenticate to the portal with a login.

2.Lead data, opportunity data and order data are available to authenticated users.

3.Authenticated users many need to run reports and dashboards.

4.There is no need for more than 10 custom objects or additional file storage.

Which community cloud license type should a data architect recommend to meet the portal requirements?

Options:

A.

Customer community.

B.

Lightning external apps starter.

C.

Customer community plus.

D.

Partner community.

Buy Now
Questions 18

Universal Containers (UC) is concerned about the accuracy of their Customer information in Salesforce. They have recently created an enterprise-wide trusted source MDM for Customer data which they have certified to be accurate. UC has over 20 million unique customer records in the trusted source and Salesforce. What should an Architect recommend to ensure the data in Salesforce is identical to the MDM?

Options:

A.

Extract the Salesforce data into Excel and manually compare this against the trusted source.

B.

Load the Trusted Source data into Salesforce and run an Apex Batch job to find difference.

C.

Use an AppExchange package for Data Quality to match Salesforce data against the Trusted source.

D.

Leave the data in Salesforce alone and assume that it will auto-correct itself over time.

Buy Now
Questions 19

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.

Buy Now
Questions 20

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 21

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.

Buy Now
Questions 22

Universal Containers has a rollup summary field on account to calculate the number of contacts associated with an account. During the account load, Salesforce is throwing an "UNABLE _TO_LOCK_ROW" error.

Which solution should a data architect recommend to resolve the error?

Options:

A.

Defer rollup summary field calculation during data migration.

B.

Perform a batch job in serial mode and reduce the batch size.

C.

Perform a batch job in parallel mode and reduce the batch size.

D.

Leverage Data Loader's platform API to load data.

Buy Now
Questions 23

Universal Container has implemented Sales Cloud to manage patient and related health records. During a recent security audit of the system it was discovered that same standard and custom fields need to encrypted.

Which solution should a data architect recommend to encrypt existing fields?

Options:

A.

Use Apex Crypto Class encrypt customer and standard fields.

B.

Implement classic encryption to encrypt custom and standard fields.

C.

Implement shield platform encryption to encrypt and standard fields

D.

Expert data out of Salesforce and encrypt custom and standard fields.

Buy Now
Questions 24

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

Buy Now
Questions 25

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.

Buy Now
Questions 26

A large Automobile company has implemented SF for its Sales Associates. Leads flow from its website to SF using a batch integration in SF. The Batch job connects the leads to Accounts in SF. Customer visiting their retail stores are also created in SF as Accounts.

The company has noticed a large number of duplicate accounts in SF. On analysis, it was found that certain customers could interact with its website and also visit the store. The Sales associates use Global Search to search for customers in Salesforce before they create the customers.

Which scalable option should a data Architect choose to implement to avoid duplicates?

Options:

A.

Create duplicate rules in SF to validate duplicates during the account creation process

B.

Implement a MDM solution to validate the customer information before creating Accounts in SF.

C.

Build Custom search based on fields on Accounts which can be matched with customer when they visit the store

D.

Customize Account creation process to search if customer exists before creating an Account.

Buy Now
Questions 27

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

Options:

A.

Metadata API

B.

Tooling API

C.

Bulk API in serial mode

D.

SOAP API

Buy Now
Questions 28

Universal Containers (UC) is a major supplier of office supplies. Some products are produced by UC and some by other manufacturers. Recently, a number of customers have complained that product descriptions on the invoices do not match the descriptions in the online catalog and on some of the order confirmations (e.g., "ballpoint pen" in the catalog and "pen" on the invoice, and item color labels are inconsistent: "what vs. "White" or "blk" vs. "Black"). All product data is consolidated in the company data warehouse and pushed to Salesforce to generate quotes and invoices. The online catalog and webshop is a Salesforce Customer Community solution. What is a correct technique UC should use to solve the data inconsistency?

Options:

A.

Change integration to let product master systems update product data directly in Salesforce via the Salesforce API.

B.

Add custom fields to the Product standard object in Salesforce to store data from the different source systems.

C.

Define a data taxonomy for product data and apply the taxonomy to the product data in the data warehouse.

D.

Build Apex Triggers in Salesforce that ensure products have the correct names and labels after data is loaded into salesforce.

Buy Now
Questions 29

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 30

Get Cloud Consulting needs to integrate two different systems with customer records into the Salesforce Account object. So that no duplicate records are created in Salesforce, Master Data Management will be used.

An Architect needs to determine which system is the system of record on a field level.

What should the Architect do to achieve this goal?

Options:

A.

Master Data Management systems determine system of record, and the Architect doesn't have to think about what data is controlled by what system.

B.

Key stakeholders should review any fields that share the same purpose between systems to see how they will be used in Salesforce.

C.

The database schema for each external system should be reviewed, and fields with different names should always be separate fields in Salesforce.

D.

Any field that is an input field in either external system will be overwritten by the last record integrated and can never have a system of record.

Buy Now
Questions 31

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 visit the 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.

Buy Now
Questions 32

A customer wishes to migrate 700,000 Account records in a single migration into Salesforce. What is the recommended solution to migrate these records while minimizing migration time?

Options:

A.

Use Salesforce Soap API in parallel mode.

B.

Use Salesforce Bulk API in serial mode.

C.

Use Salesforce Bulk API in parallel mode.

D.

Use Salesforce Soap API in serial mode.

Buy Now
Questions 33

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.

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

PDF + Testing Engine

$66.4  $165.99

Testing Engine

$46  $114.99
buy now Data-Architect testing engine

PDF (Q&A)

$42  $104.99
buy now Data-Architect pdf