Salesforce Data Architect Exam Practice Test Instant Access

Question 1

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?

ABidirectional integration

BUnidirectional integration

CVirtualization

DPersistence

Answer : D

Persistence is the data pattern that will allow a data architect to satisfy the requirements, while also keeping limits in mind. Persistence means storing data from external sources in Salesforce objects, either standard or custom. This allows you to access the data within Salesforce and use it for reporting, analytics, workflows, and other features. Persistence also helps you avoid hitting API limits or performance issues when accessing large volumes of data from external systems. You can use various tools such as Data Loader, Bulk API, or Platform Events to persist IoT data from connected devices to a cloud database in Salesforce.

Question 2

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?

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

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

CUse Salesforce Connect to integrate the website and the marketing system
into Service Console using external objects.

DBuild customer view in Service Console with components that show website
data and marketing data as mashup.

Answer : D

Building a customer view in Service Console with components that show website data and marketing data as mashup is the best option to fulfill the requirement with minimum development effort in Salesforce. A mashup is a technique that combines data from different sources into a single user interface. You can use Visualforce pages or Lightning components to create mashups that display data from external systems such as your website and marketing system. This way, you can provide your contact center agents with a comprehensive view of the customer information they need.

Question 3

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?

AUse custom fields to capture the authorization details.

BCreate a custom object to maintain the authorization.

CUtilize the Authorization Form Consent object to capture the consent.

DUse AppExchange solution to address the requirement.

Answer : C

The Authorization Form Consent object is a standard object that allows you to capture customer consent for marketing purposes. It has fields such as Consent Captured Date, Consent Captured Source, Consent Description, and Consent Status. You can use this object to create consent forms and track customer responses. This is the best option to fulfill the requirement, as it does not require any custom development or external solution.

Question 4

Northern Trail Outfitters needs to implement an archive solution for Salesforce dat

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

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

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

CUse 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.

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

Answer : A

Identifying a location to store archived data and using scheduled batch jobs to migrate and purge the aged data on a nightly basis can be a way to meet the requirements for an archive solution. The article provides a use case of how to use Heroku Connect, Postgres, and Salesforce Connect to archive old data, free up space in the org, and still retain the option to unarchive the data if needed. The article also explains how this solution can improve Salesforce performance and meet data retention policies.

Question 5

Northern Trail Outfitters would like to report on the type of customers. A custom field for customer type was created in Account object. Users need to be limited to the following defined choices when entering information in this field:

1. High Value

2. Medium Value

3. Low Value

Which strategy should a data architect recommend to configure customer type?

ALookup to a custom object with defined choices.

BSingle-select restricted picklist with defined choices.

CProvide help text to guide users with defined choices.

DCreate a validation rule to limit entry to defined choices.

Answer : B

single-select restricted picklist with defined choices can be a way to configure customer type. The article states that picklists are fields that allow users to select one or more predefined values from a list, and restricted picklists ensure that users can only select from the defined values. This can help to limit the choices for customer type and ensure data quality.

Question 6

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?

AUs custom objects to maintain Sales Orders in Salesforce.

BUse custom big objects to maintain Sales Orders in Salesforce.

CUse external objects to maintain Sales Order in Salesforce.

DUse Standard order object to maintain Sale Orders in Salesforce

Answer : C

Using external objects to maintain Sales Order in Salesforce is the best recommendation for maintaining Sales Orders in Salesforce, as it allows users to access large volumes of data stored outside Salesforce without copying or synchronizing it. Using custom objects, custom big objects, or standard order object may not be feasible or optimal for storing more than 150 million records that will not be updated in Salesforce.

Question 7

Universal Container (UC) has accumulated data over years and has never deleted data from its Salesforce org. UC is now exceeding the storage allocations in the org. UC is now looking for option to delete unused from the org.

Which three recommendations should a data architect make is order to reduce the number of records from the org?

Choose 3 answers

AUse hard delete in Bulk API to permanently delete records from Salesforce.

BUse hard delete in batch Apex to permanently delete records from Salesforce.

CIdentify records in objects that have not been modified or used In last 3 years.

DUse Rest API to permanently delete records from the Salesforce org.

EArchive the records in enterprise data warehouse (EDW) before deleting from Salesforce.

Answer : A, C, E

Using hard delete in Bulk API, identifying records that have not been modified or used in last 3 years, and archiving the records in EDW before deleting from Salesforce are all good recommendations to reduce the number of records from the org1.Using hard delete in batch Apex or Rest API may not be as efficient or scalable as Bulk API

Salesforce Data Architect Salesforce Certified Data Architect Exam Practice Test