Salesforce Salesforce Certifications DATA-ARCHITECT Questions & Answers

• Question 241:

  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.

  Correct Answer: BC

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

  NTO would like to retrieve their SF orgs meta data programmatically for backup within a various external. Which API is the best fit for accomplishing this task?

  A. Metadata API

  B. Tooling API

  C. Bulk API in serial mode

  D. SOAP API

  Correct Answer: A

  Explanation: The best API for retrieving Salesforce org metadata programmatically is the Metadata API. The Metadata API provides access to the metadata that defines the structure and configuration of an org, such as custom objects, fields, workflows, security settings, etc. It also supports deploying, retrieving, creating, updating, and deleting metadata components. The Metadata API can be used with various tools, such as Ant, Workbench, or IDEs.

• Question 243:

  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

  Correct Answer: A

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

  A data architect has been tasked with optimizing a data stewardship engagement for a Salesforce instance.

  Which three areas of Salesforce should the architect review before proposing any design recommendation? Choose 3 answers

  A. Review the metadata xml files for redundant fields to consolidate.

  B. Determine if any integration points create records in Salesforce.

  C. Run key reports to determine what fields should be required.

  D. Export the setup audit trail to review what fields are being used.

  E. Review the sharing model to determine impact on duplicate records.

  Correct Answer: BCE

  Explanation: Determining if any integration points create records in Salesforce, running key reports to determine what fields should be required, and reviewing the sharing model to determine impact on duplicate records are three areas of Salesforce that the architect should review before proposing any design recommendation. These areas will help to identify the sources and quality of data, the business rules and validations for data entry, and the access and visibility of data across users and roles. Reviewing the metadata xml files for redundant fields to consolidate, and exporting the setup audit trail to review what fields are being used are not necessary steps for optimizing a data stewardship engagement, as they are more related to metadata management and audit tracking.

• Question 245:

  Universal Containers (UC) has 50 million customers and stores customer order history on an ERP system. UC also uses Salesforce to manage opportunities and customer support.

  In order to provide seamless customer support, UC would like to see the customer's order history when viewing the customer record during a sales or support call.

  What should a data architect do in order to provide this functionality, while preserving the user experience?

  A. Use an Apex callout to populate a text area field for displaying the order history.

  B. Use Salesforce Connect and an external object to display the order history in Salesforce

  C. Import the order history into a custom Salesforce object, update nightly

  D. Embed the ERP system in an iframe and display on a custom tab.

  Correct Answer: B

  Explanation: According to Trailhead2, Salesforce Connect is a feature that allows administrators to integrate external data sources with Salesforce without copying or synchronizing the data. Salesforce Connect can use external objects to display the external data in Salesforce as if it were stored in Salesforce objects, enabling seamless user experience and real-time access. Option B is the correct answer because it suggests using Salesforce Connect and an external object to display the order history in Salesforce. Option A is incorrect because using an Apex callout to populate a text area field for displaying the order history can be inefficient and unreliable, as it requires making an HTTP request for each customer record and storing the order history as unstructured text. Option C is incorrect because importing the order history into a custom Salesforce object, update nightly can consume a lot of storage space and cause data latency, as the order history may change more frequently than once a night. Option D is incorrect because embedding the ERP system in an iframe and displaying on a custom tab can degrade the user experience and security, as it requires switching between tabs and authenticating with another system.

• Question 246:

  Universal Containers (UC) has several custom Visualforce applications have been developed in which users are able to edit Opportunity records. UC struggles with data completeness on their Opportunity records and has decided to make certain fields required that have not been in the past. The newly required fields are dependent on the Stage of the Opportunity, such that certain fields are only required once an Opportunity advances to later stages. There are two fields. What is the simplest approach to handle this new requirement?

  A. Update the Opportunity page layout to mark these fields as required.

  B. Use a validation rule for each field that takes the Stage into consideration.

  C. Update these Opportunity field definitions in Setup to be required.

  D. Write an Apex trigger that checks each field when records are saved.

  Correct Answer: B

  Explanation: Using a validation rule for each field that takes the Stage into consideration is the simplest approach to handle this new requirement. A validation rule can enforce the field requirements based on the logic and criteria that you define, and display an error message when users try to save a record that does not meet the requirements. Updating the Opportunity page layout to mark these fields as required will not work because page layouts do not support conditional field requirements. Updating these Opportunity field definitions in Setup to be required will not work because it will apply to all stages and records. Writing an Apex trigger that checks each field when records are saved is not the simplest approach because it requires coding and testing

• Question 247:

  Northern Trail Outfitters (NTO) plans to maintain contact preferences for customers and employees. NTO has implemented the following:

  1.

  Customers are Person Accounts for their retail business.

  2.

  Customers are represented as Contacts for their commercial business.

  3.

  Employees are maintained as Users.

  4.

  Prospects are maintained as Leads.

  NTO needs to implement a standard communication preference management model for Person Accounts, Contacts, Users, and Leads.

  Which option should the data architect recommend NTO to satisfy this requirement?

  A. Create custom fields for contact preferences in Lead, Person Account, and Users objects.

  B. Create case for contact preferences, and use this to validate the preferences for Lead, Person Accounts, and Users.

  C. Create a custom object to maintain preferences and build relationships to Lead, Person Account, and Users.

  D. Use Individual objects to maintain the preferences with relationships to Lead, Person Account, and Users.

  Correct Answer: D

  Explanation: The Individual object is a standard object that lets you store details about data privacy and protection preferences for person accounts, contacts, users, and leads. The Individual object can be used to implement a standard communication preference management model for NTO, with relationships to the other objects.

• Question 248:

  Universal Containers (UC) maintains a collection of several million Account records that represent business in the United Sates. As a logistics company, this list is one of the most valuable and important components of UC's business, and the accuracy of shipping addresses is paramount. Recently it has been noticed that too many of the addresses of these businesses are inaccurate, or the businesses don't exist. Which two scalable strategies should UC consider to improve the quality of their Account addresses?

  A. Contact each business on the list and ask them to review and update their address information.

  B. Build a team of employees that validate Accounts by searching the web and making phone calls.

  C. Integrate with a third-party database or services for address validation and enrichment.

  D. Leverage Data.com Clean to clean up Account address fields with the DandB database.

  Correct Answer: CD

  Explanation: Integrating with a third-party database or service for address validation and enrichment is a scalable strategy that can improve the quality of the Account addresses by comparing them with a reliable source of data1. Leveraging Data.com Clean to clean up Account address fields with the DandB database is another scalable strategy that can automatically update and enrich Account records with verified information from Data.com2.

• Question 249:

  A company has 12 million records, and a nightly integration queries these records.

  Which two areas should a Data Architect investigate during troubleshooting if queries are timing out? (Choose two.)

  A. Make sure the query doesn't contain NULL in any filter criteria.

  B. Create a formula field instead of having multiple filter criteria.

  C. Create custom indexes on the fields used in the filter criteria.

  D. Modify the integration users' profile to have View All Data.

  Correct Answer: AC

  Explanation: Making sure the query does not contain NULL in any filter criteria can avoid full table scans and leverage indexes more efficiently. Queries with NULL filters are not selective and can cause performance issues. Creating custom indexes on the fields used in the filter criteria can also enhance the query performance by reducing the number of records to scan.

• Question 250:

  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.

  Correct Answer: C

  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.