ExamGecko
Home Home / Salesforce / Certified Data Architect

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

Question list
Search
Search

List of questions

Search

Related questions











Universal Containers (UC) is migrating data from legacy system to Salesforce. During data analysis it was discovered that data types of fields being migrated do not match with Salesforce data types.

Which solution should a data architect use to ensure successful data migrations?

A.
Migrate legacy data to a staging database for mapping then leverage an ETL tool to transform the data and load into Salesforce.
A.
Migrate legacy data to a staging database for mapping then leverage an ETL tool to transform the data and load into Salesforce.
Answers
B.
Export legacy data into the staging database and leverage stored procedures to transform data types before loading into Salesforce.
B.
Export legacy data into the staging database and leverage stored procedures to transform data types before loading into Salesforce.
Answers
C.
Migrate the legacy data leveraging an ETL tool to transform data types and load data into Salesforce.
C.
Migrate the legacy data leveraging an ETL tool to transform data types and load data into Salesforce.
Answers
D.
Export legacy data into CSV files and leverage data loader to load data into Salesforce.
D.
Export legacy data into CSV files and leverage data loader to load data into Salesforce.
Answers
Suggested answer: C

Explanation:

According tothis article, migrating the legacy data leveraging an ETL tool to transform data types and load data into Salesforce can be a way to ensure successful data migrations. The article states that ETL tools can help with data cleansing, mapping, transformation, and loading, and that they can handle different data types and formats. The article also provides some best practices for data migration, such as identifying the data to migrate, creating templates for the data, preparing the destination org, and validating the data.

Based on government regulations, a Salesforce customer plans to implement the following in Salesforce for compliance:

Access to customer information based on record ownership

Ability for customers to request removal of their information from Salesforce

Prevent users from accessing Salesforce from outside company network (virtual private network, or VPN)

What should a data architect recommend to address these requirements?

A.
Contact Salesforce support to restrict access only with VPN and other requirements
A.
Contact Salesforce support to restrict access only with VPN and other requirements
Answers
B.
Allow users access to Salesforce through a custom web application hosted within VPN.
B.
Allow users access to Salesforce through a custom web application hosted within VPN.
Answers
C.
Implement IP restrictions, sharing settings, and custom Apex to support customer requests.
C.
Implement IP restrictions, sharing settings, and custom Apex to support customer requests.
Answers
D.
Implement Salesforce shield with Event Monitoring to address the requirement.
D.
Implement Salesforce shield with Event Monitoring to address the requirement.
Answers
Suggested answer: C

Explanation:

IP restrictions can be used to prevent users from accessing Salesforce from outside the company network or VPN. According tothis article, sharing settings can be used to control access to customer information based on record ownership. According tothis article, custom Apex can be used to support customer requests for removal of their information from Salesforce.

Universal Containers has multiple systems all containing and maintaining customer dat

a. Although point-to-point integrations are in place, customers are complaining about consistency in the data.

What solution should the data architect recommend?

A.
Improve existing point-to-point integrations
A.
Improve existing point-to-point integrations
Answers
B.
Data cleanse each system
B.
Data cleanse each system
Answers
C.
Perform a onetime synchronization to level set the built up inconsistencies
C.
Perform a onetime synchronization to level set the built up inconsistencies
Answers
D.
An MDM solution as the customer master, with centralized integrations to ensure consistency across all systems.
D.
An MDM solution as the customer master, with centralized integrations to ensure consistency across all systems.
Answers
Suggested answer: D

Explanation:

Master data management (MDM) is a solution that helps organizations manage their master data across multiple systems and ensure consistency and quality. An MDM solution can act as the customer master, with centralized integrations to other systems, to avoid data duplication and inconsistency.

Northern Trail Outfitters (NTO) has multiple Salesforce orgs based on regions. Users need read-only access to customers across all Salesforce orgs.

Which feature in Salesforce can be used to provide access to customer records across all NTO orgs?

A.
Salesforce Connect
A.
Salesforce Connect
Answers
B.
Salesforce 2 Salesforce
B.
Salesforce 2 Salesforce
Answers
C.
Federated Search
C.
Federated Search
Answers
D.
External APIs
D.
External APIs
Answers
Suggested answer: A

Explanation:

Salesforce Connect is a feature that allows users to access data from external sources and multiple Salesforce orgs, using either clicks or code. Salesforce Connect can provide read-only access to customer records across all NTO orgs, without replicating or storing the data in Salesforce.

Northern Trail Outfitters (NTO) plans to maintain contact preferences for customers and employees. NTO has implemented the following:

1. Customers are Person Accounts for their retail business.

2. Customers are represented as Contacts for their commercial business.

3. Employees are maintained as Users.

4. Prospects are maintained as Leads.

NTO needs to implement a standard communication preference management model for Person Accounts, Contacts, Users, and Leads.

Which option should the data architect recommend NTO to satisfy this requirement?

A.
Create custom fields for contact preferences in Lead, Person Account, and Users objects.
A.
Create custom fields for contact preferences in Lead, Person Account, and Users objects.
Answers
B.
Create case for contact preferences, and use this to validate the preferences for Lead, Person Accounts, and Users.
B.
Create case for contact preferences, and use this to validate the preferences for Lead, Person Accounts, and Users.
Answers
C.
Create a custom object to maintain preferences and build relationships to Lead, Person Account, and Users.
C.
Create a custom object to maintain preferences and build relationships to Lead, Person Account, and Users.
Answers
D.
Use Individual objects to maintain the preferences with relationships to Lead, Person Account, and Users.
D.
Use Individual objects to maintain the preferences with relationships to Lead, Person Account, and Users.
Answers
Suggested answer: D

Explanation:

The Individual object is a standard object that lets you store details about data privacy and protection preferences for person accounts, contacts, users, and leads. The Individual object can be used to implement a standard communication preference management model for NTO, with relationships to the other objects.

Universal Containers (UC) is building a Service Cloud call center application and has a multisystem support solution. UC would like or ensure that all systems have access to the same customer information.

What solution should a data architect recommend?

A.
Make Salesforce the system of record for all data.
A.
Make Salesforce the system of record for all data.
Answers
B.
Implement a master data management (MDM) strategy for customer data.
B.
Implement a master data management (MDM) strategy for customer data.
Answers
C.
Load customer data in all systems.
C.
Load customer data in all systems.
Answers
D.
Let each system be an owner of data it generates.
D.
Let each system be an owner of data it generates.
Answers
Suggested answer: B

Explanation:

A master data management (MDM) strategy for customer data can help UC ensure that all systems have access to the same customer information, without loading or duplicating data in all systems. An MDM strategy can also help UC avoid data conflicts and inconsistencies that may arise from having multiple systems as owners of data.

Universal Containers uses Apex jobs to create leads in Salesforce. The business team has requested that lead creation failures should be reported to them.

Which option does Apex provide to report errors from this Apex job?

A.
Use Custom Object to store leads, and allow unprocessed leads to be reported.
A.
Use Custom Object to store leads, and allow unprocessed leads to be reported.
Answers
B.
Save Apex errors in a custom object, and allow access to this object for reporting.
B.
Save Apex errors in a custom object, and allow access to this object for reporting.
Answers
C.
Use Apex services to email failures to business when error occurs.
C.
Use Apex services to email failures to business when error occurs.
Answers
D.
Use AppExchange package to clean lead information before Apex job processes them.
D.
Use AppExchange package to clean lead information before Apex job processes them.
Answers
Suggested answer: C

Explanation:

saving Apex errors in a custom object can be a way to report errors from an Apex job. The article provides an example of how to create a custom object called AsyncApexError__c and use a trigger to insert error records into it. The custom object can then be used for reporting or notification purposes.

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.
A.
Create multiple similar products and distribute the skew across those products.
Answers
B.
Change the lookup relationship to master-detail relationship.
B.
Change the lookup relationship to master-detail relationship.
Answers
C.
Create a custom object to maintain the relationship between products and customers.
C.
Create a custom object to maintain the relationship between products and customers.
Answers
D.
Select Clear the value of this field option while configuring the lookup relationship.
D.
Select Clear the value of this field option while configuring the lookup relationship.
Answers
Suggested 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.

Northern Trail Outfitters would like to report on the type of customers. A custom field for customer type was created in Account object. Users need to be limited to the following defined choices when entering information in this field:

1. High Value

2. Medium Value

3. Low Value

Which strategy should a data architect recommend to configure customer type?

A.
Lookup to a custom object with defined choices.
A.
Lookup to a custom object with defined choices.
Answers
B.
Single-select restricted picklist with defined choices.
B.
Single-select restricted picklist with defined choices.
Answers
C.
Provide help text to guide users with defined choices.
C.
Provide help text to guide users with defined choices.
Answers
D.
Create a validation rule to limit entry to defined choices.
D.
Create a validation rule to limit entry to defined choices.
Answers
Suggested answer: B

Explanation:

single-select restricted picklist with defined choices can be a way to configure customer type. The article states that picklists are fields that allow users to select one or more predefined values from a list, and restricted picklists ensure that users can only select from the defined values. This can help to limit the choices for customer type and ensure data quality.

Northern Trail Outfitters needs to implement an archive solution for Salesforce dat

a. This archive solution needs to help NTO do the following:

1. Remove outdated Information not required on a day-to-day basis.

2. Improve Salesforce performance.

Which solution should be used to meet these requirements?

A.
Identify a location to store archived data and use scheduled batch jobs to migrate and purge the aged data on a nightly basis,
A.
Identify a location to store archived data and use scheduled batch jobs to migrate and purge the aged data on a nightly basis,
Answers
B.
Identify a location to store archived data, and move data to the location using a time-based workflow.
B.
Identify a location to store archived data, and move data to the location using a time-based workflow.
Answers
C.
Use a formula field that shows true when a record reaches a defined age and use that field to run a report and export a report into SharePoint.
C.
Use a formula field that shows true when a record reaches a defined age and use that field to run a report and export a report into SharePoint.
Answers
D.
Create a full copy sandbox, and use it as a source for retaining archived data.
D.
Create a full copy sandbox, and use it as a source for retaining archived data.
Answers
Suggested answer: A

Explanation:

Identifying a location to store archived data and using scheduled batch jobs to migrate and purge the aged data on a nightly basis can be a way to meet the requirements for an archive solution. The article provides a use case of how to use Heroku Connect, Postgres, and Salesforce Connect to archive old data, free up space in the org, and still retain the option to unarchive the data if needed. The article also explains how this solution can improve Salesforce performance and meet data retention policies.

Total 260 questions
Go to page: of 26