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

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

Questions 4

What is an advantage of using Custom metadata type over Custom setting?

Options:

A.

Custom metadata records are not copied from production to sandbox.

B.

Custom metadata types are available for reporting.

C.

Custom metadata records are deployable using packages.

D.

Custom metadata records are editable in Apex.

Buy Now
Questions 5

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 6

Cloud Kicks has the following requirements:

• 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 of the 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 7

Northern Trail Outfitter has implemented Salesforce for its associates nationwide, Senior management is concerned that the executive dashboard are not reliable for their real-time decision-making. On analysis , the team the following issues with data entered in Salesforce.

Information in certain records is incomplete.

Incorrect entry in certain fields causes records to be excluded in report fitters.

Duplicate entries cause incorrect counts.

Which three steps should a data architect recommend to address the issues?

Options:

A.

Periodically export data to cleanse data and import them back into Salesforce for executive reports.

B.

Build a sales data warehouse with purpose-build data marts for dashboards and senior management reporting.

C.

Explore third-party data providers to enrich and augment information entered in salesforce.

D.

Leverage Salesforce features, such as validate rules, to avoid incomplete and incorrect records.

E.

design and implement data-quality dashboard to monitor and act on records that are incomplete or incorrect

Buy Now
Questions 8

Universal Container require all customers to provide either a phone number of an email address when registering for an account.

What should the data architect use to ensure this requirement is met?

Options:

A.

validation Rule

B.

required Fields

C.

Apex Class

D.

Process Builder

Buy Now
Questions 9

NTO has 1 million customer records spanning 25 years. As part of its new SF project, NTO would like to create a master data management strategy to help preserve the history and relevance of its customer data.

Which 3 activities will be required to identify a successful master data management strategy? Choose 3 answers:

Options:

A.

Identify data to be replicated

B.

Create a data archive strategy

C.

Define the systems of record for critical data

D.

Install a data warehouse

E.

Choose a Business Intelligence tool.

Buy Now
Questions 10

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 11

A manager at Cloud Kicks is importing Leads into Salesforce and needs to avoid creating duplicate records.

Which two approaches should the manager take to achieve this goal? (Choose two.)

Options:

A.

Acquire an AppExchange Lead de-duplication application.

B.

Implement Salesforce Matching and Duplicate Rules.

C.

Run the Salesforce Lead Mass de-duplication tool.

D.

Create a Workflow Rule to check for duplicate records.

Buy Now
Questions 12

Universal Containers (UC) has implemented Sales Cloud for its entire sales organization, UC has built a custom object called projects_c that stores customers project detail and employee bitable hours.

The following requirements are needed:

A subnet of individuals from the finance team will need to access to the projects object for reporting and adjusting employee utilization.

The finance users will not access to any sales objects, but they will need to interact with the custom object.

Which license type a data architect recommend for the finance team that best meets the requirements?

Options:

A.

Service Cloud

B.

Sales Cloud

C.

Light Platform Start

D.

Lighting platform plus

Buy Now
Questions 13

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.

Buy Now
Questions 14

Northern Trail Outfitters (NTO) has implemented Salesforce for its sales users. The opportunity management in Saiesforce Is implemented as follows:

1. Sales users enter their opportunities in Salesforce for forecasting and reporting purposes.

2. NTO has a product pricing system (PPS) that is used to update the Opportunity Amount field on opportunities on a daily basis.

3. PPS is the trusted source within NTO for Opportunity Amount.

4. NTO uses Opportunity Forecast for its sales planning and management.

Sales users have noticed that their updates to the Opportunity Amount field are overwritten when PPS updates their opportunities.

How should a data architect address this overwriting issue?

Options:

A.

Create a custom field for Opportunity amount that PSS updates separating the field sales user updates.

B.

Change PSS integration to update only Opportunity Amount field when the value is null.

C.

Change Opportunity Amount field access to Read Only for sales users field-level security.

D.

Create a custom field for Opportunity amount that sales users update separating the field that PPS updates.

Buy Now
Questions 15

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

Buy Now
Questions 16

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 17

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 18

A customer wants to maintain geographic location information including latitude and longitude in a custom object. What would a data architect recommend to satisfy this requirement?

Options:

A.

Create formula fields with geolocation function for this requirement.

B.

Create custom fields to maintain latitude and longitude information

C.

Create a geolocation custom field to maintain this requirement

D.

Recommend app exchange packages to support this requirement.

Buy Now
Questions 19

Universal Containers is exporting 40 million Account records from Salesforce using Informatica Cloud. The ETL tool fails and the query log indicates a full table scan time-out failure. What is the recommended solution?

Options:

A.

Modify the export job header to specify Export-in-Parallel.

B.

Modify the export job header to specify Sforce-Enable-PKChunking.

C.

Modify the export query that includes standard index fields(s).

D.

Modify the export query with LIMIT clause with Batch size 10,000.

Buy Now
Questions 20

An Architect needs information about who is creating, changing, or deleting certain fields within the past four months.

How can the Architect access this information?

Options:

A.

Create a field history report for the fields in question.

B.

After exporting the setup audit trail, find the fields in question.

C.

After exporting the metadata, search it for the fields in question.

D.

Remove "customize application" permissions from everyone else.

Buy Now
Questions 21

Universal Containers (UC) is in the process of migrating lagacy inventory data from an enterprise resources planning (ERP) system into Sales Cloud with the following requirements:

Legacy inventory data will be stored in a custom child objects called Inventory_c.

Inventory data should be related to the standard Account object.

The Inventory_c object should Inhent the same sharing rules as the Account object.

Anytime an Account record is deleted in Salesforce, the related Inventory_c record(s) should be deleted as well.

What type of relationship field should a data architect recommend in this scenario?

Options:

A.

Master-detail relationship filed on Account, related to Inventory_c

B.

Master-detail relationship filed on Inventory_c, related to Account

C.

Indirect lookup relationship field on Account, related to Inventory_c

D.

Lookup relationship fields on Inventory related to Account

Buy Now
Questions 22

Universal Containers (UC) has a Salesforce org with multiple automated processes defined for group membership processing, UC also has multiple admins on staff that perform manual adjustments to the role hierarchy. The automated tasks and manual tasks overlap daily, and UC is experiencing "lock errors" consistently.

What should a data architect recommend to mitigate these errors?

Options:

A.

Enable granular locking.

B.

Remove SOQL statements from Apex Loops.

C.

Enable sharing recalculations.

D.

Ask Salesforce support for additional CPU power.

Buy Now
Questions 23

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 24

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.

Buy Now
Questions 25

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.

Buy Now
Questions 26

Universal Containers (UC) has multi -level account hierarchies that represent departments within their major Accounts. Users are creating duplicate Contacts across multiple departments. UC wants to clean the data so as to have a single Contact across departments. What two solutions should UC implement to cleanse their data? Choose 2 answers

Options:

A.

Make use of a third -party tool to help merge duplicate Contacts across Accounts.

B.

Use Data.com to standardize Contact address information to help identify duplicates.

C.

Use Workflow rules to standardize Contact information to identify and prevent duplicates.

D.

Make use of the Merge Contacts feature of Salesforce to merge duplicates for an Account.

Buy Now
Questions 27

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”-based approach to classify the record storage need.

Buy Now
Questions 28

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 the data 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 29

Cloud Kicks has the following requirements:

- Data needs to be sent from Salesforce to an external system to generate invoices from their Order Management System (OMS).

- A Salesforce administrator must be able to customize which fields will be sent to the external system without changing code.

What are two approaches for fulfilling these requirements? (Choose two.)

Options:

A.

A set to determine which fields to send in an HTTP callout.

B.

An Outbound Message to determine which fields to send to the OMS.

C.

A Field Set that determines which fields to send in an HTTP callout.

D.

Enable the field -level security permissions for the fields to send.

Buy Now
Questions 30

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 31

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 32

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

Buy Now
Questions 33

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

Buy Now
Exam Code: Data-Architect
Exam Name: Salesforce Certified Data Architect (SP23)
Last Update: May 2, 2024
Questions: 257
Data-Architect pdf

Data-Architect PDF

$28  $80
Data-Architect Engine

Data-Architect Testing Engine

$33.25  $95
Data-Architect PDF + Engine

Data-Architect PDF + Testing Engine

$45.5  $130