Salesforce DATA-ARCHITECT Online Practice Questions and Exam Preparation

Salesforce DATA-ARCHITECT Online Questions & Answers

• Question 151:

  UC has one SF org (Org A) and recently acquired a secondary company with its own Salesforce org (Org B). UC has decided to keep the orgs running separately but would like to bidirectionally share opportunities between the orgs in near- real time.

  Which 3 options should a data architect recommend to share data between Org A and Org B?

  Choose 3 answers.

  A. Leverage Heroku Connect and Heroku Postgres to bidirectionally sync Opportunities.
  B. Install a 3rd party AppExchange tool to handle the data sharing
  C. Develop an Apex class that pushes opportunity data between orgs daily via the Apex schedule.
  D. Leverage middleware tools to bidirectionally send Opportunity data across orgs.
  E. Use Salesforce Connect and the cross-org adapter to visualize Opportunities into external objects
  A. Leverage Heroku Connect and Heroku Postgres to bidirectionally sync Opportunities.
  D. Leverage middleware tools to bidirectionally send Opportunity data across orgs.
  E. Use Salesforce Connect and the cross-org adapter to visualize Opportunities into external objects

  ---

  Explanation

  Leveraging Heroku Connect and Heroku Postgres, middleware tools, or Salesforce Connect and the cross-org adapter are all viable options to share data between Org A and Org B in near-real time3. Installing a 3rd party AppExchange tool may not provide bidirectional sync or may have additional costs. Developing an Apex class that pushes opportunity data between orgs daily via the Apex schedule may not meet the near- real time requirement.

• Question 152:

  Universal Containers has a rollup summary field on account to calculate the number of contacts associated with an account. During the account load, Salesforce is throwing an "UNABLE _TO_LOCK_ROW" error.

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

  A. Defer rollup summary field calculation during data migration.
  B. Perform a batch job in serial mode and reduce the batch size.
  C. Perform a batch job in parallel mode and reduce the batch size.
  D. Leverage Data Loader's platform API to load data.
  B. Perform a batch job in serial mode and reduce the batch size.

  ---

  Explanation

  According to the Salesforce documentation1, the "UNABLE _TO_LOCK_ROW" error occurs when a record is being updated or created, and another operation tries to access or update the same record at the same time. This can cause lock contention and timeout issues. To resolve the error, some of the recommended solutions are: Perform a batch job in serial mode and reduce the batch size (option B). This means running the batch job one at a time and processing fewer records per batch. This can reduce the chances of concurrent updates and lock contention on the same records.

  Use the FOR UPDATE keyword to lock records in Apex code or API calls. This means explicitly locking the records that are being accessed or updated by a transaction, and preventing other transactions from modifying them until the lock is released. This can avoid conflicts and errors between concurrent operations on the same records2.

  Defer rollup summary field calculation during data migration (option A). This means disabling the automatic calculation of rollup summary fields on the parent object when child records are inserted or updated. This can improve performance and avoid locking issues on the parent records. However, this option is only available for custom objects, not standard objects3. Performing a batch job in parallel mode and reducing the batch size (option C) is not a good solution, as it can still cause lock contention and errors if multiple batches try to access or update the same records at the same time. Leveraging Data Loader's platform API to load data (option D) is also not a good solution, as it can still encounter locking issues if other operations are modifying the same records at the same time.

• Question 153:

  Northern Trail Outfitters (NTO) wants to start a loyalty program to reward repeat customers. The program will track every item a customer has bought and grants them points for discounts. The following conditions will exist upon implementation:

  Data will be used to drive marketing and product development initiatives.

  NTO estimates that the program will generate 100 million rows of date monthly.

  NTO will use Salesforce's Einstein Analytics and Discovery to leverage their data and make business and marketing decisions.

  What should the Data Architect do to store, collect, and use the reward program data?

  A. Create a custom big object in Salesforce which will be used to capture the Reward Program data for consumption by Einstein.
  B. Have Einstein connect to the point of sales system to capture the Reward Program data.
  C. Create a big object in Einstein Analytics to capture the Loyalty Program data.
  D. Create a custom object in Salesforce that will be used to capture the Reward Program data.
  A. Create a custom big object in Salesforce which will be used to capture the Reward Program data for consumption by Einstein.

  ---

  Explanation

  According to the official Salesforce guide1, big objects are designed to store and manage massive data volumes within Salesforce without affecting performance. They can be queried by using Async SOQL or standard SOQL, and they can be accessed by using Apex, Visualforce, Lightning components, or APIs. Big objects are ideal for storing data that is used for analytics or reporting purposes, such as the reward program data. Option A is the correct answer because it allows NTO to create a custom big object in Salesforce that can store the reward program data and make it available for consumption by Einstein Analytics and Discovery. Option B is incorrect because Einstein cannot connect directly to the point of sales system to capture the reward program data. Option C is incorrect because Einstein Analytics does not support creating big objects. Option D is incorrect because custom objects are not suitable for storing large volumes of data.

• Question 154:

  Which two statements are accurate with respect to performance testing a Force.

  com application?

  A. All Force.com applications must be performance tested in a sandbox as well as production.
  B. A performance test plan must be created and submitted to Salesforce customer support.
  C. Applications with highly customized code or large volumes should be performance tested.
  D. Application performance benchmarked in a sandbox can also be expected in production.
  B. A performance test plan must be created and submitted to Salesforce customer support.
  C. Applications with highly customized code or large volumes should be performance tested.

  ---

  Explanation

  A performance test plan is required for any Force.com application that has highly customized code or large volumes of data. You need to create and submit a performance test plan to Salesforce customer support before conducting any performance testing in your sandbox or production org2. Applications with highly customized code or large volumes of data should be performance tested to ensure they meet the expected response time and throughput

• Question 155:

  What is an advantage of using Custom metadata type over Custom setting?

  A. Custom metadata records are not copied from production to sandbox.
  B. Custom metadata types are available for reporting.
  C. Custom metadata records are deployable using packages.
  D. Custom metadata records are editable in Apex.
  C. Custom metadata records are deployable using packages.

  ---

  Explanation

  Custom metadata records are deployable using packages, which makes them easier to migrate from one environment to another. Custom settings records are not deployable using packages, and they are copied from production to sandbox.

  Custom metadata types are not available for reporting, and custom metadata records are not editable in Apex.

• Question 156:

  A customer is operating in a highly reputated industry and is planning to implement SF. The customer information maintained in SF, includes the following:

  Personally, identifiable information (PII)

  IP restrictions on profiles organized by Geographic location Financial records that need to be private and accessible only by the assigned Sales associate.

  User should not be allowed to export information from Salesforce. Enterprise security has mandate access to be restricted to users within a specific geography and detail monitoring of user activity.

  Which 3 Salesforce shield capabilities should a data architect recommend? Choose 3 answers:

  A. Event monitoring to monitor all user activities
  B. Restrict access to SF from users outside specific geography
  C. Prevent Sales users access to customer PII information
  D. Transaction security policies to prevent export of SF Data.
  E. Encrypt Sensitive Customer information maintained in SF.
  B. Restrict access to SF from users outside specific geography
  D. Transaction security policies to prevent export of SF Data.
  E. Encrypt Sensitive Customer information maintained in SF.

  ---

  Explanation

  The best Salesforce Shield capabilities for the customer are to restrict access to SF from users outside specific geography, implement transaction security policies to prevent export of SF data, and encrypt sensitive customer information maintained in SF. Salesforce Shield is a set of security features that help protect enterprise data on the Salesforce platform. It includes three components: Event Monitoring, Platform Encryption, and Field Audit Trail. Restricting access to SF from users outside specific geography can be done using network-based security features, such as IP whitelisting or VPN. Transaction security policies can be used to define actions or notifications based on user behavior patterns, such as exporting data or logging in from an unknown device. Platform Encryption can be used to encrypt data at rest using a tenant secret key that is controlled by the customer.

• Question 157:

  Universal Containers (UC) has an Application custom object, which has tens of millions of records created in the past 5 years. UC needs the last 5 years of data to exist in Salesforce at all times for reporting and queries. UC is currently encountering performance issues when reporting and running queries on this Object using date ranges as filters.

  Which two options can be used to improve report performance?

  A. Ask support to create a skinny table for Application with the necessary reporting fields.
  B. Add custom indexes to all fields on Application without a standard index.
  C. Run multiple reports to get different pieces of the data and combine them.
  D. Add custom indexes to the Date fields used for filtering the report.
  A. Ask support to create a skinny table for Application with the necessary reporting fields.
  D. Add custom indexes to the Date fields used for filtering the report.

  ---

  Explanation

  Ask support to create a skinny table for Application with the necessary reporting fields. This is an option that can improve report performance by creating a custom table that contains frequently used fields and copies their values from standard or custom objects. Skinny tables are kept in sync with their source tables and are used in place of them for reports and queries4. Add custom indexes to the Date fields used for filtering the report. This is another option that can improve report performance by creating custom indexes on fields that are often used as filters or join conditions in reports and queries. Custom indexes can speed up data retrieval and reduce query execution time

• Question 158:

  Universal Container require all customers to provide either a phone number of an email address when registering for an account.

  What should the data architect use to ensure this requirement is met?

  A. validation Rule
  B. required Fields
  C. Apex Class
  D. Process Builder
  A. validation Rule

  ---

  Explanation

  Using a validation rule is the best way to ensure that all customers provide either a phone number or an email address when registering for an account, as it allows defining a formula that evaluates whether a record meets certain criteria.

  Using required fields may not work if both phone number and email address are required. Using an Apex class or a Process Builder may be more complex or cumbersome than using a validation rule.

• Question 159:

  UC has to built a B2C ecommerce site on Heroku that shares customer and order data with a Heroku Postgres database. UC is currently utilizing Postgres as the single source of truth for both customers and orders. UC has asked a data architect to replicate the data into salesforce so that salesforce can now act as the system of record.

  What are the 3 considerations that data architect should weigh before implementing this requirement? Choose 3 answers

  A. Consider whether the data is required for sales reports, dashboards and KPI's.
  B. Determine if the data is driver of key process implemented within salesforce.
  C. Ensure there is a tight relationship between order data and an enterprise resource plaining (ERP) application.
  D. Ensure the data is CRM center and able to populate standard of custom objects.
  E. A selection of the tool required to replicate the data.
  F. Heroku Connect is required but this is confusing
  A. Consider whether the data is required for sales reports, dashboards and KPI's.
  B. Determine if the data is driver of key process implemented within salesforce.
  D. Ensure the data is CRM center and able to populate standard of custom objects.

  ---

  Explanation

  A is a valid consideration because if Salesforce is expected to act as the system of record, the organization must confirm that the replicated data will actually support reporting, dashboards, and KPIs inside Salesforce. If leadership plans to run sales performance reports, revenue analysis, customer segmentation, or order trend dashboards in Salesforce, then the data must live there in a reliable and structured way. Without a reporting need, replicating large volumes of data may add unnecessary complexity.

  B is also correct because becoming the system of record means the data will drive core business processes within Salesforce. If customer or order data is used in flows, validation rules, approval processes, service automation, or other operational logic, then the architect must ensure the data is complete, accurate, and synchronized at the right frequency. Process dependency is a primary factor when deciding whether Salesforce should own and govern that data.

  D is correct because the data must be CRM-centric and capable of being modeled properly within Salesforce. This includes evaluating how customer and order data map to standard objects such as Account, Contact, and Order, or whether custom objects are required. The structure, relationships, external IDs, and data quality rules must align with Salesforce's data model. If the data cannot be cleanly represented in Salesforce, making it the system of record would create long- term maintenance and usability issues.

  C is not required for this decision. A tight relationship with an ERP system may be relevant in a broader enterprise architecture discussion, but it is not a determining factor for whether Salesforce should replicate and own the data.

  E is not one of the primary architectural considerations. Tool selection, such as choosing Heroku Connect or another integration method, comes after defining the business need, data ownership model, and data design.

  Therefore, the explanation that supports B, C, and E does not align with the correct answers. The correct architectural considerations are A, B, and D.

• Question 160:

  A large telecommunication provider that provides internet services to both residence and business has the following attributes:

  A customer who purchases its services for their home will be created as an Account in Salesforce.

  Individuals within the same house address will be created as Contact in Salesforce.

  Businesses are created as Accounts in Salesforce.

  Some of the customers have both services at their home and business.

  What should a data architect recommend for a single view of these customers without creating multiple customer records?

  A. Customers are created as Contacts and related to Business and Residential Accounts using the Account Contact Relationships.
  B. Customers are created as Person Accounts and related to Business and Residential Accounts using the Account Contact relationship.
  C. Customer are created as individual objects and relate with Accounts for Business and Residence accounts.
  D. Costumers are created as Accounts for Residence Account and use Parent Account to relate Business Account.
  B. Customers are created as Person Accounts and related to Business and Residential Accounts using the Account Contact relationship.

  ---

  Explanation

  Creating customers as Contacts and relating them to Business and Residential Accounts using the Account Contact Relationships (option A) is the best option to recommend for a single view of these customers without creating multiple customer records, as it allows the data architect to model complex relationships between customers and accounts using native Salesforce features and tools. Creating customers as Person Accounts and relating them to Business and Residential Accounts using the Account Contact relationship (option B) is not a good option, as it may create data redundancy and inconsistency, and it does not leverage the existing Contact object. Creating customers as individual objects and relating them with Accounts for Business and Residence accounts (option C) is also not a good option, as it may require more customization and maintenance effort, and it does not leverage the existing Account and Contact objects.

  Creating customers as Accounts for Residence Account and using Parent Account to relate Business Account (option D) is also not a good option, as it may create confusion and complexity with the account hierarchy, and it does not leverage the existing Contact object.