Summer Special Discount 60% Offer - Ends in 0d 00h 00m 00s - Coupon code: brite60

ExamsBrite Dumps

Salesforce Certified Data Architect (SP25) Question and Answers

Salesforce Certified Data Architect (SP25)

Last Update Jul 15, 2025
Total Questions : 257

We are offering FREE Data-Architect Salesforce exam questions. All you do is to just go and sign up. Give your details, prepare Data-Architect free exam questions and then go for complete pool of Salesforce Certified Data Architect (SP25) test questions that will help you more.

Data-Architect pdf

Data-Architect PDF

$42  $104.99
Data-Architect Engine

Data-Architect Testing Engine

$50  $124.99
Data-Architect PDF + Engine

Data-Architect PDF + Testing Engine

$66  $164.99
Questions 1

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.

Discussion 0
Questions 2

Universal Containers (UC) is expecting to have nearly 5 million shipments records in its Salesforce org. Each shipment record has up to 10 child shipment item records. The Shipment custom object has an Organization-wide Default (OWD) sharing model set to Private and the Shipment Item custom object has a Master-Detail relationship to Shipment. There are 25 sharing rules set on the Shipment custom object, which allow shipment records to be shared to each of UC's 25 business areas around the globe. These sharing rules use public groups, one for each business area plus a number of groups for management and support roles. UC has a high turnover of Sales Reps and often needs to move Sales Reps between business areas in order to meet local demand. What feature would ensure that performance, when moving Sales Reps between regions, remains adequate while meeting existing requirements?

Options:

A.  

Implement data archiving for old Shipment records.

B.  

Contact Salesforce to create Skinny tables on Shipment.

C.  

Configure shipment OWD to Public Read/Write.

D.  

Contact Salesforce to enable Defer Sharing Rules

Discussion 0
Questions 3

Universal Containers (UC) is concerned that data is being corrupted daily either through negligence or maliciousness. They want to implement a backup strategy to help recover any corrupted data or data mistakenly changed or even deleted. What should the data architect consider when designing a field -level audit and recovery plan?

Options:

A.  

Reduce data storage by purging old data.

B.  

Implement an AppExchange package.

C.  

Review projected data storage needs.

D.  

Schedule a weekly export file.

Discussion 0
Questions 4

Universal Containers has been a customer of Salesforce for 10 years. Currently they have 2 million accounts in the system. Due to an erroneous integration built 3 years ago, it is estimated there are 500,000 duplicates in the system.

Which solution should a data architect recommend to remediate the duplication issue?

Options:

A.  

Develop an ETL process that utilizers the merge API to merge the duplicate records

B.  

Utilize a data warehouse as the system of truth

C.  

Extract the data using data loader and use excel to merge the duplicate records

D.  

Implement duplicate rules

Discussion 0
Questions 5

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.

Discussion 0
Questions 6

Universal Containers (UC) is implementing a Salesforce project with large volumes of data and daily transactions. The solution includes both real-time web service integrations and Visualforce mash -ups with back -end systems. The Salesforce Full sandbox used by the project integrates with full-scale back -end testing systems. What two types of performance testing are appropriate for this project? 

Choose 2 answers

Options:

A.  

Pre -go -live automated page -load testing against the Salesforce Full sandbox.

B.  

Post go -live automated page -load testing against the Salesforce Production org.

C.  

Pre -go -live unit testing in the Salesforce Full sandbox.

D.  

Stress testing against the web services hosted by the integration middleware.

Discussion 0
Questions 7

Due to security requirements, Universal Containers needs to capture specific user actions, such as login, logout, file attachment download, package install, etc. What is the recommended approach for defining a solution for this requirement?

Options:

A.  

Use a field audit trail to capture field changes.

B.  

Use a custom object and trigger to capture changes.

C.  

Use Event Monitoring to capture these changes.

D.  

Use a third-party AppExchange app to capture changes.

Discussion 0
Questions 8

Northern Trail Outfitters is streaming IoT data from connected devices to a cloud database. Every 24 hours. 100,000 records are generated.

NIO employees will need to see these lol records within Salesforce and generate weekly reports on it. Developers may also need to write programmatic logic to aggregate the records and incorporate them into workflows.

Which data pattern will allow a data architect to satisfy these requirements, while also keeping limits in mind?

Options:

A.  

Bidirectional integration

B.  

Unidirectional integration

C.  

Virtualization

D.  

Persistence

Discussion 0
Questions 9

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 solutions 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

Discussion 0
Questions 10

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.

Discussion 0
Questions 11

How can an architect find information about who is creating, changing, or deleting certain fields within the past two months?

Options:

A.  

Remove "customize application" permissions from everyone else.

B.  

Export the metadata and search it for the fields in question.

C.  

Create a field history report for the fields in question.

D.  

Export the setup audit trail and find the fields in question.

Discussion 0
Questions 12

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.

Discussion 0
Questions 13

Northern Trail Outfitters (NTO) has recently implemented Salesforce to track opportunities across all their regions. NTO sales teams across all regions have historically managed their sales process in Microsoft Excel. NTO sales teams are complaining that their data from the Excel files were not migrated as part of the implementation and NTO is now facing low Salesforce adoption.

What should a data architect recommend to increase Salesforce adoption?

Options:

A.  

Use the Excel connector to Salesforce to sync data from individual Excel files.

B.  

Define a standard mapping and train sales users to import opportunity data.

C.  

Load data in external database and provide access to database to sales users.

D.  

Create a chatter group and upload all Excel files to the group.

Discussion 0
Questions 14

Universal Containers wants to automatically archive all inactive Account data that is older than 3 years. The information does not need to remain accessible within the application. Which two methods should be recommended to meet this requirement? Choose 2 answers

Options:

A.  

Use the Force.com Workbench to export the data.

B.  

Schedule a weekly export file from the Salesforce UI.

C.  

Schedule jobs to export and delete using an ETL tool.

D.  

Schedule jobs to export and delete using the Data Loader.

Discussion 0
Questions 15

Northern Trail Outfitters (NTO) has multiple Salesforce orgs based on regions. Users need read-only access to customers across all Salesforce orgs.

Which feature in Salesforce can be used to provide access to customer records across all NTO orgs?

Options:

A.  

Salesforce Connect

B.  

Salesforce 2 Salesforce

C.  

Federated Search

D.  

External APIs

Discussion 0
Questions 16

A large automobile manufacturer has decided to use Salesforce as its CRM. It needs to maintain the following dealer types in their CRM:

Local dealers

Regional distributor

State distributor

Service dealer

The attributes are different for each of the customer types. The CRM users should be allowed to enter only attributes related to the customer types. The processes and business rules for each of the customer types could be different.

How should the different dealers be maintained in Salesforce?

Options:

A.  

Use Accounts for dealers, and create record types for each of the dealer types.

B.  

Create dealers as Accounts, and build custom views for each of the dealer types.

C.  

Use Accounts for dealers and custom picklist field for each of the dealer types

D.  

Create Custom objects for each dealer types and custom fields for dealer attributes.

Discussion 0
Questions 17

Company S was recently acquired by Company T. As part of the acquisition, all of the data for the Company S's Salesforce instance (source) must be migrated into the Company T's Salesforce instance (target). Company S has 6 million Case records.

An Architect has been tasked with optimizing the data load time.

What should the Architect consider to achieve this goal?

Options:

A.  

Pre-process the data, then use Data Loader with SOAP API to upsert with zip compression enabled.

B.  

Directly leverage Salesforce-to-Salesforce functionality to load Case data.

C.  

Load the data in multiple sets using Bulk API parallel processes.

D.  

Utilize the Salesforce Org Migration Tool from the Setup Data Management menu.

Discussion 0
Questions 18

Universal Containers has implemented Salesforce for its operations. In order for customers to be created in their MDM solution, the customer record needs to have the following attributes:

1. First Name

2. Last Name

3. Email

Which option should the data architect recommend to mandate this when customers are created in Salesforce?

Options:

A.  

Configure Page Layout marking attributes as required fields.

B.  

Create validation rules to check If the required attributes are entered.

C.  

Mark Fields for the attributes as required under Setup.

D.  

Build validation in Integration with MDM to check required attributes.

Discussion 0
Questions 19

Universal Containers has a large number of Opportunity fields (100) that they want to track field history on. Which two actions should an architect perform in order to meet this requirement? Choose 2 answers

Options:

A.  

Create a custom object to store a copy of the record when changed.

B.  

Create a custom object to store the previous and new field values.

C.  

Use Analytic Snapshots to store a copy of the record when changed.

D.  

Select the 100 fields in the Opportunity Set History Tracking page.

Discussion 0
Questions 20

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

Discussion 0
Questions 21

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 solutions 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

Discussion 0
Questions 22

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.

Discussion 0
Questions 23

Ursa Major Solar's legacy system has a quarterly accounts receivable report that compiles data from the following:

- Accounts

- Contacts

- Opportunities

- Orders

- Order Line Items

Which issue will an architect have when implemented this in Salesforce?

Options:

A.  

Custom report types CANNOT contain Opportunity data.

B.  

Salesforce does NOT support Orders or Order Line Items.

C.  

Salesforce does NOT allow more than four objects in a single report type.

D.  

A report CANNOT contain data from Accounts and Contacts.

Discussion 0
Questions 24

Universal Container has implemented Sales Cloud to manage patient and related health records. During a recent security audit of the system, it was discovered that same standard and custom fields need to encrypted.

Which solution should a data architect recommend to encrypt existing fields?

Options:

A.  

Use Apex Crypto Class encrypt customer and standard fields.

B.  

Implement classic encryption to encrypt custom and standard fields.

C.  

Implement shield platform encryption to encrypt and standard fields

D.  

Expert data out of Salesforce and encrypt custom and standard fields.

Discussion 0
Questions 25

Universal Containers (UC) owns a complex Salesforce org with many Apex classes, triggers, and automated processes that will modify records if available. UC has identified that, in its current development state, UC runs change of encountering race condition on the same record.

What should a data architect recommend to guarantee that records are not being updated at the same time?

Options:

A.  

Embed the keywords FOR UPDATE after SOQL statements.

B.  

Disable classes or triggers that have the potential to obtain the same record.

C.  

Migrate programmatic logic to processes and flows.

D.  

Refactor or optimize classes and trigger for maximum CPU performance.

Discussion 0
Questions 26

Universal Containers is planning out their archiving and purging plans going forward for their custom objects Topic__c and Comment__c. Several options are being considered, including analytics snapshots, offsite storage, scheduled purges, etc. Which three questions should be considered when designing an appropriate archiving strategy?

Options:

A.  

How many fields are defined on the custom objects that need to be archived?

B.  

Which profiles and users currently have access to these custom object records?

C.  

If reporting is necessary, can the information be aggregated into fewer, summary records?

D.  

Will the data being archived need to be reported on or accessed in any way in the future?

E.  

Are there any regulatory restrictions that will influence the archiving and purging plans?

Discussion 0
Questions 27

A shipping and logistics company has created a large number of reports within Sales Cloud since Salesforce was introduced. Some of these reports analyze large amounts of data regarding the whereabouts of the company's containers, and they are starting to time out when users are trying to run the reports. What is a recommended approach to avoid these time-out issues?

Options:

A.  

Improve reporting performance by creating a custom Visualforce report that is using a cache of the records in the report.

B.  

Improve reporting performance by replacing the existing reports in Sales Cloud with new reports based on Analytics Cloud.

C.  

Improve reporting performance by creating an Apex trigger for the Report object that will pre-fetch data before the report is run.

D.  

Improve reporting performance by creating a dashboard that is scheduled to run the reports only once per day.

Discussion 0
Questions 28

Universal Containers has millions of rows of data in Salesforce that are being used in reports to evaluate historical trends. Performance has become an issue, as well as data storage limits. Which two strategies should be recommended when talking with stakeholders?

Options:

A.  

Use scheduled batch Apex to copy aggregate information into a custom object and delete the original records.

B.  

Combine Analytics Snapshots with a purging plan by reporting on the snapshot data and deleting the original records.

C.  

Use Data Loader to extract data, aggregate it, and write it back to a custom object, then delete the original records.

D.  

Configure the Salesforce Archiving feature to archive older records and remove them from the data storage limits.

Discussion 0
Questions 29

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.

Discussion 0
Questions 30

A consumer products company has decided to use Salesforce for its contact center. The contact center agents need access to the following information in Service Console when a customer contacts them:

1. Customer browsing activity on its website stored on its on premise system

2. Customer interactions with sales associates at its retail stores maintained in Salesforce

3. Contact center interactions maintained in Salesforce

4. Email campaign activity to customer from its marketing systems.

What should a data architect do to fulfill these requirements with minimum development effort in Salesforce?

Options:

A.  

Create web tabs in Service Console to show website and marketing activities.

B.  

Build custom components in Service Console to bring information from the marketing and website information.

C.  

Use Salesforce Connect to integrate the website and the marketing system

into Service Console using external objects.

D.  

Build customer view in Service Console with components that show website

data and marketing data as mashup.

Discussion 0
Questions 31

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.

Discussion 0
Questions 32

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.

Discussion 0
Questions 33

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.

Discussion 0
Questions 34

Universal Containers (UC) has three systems: Salesforce, a cloud -based ERP system, and an on -premise Order Management System (OMS). An architect has been tasked with creating a solution that uses Salesforce as the system of record for Leads and the OMS as the system of record for Account and Contacts. UC wants Accounts and Contacts to be able to maintain their names in each system (i.e., "John Doe" in the OMS and "Johnny Doe" in Salesforce), but wants to have a consolidated data store which links referenced records across the systems. What approach should an architect suggest so the requirements are met?

Options:

A.  

Have Salesforce poll the OMS nightly and bring in the desired Accounts and Contacts.

B.  

Implement an integration tool to send OMS Accounts and Contacts to Salesforce.

C.  

Implement a Master Data Management strategy to reconcile Leads, Accounts, and Contacts.

D.  

Use the Streaming API to send Account and Contact data from Salesforce to the OMS.

Discussion 0
Questions 35

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

Discussion 0
Questions 36

Universal Containers (UC) is implementing Salesforce Sales Cloud and Service Cloud. As part of their implementation, they are planning to create a new custom object (Shipments), which will have a lookup relationship to Opportunities. When creating shipment records, Salesforce users need to manually input a customer reference, which is provided by customers, and will be stored in the Customer_Reference__c text custom field. Support agents will likely use this customer reference to search for Shipment records when resolving shipping issues. UC is expecting to have around 5 million shipment records created per year. What is the recommended solution to ensure that support agents using global search and reports can quickly find shipment records?

Options:

A.  

Implement an archiving process for shipment records created after five years.

B.  

Implement an archiving process for shipment records created after three years.

C.  

Set Customer-Reference_c as an External ID (non-unique).

D.  

Set Customer-Reference_c as an External ID (unique).

Discussion 0
Questions 37

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.

Discussion 0
Questions 38

Universal Containers (UC) has an open sharing model for its Salesforce users to allow all its Salesforce internal users to edit all contacts, regardless of who owns the contact. However, UC management wants to allow only the owner of a contact record to delete that contact. If a user does not own the contact, then the user should not be allowed to delete the record. How should the architect approach the project so that the requirements are met?

Options:

A.  

Create a "before delete" trigger to check if the current user is not the owner.

B.  

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

C.  

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

D.  

Create a validation rule on the Contact object to check if the current user is not the owner.

Discussion 0
Questions 39

Cloud Kicks stores Invoice records in a custom object. Invoice records are being sent to the Accounting department with missing States and incorrectly formatted Postal Codes.

Which two actions should Cloud Kicks take to improve data quality? (Choose two.)

Options:

A.  

Change each address field to require on the Page Layout.

B.  

Write an Apex Trigger to require all fields to be populated.

C.  

Utilize a Validation Rule with a REGEX operator on Postal Code.

D.  

Utilize a Validation Rule with a CONTAINS operator on address fields.

Discussion 0
Questions 40

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.

Discussion 0
Questions 41

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.

Discussion 0
Questions 42

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.

Discussion 0
Questions 43

Northern Trail Outfitters needs to implement an archive solution for Salesforce data. This archive solution needs to help NTO do the following:

1. Remove outdated Information not required on a day-to-day basis.

2. Improve Salesforce performance.

Which solution should be used to meet these requirements?

Options:

A.  

Identify a location to store archived data and use scheduled batch jobs to migrate and purge the aged data on a nightly basis,

B.  

Identify a location to store archived data, and move data to the location using a time-based workflow.

C.  

Use a formula field that shows true when a record reaches a defined age and use that field to run a report and export a report into SharePoint.

D.  

Create a full copy sandbox, and use it as a source for retaining archived data.

Discussion 0
Questions 44

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.

Discussion 0
Questions 45

Two million Opportunities need to be loaded in different batches into Salesforce using the Bulk API in parallel mode.

What should an Architect consider when loading the Opportunity records?

Options:

A.  

Use the Name field values to sort batches.

B.  

Order batches by Auto-number field.

C.  

Create indexes on Opportunity object text fields.

D.  

Group batches by the AccountId field.

Discussion 0
Questions 46

Northern Trail Outfitter has implemented Salesforce for its associates nationwide, Senior management is concerned that the executive dashboard is 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

Discussion 0
Questions 47

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.

Discussion 0
Questions 48

Universal Containers (UC) is going thought major reorganization of their sales team. This would require changes to a large a number of group members and sharing rules. UCs administrator is concerned about long processing time and failure during the process.

What should a Data architect implement to make changes efficiently?

Options:

A.  

Log a case with salesforce to make sharing rule changes.

B.  

Enable Defer Sharing Calculation prior to making sharing rule changes.

C.  

Delete old sharing rules and build new sharing rules

D.  

Log out all users and make changes to sharing rules.

Discussion 0
Questions 49

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.

Discussion 0
Questions 50

Northern Trail Outfitters (NTO) has an external product master system that syncs product and pricing information with Salesforce. Users have been complaining that they are seeing discrepancies in product and pricing information displayed on the NTO website and Salesforce.

As a data architect, which action is recommended to avoid data sync issues?

Options:

A.  

Build a custom integration for two-way sync of product and pricing information between product master to Salesforce.

B.  

Build a custom integration for one-way sync of product and pricing information from product master to Salesforce.

C.  

Implement a manual process to update the products from an extract from the products master on a weekly basis.

D.  

Use the Customer 360 data manager to sync product and pricing information from product master database to Salesforce.

Discussion 0
Questions 51

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.

Discussion 0
Questions 52

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

Discussion 0
Questions 53

Get Cloudy Consulting monitors 15,000 servers, and these servers automatically record their status every 10 minutes. Because of company policy, these status reports must be maintained for 5 years. Managers at Get Cloudy Consulting need access to up to one week's worth of these status reports with all of their details.

An Architect is recommending what data should be integrated into Salesforce and for how long it should be stored in Salesforce.

Which two limits should the Architect be aware of? (Choose two.)

Options:

A.  

Data storage limits

B.  

Workflow rule limits

C.  

API Request limits

D.  

Webservice callout limits

Discussion 0
Questions 54

Northern Trail Outfitters Is planning to build a consent form to record customer authorization for marketing purposes.

What should a data architect recommend to fulfill this requirement?

Options:

A.  

Use custom fields to capture the authorization details.

B.  

Create a custom object to maintain the authorization.

C.  

Utilize the Authorization Form Consent object to capture the consent.

D.  

Use AppExchange solution to address the requirement.

Discussion 0
Questions 55

NTO (Northern Trail Outlets) has a complex Salesforce org which has been developed over past 5 years. Internal users are complaining abt multiple data issues, including incomplete and duplicate data in the org. NTO has decided to engage a data architect to analyze and define data quality standards.

Which 3 key factors should a data architect consider while defining data quality standards? Choose 3 answers:

Options:

A.  

Define data duplication standards and rules

B.  

Define key fields in staging database for data cleansing

C.  

Measure data timeliness and consistency

D.  

Finalize an extract transform load (ETL) tool for data migration

E.  

Measure data completeness and accuracy

Discussion 0
Questions 56

Universal Containers (UC) uses the following Salesforce products:

Sales Cloud for customer management.

Marketing Cloud for marketing.

Einstein Analytics for business reporting.

UC occasionally gets a list of prospects from third-party source as comma-separated values (CSV) files for marketing purposes. Historically, UC would load contact Lead object in Salesforce and sync to Marketing Cloud to send marketing communications. The number of records in the Lead object has grown over time and has been consuming large amounts of storage in Sales Cloud, UC is looking for recommendations to reduce the storage and advice on how to optimize the marketing Cloud to send marketing communications. The number of records in the Lead object has grown over time and has been consuming large amounts of storage in Sales Cloud, UC is looking for recommendations to reduce the storage and advice on how to optimize the marketing process.

What should a data architect recommend to UC in order to immediately avoid storage issues in the future?

Options:

A.  

Load the CSV files in Einstein Analytics and sync with Marketing Cloud prior to sending marketing communications;

B.  

Load the CSV files in an external database and sync with Marketing Cloud prior to sending marketing communications.

C.  

Load the contacts directly to Marketing Cloud and have a reconciliation process to track prospects that are converted to customers.

D.  

Continue to use the existing process to use Lead object to sync with Marketing Cloud and delete Lead records from Sales after the sync is complete.

Discussion 0
Questions 57

Universal Containers uses Apex jobs to create leads in Salesforce. The business team has requested that lead creation failures should be reported to them.

Which option does Apex provide to report errors from this Apex job?

Options:

A.  

Use Custom Object to store leads, and allow unprocessed leads to be reported.

B.  

Save Apex errors in a custom object, and allow access to this object for reporting.

C.  

Use Apex services to email failures to business when error occurs.

D.  

Use AppExchange package to clean lead information before Apex job processes them.

Discussion 0
Questions 58

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.

Discussion 0
Questions 59

Universal Containers (UC) has implemented a master data management strategy, which uses a central system of truth, to ensure the entire company has the same customer information in all systems. UC customer data changes need to be accurate at all times in all of the systems. Salesforce is the identified system of record for this information.

What is the correct solution for ensuring all systems using customer data are kept up to date?

Options:

A.  

Send customer data nightly to the system of truth in a scheduled batch job.

B.  

Send customer record changes from Salesforce to each system in a nightly batch job.

C.  

Send customer record changes from Salesforce to the system of truth in real time.

D.  

Have each system pull the record changes from Salesforce using change data capture.

Discussion 0
Questions 60

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

Discussion 0
Questions 61

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.

Discussion 0
Questions 62

UC is migrating data from legacy system to SF. UC would like to preserve the following information on records being migrated:

    Date time stamps for created date and last modified date.

    Ownership of records belonging to inactive users being migrated to Salesforce.

Which 2 solutions should a data architect recommends to preserve the date timestamps and ownership on records? Choose 2 answers.

Options:

A.  

Log a case with SF to update these fields

B.  

Enable update records with Inactive Owners Permission

C.  

Enable Set Audit fields upon Record Creation Permission

D.  

Enable modify all and view all permission.

Discussion 0
Questions 63

A national nonprofit organization is using Salesforce to recruit members. The recruitment process requires a member to be matched with a volunteer opportunity. Given the following:

1. A record is created in Project__ c and used to track the project through completion.

2. The member may then start volunteering and is required to track their volunteer hours, which is stored in VTOTime_c object related to the project.

3. Ability to view or edit the VTOTime__c object needs to be the same as the Project__ c

record.

4. Managers must see total hours volunteered while viewing the Project__ c record.

Which data relationship should the data architect use to support this requirement when creating the custom VTOTime__c object?

Options:

A.  

Lookup Field on Project_c to VTOTime_c displaying a list of VTOTime__c in

a related list.

B.  

Lookup field on VTOTime_c to Project_c with formula filed on Project__ c

showing Sum of hours from VTOTime__c records.

C.  

Master Detail Field on VTOTime_ c to Project_c with rollup summary field on Project __c showing sum of hours from VTOTime_c records.

D.  

Master Detail field on Project _c to VTOTime _c showing a list of VTOTime_c Records in a related list.

Discussion 0
Questions 64

Universal Containers (UC) is a major supplier of office supplies. Some products are produced by UC and some by other manufacturers. Recently, a number of customers have complained that product descriptions on the invoices do not match the descriptions in the online catalog and on some of the order confirmations (e.g., "ballpoint pen" in the catalog and "pen" on the invoice, and item color labels are inconsistent: "what vs. "White" or "blk" vs. "Black"). All product data is consolidated in the company data warehouse and pushed to Salesforce to generate quotes and invoices. The online catalog and webshop is a Salesforce Customer Community solution. What is a correct technique UC should use to solve the data inconsistency?

Options:

A.  

Change integration to let product master systems update product data directly in Salesforce via the Salesforce API.

B.  

Add custom fields to the Product standard object in Salesforce to store data from the different source systems.

C.  

Define a data taxonomy for product data and apply the taxonomy to the product data in the data warehouse.

D.  

Build Apex Triggers in Salesforce that ensure products have the correct names and labels after data is loaded into salesforce.

Discussion 0
Questions 65

Universal Containers (UC) is in the process of migrating legacy 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 object called Inventory_c.

Inventory data should be related to the standard Account object.

The Inventory object should Invent 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

Discussion 0
Questions 66

NTO has a loyalty program to reward repeat customers. The following conditions exists:

1.Reward levels are earned based on the amount spent during the previous 12 months.

2.The program will track every item a customer has bought and grant them points for discount.

3.The program generates 100 million records each month.

NTO customer support would like to see a summary of a customer’s recent transaction and reward level(s) they have attained.

Which solution should the data architect use to provide the information within the salesforce for the customer support agents?

Options:

A.  

Create a custom object in salesforce to capture and store all reward program. Populate nightly from the point-of-scale system, and present on the customer record.

B.  

Capture the reward program data in an external data store and present the 12 months trailing summary in salesforce using salesforce connect and then external object.

C.  

Provide a button so that the agent can quickly open the point of sales system displaying the customer history.

D.  

Create a custom big object to capture the reward program data and display it on the contact record and update nightly from the point-of-scale system.

Discussion 0
Questions 67

Universal Containers would like to remove data silos and connect their legacy CRM together with their ERP and with Salesforce. Most of their sales team has already migrated to Salesforce for daily use, although a few users are still on the old CRM until some functionality they require is completed. Which two techniques should be used for smooth interoperability now and in the future.

Options:

A.  

Replicate ongoing changes in the legacy CRM to Salesforce to facilitate a smooth transition when the legacy CRM is eventually retired.

B.  

Specify the legacy CRM as the system of record during transition until it is removed from operation and fully replaced by Salesforce.

C.  

Work with stakeholders to establish a Master Data Management plan for the system of record for specific objects, records, and fields.

D.  

Do not connect Salesforce and the legacy CRM to each other during this transition period, but do allow both to interact with the ERP.

Discussion 0
Questions 68

US has released a new disaster recovery (DR)policy that states that cloud solutions need a business continuity plan in place separate from the cloud providers built in data recovery solution.

Which solution should a data architect use to comply with the DR policy?

Options:

A.  

Leverage a 3rd party tool that extract salesforce data/metadata and stores the information in an external protected system.

B.  

Leverage salesforce weekly exports, and store data in Flat files on a protected system.

C.  

Utilize an ETL tool to migrate data to an on-premise archive solution.

D.  

Write a custom batch job to extract data changes nightly, and store in an external protected system.

Discussion 0
Questions 69

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.

Discussion 0
Questions 70

Universal Containers is creating a new B2C service offering for consumers to ship goods across continents. This is in addition to their well-established B2B offering. Their current Salesforce org uses the standard Account object to track B2B customers. They are expecting to have over 50,000,000 consumers over the next five years across their 50 business regions. B2C customers will be individuals. Household data is not required to be stored. What is the recommended data model for consumer account data to be stored in Salesforce?

Options:

A.  

Use the Account object with Person Accounts and a new B2C page layout.

B.  

Use the Account object with a newly created Record Type for B2C customers.

C.  

Create a new picklist value for B2C customers on the Account Type field.

D.  

Use 50 umbrella Accounts for each region, with customers as associated Contacts.

Discussion 0
Questions 71

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.

Discussion 0
Questions 72

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

Discussion 0
Questions 73

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.

Discussion 0
Questions 74

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.

Discussion 0
Questions 75

Universal Containers (CU) is in the process of implementing an enterprise data warehouse (EDW). UC needs to extract 100 million records from Salesforce for migration to the EDW.

What data extraction strategy should a data architect use for maximum performance?

Options:

A.  

Install a third-party AppExchange tool.

B.  

Call the REST API in successive queries.

C.  

Utilize PK Chunking with the Bulk API.

D.  

Use the Bulk API in parallel mode.

Discussion 0
Questions 76

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.

Discussion 0
Questions 77

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

Discussion 0