Salesforce Salesforce Certifications DATA-ARCHITECT Questions & Answers

• Question 141:

  Northern Trail Outfitters (NTO) wants to capture a list of customers that have bought a particular product. The solution architect has recommended to create a custom object for product, and to create a lookup relationship between its customers and its products.

  Products will be modeled as a custom object (NTO_ Product__ c) and customers are modeled as person accounts. Every NTO product may have millions of customers looking up a single product, resulting in a lookup skew.

  What should a data architect suggest to mitigate Issues related to lookup skew?

  A. Create multiple similar products and distribute the skew across those products.

  B. Change the lookup relationship to master-detail relationship.

  C. Create a custom object to maintain the relationship between products and customers.

  D. Select Clear the value of this field option while configuring the lookup relationship.

  Correct Answer: A

  Explanation: creating multiple similar products and distributing the skew across those products can be a way to mitigate issues related to lookup skew. The article explains that lookup skew happens when a very large number of records are associated with a single record in the lookup object, and this can cause record locking and performance issues. The article suggests creating multiple copies of the same product record and assigning different child records to each copy, so that the number of child records per parent record is reduced.

• Question 142:

  The data architect for UC has written a SOQL query that will return all records from the Task object that do not have a value in the WhatID field:

  Select id, description, Subject from Task where WhatId!= NULL

  When the data architect usages the query to select values for a process a time out error occurs.

  What does the data architect need to change to make this query more performant?

  A. Remove description from the requested field set.

  B. Change query to SOSL.

  C. Add limit 100 to the query.

  D. Change the where clause to filter by a deterministic defined value.

  Correct Answer: D

  Explanation: According to the Salesforce documentation, SOQL is a query language that allows querying data from Salesforce objects and fields. SOQL queries have various clauses and operators that can be used to filter and sort the results. However, some clauses and operators can affect the performance of SOQL queries by increasing the cost or complexity of executing them. To make this query more performant, a data architect should change the where clause to filter by a deterministic defined value (option D). This means using a filter condition that specifies a concrete value or range of values for a field, such as WhatId = `001xx000003DGg3' or WhatId IN (`001xx000003DGg3', `001xx000003DGg4'). This can improve the performance of the query by reducing the number of records that need to be scanned and returned. A deterministic defined value can also leverage an index on the field, which can speed up the query execution. Removing description from the requested field set (option A) is not a good solution, as it can affect the functionality or usability of the query. The description field may contain important or relevant information that is needed for the process. Changing the query to SOSL (option B) is also not a good solution, as SOSL is a different query language that allows searching text fields across multiple objects. SOSL queries have different syntax and limitations than SOQL queries, and may not return the same results or performance. Adding limit 100 to the query (option C) is also not a good solution, as it can affect the completeness or accuracy of the query. The limit clause specifies the maximum number of records that can be returned by the query, which may not include all the records that match the filter condition.

• Question 143:

  Get Cloudy Consulting is migrating their legacy system's users and data to Salesforce. They will be creating 15,000 users, 1.5 million Account records, and 15 million Invoice records. The visibility of these records is controlled by a 50 owner and criteria-based sharing rules.

  Get Cloudy Consulting needs to minimize data loading time during this migration to a new organization.

  Which two approaches will accomplish this goal? (Choose two.)

  A. Create the users, upload all data, and then deploy the sharing rules.

  B. Contact Salesforce to activate indexing before uploading the data.

  C. First, load all account records, and then load all user records.

  D. Defer sharing calculations until the data has finished uploading.

  Correct Answer: AD

  Explanation: Creating the users, uploading all data, and then deploying the sharing rules will reduce the number of sharing recalculations that occur during the data load. Deferring sharing calculations until the data has finished uploading will also improve the performance by postponing the sharing rule evaluation. These are the recommended best practices for loading large data sets into Salesforce

• Question 144:

  Universal Containers (UC) has implemented a master data management strategy, which uses a central system of truth, to ensure the entire company has the same customer information in all systems. UC customer data changes need to be accurate at all times in all of the systems. Salesforce is the identified system of record for this information.

  What is the correct solution for ensuring all systems using customer data are kept up to date?

  A. Send customer data nightly to the system of truth in a scheduled batch job.

  B. Send customer record changes from Salesforce to each system in a nightly batch job.

  C. Send customer record changes from Salesforce to the system of truth in real time.

  D. Have each system pull the record changes from Salesforce using change data capture.

  Correct Answer: C

  Explanation: Having each system pull the record changes from Salesforce using change data capture (option D) is the correct solution for ensuring all systems using customer data are kept up to date, as it allows the systems to subscribe to real-time events from Salesforce and receive notifications when customer records are created, updated, deleted, or undeleted. Sending customer data nightly to the system of truth in a scheduled batch job (option A) or sending customer record changes from Salesforce to each system in a nightly batch job (option B) are not good solutions, as they may cause data latency and inconsistency, and they do not provide real-time updates. Sending customer record changes from Salesforce to the system of truth in real time (option C) is also not a good solution, as it does not address how the other systems will receive the updates from the system of truth.

• Question 145:

  A large telecommunication provider that provides internet services to both residence and business has the following attributes:

  A customer who purchases its services for their home will be created as an Account in Salesforce.

  Individuals within the same house address will be created as Contact in Salesforce.

  Businesses are created as Accounts in Salesforce.

  Some of the customers have both services at their home and business.

  What should a data architect recommend for a single view of these customers without creating multiple customer records?

  A. Customers are created as Contacts and related to Business and Residential Accounts using the Account Contact Relationships.

  B. Customers are created as Person Accounts and related to Business and Residential Accounts using the Account Contact relationship.

  C. Customer are created as individual objects and relate with Accounts for Business and Residence accounts.

  D. Costumers are created as Accounts for Residence Account and use Parent Account to relate Business Account.

  Correct Answer: B

  Explanation: Creating customers as Contacts and relating them to Business and Residential Accounts using the Account Contact Relationships (option A) is the best option to recommend for a single view of these customers without creating multiple customer records, as it allows the data architect to model complex relationships between customers and accounts using native Salesforce features and tools. Creating customers as Person Accounts and relating them to Business and Residential Accounts using the Account Contact relationship (option B) is not a good option, as it may create data redundancy and inconsistency, and it does not leverage the existing Contact object. Creating customers as individual objects and relating them with Accounts for Business and Residence accounts (option C) is also not a good option, as it may require more customization and maintenance effort, and it does not leverage the existing Account and Contact objects. Creating customers as Accounts for Residence Account and using Parent Account to relate Business Account (option D) is also not a good option, as it may create confusion and complexity with the account hierarchy, and it does not leverage the existing Contact object.

• Question 146:

  NTO (Northern Trail Outlets) has a complex Salesforce org which has been developed over past 5 years. Internal users are complaining abt multiple data issues, including incomplete and duplicate data in the org. NTO has decided to engage a data architect to analyze and define data quality standards.

  Which 3 key factors should a data architect consider while defining data quality standards? Choose 3 answers:

  A. Define data duplication standards and rules

  B. Define key fields in staging database for data cleansing

  C. Measure data timeliness and consistency

  D. Finalize an extract transform load (ETL) tool for data migration

  E. Measure data completeness and accuracy

  Correct Answer: ACE

  Explanation: Defining data duplication standards and rules, measuring data timeliness and consistency, and measuring data completeness and accuracy are three key factors that a data architect should consider while defining data quality standards. Defining data duplication standards and rules can help prevent or reduce duplicate records in the org by specifying criteria and actions for identifying and merging duplicates. Measuring data timeliness and consistency can help ensure that the data is up-to-date, reliable, and synchronized across different sources. Measuring data completeness and accuracy can help ensure that the data is sufficient, relevant, and correct for the intended purposes.

• Question 147:

  UC is having issues using Informatica Cloud Louder to export +10MOrder records. Each Order record has 10 Order Line Items. What two steps can you take to help correct this? Choose two answers.

  A. Export in multiple batches

  B. Export Bulk API in parallel mode

  C. Use PK Chunking

  D. Limit Batch to 10K records

  Correct Answer: AC

  Explanation: Exporting in multiple batches and using PK Chunking are two steps that can help correct the issues with exporting large volumes of Order records using Informatica Cloud Loader. Exporting in multiple batches can reduce the load on the system and avoid timeouts or errors. Using PK Chunking can split a large data set into smaller chunks based on the record IDs and enable parallel processing of each chunk.

• Question 148:

  A manager at Cloud Kicks is importing Leads into Salesforce and needs to avoid creating duplicate records.

  Which two approaches should the manager take to achieve this goal? (Choose two.)

  A. Acquire an AppExchange Lead de-duplication application.

  B. Implement Salesforce Matching and Duplicate Rules.

  C. Run the Salesforce Lead Mass de-duplication tool.

  D. Create a Workflow Rule to check for duplicate records.

  Correct Answer: AB

  Explanation: Acquiring an AppExchange Lead de-duplication application and implementing Salesforce Matching and Duplicate Rules are two approaches that the manager at Cloud Kicks should take to avoid creating duplicate records when importing Leads into Salesforce. An AppExchange Lead de-duplication application can provide additional features and functionality for finding and preventing duplicate Leads during import, such as fuzzy matching, custom rules, mass merge, etc. Salesforce Matching and Duplicate Rules can allow the manager to define how Salesforce identifies duplicate Leads based on various criteria and how users can handle them during import, such as blocking, allowing, or alerting them. The other options are not feasible or effective for avoiding duplicate records, as they would either not work during import, not provide de-duplication capabilities, or require additional customization.

• Question 149:

  Universal Containers is setting up an external Business Intelligence (BI) system and wants to extract 1,000,000 Contact records. What should be recommended to avoid timeouts during the export process?

  A. Use the SOAP API to export data.

  B. Utilize the Bulk API to export the data.

  C. Use GZIP compression to export the data.

  D. Schedule a Batch Apex job to export the data.

  Correct Answer: C

  Explanation: According to the exam guide, one of the objectives is to "describe the use cases and considerations for using various tools and techniques for data migration (for example, Data Loader, Bulk API)"1. This implies that option B is the correct way to extract large volumes of data from Salesforce. The Bulk API is designed to handle large-scale data operations and avoid timeouts. Option A is not correct because the SOAP API is not optimized for large data sets and may encounter limits. Option C is not correct because GZIP compression does not prevent timeouts, but rather reduces the size of the data transferred. Option D is not correct because Batch Apex is used to process records asynchronously in Salesforce, not to export data to an external system.

• Question 150:

  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.

  Correct Answer: A

  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 .