Salesforce Salesforce Certifications DATA-ARCHITECT Questions & Answers

• Question 21:

  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.

  Correct Answer: B

  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.

• Question 22:

  Universal Containers (UC) has a complex system landscape and is implementing a data governance program for the first time Which two first steps would be appropriate for UC to initiate an assessment of data architecture? Choose 2 answers

  A. Engage with IT program managers to assess current velocity of projects in the pipeline.

  B. Engage with database administrators to assess current database performance metrics.

  C. Engage with executive sponsorship to assess enterprise data strategy and goals.

  D. Engage with business units and IT to assess current operational systems and data models.

  Correct Answer: CD

  Explanation: Engaging with executive sponsorship to assess enterprise data strategy and goals, and engaging with business units and IT to assess current operational systems and data models are two first steps that would be appropriate for UC to initiate an assessment of data architecture. These steps will help to understand the current state of data management, the business needs and expectations, and the gaps and opportunities for improvement. Engaging with IT program managers to assess current velocity of projects in the pipeline, and engaging with database administrators to assess current database performance metrics are not relevant steps for assessing data architecture, as they are more related to project management and technical performance.

• Question 23:

  Due to security requirements, Universal Containers needs to capture specific user actions, such as login, logout, file attachment download, package install, etc. What is the recommended approach for defining a solution for this requirement?

  A. Use a field audit trail to capture field changes.

  B. Use a custom object and trigger to capture changes.

  C. Use Event Monitoring to capture these changes.

  D. Use a third-party AppExchange app to capture changes.

  Correct Answer: C

  Explanation: Event Monitoring is a feature that allows you to track user actions, such as logins, logouts, downloads, etc., in your Salesforce org. You can use Event Monitoring to monitor performance, usage, security, and compliance

• Question 24:

  UC is planning a massive SF implementation with large volumes of data. As part of the org's implementation, several roles, territories, groups, and sharing rules have been configured. The data architect has been tasked with loading all of the required data, including user data, in a timely manner.

  What should a data architect do to minimize data load times due to system calculations?

  A. Enable defer sharing calculations, and suspend sharing rule calculations

  B. Load the data through data loader, and turn on parallel processing.

  C. Leverage the Bulk API and concurrent processing with multiple batches

  D. Enable granular locking to avoid "UNABLE _TO_LOCK_ROW" error.

  Correct Answer: A

  Explanation: The correct answer is A, enable defer sharing calculations, and suspend sharing rule calculations. Defer sharing calculations and suspend sharing rule calculations are features that allow you to temporarily disable the automatic recalculation of sharing rules when you load large volumes of data. This can improve the performance and speed of your data load process by avoiding unnecessary system calculations. Loading the data through data loader, leveraging the bulk API, or enabling granular locking are also options that can help with data load times, but they do not directly address the system calculations issue.

• Question 25:

  Universal Containers has deployed Salesforce for case management The company is having difficulty understanding what percentage of cases are resolved from the initial call to their support organization. What first step is recommended to implement a reporting solution to measure the support reps case closure rates?

  A. Enable field history tracking on the Case object.

  B. Create a report on Case analytic snapshots.

  C. Install AppExchange packages for available reports.

  D. Create Contact and Opportunity Reports and Dashboards.

  Correct Answer: A

  Explanation: Enabling field history tracking on the Case object is the first step to implement a reporting solution to measure the support reps case closure rates. Field history tracking allows you to track changes to certain fields on the Case object, such as Status, Owner, or Priority. You can then create reports based on the field history data to analyze how long it took to close a case, how many times the case owner changed, or how many cases were escalated.

• Question 26:

  Cloud Kicks stores Invoice records in a custom object. Invoice records are being sent to the Accounting department with missing States and incorrectly formatted Postal Codes.

  Which two actions should Cloud Kicks take to improve data quality? (Choose two.)

  A. Change each address field to require on the Page Layout.

  B. Write an Apex Trigger to require all fields to be populated.

  C. Utilize a Validation Rule with a REGEX operator on Postal Code.

  D. Utilize a Validation Rule with a CONTAINS operator on address fields.

  Correct Answer: CD

  Explanation: Utilizing a Validation Rule with a REGEX operator on Postal Code and utilizing a Validation Rule with a CONTAINS operator on address fields are two actions that Cloud Kicks should take to improve data quality for their Invoice records. A Validation Rule with a REGEX operator can check if the Postal Code field matches a specific pattern or format, such as a five-digit number or a combination of letters and numbers. A Validation Rule with a CONTAINS operator can check if the address fields contain certain values, such as valid state abbreviations or country names. These Validation Rules can prevent users from saving invalid or incomplete data and display error messages to guide them to correct the data. The other options are not effective or recommended for improving data quality, as they would either require additional customization, not enforce data standards, or not address the specific issues of missing states and incorrectly formatted postal codes

• Question 27:

  As part of addressing general data protection regulation (GDPR) requirements, UC plans to implement a data classification policy for all its internal systems that stores customer information including salesforce.

  What should a data architect recommend so that UC can easily classify consumer information maintained in salesforce under both standard and custom objects?

  A. Use App Exchange products to classify fields based on policy.

  B. Use data classification metadata fields available in field definition.

  C. Create a custom picklist field to capture classification of information on customer.

  D. Build reports for customer information and validate.

  Correct Answer: B

  Explanation: The correct answer is B, use data classification metadata fields available in field definition. Data classification metadata fields are standard fields that allow you to classify the sensitivity level of your data based on your organization's policies. You can use these fields to indicate whether a field contains confidential, restricted, or general data. These fields are available for both standard and custom objects in Salesforce. Using app exchange products, creating a custom picklist field, or building reports would not be as effective or consistent as using data classification metadata fields.

• Question 28:

  A data architect is working with a large B2C retailer and needs to model the consumer account structure in Salesforce.

  What standard feature should be selected in this scenario?

  A. Individual Accounts

  B. Account Contact

  C. Contacts

  D. Person Accounts

  Correct Answer: D

  Explanation: According to this article, person accounts are designed to store information about individual people by combining certain account and contact fields into a single record. This is suitable for a large B2C retailer that needs to model the consumer account structure in Salesforce.

• Question 29:

  Universal Containers (UC) needs to move millions of records from an external enterprise resource planning (ERP) system into Salesforce.

  What should a data architect recommend to be done while using the Bulk API in serial mode instead of parallel mode?

  A. Placing 20 batches on the queue for upset jobs.

  B. Inserting 1 million orders distributed across a variety of accounts with potential lock exceptions.

  C. Leveraging a controlled feed load with 10 batches per job.

  D. Inserting 1 million orders distributed across a variety of accounts with lock exceptions eliminated and managed.

  Correct Answer: B

  Explanation: According to this article, inserting 1 million orders distributed across a variety of accounts with potential lock exceptions is a scenario where using the Bulk API in serial mode can help to prevent the lock contention issue that can occur in parallel mode.

• Question 30:

  Universal Containers has a large volume of Contact data going into Salesforce.com. There are 100,000 existing contact records. 200,000 new contacts will be loaded. The Contact object has an external ID field that is unique and must be populated for all existing records. What should the architect recommend to reduce data load processing time?

  A. Load Contact records together using the Streaming API via the Upsert operation.

  B. Delete all existing records, and then load all records together via the Insert operation.

  C. Load all records via the Upsert operation to determine new records vs. existing records.

  D. Load new records via the Insert operation and existing records via the Update operation.

  Correct Answer: D

  Explanation: Loading new records via the Insert operation and existing records via the Update operation will allow using the external ID field as a unique identifier and avoid any duplication or overwriting of records. This is faster and safer than deleting all existing records or using the Upsert operation, which might cause conflicts or errors .