Question 1

Your organization has a very large amount of historical sales data stored in an external system. The sales team occasionally needs to access this data for customer inquiries but does not need to manipulate the data. Which option is the most suitable?

Options :

A : Import all the sales data into Salesforce for easy access

B : Create a virtual data model in Salesforce using Salesforce Connect

C : Continually sync the sales data between the external system and Salesforce using an ETL tool

D : Store the sales data in Salesforce Big Objects

Answer: B

Question 2

Universal Container is Implementing salesforce and needs to migrate data from two legacy systems.

UC would like to clean and duplicate data before migrate to Salesforce.

Which solution should a data architect recommend a clean migration?

Options :

A : Define external IDs for an object, migrate second database to first database, and load into Salesforce

B : Define duplicate rules in Salesforce, and load data into Salesforce from both databases

C : Set up staging data base, and define external IDs to merge, clean duplicate data, and load into Salesforce.

D : Define external IDs for an object, Insert data from one database, and use upsert for a second database

Answer: D

Question 3

Universal Containers has a custom object with millions of rows of data.

When executing SOQL queries, which three options prevent a query from being selective? (Choose three.)

Options :

A : Using leading % wildcards

B : Using trailing % wildcards.

C : Performing large loads and deletions.

D : Using NOT and != operators

E : Using a custom index on a deterministic formula field.

Answer: A,D

Question 4

A company needs to migrate a large volume of data into Salesforce. The data includes both simple and complex object relationships. What is the best approach to improve the performance of this data migration?

Options :

A : Use the Data Import Wizard for all data

B : Migrate the data during peak business hours

C : Use a combination of the Bulk API for simple objects and SOAP/REST APIs for complex relationships

D : Load all data simultaneously to minimize total migration time

Answer: C

Question 5

A healthcare organization wants to regularly export large volumes of patient data from their Salesforce platform for further processing and backup purposes. What is an effective way to perform such an operation?

Higher Test Marks with Free Online Data-Architect Exam Practice

Buying Options: