Salesforce DATA-ARCHITECT Online Practice Questions and Exam Preparation

Salesforce DATA-ARCHITECT Online Questions & Answers

• Question 191:

  A shipping and logistics company has created a large number of reports within Sales Cloud since Salesforce was introduced. Some of these reports analyze large amounts of data regarding the whereabouts of the company's containers, and they are starting to time out when users are trying to run the reports.

  What is a recommended approach to avoid these time-out issues?

  A. Improve reporting performance by creating a custom Visualforce report that is using a cache of the records in the report.
  B. Improve reporting performance by replacing the existing reports in Sales Cloud with new reports based on Analytics Cloud.
  C. Improve reporting performance by creating an Apex trigger for the Report object that will pre-fetch data before the report is run.
  D. Improve reporting performance by creating a dashboard that is scheduled to run the reports only once per day.
  B. Improve reporting performance by replacing the existing reports in Sales Cloud with new reports based on Analytics Cloud.

  ---

  Explanation

  Improving reporting performance by replacing the existing reports in Sales Cloud with new reports based on Analytics Cloud can avoid the time-out issues by leveraging the power and scalability of Analytics Cloud. Analytics Cloud can handle large volumes of data and provide faster and more interactive reports than Sales Cloud .

• Question 192:

  Northern Trail Outfitter has implemented Salesforce for its associates nationwide, Senior management is concerned that the executive dashboard is not reliable for their real-time decision-making. On analysis, the team the following issues with data entered in Salesforce.

  Information in certain records is incomplete.

  Incorrect entry in certain fields causes records to be excluded in report fitters.

  Duplicate entries cause incorrect counts.

  Which three steps should a data architect recommend to address the issues?

  A. Periodically export data to cleanse data and import them back into Salesforce for executive reports.
  B. Build a sales data warehouse with purpose-build data marts for dashboards and senior management reporting.
  C. Explore third-party data providers to enrich and augment information entered in salesforce.
  D. Leverage Salesforce features, such as validate rules, to avoid incomplete and incorrect records.
  E. design and implement data-quality dashboard to monitor and act on records that are incomplete or incorrect
  B. Build a sales data warehouse with purpose-build data marts for dashboards and senior management reporting.
  C. Explore third-party data providers to enrich and augment information entered in salesforce.
  D. Leverage Salesforce features, such as validate rules, to avoid incomplete and incorrect records.

  ---

  Explanation

  According to the Salesforce documentation3, data quality is the measure of how well the data in Salesforce meets the expectations and requirements of the users and stakeholders. Data quality can be affected by various factors, such as data entry errors, data duplication, data inconsistency, data incompleteness, data timeliness, etc. To address the issues with data quality that affect the reliability of executive dashboards, a data architect should recommend: Building a sales data warehouse with purpose-built data marts for dashboards and senior management reporting (option B). This means creating a separate database or system that stores and organizes sales data from Salesforce and other sources for analytical purposes. A data warehouse can provide a single source of truth for sales data and enable faster and more accurate reporting and analysis. A data mart is a subset of a data warehouse that focuses on a specific subject or business area, such as sales performance, customer segmentation, product profitability, etc. A data mart can provide tailored and relevant data for different users or groups based on their needs and interests. Exploring third-party data providers to enrich and augment information entered in Salesforce (option C). This means using external services or tools that can validate, correct, update, and enhance the data that is entered or imported into Salesforce. This can help improve data quality and accuracy, and reduce data duplication and incompleteness.

  Leveraging Salesforce features, such as validation rules, to avoid incomplete and incorrect records (option D). This means using features that allow defining rules and criteria to validate the data that is entered or updated by the users or integrations. This can help prevent invalid or incorrect data from being saved, and trigger actions or alerts to correct or improve the data. Periodically exporting data to cleanse data and import them back into Salesforce for executive reports (option A) is not a good solution, as it can be time-consuming, error- prone, and inefficient. It may also cause data inconsistency and synchronization issues between Salesforce and other systems. Designing and implementing data-quality dashboard to monitor and act on records that are incomplete or incorrect (option E) is also not a good solution, as it can be complex, costly, and difficult to maintain. It may also not address the root causes of data quality issues or prevent them from occurring in the first place.

• Question 193:

  US has released a new disaster recovery (DR)policy that states that cloud solutions need a business continuity plan in place separate from the cloud providers built in data recovery solution.

  Which solution should a data architect use to comply with the DR policy?

  A. Leverage a 3rd party tool that extract salesforce data/metadata and stores the information in an external protected system.
  B. Leverage salesforce weekly exports, and store data in Flat files on a protected system.
  C. Utilize an ETL tool to migrate data to an on-premise archive solution.
  D. Write a custom batch job to extract data changes nightly, and store in an external protected system.
  A. Leverage a 3rd party tool that extract salesforce data/metadata and stores the information in an external protected system.

  ---

  Explanation

  The best solution to comply with the DR policy is to leverage a 3rd party tool that extract Salesforce data/metadata and stores the information in an external protected system. This solution can help create a backup of Salesforce data and metadata in case of a disaster or data loss event. It can also help restore data from the backup system to Salesforce if needed. There are various 3rd party tools available in the AppExchange or online that offer data backup and recovery services for Salesforce67. Leverage Salesforce weekly exports and store data in flat files on a protected system is not a good solution because it does not include metadata backup and it does not allow granular or automated data recovery.

  Utilize an ETL tool to migrate data to an on-premise archive solution is not a good solution because it does not include metadata backup and it may require complex data transformations and synchronizations. Write a custom batch job to extract data changes nightly and store in an external protected system is not a good solution because it does not include metadata backup and it may have performance or reliability issues.

• Question 194:

  Universal Containers (UC) is implementing its new Internet of Things technology, which consists of smart containers that provide information on container temperature and humidity updated every 10 minutes back to UC. There are roughly 10,000 containers equipped with this technology with the number expected to increase to 50,000 across the next five years. It is essential that Salesforce user have access to current and historical temperature and humidity data for each container.

  What is the recommended solution?

  A. Create new custom fields for temperature and humidity in the existing Container custom object, as well as an external ID field that is unique for each container. These custom fields are updated when a new measure is received.
  B. Create a new Container Reading custom object, which is created when a new measure is received for a specific container. The Container Reading custom object has a master- detail relationship to the container object.
  C. Create a new Lightning Component that displays last humidity and temperature data for a specific container and can also display historical trends obtaining relevant data from UC's existing data warehouse.
  D. Create a new Container Reading custom object with a master-detail relationship to Container which is created when a new measure is received for a specific container. Implement an archiving process that runs every hour.
  D. Create a new Container Reading custom object with a master-detail relationship to Container which is created when a new measure is received for a specific container. Implement an archiving process that runs every hour.

  ---

  Explanation

  The recommended solution for Universal Containers (UC) to implement its new Internet of Things technology is to create a new Container Reading custom object with a master-detail relationship to Container which is created when a new measure is received for a specific container. Implement an archiving process that runs every hour. This solution would allow UC to store and access current and historical temperature and humidity data for each container on Salesforce, and use reports and dashboards to analyze it. However, since UC expects a large volume of data over time, they should implement an archiving process that moves data off-platform after a certain period of time to avoid hitting the Org data storage limit and maintain optimal performance. The other options are not recommended, as they would either not store the historical data on Salesforce, or create too many custom fields on the Container object that could impact performance and usability.

• Question 195:

  Universal Containers (UC) has over 10 million accounts with an average of 20 opportunities with each account. A Sales Executive at UC needs to generate a daily report for all opportunities in a specific opportunity stage.

  Which two key considerations should be made to make sure the performance of the report is not degraded due to large data volume?

  A. Number of queries running at a time.
  B. Number of joins used in report query.
  C. Number of records returned by report query.
  D. Number of characters in report query.
  B. Number of joins used in report query.
  C. Number of records returned by report query.

  ---

  Explanation

  The number of joins used in report query and the number of records returned by report query are two key considerations to make sure the performance of the report is not degraded due to large data volume. The number of joins used in report query affects the complexity and execution time of the query, especially when joining multiple large objects4. The number of records returned by report query affects the amount of data that needs to be processed and displayed by the report engine.

• Question 196:

  Universal Containers (UC) owns a complex Salesforce org with many Apex classes, triggers, and automated processes that will modify records if available. UC has identified that, in its current development state, UC runs change of encountering race condition on the same record.

  What should a data architect recommend to guarantee that records are not being updated at the same time?

  A. Embed the keywords FOR UPDATE after SOQL statements.
  B. Disable classes or triggers that have the potential to obtain the same record.
  C. Migrate programmatic logic to processes and flows.
  D. Refactor or optimize classes and trigger for maximum CPU performance.
  A. Embed the keywords FOR UPDATE after SOQL statements.

  ---

  Explanation

  According to the How to avoid row lock or race condition in Apex blog post, one of the ways to prevent race condition in Apex is to use the FOR UPDATE keyword in SOQL statements. The blog post states that "We need to lock the records on which we are working such that other batches or threads will not be having any effect on them. How can we lock a record, then? We need to make use of FOR UPDATE keyword in the SOQL query." Therefore, a data architect should recommend this solution to guarantee that records are not being updated at the same time by different processes.

• Question 197:

  Universal Containers is establishing a call center that will use Salesforce. UC receives 10 million calls and creates 100 million cases every month. Cases are linked to a custom call object using lookup relationship. UC would like to run reports and dashboard to better understand different case types being created on calls to better serve customers.

  What solution should a data architect recommend to meet the business requirement?

  A. Archive records to a data warehouse and run analytics on the data warehouse.
  B. Leverage big objects to archive records and Einstein Analytics to run reports.
  C. Leverage custom objects to store aggregate data and run analytics.
  D. Leverage out-of-the-box reports and dashboard on case and interactive voice response (IVR) custom object.
  B. Leverage big objects to archive records and Einstein Analytics to run reports.

  ---

  Explanation

  According to this article, big objects can store and manage massive amounts of data on the Salesforce platform. This can help UC to archive records from other objects or bring massive datasets from outside systems into a big object.

  According to this article, Einstein Analytics can be used to create dashboards and lenses to analyze big object data and get insights from advanced AI-driven analytics.

• Question 198:

  Universal Containers has a large number of Opportunity fields (100) that they want to track field history on. Which two actions should an architect perform in order to meet this requirement? Choose 2 answers

  A. Create a custom object to store a copy of the record when changed.
  B. Create a custom object to store the previous and new field values.
  C. Use Analytic Snapshots to store a copy of the record when changed.
  D. Select the 100 fields in the Opportunity Set History Tracking page.
  A. Create a custom object to store a copy of the record when changed.
  B. Create a custom object to store the previous and new field values.

  ---

  Explanation

  Creating a custom object to store a copy of the record when changed and creating a custom object to store the previous and new field values are two possible actions that an architect can perform to meet the requirement of tracking field history on 100 Opportunity fields. A custom object can store more fields and records than the standard field history tracking feature, which has a limit of 20 fields per object and 18 or 24 months of data retention. A custom object can also be used for reporting and analysis of field history data. The other options are not feasible or effective for meeting the requirement

• Question 199:

  Universal Containers (UC) has adopted Salesforce as its primary sales automated tool. UC has 100,00 customers with a growth rate of 10% a year, UC uses an on-premise web- based billing and invoice system that generates over 1 million invoices a year supporting a monthly billing cycle.

  The UC sales team needs to be able to pull a customer record and view their account status, Invoice history, and opportunities without navigating outside of Salesforce.

  What should a data architect use to provide the sales team with the required functionality?

  A. Create a custom object and migrate the last 12 months of Invoice data into Salesforce so it can be displayed on the Account layout.
  B. Write an Apex callout and populate a related list to display on the account record.
  C. Create a mashup page that will present the billing system records within Salesforce.
  D. Create a visual force tab with the billing system encapsulated within an iframe.
  C. Create a mashup page that will present the billing system records within Salesforce.

  ---

  Explanation

  To provide the sales team with the required functionality, a data architect should use a mashup page that will present the billing system records within Salesforce. A mashup page is a web page that combines data from multiple sources into a single integrated view. A mashup page can be created using Visualforce or Lightning Web Components, and can use Salesforce Connect or custom integrations to access external data from the on-premise web-based billing and invoice system. This will allow the sales team to pull a customer record and view their account status, invoice history, and opportunities without navigating outside of Salesforce. Option A is incorrect because creating a custom object and migrating the last 12 months of invoice data into Salesforce so it can be displayed on the account layout will consume a lot of storage space and may not reflect the latest data from the billing system. Option B is incorrect because writing an Apex callout and populating a related list to display on the account record will require additional development effort and may not be scalable or performant for large volumes of data. Option D is incorrect because creating a visual force tab with the billing system encapsulated within an iframe will not allow the sales team to view the billing system records within the customer record, but rather in a separate tab.

• Question 200:

  Get Cloudy Consulting uses an invoicing system that has specific requirements. One requirement is that attachments associated with the Invoice_c custom object be classified by Types (i.e., ""Purchase Order"", ""Receipt"", etc.) so that reporting can be performed on invoices showing the number of attachments grouped by Type.

  What should an Architect do to categorize the attachments to fulfill these requirements?

  A. Add additional options to the standard ContentType picklist field for the Attachment object.
  B. Add a ContentType picklist field to the Attachment layout and create additional picklist options.
  C. Create a custom picklist field for the Type on the standard Attachment object with the values.
  D. Create a custom object related to the Invoice object with a picklist field for the Type.
  D. Create a custom object related to the Invoice object with a picklist field for the Type.

  ---

  Explanation

  Creating a custom object related to the Invoice object with a picklist field for the Type allows the architect to categorize the attachments and report on them by Type. The standard Attachment object does not have a ContentType picklist field, and adding a custom picklist field to it would not be best practice.