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

Activedumpsnet Logo
  1. Home
  2. Salesforce
  3. Application Architect
  4. Data-Architect - Salesforce Certified Data Architect (SP23)

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

Page: 1 / 26
Total 257 questions
Get Data-Architect Full Access Download Data-Architect PDF

Salesforce Certified Data Architect (SP23) Questions and Answers

Question 1

A Customer is migrating 10 million order and 30 million order lines into Salesforce using Bulk API. The Engineer is experiencing time-out errors or long delays querying parents order IDs in Salesforce before importing related order line items. What is the recommended solution?

Options:

A.

Query only indexed ID field values on the imported order to import related order lines.

B.

Leverage an External ID from source system orders to import related order lines.

C.

Leverage Batch Apex to update order ID on related order lines after import.

D.

Leverage a sequence of numbers on the imported orders to import related order lines.

Question 2

Ursa Major Solar has defined a new Data Quality Plan for their Salesforce data.

Which two approaches should an Architect recommend to enforce the plan throughout the organization? (Choose two.)

Options:

A.

Ensure all data is stored in an external system and set up an integration to Salesforce for view-only access.

B.

Schedule reports that will automatically catch duplicates and merge or delete the records every week.

C.

Enforce critical business processes by using Workflow, Validation Rules, and Apex code.

D.

Schedule a weekly dashboard displaying records that are missing information to be sent to managers for review.

Question 3

NTO has implemented salesforce for its sales users. The opportunity management in salesforce 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 opportunity amount field on opportunities on a daily basis.

3.PPS is the trusted source within the 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 overriding issue?

Options:

A.

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

B.

Create a custom field for opportunity amount that PPS updates separating the field that sales user updates.

C.

Change opportunity amount field access to read only for sales users using field level security.

D.

Change PPS integration to update only opportunity amount fields when values is NULL.

Question 4

DreamHouse Realty has a Salesforce deployment that manages Sales, Support, and Marketing efforts in a multi-system ERP environment. The company recently reached the limits of native reports and dashboards and needs options for providing more analytical insights.

What are two approaches an Architect should recommend? (Choose two.)

Options:

A.

Weekly Snapshots

B.

Einstein Analytics

C.

Setup Audit Trails

D.

AppExchange Apps

Question 5

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 6

For a production cutover, a large number of Account records will be loaded into Salesforce from a legacy system. The legacy system does not have enough information to determine the Ownership for these Accounts upon initial load. Which two recommended options assign Account ownership to mitigate potential performance problems?

Options:

A.

Let a “system user” own all the Account records without assigning any role to this user in Role Hierarchy.

B.

Let a “system user” own the Account records and assign this user to the lowest-level role in the Role Hierarchy.

C.

Let the VP of the Sales department, who will report directly to the senior VP, own all the Account records.

D.

Let a “system user” own all the Account records and make this user part of the highest-level role in the Role Hierarchy.

Question 7

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.

Question 8

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.

Question 9

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 10

Universal Container has a Sales Cloud implementation for a sales team and an enterprise resource planning (ERP) as a customer master Sales team are complaining about duplicate account and data quality issues with account data.

Which two solution should a data architect recommend to resolve the complaints?

Options:

A.

Build a nightly batch job to de-dupe data, and merge account records.

B.

Integrate Salesforce with ERP, and make ERP as system of truth.

C.

Build a nightly sync job from ERP to Salesforce.

D.

Implement a de-dupe solution and establish account ownership in Salesforce

Question 11

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.

Question 12

Cloud Kicks currently has a Public Read/Write sharing model for the company's Contacts. Cloud Kicks management team requests that only the owner of a contact record be allowed to delete that contact.

What should an Architect do to meet these requirements?

Options:

A.

Set the profile of the users to remove delete permission from the Contact object.

B.

Check if the current user is NOT the owner by creating a "before delete" trigger.

C.

Set the Sharing settings as Public Read Only for the Contact object.

D.

Check if the current user is NOT the owner by creating a validation rule on the Contact object.

Question 13

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 a data 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.

Question 14

Get Cloudy Consulting uses an invoicing system that has specific requirements. One requirement is that attachments associated with the Invoice_c custom object be classified by Types (i.e., ""Purchase Order"", ""Receipt"", etc.) so that reporting can be performed on invoices showing the number of attachments grouped by Type.

What should an Architect do to categorize the attachments to fulfill these requirements?

Options:

A.

Add additional options to the standard ContentType picklist field for the Attachment object.

B.

Add a ContentType picklist field to the Attachment layout and create additional picklist options.

C.

Create a custom picklist field for the Type on the standard Attachment object with the values.

D.

Create a custom object related to the Invoice object with a picklist field for the Type.

Question 15

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 data quality 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.

Question 16

A health care provider wishes to use salesforce to track patient care. The following actions are in Salesforce

1. Payment Providers: Orgas who pay for the care 2 patients.

2. Doctors: They provide care plan for patients and need to support multiple patients, they are provided access to patient information.

3. Patients: They are individuals who need care.

A data architect needs to map the actor to Sf objects. What should be the optimal selection by the data architect?

Options:

A.

Patients as Contacts, Payment providers as Accounts, & Doctors as Accounts

B.

Patients as Person Accounts, Payment providers as Accounts, & Doctors as Contacts

C.

Patients as Person Accounts, Payment providers as Accounts, & Doctors as Person Account

D.

Patients as Accounts, Payment providers as Accounts, & Doctors as Person Accounts

Question 17

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

Question 18

A company has 12 million records, and a nightly integration queries these records.

Which two areas should a Data Architect investigate during troubleshooting if queries are timing out? (Choose two.)

Options:

A.

Make sure the query doesn't contain NULL in any filter criteria.

B.

Create a formula field instead of having multiple filter criteria.

C.

Create custom indexes on the fields used in the filter criteria.

D.

Modify the integration users' profile to have View All Data.

Question 19

Universal Containers (UC) is migrating from an on-premise homegrown customer relationship management (CRM) system- During analysis, UC users highlight a pain point that there are multiple versions of many customers.

What should the data architect do for a successful migration to mitigate the pain point?

Options:

A.

Hire an intern manually de-duplicate the records after migrating to Salesforce.

B.

Migrate the data as is, and use Salesforce's de-duplicating feature.

C.

Have the users manually clean the data in the old system prior to migration.

D.

Store the data in a staging database, and de-duplicate identical records.

Question 20

Universal Containers (UC) has 1,000 accounts and 50,000 opportunities. UC has an enterprise security requirement to export all sales data outside of Salesforce on a weekly basis. The security requirement also calls for exporting key operational data that includes events such as file downloads, logins, logouts, etc. Which two recommended approaches would address the above requirement?

Options:

A.

Use Field Audit History to capture operational data and extract it to on-premise systems.

B.

Use Weekly Export to extract transactional data to on-premise systems.

C.

Use a custom built extract job to extract operational data to on-premise systems.

D.

Use Event Monitoring to extract event data to on-premise systems.

Question 21

Which two aspects of data does an Enterprise data governance program aim to improve?

Options:

A.

Data integrity

B.

Data distribution

C.

Data usability

D.

Data modeling

Question 22

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 23

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.

Question 24

Which two best practices 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 fields are pre-indexed.

D.

Use Find in “ALL FIELDS” for faster searches.

Question 25

Universal Containers is integrating a new Opportunity engagement system with Salesforce. According to their Master Data Management strategy, Salesforce is the system of record for Account, Contact, and Opportunity data. However, there does seem to be valuable Opportunity data in the new system that potentially conflicts with what is stored in Salesforce. What is the recommended course of action to appropriately integrate this new system?

Options:

A.

The MDM strategy defines Salesforce as the system of record, so Salesforce Opportunity values prevail in all conflicts.

B.

A policy should be adopted so that the system whose record was most recently updated should prevail in conflicts.

C.

The Opportunity engagement system should become the system of record for Opportunity records.

D.

Stakeholders should be brought together to discuss the appropriate data strategy moving forward.

Question 26

Cloud Kicks is launching a Partner Community, which will allow users to register shipment requests that are then processed by Cloud Kicks employees. Shipment requests contain header information, and then a list of no more than 5 items being shipped.

First, Cloud Kicks will introduce its community to 6,000 customers in North America, and then to 24,000 customers worldwide within the next two years. Cloud Kicks expects 12 shipment requests per week per customer, on average, and wants customers to be able to view up to three years of shipment requests and use Salesforce reports.

What is the recommended solution for the Cloud Kicks Data Architect to address the requirements?

Options:

A.

Create an external custom object to track shipment requests and a child external object to track shipment items. External objects are stored off-platform in Heroku’s Postgres database.

B.

Create an external custom object to track shipment requests with five lookup custom fields for each item being shipped. External objects are stored off-platform in Heroku’s Postgres database.

C.

Create a custom object to track shipment requests and a child custom object to track shipment items. Implement an archiving process that moves data off-platform after three years.

D.

Create a custom object to track shipment requests with five lookup custom fields for each item being shipped Implement an archiving process that moves data off-platform after three years.

Question 27

NTO has multiple systems across its enterprise landscape including salesforce, with disparate version the customer records.

In salesforce, the customer is represented by the contact object.

NTO utilizes an MDM solution with these attributes:

1.The MDM solution keeps track of customer master with a master key.

2.The master key is a map to the record ID’s from each external system that customer data is stored within.

3.The MDM solution provides de-duplication features, so it acts as the single source of truth.

How should a data architect implement the storage of master key within salesforce?

Options:

A.

Store the master key in Heroku postgres and use Heroku connect for synchronization.

B.

Create a custom object to store the master key with a lookup field to contact.

C.

Create an external object to store the master key with a lookup field to contact.

D.

Store the master key on the contact object as an external ID (Field for referential imports)

Question 28

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.

Question 29

Universal Containers (UC) is planning to move away from legacy CRM to Salesforce. As part of one-time data migration, UC will need to keep the original date when a contact was created in the legacy system. How should an Architect design the data migration solution to meet this requirement?

Options:

A.

After the data is migrated, perform an update on all records to set the original date in a standard CreatedDate field.

B.

Create a new field on Contact object to capture the Created Date. Hide the standard CreatedDate field using Field -Level Security.

C.

Enable "Set Audit Fields" and assign the permission to the user loading the data for the duration of the migration.

D.

Write an Apex trigger on the Contact object, before insert event to set the original value in a standard CreatedDate field.

Question 30

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.

Question 31

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.

Question 32

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.

Question 33

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

Load More Data-Architect Questions 
Page: 1 / 26
Total 257 questions
Get Data-Architect Full Access Download Data-Architect PDF