Weekend Sale Special Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: suredis

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

Salesforce Certified Data Architect (SP23) Questions and Answers

Testing Engine

  • Product Type: Testing Engine
$42  $119.99

PDF Study Guide

  • Product Type: PDF Study Guide
$36.75  $104.99
Question 1

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.

Question 2

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

Question 3

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 4

What 2 data management policies does the data classification feature allow customers to classify in salesforce? Choose 2 answers:

Options:

A.

Reference data policy.

B.

Data governance policy.

C.

Data sensitivity policy.

D.

Compliance categorization policy.

Question 5

Universal Containers (UC) management has identified a total of ten text fields on the Contact object as important to capture any changes made to these fields, such as who made the change, when they made the change, what is the old value, and what is the new value. UC needs to be able to report on these field data changes within Salesforce for the past 3 months. What are two approaches that will meet this requirement? Choose 2 answers

Options:

A.

Create a workflow to evaluate the rule when a record is created and use field update actions to store previous values for these ten fields in ten new fields.

B.

Write an Apex trigger on Contact after insert event and after update events and store the old values in another custom object.

C.

Turn on field Contact object history tracking for these ten fields, then create reports on contact history.

D.

Create a Contact report including these ten fields and Salesforce Id, then schedule the report to run once a day and send email to the admin.

Question 6

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 7

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.

Question 8

Universal Containers (UC) has over 10 million accounts with an average of 20 opportunities with each account. A Sales Executive at UC needs to generate a daily report for all opportunities in a specific opportunity stage.

Which two key considerations should be made to make sure the performance of the report is not degraded due to large data volume?

Options:

A.

Number of queries running at a time.

B.

Number of joins used in report query.

C.

Number of records returned by report query.

D.

Number of characters in report query.

Question 9

Universal Containers has successfully migrated 50 million records into five different objects multiple times in a full copy sandbox. The Integration Engineer wants to re-run the test again a month before it goes live into Production. What is the recommended approach to re-run the test?

Options:

A.

Truncate all 5 objects quickly and re-run the data migration test.

B.

Refresh the full copy sandbox and re-run the data migration test.

C.

Hard delete all 5 objects’ data and re-run the data migration test.

D.

Truncate all 5 objects and hard delete before running the migration test.

Question 10

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 11

UC has large amount of orders coming in from its online portal. Historically all order are assigned to a generic user.

Which 2 measures should data architect recommend to avoid any performance issues while working with large number of order records? Choose 2 answers:

Options:

A.

Clear the role field in the generic user record.

B.

Salesforce handles the assignment of orders automatically and there is no performance impact.

C.

Create a role at top of role hierarchy and assign the role to the generic user.

D.

Create a pool of generic users and distribute the assignment of memory to the pool of users.

Question 12

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.

Question 13

Universal Containers (UC) has implemented Sales Cloud and it has been noticed that Sales reps are not entering enough data to run insightful reports and dashboards. UC executives would like to monitor and measure data quality metrics. What solution addresses this requirement?

Options:

A.

Use third-party AppExchange tools to monitor and measure data quality.

B.

Generate reports to view the quality of sample data.

C.

Use custom objects and fields to calculate data quality.

D.

Export the data to an enterprise data warehouse and use BI tools for data quality.

Question 14

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.

Question 15

Universal Containers is looking to use Salesforce to manage their sales organization. They will be migrating legacy account data from two aging systems into Salesforce. Which two design considerations should an architect take to minimize data duplication? Choose 2 answers

Options:

A.

Use a workflow to check and prevent duplicates.

B.

Clean data before importing to Salesforce.

C.

Use Salesforce matching and duplicate rules.

D.

Import the data concurrently.

Question 16

Universal Containers (UC) is in the process of selling half of its company. As part of this split, UC's main Salesforce org will be divided into two org:org A and org B, UC has delivered these requirements to its data architect

1. The data model for Org B will drastically change with different objects, fields, and picklist values.

2. Three million records will need to be migrated from org A to org B for compliance reasons.

3. The migrate will need occur within the next two month, prior to be split.

Which migrate strategy should a data architect use to successfully migrate the date?

Options:

A.

use as ETL tool to orchestrate the migration.

B.

Use Data Loader for export and Data Import Wizard for import

C.

Write a script to use the Bulk API

D.

Use the Salesforces CLI to query, export, and import

Question 17

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.

Question 18

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.

Question 19

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 20

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 21

NTO has decided to franchise its brand. Upon implementation, 1000 franchisees will be able to access BTO’s product information and track large customer sales and opportunities through a portal. The Franchisees will also be able to run monthly and quarterly sales reports and projections as well as view the reports in dashboards.

Which licenses does NTO need to provide these features to the Franchisees?

Options:

A.

Salesforce Sales Cloud license

B.

Lightning Platform license

C.

Customer Community license

D.

Partner Community license

Question 22

During the implementation of Salesforce, a customer has the following requirements for Sales Orders:

1. Sales Order information needs to be shown to users in Salesforce.

2. Sales Orders are maintained in the on-premises enterprise resource planning (ERP).

3. Sales Order information has more than 150 million records.

4. Sales Orders will not be updated in Salesforce.

What should a data architect recommend for maintaining Sales Orders in salesforce?

Options:

A.

Us custom objects to maintain Sales Orders in Salesforce.

B.

Use custom big objects to maintain Sales Orders in Salesforce.

C.

Use external objects to maintain Sales Order in Salesforce.

D.

Use Standard order object to maintain Sale Orders in Salesforce

Question 23

Universal Containers (UC) has a data model as shown in the image. The Project object has a private sharing model, and it has Roll -Up summary fields to calculate the number of resources assigned to the project, total

hours for the project, and the number of work items associated to the project. What should the architect consider, knowing there will be a large amount of time entry records to be loaded regularly from an external

system into Salesforce.com?

Options:

A.

Load all data using external IDs to link to parent records.

B.

Use workflow to calculate summary values instead of Roll -Up.

C.

Use triggers to calculate summary values instead of Roll -Up.

D.

Load all data after deferring sharing calculations.

Question 24

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 25

UC has millions of Cases and are running out of storage. Some user groups need to have access to historical cases for up to 7 years.

Which 2 solutions should a data architect recommend in order to minimize performance and storage issues?

Choose 2 answers:

Options:

A.

Export data out of salesforce and store in Flat files on external system.

B.

Create a custom object to store case history and run reports on it.

C.

Leverage on premise data archival and build integration to view archived data.

D.

Leverage big object to archive case data and lightning components to show archived data.

Question 26

All accounts and opportunities are created in Salesforce. Salesforce is integrated with three systems:

• An ERP system feeds order data into Salesforce and updates both Account and Opportunity records.

• An accounting system feeds invoice data into Salesforce and updates both Account and Opportunity records.

• A commission system feeds commission data into Salesforce and updates both Account and Opportunity records.

How should the architect determine which of these systems is the system of record?

Options:

A.

Account and opportunity data originates in Salesforce, and therefore Salesforce is the system of record.

B.

Whatever system updates the attribute or object should be the system of record for that field or object.

C.

Whatever integration data flow runs last will, by default, determine which system is the system of record.

D.

Data flows should be reviewed with the business users to determine the system of record per object or field.

Question 27

In their legacy system. Universal Containers has a monthly accounts receivable report that compiles data from Accounts, Contacts, Opportunities, Orders. and Order Line Items. What difficulty will an architect run into when implementing this in Salesforce?

Options:

A.

Salesforce allows up to four objects in a single report type.

B.

Salesforce does not support Orders or Order Line Items.

C.

A report cannot contain data from Accounts and Contacts.

D.

Custom report types cannot contain Opportunity data.

Question 28

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.

Question 29

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.

Question 30

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 31

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

Question 32

Northern trail Outfitters (NTO) uses Sales Cloud and service Cloud to manage sales and support processes. Some of NTOs team are complaining they see new fields on their page unsure of which values need be input. NTO is concerned about lack of governance in making changes to Salesforce.

Which governance measure should a data architect recommend to solve this issue?

Options:

A.

Add description fields to explain why the field is used, and mark the field as required.

B.

Create and manage a data dictionary and ups a governance process for changes made to common objects.

C.

Create reports to identify which users are leaving blank, and use external data sources o agreement the missing data.

D.

Create validation rules with error messages to explain why the fields is used

Question 33

Universal Containers (UC) has a Salesforce instance with over 10.000 Account records. They have noticed similar, but not identical. Account names and addresses. What should UC do to ensure proper data quality?

Options:

A.

Use a service to standardize Account addresses, then use a 3rd -party tool to merge Accounts based on rules.

B.

Run a report, find Accounts whose name starts with the same five characters, then merge those Accounts.

C.

Enable Account de -duplication by creating matching rules in Salesforce, which will mass merge duplicate Accounts.

D.

Make the Account Owner clean their Accounts' addresses, then merge Accounts with the same address.