Free Salesforce Data-Architect Exam Actual Questions

The questions for Data-Architect were last updated On Dec 17, 2024

Get All 257 Questions
Question No. 1

Northern Trail Outfitters (NTO) wants to start a loyalty program to reward repeat customers. The program will track every item a customer has bought and grants them points for discounts. The following conditions will exist upon implementation:

Data will be used to drive marketing and product development initiatives.

NTO estimates that the program will generate 100 million rows of date monthly.

NTO will use Salesforce's Einstein Analytics and Discovery to leverage their data and make business and marketing decisions.

What should the Data Architect do to store, collect, and use the reward program data?

Show Answer Hide Answer
Correct Answer: A

According to the official Salesforce guide1, big objects are designed to store and manage massive data volumes within Salesforce without affecting performance. They can be queried by using Async SOQL or standard SOQL, and they can be accessed by using Apex, Visualforce, Lightning components, or APIs. Big objects are ideal for storing data that is used for analytics or reporting purposes, such as the reward program data. Option A is the correct answer because it allows NTO to create a custom big object in Salesforce that can store the reward program data and make it available for consumption by Einstein Analytics and Discovery. Option B is incorrect because Einstein cannot connect directly to the point of sales system to capture the reward program data. Option C is incorrect because Einstein Analytics does not support creating big objects. Option D is incorrect because custom objects are not suitable for storing large volumes of data.


Question No. 2

NTO need to extract 50 million records from a custom object everyday from its Salesforce org. NTO is facing query timeout issues while extracting these records.

What should a data architect recommend in order to get around the time out issue?

Show Answer Hide Answer
Correct Answer: C

The best solution to extract 50 million records from a custom object everyday from Salesforce org without facing query timeout issues is to use an ETL tool for extraction of records. ETL stands for extract, transform, and load, and it refers to a process of moving data from one system to another. An ETL tool is a software application that can connect to various data sources, perform data transformations, and load data into a target destination.ETL tools can handle large volumes of data efficiently and reliably, and they often provide features such as scheduling, monitoring, error handling, and logging5. Using a custom auto number and formula field and use that to chunk records while extracting data is a possible workaround, but it requires creating additional fields and writing complex queries.The REST API can extract data as it automatically chunks records by 200, but it has some limitations, such as a maximum of 50 million records per query job6.Asking SF support to increase the query timeout value is not feasible because query timeout values are not configurable


Question No. 3

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?

Show Answer Hide Answer
Correct Answer: D

Contacting Salesforce to enable Defer Sharing Rules is the feature that would ensure that performance, when moving Sales Reps between regions, remains adequate while meeting existing requirements. Defer Sharing Rules allows you to defer sharing rule recalculation when you make changes to public groups or roles that are used in sharing rules.This can improve performance and avoid locking issues when you move users between groups or roles2. Implementing data archiving for old Shipment records will not help with the performance issue related to sharing rules. Contacting Salesforce to create Skinny tables on Shipment will not help with the performance issue related to sharing rules. Configuring shipment OWD to Public Read/Write will not meet the existing requirements of having a Private sharing model.


Question No. 4

Universal Containers has defined a new Data Quality Plan for their Salesforce data and wants to know how they can enforce it throughout the organization. Which two approaches should an architect recommend to enforce this new plan?

Choose 2 answers

Show Answer Hide Answer
Correct Answer: A, B

Scheduling a weekly dashboard displaying records that are missing information to be sent to managers for review and using Workflow, Validation Rules, and Force.com code (Apex) to enforce critical business processes are two approaches that an architect should recommend to enforce the new Data Quality Plan for UC's Salesforce data. Scheduling a weekly dashboard can provide a regular and visual way of monitoring the data quality and identifying any gaps or issues that need to be addressed by the managers or users. Using Workflow, Validation Rules, and Apex can provide various ways of enforcing data quality standards and business logic by automating actions, displaying error messages, or executing custom code when users create or edit records.The other options are not suitable or helpful for enforcing the Data Quality Plan, as they would either not provide real-time feedback, not prevent data quality issues, or not leverage the capabilities of Salesforce


Question No. 5

A casino is implementing Salesforce and is planning to build a customer 360 degree view for a customer who visits its resorts. The casino currently maintains the following systems that record customer activity: L Point-of-sale system: All purchases for a customer

2. Salesforce; All customer service activity and sales activities for a customer

3. Mobile app: All bookings, preferences, and browser activity for a customer

4. Marketing: All email, SMS, and social campaigns for a customer

Customer service agents using Salesforce would like to view the activities from all four systems to provide support to customers. The information has to be current and real time.

What strategy should the data architect implement to satisfy this requirement?

Show Answer Hide Answer
Correct Answer: A

Exploring external data sources in Salesforce to build a 360 degree view of the customer (option A) is the best strategy to satisfy this requirement, as it allows customer service agents to view the activities from all four systems in real time without storing or replicating the data in Salesforce. Using a customer data mart to create the 360 degree view of the customer (option B) is not a good strategy, as it may introduce additional complexity and cost, and it does not leverage the native Salesforce features. Periodically uploading summary information in Salesforce to build a 360 degree view (option C) is also not a good strategy, as it may cause data latency and inconsistency, and it does not provide real-time information. Migrating customer activities from all four systems into Salesforce (option D) is also not a good strategy, as it may cause data redundancy and conflicts, and it does not scale well with large volumes of data.


Get All 257 Questions Explore Other Salesforce Exams