Salesforce DATA-ARCHITECT Online Practice Questions and Exam Preparation

Salesforce DATA-ARCHITECT Online Questions & Answers

• Question 131:

  Universal Containers has more than 10 million records in the Order_c object. The query has timed out when running a bulk query.

  What should be considered to resolve query timeout?

  A. Tooling API
  B. PK Chunking
  C. Metadata API
  D. Streaming API
  B. PK Chunking

  ---

  Explanation

  PK Chunking can resolve query timeout when running a bulk query on an object with more than 10 million records. PK Chunking is a feature of the Bulk API that splits a query into multiple batches based on the record IDs (primary keys) of the queried object. This can improve the query performance and avoid timeouts by reducing the number of records processed in each batch.

• Question 132:

  Universal Containers (UC) has implemented a master data management strategy, which uses a central system of truth, to ensure the entire company has the same customer information in all systems. UC customer data changes need to be accurate at all times in all of the systems. Salesforce is the identified system of record for this information.

  What is the correct solution for ensuring all systems using customer data are kept up to date?

  A. Send customer data nightly to the system of truth in a scheduled batch job.
  B. Send customer record changes from Salesforce to each system in a nightly batch job.
  C. Send customer record changes from Salesforce to the system of truth in real time.
  D. Have each system pull the record changes from Salesforce using change data capture.
  C. Send customer record changes from Salesforce to the system of truth in real time.

  ---

  Explanation

  Having each system pull the record changes from Salesforce using change data capture (option D) is the correct solution for ensuring all systems using customer data are kept up to date, as it allows the systems to subscribe to real-time events from Salesforce and receive notifications when customer records are created, updated, deleted, or undeleted. Sending customer data nightly to the system of truth in a scheduled batch job (option A) or sending customer record changes from Salesforce to each system in a nightly batch job (option B) are not good solutions, as they may cause data latency and inconsistency, and they do not provide real-time updates. Sending customer record changes from Salesforce to the system of truth in real time (option C) is also not a good solution, as it does not address how the other systems will receive the updates from the system of truth.

• Question 133:

  Which two best practices should be followed when using SOSL for searching?

  A. Use searches against single Objects for greater speed and accuracy.
  B. Keep searches specific and avoid wildcards where possible.
  C. Use SOSL option to ignore custom indexes as search fields are pre-indexed.
  D. Use Find in "ALL FIELDS" for faster searches.
  B. Keep searches specific and avoid wildcards where possible.
  D. Use Find in "ALL FIELDS" for faster searches.

  ---

  Explanation

  The two best practices that should be followed when using SOSL for searching are: Keep searches specific and avoid wildcards where possible. Use Find in "ALL FIELDS" for faster searches. These best practices are helpful because they optimize the search performance and relevance. For example, keeping searches specific and avoiding wildcards where possible can reduce the number of results returned and improve the search accuracy. Using Find in "ALL FIELDS" for faster searches can leverage Salesforce's pre-defined indexes on common fields and return results more quickly than specifying individual fields.

• Question 134:

  Universal Containers (UC) needs to move millions of records from an external enterprise resource planning (ERP) system into Salesforce.

  What should a data architect recommend to be done while using the Bulk API in serial mode instead of parallel mode?

  A. Placing 20 batches on the queue for upset jobs.
  B. Inserting 1 million orders distributed across a variety of accounts with potential lock exceptions.
  C. Leveraging a controlled feed load with 10 batches per job.
  D. Inserting 1 million orders distributed across a variety of accounts with lock exceptions eliminated and managed.
  B. Inserting 1 million orders distributed across a variety of accounts with potential lock exceptions.

  ---

  Explanation

  According to this article, inserting 1 million orders distributed across a variety of accounts with potential lock exceptions is a scenario where using the Bulk API in serial mode can help to prevent the lock contention issue that can occur in parallel mode.

• Question 135:

  Universal Containers (UC) has 50 million customers and stores customer order history on an ERP system. UC also uses Salesforce to manage opportunities and customer support.

  In order to provide seamless customer support, UC would like to see the customer's order history when viewing the customer record during a sales or support call.

  What should a data architect do in order to provide this functionality, while preserving the user experience?

  A. Use an Apex callout to populate a text area field for displaying the order history.
  B. Use Salesforce Connect and an external object to display the order history in Salesforce
  C. Import the order history into a custom Salesforce object, update nightly
  D. Embed the ERP system in an iframe and display on a custom tab.
  B. Use Salesforce Connect and an external object to display the order history in Salesforce

  ---

  Explanation

  According to Trailhead2, Salesforce Connect is a feature that allows administrators to integrate external data sources with Salesforce without copying or synchronizing the data. Salesforce Connect can use external objects to display the external data in Salesforce as if it were stored in Salesforce objects, enabling seamless user experience and real-time access. Option B is the correct answer because it suggests using Salesforce Connect and an external object to display the order history in Salesforce. Option A is incorrect because using an Apex callout to populate a text area field for displaying the order history can be inefficient and unreliable, as it requires making an HTTP request for each customer record and storing the order history as unstructured text. Option C is incorrect because importing the order history into a custom Salesforce object, update nightly can consume a lot of storage space and cause data latency, as the order history may change more frequently than once a night. Option D is incorrect because embedding the ERP system in an iframe and displaying on a custom tab can degrade the user experience and security, as it requires switching between tabs and authenticating with another system.

• Question 136:

  Northern trail Outfitters (NTO) runs its entire out of an enterprise data warehouse (EDW), NTD's sales team starting to use Salesforce after a recent implementation, but currently lacks data required to advanced and opportunity to the next stage.

  NTO's management has research Salesforce Connect and would like to use It to virtualize and report on data from the EDW within Salesforce. NTO will be running thousands of reports per day across 10 to 15 external objects.

  What should a data architect consider before implementing Salesforce Connect for reporting?

  A. Maximum number for records returned
  B. OData callout limits per day
  C. Maximum page size for server-driven paging
  D. Maximum external objects per org
  B. OData callout limits per day

  ---

  Explanation

  According to the Salesforce Connect Reporting blog post, one of the considerations for using Salesforce Connect for reporting is the OData callout limits per day. The blog post states that "Salesforce Connect has a limit of 100,000 callouts per day. This limit is shared across all external data sources in your org. If you exceed this limit, you will receive an error message and no more callouts will be allowed until the next day." Therefore, a data architect should consider this limit before implementing Salesforce Connect for reporting.

• Question 137:

  Every year, Ursa Major Solar has more than 1 million orders. Each order contains an average of 10 line items. The Chief Executive Officer (CEO) needs the Sales Reps to see how much money each customer generates year-over-year.

  However, data storage is running low in Salesforce.

  Which approach for data archiving is appropriate for this scenario?

  A. 1. Annually export and delete order line items. 2. Store them in a zip file in case the data is needed later.
  B. 1. Annually aggregate order amount data to store in a custom object. 2. Delete those orders and order line items.
  C. 1. Annually export and delete orders and order line items. 2. Store them in a zip file in case the data is needed later.
  D. 1. Annually delete orders and order line items. 2. Ensure the customer has order information in another system.
  B. 1. Annually aggregate order amount data to store in a custom object. 2. Delete those orders and order line items.

  ---

  Explanation

  Option B is the most appropriate approach for data archiving in this scenario1. By aggregating order amount data at a summary level and storing it in a custom object, you can reduce data storage and still provide visibility to the Sales Reps on how much money each customer generates year-over-year. Option A is not correct because storing data in a zip file does not make it available in Salesforce. Option C is not correct because exporting and deleting orders and order line items may lose important details that are needed for analysis or reporting. Option D is not correct because deleting orders and order line items without exporting them may cause data loss or inconsistency if the customer does not have order information in another system.

• Question 138:

  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?

  A. Use a field audit trail to capture field changes.
  B. Use a custom object and trigger to capture changes.
  C. Use Event Monitoring to capture these changes.
  D. Use a third-party AppExchange app to capture changes.
  C. Use Event Monitoring to capture these changes.

  ---

  Explanation

  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 139:

  UC has a roll-up summary field on Account to calculate the count of contacts associated with an account. During the account load, SF is throwing an "Unable to lock a row" error.

  Which solution should a data architect recommend, to resolve the error?

  A. Leverage data loader platform API to load data.
  B. Perform Batch job in parallel mode and reduce Batch size
  C. Perform Batch job in serial mode and reduce batch size
  D. Defer roll-up summary fields calculation during data migration.
  C. Perform Batch job in serial mode and reduce batch size

  ---

  Explanation

  The best solution to resolve the error of "Unable to lock a row" during the account load is to perform batch job in serial mode and reduce batch size. This is because roll-up summary fields are calculated synchronously when the parent record is updated, and asynchronously when the child record is updated. Therefore, updating many child records at once can cause locking issues on the parent record. To avoid this, it is recommended to use serial mode and smaller batch sizes when loading data using tools like Data Loader or Bulk API12. Leverage data loader platform API to load data is not a good option because it does not specify the mode or batch size. Perform batch job in parallel mode and reduce batch size is not a good option because parallel mode can still cause locking issues even with smaller batches. Defer roll-up summary fields calculation during data migration is not a good option because it is not possible to defer or disable roll- up summary fields calculation

• Question 140:

  NTO (Northern Trail Outlets) has a complex Salesforce org which has been developed over past 5 years. Internal users are complaining abt multiple data issues, including incomplete and duplicate data in the org. NTO has decided to engage a data architect to analyze and define data quality standards.

  Which 3 key factors should a data architect consider while defining data quality standards? Choose 3 answers:

  A. Define data duplication standards and rules
  B. Define key fields in staging database for data cleansing
  C. Measure data timeliness and consistency
  D. Finalize an extract transform load (ETL) tool for data migration
  E. Measure data completeness and accuracy
  A. Define data duplication standards and rules
  C. Measure data timeliness and consistency
  E. Measure data completeness and accuracy

  ---

  Explanation

  Defining data duplication standards and rules, measuring data timeliness and consistency, and measuring data completeness and accuracy are three key factors that a data architect should consider while defining data quality standards.

  Defining data duplication standards and rules can help prevent or reduce duplicate records in the org by specifying criteria and actions for identifying and merging duplicates. Measuring data timeliness and consistency can help ensure that the data is up-to-date, reliable, and synchronized across different sources. Measuring data completeness and accuracy can help ensure that the data is sufficient, relevant, and correct for the intended purposes.