Salesforce DATA-ARCHITECT Online Practice Questions and Exam Preparation

Salesforce DATA-ARCHITECT Online Questions & Answers

• Question 111:

  All accounts and opportunities are created in Salesforce. Salesforce is integrated with three systems:

  1. An ERP system feeds order data into Salesforce and updates both Account and Opportunity records.

  2. An accounting system feeds invoice data into Salesforce and updates both Account and Opportunity records.

  3. A commission system feeds commission data into Salesforce and updates both Account and Opportunity records.

  How should the architect determine which of these systems is the system of record?

  A. Account and opportunity data originates in Salesforce, and therefore Salesforce is the system of record.
  B. Whatever system updates the attribute or object should be the system of record for that field or object.
  C. Whatever integration data flow runs last will, by default, determine which system is the system of record.
  D. Data flows should be reviewed with the business users to determine the system of record per object or field.
  D. Data flows should be reviewed with the business users to determine the system of record per object or field.

  ---

  Explanation

  Option D is correct because data flows should be reviewed with the business users to determine the system of record per object or field1. The system of record is the authoritative source of data for a given entity or attribute2. It may vary depending on the business context and requirements. Option A is not correct because account and opportunity data originates in Salesforce, but it may not be the system of record for all attributes or objects if they are updated by other systems2. Option B is not correct because whatever system updates the attribute or object may not be the system of record for that field or object if there are conflicting or overlapping updates from other systems2. Option C is not correct because whatever integration data flow runs last may not determine which system is the system of record if there are different business rules or logic applied by different systems2.

• Question 112:

  A large retail B2C customer wants to build a 360 view of its customer for its call center agents. The customer interaction is currently maintained in the following system:

  1. Salesforce CRM

  3. Customer Master Data management (MDM)

  4. Contract Management system

  5. Marketing solution

  What should a data architect recommend that would help upgrade uniquely identify customer across multiple systems:

  A. Store the salesforce id in all the solutions to identify the customer.
  B. Create a custom object that will serve as a cross reference for the customer id.
  C. Create a customer data base and use this id in all systems.
  D. Create a custom field as external id to maintain the customer Id from the MDM solution.
  D. Create a custom field as external id to maintain the customer Id from the MDM solution.

  ---

  Explanation

  To help uniquely identify customer across multiple systems, a data architect should recommend creating a custom field as external ID to maintain the customer ID from the MDM solution. An external ID is a custom field that has the "External ID" attribute enabled, which means that it contains unique record identifiers from a system outside of Salesforce. By using the customer ID from the MDM solution as an external ID in Salesforce CRM, Contract Management system, and Marketing solution, the data architect can ensure that each customer can be easily identified and integrated across these systems. Option A is incorrect because storing the Salesforce ID in all the solutions to identify the customer will not work if the customer records are created or updated in other systems besides Salesforce CRM. Option B is incorrect because creating a custom object that will serve as a cross reference for the customer ID will require additional configuration effort and may not be consistent with the actual customer records in each system. Option C is incorrect because creating a customer database and using this ID in all systems will require additional infrastructure cost and maintenance effort.

• Question 113:

  To avoid creating duplicate Contacts, a customer frequently uses Data Loader to upsert Contact records into Salesforce.

  What common error should the data architect be aware of when using upsert?

  A. Errors with duplicate external Id values within the same CSV file.
  B. Errors with records being updated and inserted in the same CSV file.
  C. Errors when a duplicate Contact name is found cause upsert to fail.
  D. Errors with using the wrong external Id will cause the load to fail.
  A. Errors with duplicate external Id values within the same CSV file.

  ---

  Explanation

  Data Loader uses external Id fields to match records in the CSV file with records in Salesforce during an upsert operation. If the CSV file contains duplicate external Id values within the same file, Data Loader will throw an error saying "Duplicate Id Specified" and will not process those records. Therefore, it is important to ensure that the CSV file does not have any duplicate external Id values before using Data Loader to upsert records.

• Question 114:

  North Trail Outfitters (NTD) is in the process of evaluating big objects to store large amounts of asset data from an external system. NTO will need to report on this asset data weekly.

  Which two native tools should a data architect recommend to achieve this reporting requirement?

  A. Standard reports and dashboards
  B. Async SOQL with a custom object
  C. Standard SOQL queries
  D. Einstein Analytics
  B. Async SOQL with a custom object
  D. Einstein Analytics

  ---

  Explanation

  Async SOQL with a custom object (option B) and Einstein Analytics (option D) are the two native tools that can be used to report on big object data. Async SOQL allows querying big object data and storing the results in a custom object, which can then be used for reporting. Einstein Analytics can connect to big object data sources and provide advanced analytics and visualization features. Standard reports and dashboards (option A) and standard SOQL queries (option C) cannot be used to report on big object data, as they do not support big object fields

• Question 115:

  What should a data architect do to provide additional guidance for users when they enter information in a standard field?

  A. Provide custom help text under field properties.
  B. Create a custom page with help text for user guidance.
  C. Add custom help text in default value for the field.
  D. Add a label field with help text adjacent to the custom field.
  A. Provide custom help text under field properties.

  ---

  Explanation

  The correct answer is A. To provide additional guidance for users when they enter information in a standard field, a data architect should provide custom help text under field properties. This will display a help icon next to the field label that users can hover over to see the help text. Option B is incorrect because creating a custom page with help text for user guidance will require additional development effort and may not be easily accessible by users. Option C is incorrect because adding custom help text in default value for the field will overwrite the actual default value of the field and may confuse users. Option D is incorrect because adding a label field with help text adjacent to the custom field will clutter the page layout and may not be visible to users.

• Question 116:

  Universal Containers has millions of rows of data in Salesforce that are being used in reports to evaluate historical trends. Performance has become an issue, as well as data storage limits.

  Which two strategies should be recommended when talking with stakeholders?

  A. Use scheduled batch Apex to copy aggregate information into a custom object and delete the original records.
  B. Combine Analytics Snapshots with a purging plan by reporting on the snapshot data and deleting the original records.
  C. Use Data Loader to extract data, aggregate it, and write it back to a custom object, then delete the original records.
  D. Configure the Salesforce Archiving feature to archive older records and remove them from the data storage limits.
  A. Use scheduled batch Apex to copy aggregate information into a custom object and delete the original records.
  D. Configure the Salesforce Archiving feature to archive older records and remove them from the data storage limits.

  ---

  Explanation

  Using scheduled batch Apex to copy aggregate information into a custom object and delete the original records can improve the performance and reduce the data storage limits by removing unnecessary data and keeping only the summary data that is needed for reporting. Configuring the Salesforce Archiving feature to archive older records and remove them from the data storage limits can also help with performance and storage issues by moving historical data to a separate system that is still accessible but does not affect the operational data

• Question 117:

  UC has millions of case records with case history and SLA data. UC's compliance team would like historical cases to be accessible for 10 years for Audit purpose.

  What solution should a data architect recommend?

  A. Archive Case data using Salesforce Archiving process
  B. Purchase more data storage to support case object
  C. Use a custom object to store archived case data.
  D. Use a custom Big object to store archived case data.
  D. Use a custom Big object to store archived case data.

  ---

  Explanation

  The best solution to store historical cases for 10 years for audit purpose is to use a custom Big object to store archived case data. Big objects are a type of custom object that can store massive amounts of data on the Salesforce platform without affecting performance or storage limits. They also support point-and-click tools, triggers, and Apex code. Big objects can be used for archiving historical data that needs to be retained for compliance or analytics purposes3. Archiving case data using Salesforce Archiving process is not a good option because it only supports archiving cases that are closed for more than one year, and it does not allow customizing the archival criteria or accessing the archived data via Apex or APIs4. Purchasing more data storage to support case object is expensive and may impact performance. Using a custom object to store archived case data is not scalable and may consume a lot of storage space.

• Question 118:

  A data architect is working with a large B2C retailer and needs to model the consumer account structure in Salesforce.

  What standard feature should be selected in this scenario?

  A. Individual Accounts
  B. Account Contact
  C. Contacts
  D. Person Accounts
  D. Person Accounts

  ---

  Explanation

  According to this article, person accounts are designed to store information about individual people by combining certain account and contact fields into a single record. This is suitable for a large B2C retailer that needs to model the consumer account structure in Salesforce.

• Question 119:

  Universal Container (UC) stores 10 million rows of inventory data in a cloud database, As part of creating a connected experience in Salesforce, UC would like to this inventory data to Sales Cloud without a import. UC has asked its data architect to determine if Salesforce Connect is needed.

  Which three consideration should the data architect make when evaluating the need for Salesforce Connect?

  A. You want real-time access to the latest data, from other systems.
  B. You have a large amount of data and would like to copy subsets of it into Salesforce.
  C. You need to expose data via a virtual private connection.
  D. You have a large amount of data that you don't want to copy into your Salesforce org.
  E. You need to small amounts of external data at any one time.
  A. You want real-time access to the latest data, from other systems.
  D. You have a large amount of data that you don't want to copy into your Salesforce org.
  E. You need to small amounts of external data at any one time.

  ---

  Explanation

  The correct answer is A, D, and E. The data architect should consider these three factors when evaluating the need for Salesforce Connect: You want real-time access to the latest data from other systems, you have a large amount of data that you don't want to copy into your Salesforce org, and you need to small amounts of external data at any one time. These factors indicate that Salesforce Connect is a suitable solution for creating a connected experience in Salesforce without importing inventory data from a cloud database. Salesforce Connect allows Salesforce to access external data via OData or custom adapters without storing it in Salesforce, which reduces storage costs and ensures data freshness.

  Salesforce Connect also supports pagination and caching to optimize performance when accessing small amounts of external data at any one time. Option B is incorrect because if you have a large amount of data and would like to copy subsets of it into Salesforce, you may not need Salesforce Connect but rather use other tools such as Data Loader or API integration. Option C is incorrect because if you need to expose data via a virtual private connection, you may not need Salesforce Connect but rather use other tools such as VPN or VPC peering.

• Question 120:

  US is implementing salesforce and will be using salesforce to track customer complaints, provide white papers on products and provide subscription (Fee) ?based support.

  Which license type will US users need to fulfil US's requirements?

  A. Lightning platform starter license.
  B. Service cloud license.
  C. Salesforce license.
  D. Sales cloud license
  B. Service cloud license.

  ---

  Explanation

  The best license type to fulfil US's requirements is the Service Cloud license. Service Cloud licenses are designed for users who need access to customer service features, such as cases, solutions, knowledge articles, entitlements, service contracts, and service console. Service Cloud users can also access standard CRM objects, such as accounts, contacts, leads, opportunities, campaigns, and reports3. Lightning Platform Starter license is not a good option because it is intended for users who need access to one custom app and a limited set of standard objects. Salesforce license is not a specific license type, but rather a generic term for any license that grants access to the Salesforce platform. Sales Cloud license is not a good option because it is intended for users who need access to sales features, such as products, price books, quotes, orders, and forecasts.