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

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

Questions 4

As part of addressing general data protection regulation (GDPR) requirements, UC plans to implement a data classification policy for all its internal systems that stores customer information including salesforce.

What should a data architect recommend so that UC can easily classify consumer information maintained in salesforce under both standard and custom objects?

Options:

A.

Use App Exchange products to classify fields based on policy.

B.

Use data classification metadata fields available in field definition.

C.

Create a custom picklist field to capture classification of information on customer.

D.

Build reports for customer information and validate.

Buy Now
Questions 5

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.

Buy Now
Questions 6

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 7

What should a data architect do to provide additional guidance for users when they enter information in a standard field?

Options:

A.

Provide custom help text under field properties.

B.

Create a custom page with help text for user guidance.

C.

Add custom help text in default value for the field.

D.

Add a label field with help text adjacent to the custom field.

Buy Now
Questions 8

An architect has been asked by a client to develop a solution that will integrate data and resolve duplicates and discrepancies between Salesforce and one or more external systems. What two factors should the architect take into consideration when deciding whether or not to use a Master Data Management system to achieve this solution? 

Choose 2 answers

Options:

A.

Whether the systems are cloud -based or on -premise.

B.

Whether or not Salesforce replaced a legacy CRM.

C.

Whether the system of record changes for different tables.

D.

The number of systems that are integrating with each other.

Buy Now
Questions 9

A company wants to document the data architecture of a Salesforce organization.

What are two valid metadata types that should be included? (Choose two.)

Options:

A.

RecordType

B.

Document

C.

CustomField

D.

SecuritySettings

Buy Now
Questions 10

Universal Containers wants to develop a dashboard in Salesforce that will allow Sales Managers to do data exploration using their mobile device (i.e., drill down into sales-related data) and have the possibility of adding ad-hoc filters while on the move. What is a recommended solution for building data exploration dashboards in Salesforce?

Options:

A.

Create a Dashboard in an external reporting tool, export data to the tool, and add link to the dashboard in Salesforce.

B.

Create a Dashboard in an external reporting tool, export data to the tool, and embed the dashboard in Salesforce using the Canval toolkit.

C.

Create a standard Salesforce Dashboard and connect it to reports with the appropriate filters.

D.

Create a Dashboard using Analytics Cloud that will allow the user to create ad-hoc lenses and drill down.

Buy Now
Questions 11

Universal Containers has deployed Salesforce for case management The company is having difficulty understanding what percentage of cases are resolved from the initial call to their support organization. What first step is recommended to implement a reporting solution to measure the support reps case closure rates?

Options:

A.

Enable field history tracking on the Case object.

B.

Create a report on Case analytic snapshots.

C.

Install AppExchange packages for available reports.

D.

Create Contact and Opportunity Reports and Dashboards.

Buy Now
Questions 12

NTO has been using salesforce for sales and service for 10 years. For the past 2 years, the marketing group has noticed a raise from 0 to 35 % in returned mail when sending mail using the contact information stored in salesforce.

Which solution should the data architect use to reduce the amount of returned mails?

Options:

A.

Use a 3rd-party data source to update contact information in salesforce.

B.

Email all customer and asked them to verify their information and to call NTO if their address is incorrect.

C.

Delete contacts when the mail is returned to save postal cost to NTO.

D.

Have the sales team to call all existing customers and ask to verify the contact details.

Buy Now
Questions 13

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 14

Universal Containers is experiencing frequent and persistent group membership locking issues 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 15

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
Questions 16

Get Cloudy Consulting needs to evaluate the completeness and consistency of contact information in Salesforce. Their sales reps often have incomplete information about their accounts and contacts. Additionally, they are not able to interpret the information in a consistent manner. Get Cloudy Consulting has identified certain ""key"" fields which are important to their sales reps.

What are two actions Get Cloudy Consulting can take to review their data for completeness and consistency? (Choose two.)

Options:

A.

Run a report which shows the last time the key fields were updated.

B.

Run one report per key field, grouped by that field, to understand its data variability.

C.

Run a report that shows the percentage of blanks for the important fields.

D.

Run a process that can fill in default values for blank fields.

Buy Now
Questions 17

Universal Containers (UC) has users complaining about reports timing out or simply taking too long to run What two actions should the data architect recommend to improve the reporting experience? Choose 2 answers

Options:

A.

Index key fields used in report criteria.

B.

Enable Divisions for large data objects.

C.

Create one skinny table per report.

D.

Share each report with fewer users.

Buy Now
Questions 18

Universal Containers has two systems. Salesforce and an on -premise ERP system. An architect has been tasked with copying Opportunity records to the ERP once they reach a Closed/Won Stage. The Opportunity record in the ERP system will be read-only for all fields copied in from Salesforce. What is the optimal real-time approach that achieves this solution?

Options:

A.

Implement a Master Data Management system to determine system of record.

B.

Implement a workflow rule that sends Opportunity data through Outbound Messaging.

C.

Have the ERP poll Salesforce nightly and bring in the desired Opportunities.

D.

Implement an hourly integration to send Salesforce Opportunities to the ERP system.

Buy Now
Questions 19

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

Buy Now
Questions 20

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 21

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 22

UC has millions of case records with case history and SLA data. UC’s compliance team would like historical cases to be accessible for 10 years for Audit purpose.

What solution should a data architect recommend?

Options:

A.

Archive Case data using Salesforce Archiving process

B.

Purchase more data storage to support case object

C.

Use a custom object to store archived case data.

D.

Use a custom Big object to store archived case data.

Buy Now
Questions 23

UC has a classic encryption for Custom fields and is leveraging weekly data reports for data backups. During the data validation of exported data UC discovered that encrypted field values are still being exported as part of data exported. What should a data architect recommend to make sure decrypted values are exported during data export?

Options:

A.

Set a standard profile for Data Migration user, and assign view encrypted data

B.

Create another field to copy data from encrypted field and use this field in export

C.

Leverage Apex class to decrypt data before exporting it.

D.

Set up a custom profile for data migration user and assign view encrypted data.

Buy Now
Questions 24

Which two statements are accurate with respect to performance testing a Force.com application?

Options:

A.

All Force.com applications must be performance tested in a sandbox as well as production.

B.

A performance test plan must be created and submitted to Salesforce customer support.

C.

Applications with highly customized code or large volumes should be performance tested.

D.

Application performance benchmarked in a sandbox can also be expected in production.

Buy Now
Questions 25

NTO has outgrown its current salesforce org and will be migrating to new org shortly. As part of this process NTO will be migrating all of its metadata and data. NTO’s data model in the source org has a complex relationship hierarchy with several master detail and lookup relationships across objects, which should be maintained in target org.

What 3 things should a data architect do to maintain the relationship hierarchy during migration?

Choose 3 answers:

Options:

A.

Use data loader to export the data from source org and then import or Upsert into the target org in sequential order.

B.

Create a external id field for each object in the target org and map source record ID’s to this field.

C.

Redefine the master detail relationship fields to lookup relationship fields in the target org.

D.

Replace source record ID’s with new record ID’s from the target org in the import file.

E.

Keep the relationship fields populated with the source record ID’s in the import file.

Buy Now
Questions 26

Universal Containers (UC) requires 2 years of customer related cases to be available on SF for operational reporting. Any cases older than 2 years and upto 7 years need to be available on demand to the Service agents. UC creates 5 million cases per yr.

Which 2 data archiving strategies should a data architect recommend? Choose 2 options:

Options:

A.

Use custom objects for cases older than 2 years and use nightly batch to move them.

B.

Sync cases older than 2 years to an external database, and provide access to Service agents to the database

C.

Use Big objects for cases older than 2 years, and use nightly batch to move them.

D.

Use Heroku and external objects to display cases older than 2 years and bulk API to hard delete from Salesforce.

Buy Now
Questions 27

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 28

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.

Buy Now
Questions 29

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 30

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

When executing SOQL queries, which three options prevent a query from being 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 31

Northern Trail outfitters in migrating to salesforce from a legacy CRM system that identifies the agent relationships in a look-up table.

What should the data architect do in order to migrate the data to Salesfoce?

Options:

A.

Create custom objects to store agent relationships.

B.

Migrate to Salesforce without a record owner.

C.

Assign record owner based on relationship.

D.

Migrate the data and assign to a non-person system user.

Buy Now
Questions 32

Universal Containers (UC) is transitioning from Classic to Lightning Experience.

What does UC need to do to ensure users have access to its notices and attachments in Lightning Experience?

Options:

A.

Add Notes and Attachments Related List to page Layout in Lighting Experience.

B.

Manually upload Notes in Lighting Experience.

C.

Migrate Notes and Attachment to Enhanced Notes and Files a migration tool

D.

Manually upload Attachments in Lighting Experience.

Buy Now
Questions 33

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
Exam Code: Data-Architect
Exam Name: Salesforce Certified Data Architect (SP23)
Last Update: May 3, 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