Salesforce Certified Data Architect (Data-Architect) Free Practice Test

Question 1

Northern Trail Outfitters (NTO) wants to capture a list of customers that have bought a particular product.
The solution architect has recommended to create a custom object for product, and to create a lookup relationship between its customers and its products.
Products will be modeled as a custom object (NTO_ Product__ c) and customers are modeled as person accounts. Every NTO product may have millions of customers looking up a single product, resulting in a lookup skew.
What should a data architect suggest to mitigate Issues related to lookup skew?

A. Select Clear the value of this field option while configuring the lookup relationship.

B. Create a custom object to maintain the relationship between products and customers.

C. Change the lookup relationship to master-detail relationship.

D. Create multiple similar products and distribute the skew across those products.

Correct Answer: D

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 2

Northern Trail Outfitters (NTO) plans to maintain contact preferences for customers and employees. NTO has implemented the following:
1. Customers are Person Accounts for their retail business.
2. Customers are represented as Contacts for their commercial business.
3. Employees are maintained as Users.
4. Prospects are maintained as Leads.
NTO needs to implement a standard communication preference management model for Person Accounts, Contacts, Users, and Leads.
Which option should the data architect recommend NTO to satisfy this requirement?

A. Use Individual objects to maintain the preferences with relationships to Lead, Person Account, and Users.

B. Create custom fields for contact preferences in Lead, Person Account, and Users objects.

C. Create case for contact preferences, and use this to validate the preferences for Lead, Person Accounts, and Users.

D. Create a custom object to maintain preferences and build relationships to Lead, Person Account, and Users.

Correct Answer: A

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 3

A Salesforce customer has plenty of data storage. Sales Reps are complaining that searches are bringing back old records that aren ' t relevant any longer. Sales Managers need the data for their historical reporting. What strategy should a data architect use to ensure a better user experience for the Sales Reps?

A. Set data access to Private to hide old data from Sales Reps.

B. Create a Permission Set to hide old data from Sales Reps.

C. Archive and purge old data from Salesforce on a monthly basis.

D. Use Batch Apex to archive old data on a rolling nightly basis.

Correct Answer: C

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 4

Universal Containers would like to have a Service-Level Agreement (SLA) of 1 day for any data loss due to unintentional or malicious updates of records in Salesforce. What approach should be suggested to address this requirement?

A. Evaluate a third-party AppExchange app, such as OwnBackup or Spanning, etc., for backup and archival purposes.

B. Schedule a Weekly Extract Service for key objects and extract data in XL sheets to on-premise systems.

C. Store all data in shadow custom objects on any updates and deletes, and extract them as needed .

D. Build a daily extract job and extract data to on-premise systems for long-term backup and archival purposes.

Correct Answer: A

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 5

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

A. Enable Divisions for large data objects.

B. Create one skinny table per report.

C. Share each report with fewer users.

D. Index key fields used in report criteria.

Correct Answer: B,D

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 6

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?

A. Load all data after deferring sharing calculations.

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 using external IDs to link to parent records.

Correct Answer: A

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 7

Universal Containers (UC) is using Salesforce Sales & Service Cloud for B2C sales and customer service but they are experiencing a lot of duplicate customers in the system. Which are two recommended approaches for UC to avoid duplicate data and increase the level of data quality?

A. Use an Enterprise Service Bus.

B. Use Duplicate Management.

C. Use Data.com Clean

D. Use a data warehouse.

Correct Answer: B,C

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 8

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

A. Schedule jobs to export and delete using the Data Loader.

B. Use the Force.com Workbench to export the data.

C. Schedule jobs to export and delete using an ETL tool.

D. Schedule a weekly export file from the Salesforce UI.

Correct Answer: A,C

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 9

UC is preparing to implement sales cloud and would like to its users to have read only access to an account record if they have access to its child opportunity record. How would a data architect implement this sharing requirement between objects?

A. Create a criteria-based sharing rule.

B. Add appropriate users to the account team.

C. Implicit sharing will automatically handle with standard functionality.

D. Create an owner-based sharing rule.

Correct Answer: C

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 10

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?

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

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

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

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

Correct Answer: C

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 11

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?

A. Build a sales data warehouse with purpose-build data marts for dashboards and senior management reporting.

B. Explore third-party data providers to enrich and augment information entered in salesforce.

C. Periodically export data to cleanse data and import them back into Salesforce for executive reports.

D. design and implement data-quality dashboard to monitor and act on records that are incomplete or incorrect

E. Leverage Salesforce features, such as validate rules, to avoid incomplete and incorrect records.

Correct Answer: A,B,E

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 12

Universal container (UC) would like to build a Human resources application on Salesforce to manage employee details, payroll, and hiring efforts. To adequately and store the relevant data, the application will need to leverage 45 custom objects. In addition to this, UC expects roughly 20,00 API calls into Salesfoce from an n-premises application daily.
Which license type should a data architect recommend that best fits these requirements?

A. Service Cloud

B. Lightning Platform plus

C. Lightning platform Start

D. Lightning External Apps Starts

Correct Answer: B

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Welcome to TestSimulate

Salesforce Certified Data Architect (Data-Architect) Free Practice Test