Salesforce DATA-ARCHITECT Online Practice Questions and Exam Preparation

Salesforce DATA-ARCHITECT Online Questions & Answers

• Question 41:

  NTO need to extract 50 million records from a custom object everyday from its Salesforce org. NTO is facing query timeout issues while extracting these records.

  What should a data architect recommend in order to get around the time out issue?

  A. Use a custom auto number and formula field and use that to chunk records while extracting data.
  B. The REST API to extract data as it automatically chunks records by 200.
  C. Use ETL tool for extraction of records.
  D. Ask SF support to increase the query timeout value.
  C. Use ETL tool for extraction of records.

  ---

  Explanation

  The best solution to extract 50 million records from a custom object everyday from Salesforce org without facing query timeout issues is to use an ETL tool for extraction of records. ETL stands for extract, transform, and load, and it refers to a process of moving data from one system to another. An ETL tool is a software application that can connect to various data sources, perform data transformations, and load data into a target destination. ETL tools can handle large volumes of data efficiently and reliably, and they often provide features such as scheduling, monitoring, error handling, and logging5. Using a custom auto number and formula field and use that to chunk records while extracting data is a possible workaround, but it requires creating additional fields and writing complex queries. The REST API can extract data as it automatically chunks records by 200, but it has some limitations, such as a maximum of 50 million records per query job6.

  Asking SF support to increase the query timeout value is not feasible because query timeout values are not configurable

• Question 42:

  Universal Containers wishes to maintain Lead data from Leads even after they are deleted and cleared from the Recycle Bin.

  What approach should be implemented to achieve this solution?

  A. Use a Lead standard report and filter on the IsDeleted standard field.
  B. Use a Converted Lead report to display data on Leads that have been deleted.
  C. Query Salesforce with the queryAll API method or using the ALL ROWS SOQL keywords.
  D. Send data to a Data Warehouse and mark Leads as deleted in that system.
  C. Query Salesforce with the queryAll API method or using the ALL ROWS SOQL keywords.

  ---

  Explanation

  According to the exam guide, one of the objectives is to "describe how to use queryAll() or ALL ROWS keywords to access deleted records in Apex and SOQL"1. This implies that option C is the correct way to access deleted records in Salesforce. Option D is not correct because sending data to a data warehouse does not maintain the data in Salesforce. Options A and B are not correct because they do not apply to deleted records2.

• Question 43:

  UC is migrating individual customers (B2C) data from legacy systems to SF. There are millions of customers stored as accounts and contacts in legacy database.

  Which object model should a data architect configure within SF?

  A. Leverage person account object in Salesforce
  B. Leverage custom person account object in SF
  C. Leverage custom account and contact object in SF
  D. Leverage standard account and contact object in SF
  A. Leverage person account object in Salesforce

  ---

  Explanation

  The best object model to configure within SF for migrating individual customers (B2C) data from legacy systems is to leverage person account object in Salesforce. Person accounts are a special type of accounts that store information about individual people by combining certain account and contact fields into a single record4. Person accounts are useful for B2C scenarios where there is no need to associate a company name with a contact. Person accounts also support standard Salesforce features and functionality, such as leads, campaigns, reports, dashboards, etc5. Leverage custom person account object in SF is not a good option because there is no such thing as a custom person account object.

  Leverage custom account and contact object in SF is not a good option because it would require creating and maintaining additional objects and fields that may not be necessary or compatible with standard Salesforce features. Leverage standard account and contact object in SF is not a good option because it would require filling in dummy values for the account name field, which is mandatory for standard accounts.

• Question 44:

  Northern Trail Outfitters (NTO) wants to implement backup and restore for Salesforce data, Currently, it has data backup processes that runs weekly, which back up all Salesforce data to an enterprise data warehouse (EDW). NTO wants to move to daily backups and provide restore capability to avoid any data loss in case of outage.

  What should a data architect recommend for a daily backup and restore solution?

  A. Use AppExchange package for backup and restore.
  B. Use ETL for backup and restore from EDW.
  C. Use Bulk API to extract data on daily basis to EDW and REST API for restore.
  D. Change weekly backup process to daily backup, and implement a custom restore solution.
  A. Use AppExchange package for backup and restore.

  ---

  Explanation

  The data architect should recommend using AppExchange package for backup and restore. AppExchange is a marketplace for Salesforce apps and solutions that can be installed and configured in Salesforce orgs. There are several

  AppExchange packages that provide backup and restore functionality for Salesforce data, such as OwnBackup, Odaseva, or Spanning. These packages can perform daily backups of Salesforce data to a secure cloud storage, and provide restore capability to avoid any data loss in case of outage. Option B is incorrect because using ETL (Extract, Transform, Load) for backup and restore from EDW (Enterprise Data Warehouse) will require additional development effort and may not be reliable or secure. Option C is incorrect because using Bulk API to extract data on daily basis to EDW and REST API for restore will require additional integration effort and may not be scalable or performant. Option D is incorrect because changing weekly backup process to daily backup, and implementing a custom restore solution will require additional configuration effort and may not be robust or compliant.

• Question 45:

  An architect is planning on having different batches to load one million Opportunities into Salesforce using the Bulk API in parallel mode.

  What should be considered when loading the Opportunity records?

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

  ---

  Explanation

  Ordering batches by Auto-number field will ensure that the records are processed in a sequential order and avoid any locking issues that might occur when loading related records in parallel mode. Creating indexes, grouping batches by AccountId, or sorting batches by Name field values are not necessary or beneficial for loading Opportunity records using the Bulk API.

• Question 46:

  Universal Containers (UC) has multi -level account hierarchies that represent departments within their major Accounts. Users are creating duplicate Contacts across multiple departments. UC wants to clean the data so as to have a single Contact across departments. What two solutions should UC implement to cleanse their data? Choose 2 answers

  A. Make use of a third -party tool to help merge duplicate Contacts across Accounts.
  B. Use Data.com to standardize Contact address information to help identify duplicates.
  C. Use Workflow rules to standardize Contact information to identify and prevent duplicates.
  D. Make use of the Merge Contacts feature of Salesforce to merge duplicates for an Account.
  A. Make use of a third -party tool to help merge duplicate Contacts across Accounts.
  B. Use Data.com to standardize Contact address information to help identify duplicates.

  ---

  Explanation

  Making use of a third-party tool to help merge duplicate Contacts across Accounts and using Data.com to standardize Contact address information to help identify duplicates are two solutions that UC should implement to cleanse their data and have a single Contact across departments. A third-party tool, such as an app from the AppExchange, can provide advanced features and capabilities for finding and merging duplicate Contacts across different Accounts, based on various criteria and rules. Data.com can provide address verification and standardization services that can enhance the quality and consistency of Contact address information and make it easier to identify duplicates. The other options are not feasible or effective for cleansing the data, as they would either not work across different Accounts, not address the root cause of duplication, or not provide sufficient functionality for merging duplicates

• Question 47:

  NTO has been using salesforce for sales and service for 10 years. For the past 2 years, the marketing group has noticed a raise from 0 to 35 % in returned mail when sending mail using the contact information stored in salesforce.

  Which solution should the data architect use to reduce the amount of returned mails?

  A. Use a 3rd-party data source to update contact information in salesforce.
  B. Email all customer and asked them to verify their information and to call NTO if their address is incorrect.
  C. Delete contacts when the mail is returned to save postal cost to NTO.
  D. Have the sales team to call all existing customers and ask to verify the contact details.
  A. Use a 3rd-party data source to update contact information in salesforce.

  ---

  Explanation

  Using a third-party data source to update contact information in Salesforce is the best solution to reduce the amount of returned mails. This way, the data architect can ensure that the contact information is accurate and up-to-date without relying on manual verification or deletion of contacts

• Question 48:

  Universal Containers (UC) has implemented Sales Cloud and it has been noticed that Sales reps are not entering enough data to run insightful reports and dashboards. UC executives would like to monitor and measure data quality metrics.

  What solution addresses this requirement?

  A. Use third-party AppExchange tools to monitor and measure data quality.
  B. Generate reports to view the quality of sample data.
  C. Use custom objects and fields to calculate data quality.
  D. Export the data to an enterprise data warehouse and use BI tools for data quality.
  A. Use third-party AppExchange tools to monitor and measure data quality.

  ---

  Explanation

  Using third-party AppExchange tools to monitor and measure data quality can address the requirement of UC executives by providing features such as data cleansing, deduplication, validation, enrichment, and scoring. These tools can help improve the accuracy, completeness, and consistency of the data entered by sales reps .

• Question 49:

  A consumer products company has decided to use Salesforce for its contact center. The contact center agents need access to the following information in Service Console when a customer contacts them:

  1. Customer browsing activity on its website stored on its on premise system

  2. Customer interactions with sales associates at its retail stores maintained in Salesforce

  3. Contact center interactions maintained in Salesforce

  4. Email campaign activity to customer from its marketing systems.

  What should a data architect do to fulfill these requirements with minimum development effort in Salesforce?

  A. Create web tabs in Service Console to show website and marketing activities.
  B. Build custom components in Service Console to bring information from the marketing and website information.
  C. Use Salesforce Connect to integrate the website and the marketing system into Service Console using external objects.
  D. Build customer view in Service Console with components that show website data and marketing data as mashup.
  D. Build customer view in Service Console with components that show website data and marketing data as mashup.

  ---

  Explanation

  Building a customer view in Service Console with components that show website data and marketing data as mashup is the best option to fulfill the requirement with minimum development effort in Salesforce. A mashup is a technique that combines data from different sources into a single user interface. You can use Visualforce pages or Lightning components to create mashups that display data from external systems such as your website and marketing system. This way, you can provide your contact center agents with a comprehensive view of the customer information they need.

• Question 50:

  UC is preparing to implement sales cloud and would like to its users to have read only access to an account record if they have access to its child opportunity record.

  How would a data architect implement this sharing requirement between objects?

  A. Create a criteria-based sharing rule.
  B. Implicit sharing will automatically handle with standard functionality.
  C. Add appropriate users to the account team.
  D. Create an owner-based sharing rule.
  B. Implicit sharing will automatically handle with standard functionality.

  ---

  Explanation

  Implicit sharing will automatically handle this sharing requirement with standard functionality, as it grants read-only access to parent accounts when users have access to child opportunities. This is also known as account-opportunity sharing3.

  Creating a criteria-based sharing rule (option A) or an owner-based sharing rule (option D) is not necessary, as they are used to grant additional access based on record criteria or ownership. Adding appropriate users to the account team (option C) is also not required, as it is used to grant access to specific users or groups for individual accounts.