Salesforce DATA-ARCHITECT Online Practice Questions and Exam Preparation

Salesforce DATA-ARCHITECT Online Questions & Answers

• Question 181:

  Northern Trail Outfitters (NTO) has multiple Salesforce orgs based on regions. Users need read-only access to customers across all Salesforce orgs.

  Which feature in Salesforce can be used to provide access to customer records across all NTO orgs?

  A. Salesforce Connect
  B. Salesforce 2 Salesforce
  C. Federated Search
  D. External APIs
  A. Salesforce Connect

  ---

  Explanation

  Salesforce Connect is a feature that allows users to access data from external sources and multiple Salesforce orgs, using either clicks or code. Salesforce Connect can provide read-only access to customer records across all NTO orgs, without replicating or storing the data in Salesforce.

• Question 182:

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

  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.
  A. Using leading % wildcards.
  C. Performing large loads and deletions.
  D. Using NOT and != operators.

  ---

  Explanation

  Using leading % wildcards, performing large loads and deletions, and using NOT and != operators are three options that prevent a query from being selective. These options can cause the query to scan a large number of records or indexes, which can negatively impact the performance and scalability of the query5. Using a custom index on a deterministic formula field, on the other hand, can improve the query selectivity by allowing the query to use the index instead of scanning all the records6.

• Question 183:

  Get Cloudy Consulting is migrating their legacy system's users and data to Salesforce. They will be creating 15,000 users, 1.5 million Account records, and 15 million Invoice records. The visibility of these records is controlled by a 50 owner and criteria-based sharing rules.

  Get Cloudy Consulting needs to minimize data loading time during this migration to a new organization.

  Which two approaches will accomplish this goal? (Choose two.)

  A. Create the users, upload all data, and then deploy the sharing rules.
  B. Contact Salesforce to activate indexing before uploading the data.
  C. First, load all account records, and then load all user records.
  D. Defer sharing calculations until the data has finished uploading.
  A. Create the users, upload all data, and then deploy the sharing rules.
  D. Defer sharing calculations until the data has finished uploading.

  ---

  Explanation

  Creating the users, uploading all data, and then deploying the sharing rules will reduce the number of sharing recalculations that occur during the data load. Deferring sharing calculations until the data has finished uploading will also improve the performance by postponing the sharing rule evaluation. These are the recommended best practices for loading large data sets into Salesforce

• Question 184:

  Universal Containers (UC) is implementing a formal, cross -business -unit data governance program As part of the program, UC will implement a team to make decisions on enterprise -wide data governance. Which two roles are appropriate as members of this team? Choose 2 answers

  A. Analytics/BI Owners
  B. Data Domain Stewards
  C. Salesforce Administrators
  D. Operational Data Users
  A. Analytics/BI Owners
  B. Data Domain Stewards

  ---

  Explanation

  Analytics/BI Owners and Data Domain Stewards are appropriate roles as members of a team that makes decisions on enterprise-wide data governance. Analytics/BI Owners are responsible for defining the business requirements and metrics for data analysis and reporting, and Data Domain Stewards are responsible for defining and enforcing the data quality standards and rules for specific data domains. Salesforce Administrators and Operational Data Users are not suitable roles for this team, as they are more focused on the operational aspects of data management, such as configuration, maintenance, and usage.

• Question 185:

  UC needs to load a large volume of leads into salesforce on a weekly basis. During this process the validation rules are disabled.

  What should a data architect recommend to ensure data quality is maintained in salesforce.

  A. Activate validation rules once the leads are loaded into salesforce to maintain quality.
  B. Allow validation rules to be activated during the load of leads into salesforce.
  C. Develop custom APEX batch process to improve quality once the load is completed.
  D. Ensure the lead data is preprocessed for quality before loading into salesforce.
  D. Ensure the lead data is preprocessed for quality before loading into salesforce.

  ---

  Explanation

  Ensuring the lead data is preprocessed for quality before loading into Salesforce is the best way to maintain data quality2. Activating validation rules after the load or developing a custom Apex batch process may not catch all the errors or may require additional time and resources. Allowing validation rules to be activated during the load may cause failures or delays.

• Question 186:

  A large automobile company has implemented Salesforce for its sales associates. Leads flow from its website to Salesforce using a batch integration in Salesforce. The batch job converts the leads to Accounts in Salesforce. Customers visiting their retail stores are also created in Salesforce as Accounts.

  The company has noticed a large number of duplicate Accounts in Salesforce. On analysis, it was found that certain customers could interact with its website and also visit the store. The sales associates use Global Search to search for customers in Salesforce before they create the customers.

  Which option should a data architect choose to implement to avoid duplicates?

  A. leverage duplicate rules in Salesforce to validate duplicates during the account creation process.
  B. Develop an Apex class that searches for duplicates and removes them nightly.
  C. Implement an MDM solution to validate the customer information before creating Salesforce.
  D. Build a custom search functionality that allows sales associates to search for customer in real time upon visiting their retail stores.
  A. leverage duplicate rules in Salesforce to validate duplicates during the account creation process.

  ---

  Explanation

  Leveraging duplicate rules in Salesforce to validate duplicates during the account creation process (option A) is the best option to implement to avoid duplicates, as it allows the sales associates to identify and merge duplicate accounts before they are saved. Developing an Apex class that searches for duplicates and removes them nightly (option B) is not a good option, as it may cause data loss or conflicts, and it does not prevent duplicates from being created in the first place.

  Implementing an MDM solution to validate the customer information before creating Salesforce (option C) is also not a good option, as it may introduce additional complexity and cost, and it does not address the issue of customers interacting with both the website and the store. Building a custom search functionality that allows sales associates to search for customer in real time upon visiting their retail stores (option D) is also not a good option, as it may not be reliable or user- friendly, and it does not leverage the existing Global Search feature.

• Question 187:

  An architect has been asked by a client to develop a solution that will integrate data and resolve duplicates and discrepancies between Salesforce and one or more external systems. What two factors should the architect take into consideration when deciding whether or not to use a Master Data Management system to achieve this solution?

  Choose 2 answers

  A. Whether the systems are cloud -based or on -premise.
  B. Whether or not Salesforce replaced a legacy CRM.
  C. Whether the system of record changes for different tables.
  D. The number of systems that are integrating with each other.
  C. Whether the system of record changes for different tables.
  D. The number of systems that are integrating with each other.

  ---

  Explanation

  Whether the system of record changes for different tables and the number of systems that are integrating with each other are two factors that the architect should take into consideration when deciding whether or not to use a Master Data Management system to achieve the solution of integrating data and resolving duplicates and discrepancies between Salesforce and one or more external systems. The system of record is the authoritative source of truth for a given entity or field in a given context. If different systems have different systems of record for different tables, then a Master Data Management system can help to manage and synchronize the data across systems and ensure data quality and consistency.

  The number of systems that are integrating with each other is another factor that affects the complexity and scalability of the integration solution. If there are many systems that need to integrate with each other, then a Master Data Management system can provide a centralized and standardized way of integrating data and resolving duplicates and discrepancies across systems. The other factors are not relevant or important for deciding whether or not to use a Master Data Management system, as they do not affect the data quality or integration challenges that a Master Data Management system can address.

• Question 188:

  Two million Opportunities need to be loaded in different batches into Salesforce using the Bulk API in parallel mode.

  What should an Architect consider when loading the Opportunity records?

  A. Use the Name field values to sort batches.
  B. Order batches by Auto-number field.
  C. Create indexes on Opportunity object text fields.
  D. Group batches by the AccountId field.
  D. Group batches by the AccountId field.

  ---

  Explanation

  Grouping batches by the AccountId field can improve the performance and avoid locking issues when loading Opportunity records using the Bulk API in parallel mode1. This is because the AccountId field is indexed and can be used to distribute the records evenly across batches

• Question 189:

  UC has millions of Cases and are running out of storage. Some user groups need to have access to historical cases for up to 7 years.

  Which 2 solutions should a data architect recommend in order to minimize performance and storage issues?

  Choose 2 answers:

  A. Export data out of salesforce and store in Flat files on external system.
  B. Create a custom object to store case history and run reports on it.
  C. Leverage on premise data archival and build integration to view archived data.
  D. Leverage big object to archive case data and lightning components to show archived data.
  C. Leverage on premise data archival and build integration to view archived data.
  D. Leverage big object to archive case data and lightning components to show archived data.

  ---

  Explanation

  The correct answer is C and D. To minimize performance and storage issues, a data architect should recommend leveraging on premise data archival and building integration to view archived data, and leveraging big object to archive case data and lightning components to show archived data. These solutions will allow some user groups to access historical cases for up to 7 years without consuming too much storage space or affecting the performance of queries and reports.

  Option A is incorrect because exporting data out of salesforce and storing it in flat files on external system will make it difficult to access and query the data. Option B is incorrect because creating a custom object to store case history and run reports on it will still consume a lot of storage space and impact the performance of queries and reports.

• Question 190:

  (NTO) has multiple salesforce orgs based on geographical reports (AMER, EMEA, APAC). NTO products are in the AMER org and need to be created in the EMEA and APAC after the products are approved.

  Which two features should a data architect recommend to share records between salesforce orgs? Choose 2.

  A. Change data capture (CDC)
  B. Salesforce connect.
  C. Federation search
  D. Salesforce 2 Salesforce
  A. Change data capture (CDC)
  D. Salesforce 2 Salesforce

  ---

  Explanation

  The two features that a data architect should recommend to share records between Salesforce orgs are:

  Change Data Capture (CDC): This is a feature that publishes change events for changes in Salesforce records, such as create, update, delete, and undelete operations. Change events can be subscribed by external systems or other Salesforce orgs using various tools, such as Platform Events, Streaming API, or CometD. CDC can help keep data in sync between Salesforce orgs in near real time89.

  Salesforce to Salesforce (S2S): This is a feature that allows sharing records and related data with other Salesforce orgs that you partner with. You can choose which records and fields to share, and which orgs to share with. You can also accept updates from the other orgs to keep the data consistent10. Salesforce Connect is not a good feature to share records between Salesforce orgs because it is intended for integrating external data sources with Salesforce using external objects. Federation Search is not a good feature to share records between Salesforce orgs because it is intended for searching across multiple Salesforce orgs without sharing data.