Salesforce Salesforce Certifications DATA-ARCHITECT Questions & Answers

• Question 71:

  Universal Containers (UC) is going thought major reorganization of their sales team. This would require changes to a large a number of group members and sharing rules. UCs administrator is concerned about long processing time and failure during the process.

  What should a Data architect implement to make changes efficiently?

  A. Log a case with salesforce to make sharing rule changes.

  B. Enable Defer Sharing Calculation prior to making sharing rule changes.

  C. Delete old sharing rules and build new sharing rules

  D. Log out all users and make changes to sharing rules.

  Correct Answer: B

  Explanation: The correct answer is B. To make changes efficiently, a data architect should enable Defer Sharing Calculation prior to making sharing rule changes. This will allow the administrator to make multiple changes to sharing rules without recalculating them after each change, which can take a long time and cause failures. The sharing rules can be recalculated later when there are fewer users online or during off-peak hours. Option A is incorrect because logging a case with salesforce to make sharing rule changes will not speed up the process or prevent failures. Option C is incorrect because deleting old sharing rules and building new sharing rules will not reduce the processing time or failure rate. Option D is incorrect because logging out all users and making changes to sharing rules will disrupt the business operations and may not be feasible.

• Question 72:

  Universal Containers wants to automatically archive all inactive Account data that is older than 3 years. The information does not need to remain accessible within the application. Which two methods should be recommended to meet this requirement? Choose 2 answers

  A. Use the Force.com Workbench to export the data.

  B. Schedule a weekly export file from the Salesforce UI.

  C. Schedule jobs to export and delete using an ETL tool.

  D. Schedule jobs to export and delete using the Data Loader.

  Correct Answer: CD

  Explanation: Both C and D are valid methods to automatically archive and delete inactive Account data that is older than 3 years1. You can use an ETL tool or the Data Loader to schedule jobs to export and delete data based on certain criteria3. Option A is not recommended because the Force.com Workbench is a web-based tool that does not support scheduling or automation. Option B is not suitable because the weekly export file from the Salesforce UI does not delete data from Salesforce.

• Question 73:

  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.

  Correct Answer: AD

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

  Universal Containers (UC) wants to capture information on how data entities are stored within the different applications and systems used within the company. For that purpose, the architecture team decided to create a data dictionary covering the main business domains within UC. Which two common techniques are used building a data dictionary to store information on how business entities are defined?

  A. Use Salesforce Object Query Language.

  B. Use a data definition language.

  C. Use an entity relationship diagram.

  D. Use the Salesforce Metadata API.

  Correct Answer: CD

  Explanation: A data dictionary is a document that describes the structure, format, and meaning of data entities and attributes. A common technique to build a data dictionary is to use an entity relationship diagram (ERD), which shows the logical relationships between objects and fields in a graphical way. Another technique is to use the Salesforce Metadata API, which allows you to retrieve and deploy the metadata that defines your Salesforce org

• Question 75:

  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.

  Correct Answer: D

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

  UC has been using SF for 10 years. Lately, users have noticed, that the pages load slowly when viewing Customer and Account list view.

  To mitigate, UC will implement a data archive strategy to reduce the amount of data actively loaded.

  Which 2 tasks are required to define the strategy? Choose 2 answers:

  A. Identify the recovery point objective.

  B. Identify how the archive data will be accessed and used.

  C. Identify the recovery time objective.

  D. Identify the data retention requirements

  Correct Answer: BD

  Explanation: The two tasks required to define the data archive strategy are to identify how the archive data will be accessed and used, and identify the data retention requirements. Data archiving is the process of moving infrequently used or historical data from active storage to a separate storage location for long-term retention. Data archiving can improve performance, reduce storage costs, and comply with legal or regulatory obligations. To define a data archive strategy, a data architect needs to consider how the archived data will be accessed and used by different users or processes in Salesforce or outside Salesforce, and how long the archived data needs to be retained based on business or legal requirements.

• Question 77:

  Universal Container (US) is replacing a home-grown CRM solution with Salesforce, UC has decided to migrate operational (Open and active) records to Salesforce, while keeping historical records in legacy system, UC would like historical records to be available in Salesforce on an as needed basis.

  Which solution should a data architect recommend to meet business requirement?

  A. Leverage real-time integration to pull records into Salesforce.

  B. Bring all data Salesforce, and delete it after a year.

  C. Leverage mashup to display historical records in Salesforce.

  D. Build a chair solution to go the legacy system and display records.

  Correct Answer: C

  Explanation: According to the Using Mashups article on Salesforce Developers, one of the techniques for deploying large data volumes is to use mashups to display historical records in Salesforce. The article states that "Mashups are a way to display data from an external system within a Salesforce page without copying or synchronizing the data. Mashups use a combination of Visualforce, Apex callouts, and JavaScript code that runs in the browser. Mashups are useful when you want to display large amounts of read-only data that is stored outside of Salesforce." Therefore, a data architect should recommend this solution to meet the business requirement of UC.

• Question 78:

  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.

  Correct Answer: AB

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

  For a production cutover, a large number of Account records will be loaded into Salesforce from a legacy system. The legacy system does not have enough information to determine the Ownership for these Accounts upon initial load. Which two recommended options assign Account ownership to mitigate potential performance problems?

  A. Let a "system user" own all the Account records without assigning any role to this user in Role Hierarchy.

  B. Let a "system user" own the Account records and assign this user to the lowest-level role in the Role Hierarchy.

  C. Let the VP of the Sales department, who will report directly to the senior VP, own all the Account records.

  D. Let a "system user" own all the Account records and make this user part of the highest- level role in the Role Hierarchy.

  Correct Answer: AB

  Explanation: The two recommended options to assign Account ownership to mitigate potential performance problems are to let a "system user" own all the Account records without assigning any role to this user in Role Hierarchy, or to let a "system user" own the Account records and assign this user to the lowest-level role in the Role Hierarchy. This is because these options would reduce the number of sharing calculations and rules that need to be applied to the Account records, and improve the performance and scalability of the system34. The other options are not recommended, as they would increase the sharing complexity and overhead, and potentially expose sensitive data to unauthorized users.

• Question 80:

  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.

  Correct Answer: B

  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.