Salesforce Salesforce Certifications DATA-ARCHITECT Questions & Answers

• Question 111:

  A large Automobile company has implemented SF for its Sales Associates. Leads flow from its website to SF using a batch integration in SF. The Batch job connects the leads to Accounts in SF. Customer visiting their retail stores are also created in SF as Accounts.

  The company has noticed a large number of duplicate accounts in SF. On analysis, it was found that certain customers could interact with its website and also visit the store. The Sales associates use Global Search to search for customers in Salesforce before they create the customers.

  Which scalable option should a data Architect choose to implement to avoid duplicates?

  A. Create duplicate rules in SF to validate duplicates during the account creation process

  B. Implement a MDM solution to validate the customer information before creating Accounts in SF.

  C. Build Custom search based on fields on Accounts which can be matched with customer when they visit the store

  D. Customize Account creation process to search if customer exists before creating an Account.

  Correct Answer: A

  Explanation: The data architect should choose to implement duplicate rules in SF (Salesforce) to validate duplicates during the account creation process. Duplicate rules are a feature in Salesforce that allow users to define criteria and actions for detecting and preventing duplicate records. By creating duplicate rules for accounts, the data architect can ensure that any leads from the website or customers from the retail stores that match existing accounts in Salesforce are flagged or blocked before they are created as new accounts. This will help avoid duplicate accounts in Salesforce and maintain data quality. Option B is incorrect because implementing a MDM (Master Data Management) solution to validate the customer information before creating accounts in SF will require additional infrastructure cost and maintenance effort. Option C is incorrect because building custom search based on fields on accounts which can be matched with customer when they visit the store will require additional development effort and may not be accurate or user- friendly. Option D is incorrect because customizing account creation process to search if customer exists before creating an account will require additional configuration effort and may not be consistent or scalable.

• Question 112:

  How can an architect find information about who is creating, changing, or deleting certain fields within the past two months?

  A. Remove "customize application" permissions from everyone else.

  B. Export the metadata and search it for the fields in question.

  C. Create a field history report for the fields in question.

  D. Export the setup audit trail and find the fields in question.

  Correct Answer: D

  Explanation: The setup audit trail tracks changes made in your org's setup area for the past 180 days1. You can export the setup audit trail and find the fields in question by filtering by action type, user, or date2.

• Question 113:

  Universal Containers (UC) is concerned that data is being corrupted daily either through negligence or maliciousness. They want to implement a backup strategy to help recover any corrupted data or data mistakenly changed or even deleted. What should the data architect consider when designing a field -level audit and recovery plan?

  A. Reduce data storage by purging old data.

  B. Implement an AppExchange package.

  C. Review projected data storage needs.

  D. Schedule a weekly export file.

  Correct Answer: C

  Explanation: Option C is the best answer because reviewing projected data storage needs is an important step in designing a field-level audit and recovery plan1. You need to estimate how much data storage you will need in the future and plan accordingly. Option A is not correct because reducing data storage by purging old data may not be sufficient or desirable for backup purposes. Option B is not correct because implementing an AppExchange package may not be customized or compatible with your org's requirements. Option D is not correct because scheduling a weekly export file may not be frequent or granular enough for field-level audit and recovery.

• Question 114:

  Universal Containers (UC) has a data model as shown in the image. The Project object has a private sharing model, and it has Roll -Up summary fields to calculate the number of resources assigned to the project, total hours for the project, and the number of work items associated to the project.

  What should the architect consider, knowing there will be a large amount of time entry records to be loaded regularly from an external system into Salesforce.com?

  A. Load all data using external IDs to link to parent records.

  B. Use workflow to calculate summary values instead of Roll -Up.

  C. Use triggers to calculate summary values instead of Roll -Up.

  D. Load all data after deferring sharing calculations.

  Correct Answer: D

  Explanation: Loading all data after deferring sharing calculations can improve the performance and avoid locking issues when loading a large amount of time entry records into Salesforce.com. This is because deferring sharing calculations can temporarily suspend the calculation of sharing rules until all the data is loaded, and then recalculate them in one operation

• Question 115:

  A large retail company has recently chosen SF as its CRM solution. They have the following record counts:

  2500000 accounts 25000000 contacts

  When doing an initial performance test, the data architect noticed an extremely slow response for reports and list views.

  What should a data architect do to solve the performance issue?

  A. Load only the data that the users is permitted to access

  B. Add custom indexes on frequently searched account and contact objects fields

  C. Limit data loading to the 2000 most recently created records.

  D. Create a skinny table to represent account and contact objects.

  Correct Answer: B

  Explanation: The correct answer is B, add custom indexes on frequently searched account and contact object fields. Custom indexes are a way to improve the performance of your queries and reports by creating indexes on specific fields that are often used in filters or joins. By adding custom indexes on frequently searched account and contact object fields, you can speed up the response time for reports and list views. Loading only the data that users are permitted to access, limiting data loading to the 2000 most recent records, or creating a skinny table are also possible solutions, but they are either not feasible, not scalable, or not supported by Salesforce.

• Question 116:

  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.

  Correct Answer: B

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

  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.

  Correct Answer: A

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

  NTO uses salesforce to manage relationships and track sales opportunities. It has 10 million customers and 100 million opportunities. The CEO has been complaining 10 minutes to run and sometimes failed to load, throwing a time out error.

  Which 3 options should help improve the dashboard performance?

  Choose 3 answers:

  A. Use selective queries to reduce the amount of data being returned.

  B. De-normalize the data by reducing the number of joins.

  C. Remove widgets from the dashboard to reduce the number of graphics loaded.

  D. Run the dashboard for CEO and send it via email.

  E. Reduce the amount of data queried by archiving unused opportunity records.

  Correct Answer: ABE

  Explanation: To improve the dashboard performance, the data architect should use selective queries to reduce the amount of data being returned, de-normalize the data by reducing the number of joins, and reduce the amount of data queried by archiving unused opportunity records. These options will help optimize the query performance, reduce the query complexity, and free up storage space. Option C is incorrect because removing widgets from the dashboard to reduce the number of graphics loaded will not affect the dashboard performance significantly, and may reduce the usability and functionality of the dashboard. Option D is incorrect because running the dashboard for CEO and sending it via email will not improve the dashboard performance, but rather shift the burden to another user.

• Question 119:

  As part of a phased Salesforce rollout. there will be 3 deployments spread out over the year. The requirements have been carefully documented. Which two methods should an architect use to trace back configuration changes to the detailed requirements? Choose 2 answers

  A. Review the setup audit trail for configuration changes.

  B. Put the business purpose in the Description of each field.

  C. Maintain a data dictionary with the justification for each field.

  D. Use the Force.com IDE to save the metadata files in source control.

  Correct Answer: BD

  Explanation: Option B is correct because putting the business purpose in the Description of each field is a method that an architect can use to trace back configuration changes to the detailed requirements1. The Description of each field provides a brief explanation of what the field is used for and why it is needed2. Option D is correct because using the Force.com IDE to save the metadata files in source control is another method that an architect can use to trace back configuration changes to the detailed requirements1. The Force.com IDE is an integrated development environment that allows developers to work with Salesforce metadata files and Apex code3. Source control is a system that tracks and manages changes to code and configuration files4. Option A is not correct because reviewing the setup audit trail for configuration changes is not a method to trace back configuration changes to the detailed requirements, but a way to monitor and audit the changes made in the setup area. Option C is not correct because maintaining a data dictionary with the justification for each field is not a method to trace back configuration changes to the detailed requirements, but a document that provides information about the data entities and attributes in a system.

• Question 120:

  Universal Containers (UC) is implementing a new customer categorization process where customers should be assigned to a Gold, Silver, or Bronze category if they've purchased UC's new support service. Customers are expected to be evenly distributed across all three categories. Currently, UC has around 500,000 customers, and is expecting 1% of existing non-categorized customers to purchase UC's new support service every month over the next five years. What is the recommended solution to ensure long-term performance, bearing in mind the above requirements?

  A. Implement a new global picklist custom field with Gold, Silver, and Bronze values and enable it in Account.

  B. Implement a new picklist custom field in the Account object with Gold, Silver, and Bronze values.

  C. Implement a new Categories custom object and a master-detail relationship from Account to Category.

  D. Implement a new Categories custom object and create a lookup field from Account to Category.

  Correct Answer: B

  Explanation: The recommended solution to ensure long-term performance for the customer categorization process is to implement a new picklist custom field in the Account object with Gold, Silver, and Bronze values. A picklist field is a

  simple and efficient way to store a predefined set of values for a record. A picklist field has the following benefits:

  It allows you to easily filter, sort, and group records by their category values, which can help you analyze and segment your customers. It does not require creating any additional objects or relationships, which can reduce the data model

  complexity and maintenance overhead. It supports large data volumes and can handle millions of records without affecting performance or scalability.