ExamGecko
Home / Salesforce / Certified Data Architect / List of questions
Ask Question

Salesforce Certified Data Architect Practice Test - Questions Answers, Page 8

List of questions

Question 71

Report
Export
Collapse

Get Cloudy Consulting needs to evaluate the completeness and consistency of contact information in Salesforce. Their sales reps often have incomplete information about their accounts and contacts. Additionally, they are not able to interpret the information in a consistent manner. Get Cloudy Consulting has identified certain ''key'' fields which are important to their sales reps.

What are two actions Get Cloudy Consulting can take to review their data for completeness and consistency? (Choose two.)

Run a report which shows the last time the key fields were updated.
Run a report which shows the last time the key fields were updated.
Run one report per key field, grouped by that field, to understand its data variability.
Run one report per key field, grouped by that field, to understand its data variability.
Run a report that shows the percentage of blanks for the important fields.
Run a report that shows the percentage of blanks for the important fields.
Run a process that can fill in default values for blank fields.
Run a process that can fill in default values for blank fields.
Suggested answer: A, C

Explanation:

Running a report that shows the last time the key fields were updated can help Get Cloudy Consulting identify stale or outdated data and prioritize data cleansing activities.Running a report that shows the percentage of blanks for the important fields can help Get Cloudy Consulting measure the completeness of their data and identify gaps or missing value

asked 23/09/2024
Stephen DeWhite
37 questions

Question 72

Report
Export
Collapse

Universal Containers (UC) is facing data quality issues where Sales Reps are creating duplicate customer accounts, contacts, and leads. UC wants to fix this issue immediately by prompting users about a record that possibly exists in Salesforce. UC wants a report regarding duplicate records. What would be the recommended approach to help UC start immediately?

Create an after insert and update trigger on the account, contact and lead, and send an error if a duplicate is found using a custom matching criteria.
Create an after insert and update trigger on the account, contact and lead, and send an error if a duplicate is found using a custom matching criteria.
Create a duplicate rule for account, lead, and contact, use standard matching rules for these objects, and set the action to report and alert for both creates and edits.
Create a duplicate rule for account, lead, and contact, use standard matching rules for these objects, and set the action to report and alert for both creates and edits.
Create a duplicate rule for account, lead, and contact, use standard matching rules for these objects, and set the action to block for both creates and edits.
Create a duplicate rule for account, lead, and contact, use standard matching rules for these objects, and set the action to block for both creates and edits.
Create a before insert and update trigger on account, contact, and lead, and send an error if a duplicate is found using a custom matching criteria.
Create a before insert and update trigger on account, contact, and lead, and send an error if a duplicate is found using a custom matching criteria.
Suggested answer: B

Explanation:

Creating a duplicate rule for account, lead, and contact, using standard matching rules for these objects, and setting the action to report and alert for both creates and edits can help UC fix the issue immediately by prompting users about a record that possibly exists in Salesforce.This can also generate a report regarding duplicate records that can be used for further analysis and resolution

asked 23/09/2024
Nelson G Porras
42 questions

Question 73

Report
Export
Collapse

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?

Use a declarative approach by installing and configuring Data.com Clean to monitor Account data quality.
Use a declarative approach by installing and configuring Data.com Clean to monitor Account data quality.
Implement Batch Apex that calls out a third-party data quality API in order to monitor Account data quality.
Implement Batch Apex that calls out a third-party data quality API in order to monitor Account data quality.
Use declarative approach by installing and configuring Data.com Prospector to monitor Account data quality.
Use declarative approach by installing and configuring Data.com Prospector to monitor Account data quality.
Implement an Apex Trigger on Account that queries a third-party data quality API to monitor Account data quality.
Implement an Apex Trigger on Account that queries a third-party data quality API to monitor Account data quality.
Suggested 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

asked 23/09/2024
Nisanka Mandara
30 questions

Question 74

Report
Export
Collapse

Universal Containers (UC) has a requirement to create an Account plan object that is related to the Account object. Each Account plan needs to have an Account object, but the accessibility requirement of the Account plan is different from the Account object. What should an Architect recommend?

Create a custom account plan object as detail with Account as mater in a master-detail relationship.
Create a custom account plan object as detail with Account as mater in a master-detail relationship.
Create a custom account plan object as detail with Account as master with additional sharing rules to allow access.
Create a custom account plan object as detail with Account as master with additional sharing rules to allow access.
Create an account plan object with a lookup relations to Account without any validation rules to enforce the Account association.
Create an account plan object with a lookup relations to Account without any validation rules to enforce the Account association.
Create an account plan object with a lookup relationship to Account with validation rules to enforce the Account association.
Create an account plan object with a lookup relationship to Account with validation rules to enforce the Account association.
Suggested answer: D

Explanation:

Creating an account plan object with a lookup relationship to Account with validation rules to enforce the Account association can help UC meet their requirement. A lookup relationship allows different accessibility requirements for the account plan object and the account object, as well as different ownership and sharing settings. A validation rule can ensure that each account plan has an account associated with it.

asked 23/09/2024
Vito Ranieri
44 questions

Question 75

Report
Export
Collapse

Universal Containers (UC) is using Salesforce Sales & Service Cloud for B2C sales and customer service but they are experiencing a lot of duplicate customers in the system. Which are two recommended approaches for UC to avoid duplicate data and increase the level of data quality?

Use Duplicate Management.
Use Duplicate Management.
Use an Enterprise Service Bus.
Use an Enterprise Service Bus.
Use Data.com Clean
Use Data.com Clean
Use a data warehouse.
Use a data warehouse.
Suggested answer: A, C

Explanation:

Using Duplicate Management and Data.com Clean are two recommended approaches for UC to avoid duplicate data and increase the level of data quality. Duplicate Management can prevent or alert users when they try to create or edit records that are duplicates of existing records. Data.com Clean can compare Salesforce records with Data.com records and provide suggestions for updates or removals of duplicate records.

asked 23/09/2024
Arti Karangiya
34 questions

Question 76

Report
Export
Collapse

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?

Update the Opportunity page layout to mark these fields as required.
Update the Opportunity page layout to mark these fields as required.
Use a validation rule for each field that takes the Stage into consideration.
Use a validation rule for each field that takes the Stage into consideration.
Update these Opportunity field definitions in Setup to be required.
Update these Opportunity field definitions in Setup to be required.
Write an Apex trigger that checks each field when records are saved.
Write an Apex trigger that checks each field when records are saved.
Suggested 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

asked 23/09/2024
Karsten Seifert
34 questions

Question 77

Report
Export
Collapse

A Customer is migrating 10 million order and 30 million order lines into Salesforce using Bulk API. The Engineer is experiencing time-out errors or long delays querying parents order IDs in Salesforce before importing related order line items. What is the recommended solution?

Query only indexed ID field values on the imported order to import related order lines.
Query only indexed ID field values on the imported order to import related order lines.
Leverage an External ID from source system orders to import related order lines.
Leverage an External ID from source system orders to import related order lines.
Leverage Batch Apex to update order ID on related order lines after import.
Leverage Batch Apex to update order ID on related order lines after import.
Leverage a sequence of numbers on the imported orders to import related order lines.
Leverage a sequence of numbers on the imported orders to import related order lines.
Suggested answer: B

Explanation:

Leverage an External ID from source system orders to import related order lines. This is the recommended solution because it allows you to use the upsert operation to match records based on the External ID field, which is indexed and unique.This avoids the need to query the parent order IDs in Salesforce before importing the order line items, which can cause time-out errors or long delays1.

asked 23/09/2024
Valerio Pietrantoni
44 questions

Question 78

Report
Export
Collapse

Universal Containers would like to remove data silos and connect their legacy CRM together with their ERP and with Salesforce. Most of their sales team has already migrated to Salesforce for daily use, although a few users are still on the old CRM until some functionality they require is completed. Which two techniques should be used for smooth interoperability now and in the future.

Replicate ongoing changes in the legacy CRM to Salesforce to facilitate a smooth transition when the legacy CRM is eventually retired.
Replicate ongoing changes in the legacy CRM to Salesforce to facilitate a smooth transition when the legacy CRM is eventually retired.
Specify the legacy CRM as the system of record during transition until it is removed from operation and fully replaced by Salesforce.
Specify the legacy CRM as the system of record during transition until it is removed from operation and fully replaced by Salesforce.
Work with stakeholders to establish a Master Data Management plan for the system of record for specific objects, records, and fields.
Work with stakeholders to establish a Master Data Management plan for the system of record for specific objects, records, and fields.
Do not connect Salesforce and the legacy CRM to each other during this transition period, but do allow both to interact with the ERP.
Do not connect Salesforce and the legacy CRM to each other during this transition period, but do allow both to interact with the ERP.
Suggested answer: B, C

Explanation:

Specify the legacy CRM as the system of record during transition until it is removed from operation and fully replaced by Salesforce. This is a good technique to ensure data consistency and avoid conflicts between the two systems. Work with stakeholders to establish a Master Data Management plan for the system of record for specific objects, records, and fields.This is another good technique to define the data governance and stewardship policies and processes for managing data quality and integrity across multiple systems

asked 23/09/2024
Daniela Stojanovska
36 questions

Question 79

Report
Export
Collapse

UC is trying to switch from legacy CRM to salesforce and wants to keep legacy CRM and salesforce in place till all the functionality is deployed in salesforce. The want to keep data in synch b/w Salesforce, legacy CRM and SAP. What is the recommendation.

Integrate legacy CRM to salesforce and keep data in synch till new functionality is in place
Integrate legacy CRM to salesforce and keep data in synch till new functionality is in place
Do not integrate legacy CRM to Salesforce, but integrate salesforce to SAP
Do not integrate legacy CRM to Salesforce, but integrate salesforce to SAP
Integrate SAP with Salesforce, SAP to legacy CRM but not legacy CRM to Salesforce
Integrate SAP with Salesforce, SAP to legacy CRM but not legacy CRM to Salesforce
Suggest MDM solution and link MDM to salesforce and SAP
Suggest MDM solution and link MDM to salesforce and SAP
Suggested answer: C, D

Explanation:

Integrate SAP with Salesforce, SAP to legacy CRM but not legacy CRM to Salesforce. This is a good recommendation because it allows both Salesforce and the legacy CRM to interact with the ERP system, which can be the source of truth for some data entities. However, it avoids creating a direct connection between Salesforce and the legacy CRM, which can cause data duplication and synchronization issues. Suggest MDM solution and link MDM to salesforce and SAP.This is another good recommendation because it can help manage the data lifecycle and quality across multiple systems, as well as provide a single view of the customer data

asked 23/09/2024
Eusebio Adrian
33 questions

Question 80

Report
Export
Collapse

Universal Containers (UC) has an Application custom object, which has tens of millions of records created in the past 5 years. UC needs the last 5 years of data to exist in Salesforce at all times for reporting and queries. UC is currently encountering performance issues when reporting and running queries on this Object using date ranges as filters. Which two options can be used to improve report performance?

Ask support to create a skinny table for Application with the necessary reporting fields.
Ask support to create a skinny table for Application with the necessary reporting fields.
Add custom indexes to all fields on Application without a standard index.
Add custom indexes to all fields on Application without a standard index.
Run multiple reports to get different pieces of the data and combine them.
Run multiple reports to get different pieces of the data and combine them.
Add custom indexes to the Date fields used for filtering the report.
Add custom indexes to the Date fields used for filtering the report.
Suggested answer: A, D

Explanation:

Ask support to create a skinny table for Application with the necessary reporting fields. This is an option that can improve report performance by creating a custom table that contains frequently used fields and copies their values from standard or custom objects.Skinny tables are kept in sync with their source tables and are used in place of them for reports and queries4. Add custom indexes to the Date fields used for filtering the report. This is another option that can improve report performance by creating custom indexes on fields that are often used as filters or join conditions in reports and queries.Custom indexes can speed up data retrieval and reduce query execution time

asked 23/09/2024
Wilfried Bret
30 questions
Total 260 questions
Go to page: of 26
Search

Related questions