Question No. 1

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?

AExtract the Salesforce data into Excel and manually compare this against the trusted source.

BLoad the Trusted Source data into Salesforce and run an Apex Batch job to find difference.

CUse an AppExchange package for Data Quality to match Salesforce data against the Trusted source.

DLeave the data in Salesforce alone and assume that it will auto-correct itself over time.

Show Answer

Correct Answer: C

Using an AppExchange package for Data Quality is a good way to match Salesforce data against a trusted source, such as an MDM system.You can use tools like Cloudingo, DupeCatcher, or DemandTools to identify and merge duplicate records, standardize data formats, and enrich data with external sources

Question No. 2

An Architect needs information about who is creating, changing, or deleting certain fields within the past four months.

How can the Architect access this information?

ACreate a field history report for the fields in question.

BAfter exporting the setup audit trail, find the fields in question.

CAfter exporting the metadata, search it for the fields in question.

DRemove 'customize application' permissions from everyone else.

Show Answer

Correct Answer: B

Exporting the setup audit trail can provide information about who is creating, changing, or deleting certain fields within the past four months. The setup audit trail tracks the recent setup changes that administrators and other users have made to the organization. The setup audit trail history shows up to 20 most recent changes in the Setup area, but administrators can download a report (in CSV format) of up to six months of setup history.

Question No. 3

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?

Ause as ETL tool to orchestrate the migration.

BUse Data Loader for export and Data Import Wizard for import

CWrite a script to use the Bulk API

DUse the Salesforces CLI to query, export, and import

Show Answer

Correct Answer: A

Using an ETL tool to orchestrate the migration is the best strategy for this scenario, as it can handle the data model changes, the large volume of records, and the tight timeline. Writing a script to use the Bulk API (option C) is also possible, but it would require more coding and testing effort. Using Data Loader and Data Import Wizard (option B) is not suitable for migrating three million records, as they have limitations on the batch size and the number of records per operation.Using Salesforce CLI (option D) is also not recommended for large data migration, as it is mainly designed for development and testing purposes

Question No. 4

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?

AUse a field audit trail to capture field changes.

BUse a custom object and trigger to capture changes.

CUse Event Monitoring to capture these changes.

DUse a third-party AppExchange app to capture changes.

Show Answer

Correct Answer: C

Event Monitoring is a feature that allows you to track user actions, such as logins, logouts, downloads, etc., in your Salesforce org.You can use Event Monitoring to monitor performance, usage, security, and compliance

Question No. 5

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?

AInstall a third-party AppExchange tool.

BCall the REST API in successive queries.

CUtilize PK Chunking with the Bulk API.

DUse the Bulk API in parallel mode.

Show Answer

Correct Answer: C

According to the Salesforce documentation2, extracting large amounts of data from Salesforce can be challenging and time-consuming, as it can encounter performance issues, API limits, timeouts, etc. To extract 100 million records from Salesforce for migration to an enterprise data warehouse (EDW), a data extraction strategy that can provide maximum performance is:

Utilize PK Chunking with the Bulk API (option C). This means using a feature that allows splitting a large query into smaller batches based on the record IDs (primary keys) of the queried object.This can improve performance and avoid timeouts by processing each batch asynchronously and in parallel using the Bulk API3.

Installing a third-party AppExchange tool (option A) is not a good solution, as it can incur additional costs and dependencies. It may also not be able to handle such a large volume of data efficiently. Calling the REST API in successive queries (option B) is also not a good solution, as it can encounter API limits and performance issues when querying such a large volume of data. Using the Bulk API in parallel mode (option D) is also not a good solution, as it can still cause timeouts and errors when querying such a large volume of data without chunking.

Free Salesforce Data-Architect Exam Actual Questions

The questions for Data-Architect were last updated On Jan 15, 2025