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

Salesforce Data-Architect Salesforce Certified Data Architect (SP23) Exam Practice Test

Demo: 33 questions
Total 257 questions

Salesforce Certified Data Architect (SP23) Questions and Answers

Question 1

To address different compliance requirements, such as general data protection regulation (GDPR), personally identifiable information (PII), of health insurance Portability and Accountability Act (HIPPA) and others, a SF customer decided to categorize each data element in SF with the following:

  • Data owner
  • Security Level, such as confidential
  • Compliance types such as GDPR, PII, HIPPA

A compliance audit would require SF admins to generate reports to manage compliance.

What should a data architect recommend to address this requirement?

Options:

A.

Use metadata API, to extract field attribute information and use the extract to classify and build reports

B.

Use field metadata attributes for compliance categorization, data owner, and data sensitivity level.

C.

Create a custom object and field to capture necessary compliance information and build custom reports.

D.

Build reports for field information, then export the information to classify and report for Audits.

Question 2

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 is a 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 Connect is required but this is confusing

Question 3

Universal Container (UC) stores 10 million rows of inventory data in a cloud database, As part of creating a connected experience in Salesforce, UC would like to this inventory data to Sales Cloud without a import. UC has asked its data architect to determine if Salesforce Connect is needed.

Which three consideration should the data architect make when evaluating the need for Salesforce Connect?

Options:

A.

You want real-time access to the latest data, from other systems.

B.

You have a large amount of data and would like to copy subsets of it into Salesforce.

C.

You need to expose data via a virtual private connection.

D.

You have a large amount of data that you don't want to copy into your Salesforce org.

E.

You need to small amounts of external data at any one time.

Question 4

A large insurance provider is looking to implement Salesforce. The following exist.

1. Multiple channel for lead acquisition

2. Duplication leads across channels

3. Poor customer experience and higher costs

On analysis, it found that there are duplicate leads that are resulting to mitigate the issues?

Options:

A.

Build process is manually search and merge duplicates.

B.

Standard lead information across all channels.

C.

Build a custom solution to identify and merge duplicate leads.

D.

Implement third-party solution to clean and event lead data.

E.

Implement de-duplication strategy to prevent duplicate leads

Question 5

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.

Question 6

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

Question 7

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.

Question 8

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.

Question 9

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

Question 10

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.

Question 11

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

Question 12

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.

Question 13

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.

Question 14

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.

Question 15

A large retail company has recently chosen SF as its CRM solution. They have the following record counts:

  • 2500000 accounts
  • 25000000 contacts

When doing an initial performance test, the data architect noticed an extremely slow response for reports and list views.

What should a data architect do to solve the performance issue?

Options:

A.

Load only the data that the users is permitted to access

B.

Add custom indexes on frequently searched account and contact objects fields

C.

Limit data loading to the 2000 most recently created records.

D.

Create a skinny table to represent account and contact objects.

Question 16

Cloud Kicks needs to purge detailed transactional records from Salesforce. The data should be aggregated at a summary level and available in Salesforce.

What are two automated approaches to fulfill this goal? (Choose two.)

Options:

A.

Third-party Integration Tool (ETL)

B.

Schedulable Batch Apex

C.

Third-party Business Intelligence system

D.

Apex Triggers

Question 17

UC has been using SF for 10 years. Lately, users have noticed, that the pages load slowly when viewing Customer and Account list view.

To mitigate, UC will implement a data archive strategy to reduce the amount of data actively loaded.

Which 2 tasks are required to define the strategy? Choose 2 answers:

Options:

A.

Identify the recovery point objective.

B.

Identify how the archive data will be accessed and used.

C.

Identify the recovery time objective.

D.

Identify the data retention requirements

Question 18

NTO processes orders from its website via an order management system (OMS). The OMS stores over 2 million historical records and is currently not integrated with SF. The Sales team at NTO using Sales cloud and would like visibility into related customer orders yet they do not want to persist millions of records directly in Salesforce. NTO has asked the data architect to evaluate SF connect and the concept of data verification. Which 3 considerations are needed prior to a SF Connect implementation?

Choose 3 answers:

Options:

A.

Create a 2nd system Admin user for authentication to the external source.

B.

Develop an object relationship strategy.

C.

Identify the external tables to sync into external objects

D.

Assess whether the external data source is reachable via an ODATA endpoint.

E.

Configure a middleware tool to poll external table data

Question 19

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.

Question 20

Universal Containers (UC) has implemented Salesforce, UC is running out of storage and needs to have an archiving solution, UC would like to maintain two years of data in Saleforce and archive older data out of Salesforce.

Which solution should a data architect recommend as an archiving solution?

Options:

A.

Use a third-party backup solution to backup all data off platform.

B.

Build a batch join move all records off platform, and delete all records from Salesforce.

C.

Build a batch join to move two-year-old records off platform, and delete records from Salesforce.

D.

Build a batch job to move all restore off platform, and delete old records from Salesforce.

Question 21

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.

Question 22

Developers at Universal Containers need to build a report for the business which displays Accounts opened in the past year grouped by industry. This report will also include information from contacts, opportunities, and orders. There are several million Accounts in the system. Which two options should be recommended to make this report perform well and satisfy the business need?

Options:

A.

Use triggers to populate denormalized related fields on the Account.

B.

Use an indexed data field with bounded data filters.

C.

Use Formula fields to surface information I related entities on the report.

D.

Use unbounded date ranges to filter the report.

Question 23

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.

Question 24

What makes Skinny tables fast? Choose three answers.

Options:

A.

They do not include soft-deleted records

B.

They avoid resource intensive joins

C.

Their tables are kept in sync with their source tables when the source tables are modified

D.

They can contain fields from other objects

E.

They support up to a max of 100 of columns

Question 25

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.

Question 26

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

Question 27

Universal Containers (UC) is a business that works directly with individual consumers (B2C). They are moving from a current home-grown CRM system to Salesforce. UC has about one million consumer records. What should the architect recommend for optimal use of Salesforce functionality and also to avoid data loading issues?

Options:

A.

Create a Custom Object Individual Consumer c to load all individual consumers.

B.

Load all individual consumers as Account records and avoid using the Contact object.

C.

Load one Account record and one Contact record for each individual consumer.

D.

Create one Account and load individual consumers as Contacts linked to that one Account.

Question 28

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.

Question 29

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

Question 30

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.

Question 31

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

Question 32

Universal Containers (UC) is implementing its new Internet of Things technology, which consists of smart containers that provide information on container temperature and humidity updated every 10 minutes back to UC. There are roughly 10,000 containers equipped with this technology with the number expected to increase to 50,000 across the next five years. It is essential that Salesforce user have access to current and historical temperature and humidity data for each container. What is the recommended solution?

Options:

A.

Create new custom fields for temperature and humidity in the existing Container custom object, as well as an external ID field that is unique for each container. These custom fields are updated when a new measure is received.

B.

Create a new Container Reading custom object, which is created when a new measure is received for a specific container. The Container Reading custom object has a master-detail relationship to the container object.

C.

Create a new Lightning Component that displays last humidity and temperature data for a specific container and can also display historical trends obtaining relevant data from UC’s existing data warehouse.

D.

Create a new Container Reading custom object with a master-detail relationship to Container which is created when a new measure is received for a specific container. Implement an archiving process that runs every hour.

Question 33

Universal Container (UC) has around 200,000 Customers (stored in Account object). They get 1 or 2 Orders every month from each Customer. Orders are stored in a custom object called "Order c"; this has about 50 fields. UC is expecting a growth of 10% year -over -year. What are two considerations an architect should consider to improve the performance of SOQL queries that retrieve data from the Order _c object? Choose 2 answers

Options:

A.

Use SOQL queries without WHERE conditions.

B.

Work with Salesforce Support to enable Skinny Tables.

C.

Reduce the number of triggers on Order _c object.

D.

Make the queries more selective using indexed fields.

Demo: 33 questions
Total 257 questions