Salesforce Salesforce Certifications DATA-ARCHITECT Questions & Answers

• Question 221:

  Universal Containers has implemented Salesforce for its operations. In order for customers to be created in their MDM solution, the customer record needs to have the following attributes:

  1.

  First Name

  2.

  Last Name

  3.

  Email

  Which option should the data architect recommend to mandate this when customers are created in Salesforce?

  A. Configure Page Layout marking attributes as required fields.

  B. Create validation rules to check If the required attributes are entered.

  C. Mark Fields for the attributes as required under Setup.

  D. Build validation in Integration with MDM to check required attributes.

  Correct Answer: B

  Explanation: Creating validation rules to check if the required attributes are entered is the best option to mandate this when customers are created in Salesforce. Validation rules allow you to specify criteria that must be met before a record can be saved. You can use validation rules to ensure that customers have a first name, last name, and email when they are created in Salesforce. This way, you can prevent incomplete or invalid data from being sent to your MDM solution.

• Question 222:

  Universal Containers (UC) wants to ensure their data on 100,000 Accounts pertaining mostly to US-based companies is enriched and cleansed on an ongoing basis. UC is looking for a solution that allows easy monitoring of key data quality metrics. What should be the recommended solution to meet this requirement?

  A. Use a declarative approach by installing and configuring Data.com Clean to monitor Account data quality.

  B. Implement Batch Apex that calls out a third-party data quality API in order to monitor Account data quality.

  C. Use declarative approach by installing and configuring Data.com Prospector to monitor Account data quality.

  D. Implement an Apex Trigger on Account that queries a third-party data quality API to monitor Account data quality.

  Correct Answer: A

  Explanation: Using a declarative approach by installing and configuring Data.com Clean to monitor Account data quality can help UC meet their requirement. Data.com Clean can enrich and cleanse data on an ongoing basis by comparing Salesforce records with Data.com records and providing suggestions for updates. Data.com Clean can also provide dashboards and reports to monitor key data quality metrics such as match rate, field fill rate, and record completeness

• Question 223:

  NTO has been using salesforce for sales and service for 10 years. For the past 2 years, the marketing group has noticed a raise from 0 to 35 % in returned mail when sending mail using the contact information stored in salesforce.

  Which solution should the data architect use to reduce the amount of returned mails?

  A. Use a 3rd-party data source to update contact information in salesforce.

  B. Email all customer and asked them to verify their information and to call NTO if their address is incorrect.

  C. Delete contacts when the mail is returned to save postal cost to NTO.

  D. Have the sales team to call all existing customers and ask to verify the contact details.

  Correct Answer: A

  Explanation: Using a third-party data source to update contact information in Salesforce is the best solution to reduce the amount of returned mails. This way, the data architect can ensure that the contact information is accurate and up-todate without relying on manual verification or deletion of contacts

• Question 224:

  DreamHouse Realty has a Salesforce org that is used to manage Contacts.

  What are two things an Architect should consider using to maintain data quality in this situation? (Choose two.)

  A. Use the private sharing model.

  B. Use Salesforce duplicate management.

  C. Use validation rules on new record create and edit.

  D. Use workflow to delete duplicate records.

  Correct Answer: BC

  Explanation: Using Salesforce duplicate management and using validation rules on new record create and edit are two things that an architect should consider using to maintain data quality for managing Contacts. Salesforce duplicate management allows the architect to create matching rules and duplicate rules to identify, prevent, or allow duplicate records based on various criteria. Validation rules allow the architect to enforce data quality standards and business logic by displaying error messages when users try to save invalid data. The other options are not relevant or helpful for maintaining data quality

• Question 225:

  Universal Containers (UC) is in the process of selling half of its company. As part of this split, UC's main Salesforce org will be divided into two org:org A and org B, UC has delivered these requirements to its data architect

  1.

  The data model for Org B will drastically change with different objects, fields, and picklist values.

  2.

  Three million records will need to be migrated from org A to org B for compliance reasons.

  3.

  The migrate will need occur within the next two month, prior to be split. Which migrate strategy should a data architect use to successfully migrate the date?

  A. use as ETL tool to orchestrate the migration.

  B. Use Data Loader for export and Data Import Wizard for import

  C. Write a script to use the Bulk API

  D. Use the Salesforces CLI to query, export, and import

  Correct Answer: A

  Explanation: Using an ETL tool to orchestrate the migration is the best strategy for this scenario, as it can handle the data model changes, the large volume of records, and the tight timeline. Writing a script to use the Bulk API (option C) is also possible, but it would require more coding and testing effort. Using Data Loader and Data Import Wizard (option B) is not suitable for migrating three million records, as they have limitations on the batch size and the number of records per operation. Using Salesforce CLI (option D) is also not recommended for large data migration, as it is mainly designed for development and testing purposes

• Question 226:

  Universal Containers has a custom object with millions of rows of data.

  When executing SOQL queries, which three options prevent a query from being selective? (Choose three.)

  A. Using leading % wildcards.

  B. Using trailing % wildcards.

  C. Performing large loads and deletions.

  D. Using NOT and != operators.

  E. Using a custom index on a deterministic formula field.

  Correct Answer: ACD

  Explanation: Using leading % wildcards, performing large loads and deletions, and using NOT and != operators are three options that prevent a query from being selective. These options can cause the query to scan a large number of records or indexes, which can negatively impact the performance and scalability of the query5. Using a custom index on a deterministic formula field, on the other hand, can improve the query selectivity by allowing the query to use the index instead of scanning all the records6.

• Question 227:

  Universal Containers (UC) is a major supplier of office supplies. Some products are produced by UC and some by other manufacturers. Recently, a number of customers have complained that product descriptions on the invoices do not match the descriptions in the online catalog and on some of the order confirmations (e.g., "ballpoint pen" in the catalog and "pen" on the invoice, and item color labels are inconsistent: "what vs. "White" or "blk" vs. "Black"). All product data is consolidated in the company data warehouse and pushed to Salesforce to generate quotes and invoices. The online catalog and webshop is a Salesforce Customer Community solution. What is a correct technique UC should use to solve the data inconsistency?

  A. Change integration to let product master systems update product data directly in Salesforce via the Salesforce API.

  B. Add custom fields to the Product standard object in Salesforce to store data from the different source systems.

  C. Define a data taxonomy for product data and apply the taxonomy to the product data in the data warehouse.

  D. Build Apex Triggers in Salesforce that ensure products have the correct names and labels after data is loaded into salesforce.

  Correct Answer: C

  Explanation: A correct technique UC should use to solve the data inconsistency is to define a data taxonomy for product data and apply the taxonomy to the product data in the data warehouse. A data taxonomy is a hierarchical classification of data entities and attributes that defines their meaning, format, and relationships. A data taxonomy can help ensure consistency, accuracy, and completeness of product data across different systems and channels

• Question 228:

  A custom pricing engine for a Salesforce customer has to be decided by factors with the following hierarchy: State in which the customer is located City in which the customer is located if available Zip code in which the customer is located if available Changes to this information should have minimum code changes What should a data architect recommend to maintain this information for the custom pricing engine that is to be built in Salesforce?

  A. Create a custom object to maintain the pricing criteria.

  B. Assign the pricing criteria within customer pricing engine.

  C. Maintain require pricing criteria in custom metadata types.

  D. Configure the pricing criteria in price books.

  Correct Answer: C

  Explanation: According to the Get Started with Custom Metadata Types unit on Trailhead, one of the use cases for custom metadata types is to define custom charges for an accounting app. The unit states that "Say that your org uses a standard accounting app. You can create a custom metadata type that defines custom charges, like duties and VAT rates. Then you can write some Apex code that calculates the total amount due for each invoice by using the metadata from your custom metadata type." Therefore, a similar approach can be used to maintain the pricing criteria for a custom pricing engine in Salesforce.

• Question 229:

  UC has millions of case records with case history and SLA data. UC's compliance team would like historical cases to be accessible for 10 years for Audit purpose. What solution should a data architect recommend?

  A. Archive Case data using Salesforce Archiving process

  B. Purchase more data storage to support case object

  C. Use a custom object to store archived case data.

  D. Use a custom Big object to store archived case data.

  Correct Answer: D

  Explanation: The best solution to store historical cases for 10 years for audit purpose is to use a custom Big object to store archived case data. Big objects are a type of custom object that can store massive amounts of data on the Salesforce platform without affecting performance or storage limits. They also support point-and-click tools, triggers, and Apex code. Big objects can be used for archiving historical data that needs to be retained for compliance or analytics purposes3. Archiving case data using Salesforce Archiving process is not a good option because it only supports archiving cases that are closed for more than one year, and it does not allow customizing the archival criteria or accessing the archived data via Apex or APIs4. Purchasing more data storage to support case object is expensive and may impact performance. Using a custom object to store archived case data is not scalable and may consume a lot of storage space.

• Question 230:

  An Architect needs information about who is creating, changing, or deleting certain fields within the past four months. How can the Architect access this information?

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

  B. After exporting the setup audit trail, find the fields in question.

  C. After exporting the metadata, search it for the fields in question.

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

  Correct Answer: B

  Explanation: Exporting the setup audit trail can provide information about who is creating, changing, or deleting certain fields within the past four months. The setup audit trail tracks the recent setup changes that administrators and other users have made to the organization. The setup audit trail history shows up to 20 most recent changes in the Setup area, but administrators can download a report (in CSV format) of up to six months of setup history.