ExamGecko
Home Home / Salesforce / Certified Data Architect

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

Question list
Search
Search

List of questions

Search

Related questions











Northern Trail Outfitters (NTO) has recently implemented Salesforce to track opportunities across all their regions. NTO sales teams across all regions have historically managed their sales process in Microsoft Excel. NTO sales teams are complaining that their data from the Excel files were not migrated as part of the implementation and NTO is now facing low Salesforce adoption.

What should a data architect recommend to increase Salesforce adoption?

A.
Use the Excel connector to Salesforce to sync data from individual Excel files.
A.
Use the Excel connector to Salesforce to sync data from individual Excel files.
Answers
B.
Define a standard mapping and train sales users to import opportunity data.
B.
Define a standard mapping and train sales users to import opportunity data.
Answers
C.
Load data in external database and provide access to database to sales users.
C.
Load data in external database and provide access to database to sales users.
Answers
D.
Create a chatter group and upload all Excel files to the group.
D.
Create a chatter group and upload all Excel files to the group.
Answers
Suggested answer: B

Explanation:

According to Trailhead2, one of the best practices to increase Salesforce adoption is to migrate existing data from legacy systems or spreadsheets into Salesforce, so that users can access all their data in one place and leverage the features and functionality of Salesforce. Option B is the correct answer because it suggests defining a standard mapping and training sales users to import opportunity data from Excel files into Salesforce, which can help them transition from their old process and increase their confidence and satisfaction with Salesforce. Option A is incorrect because using the Excel connector to Salesforce does not migrate the data into Salesforce, but only syncs it between Excel and Salesforce, which can cause data inconsistency and duplication issues. Option C is incorrect because loading data in an external database and providing access to it does not increase Salesforce adoption, but rather creates another system for users to manage and switch between. Option D is incorrect because creating a chatter group and uploading all Excel files to it does not migrate the data into Salesforce, but only stores it as attachments, which cannot be used for reporting or analysis purposes.

Universal Containers (UC) manages Vehicle and Service History in Salesforce. Vehicle (Vehicle__ c) and

Service History (Service-History__ c) are both custom objects related through a lookup relationship.

Every week a batch synchronization process updates the Vehicle and Service History records in Salesforce. UC has two hours of migration window every week and is facing locking issues as part of the data migration process.

What should a data architect recommend to avoid locking issues without affecting performance of data migration?

A.
Use Bulk API parallel mode for data migration
A.
Use Bulk API parallel mode for data migration
Answers
B.
Use Bulk API serial mode for data migration
B.
Use Bulk API serial mode for data migration
Answers
C.
Insert the order in another custom object and use Batch Apex to move the records to Service_ Order__ c object.
C.
Insert the order in another custom object and use Batch Apex to move the records to Service_ Order__ c object.
Answers
D.
Change the lookup configuration to 'Clear the value of this field' when lookup record is deleted.
D.
Change the lookup configuration to 'Clear the value of this field' when lookup record is deleted.
Answers
Suggested answer: B

Explanation:

According to the official Salesforce guide1, using Bulk API serial mode for data migration can help avoid locking issues by processing batches in a single thread. This mode ensures that batches are processed in the order they are received and that only one batch is processed at a time. This reduces the risk of lock contention and deadlocks, especially when updating parent and child records in a lookup relationship. Option B is the correct answer because it suggests using Bulk API serial mode for data migration. Option A is incorrect because using Bulk API parallel mode for data migration can cause locking issues by processing batches in multiple threads. This mode does not guarantee the order of batch processing and can result in concurrent updates to the same records, which can lead to lock contention and deadlocks. Option C is incorrect because inserting the order in another custom object and using Batch Apex to move the records to Service_Order__c object adds unnecessary complexity and overhead to the data migration process. Option D is incorrect because changing the lookup configuration to ''Clear the value of this field'' when lookup record is deleted does not address the locking issues caused by data migration, but rather by record deletion.

Northern Trail Outfitters (NTO) has an external product master system that syncs product and pricing information with Salesforce. Users have been complaining that they are seeing discrepancies in product and pricing information displayed on the NTO website and Salesforce.

As a data architect, which action is recommended to avoid data sync issues?

A.
Build a custom integration for two-way sync of product and pricing information between product master to Salesforce.
A.
Build a custom integration for two-way sync of product and pricing information between product master to Salesforce.
Answers
B.
Build a custom integration for one-way sync of product and pricing information from product master to Salesforce.
B.
Build a custom integration for one-way sync of product and pricing information from product master to Salesforce.
Answers
C.
Implement a manual process to update the products from an extract from the products master on a weekly basis.
C.
Implement a manual process to update the products from an extract from the products master on a weekly basis.
Answers
D.
Use the Customer 360 data manager to sync product and pricing information from product master database to Salesforce.
D.
Use the Customer 360 data manager to sync product and pricing information from product master database to Salesforce.
Answers
Suggested answer: D

Explanation:

According to Trailhead2, Customer 360 Data Manager is a feature that allows administrators to connect, reconcile, and share customer data across Salesforce orgs and external systems. Customer 360 Data Manager can sync product and pricing information from product master database to Salesforce using predefined mappings and rules, ensuring data quality and consistency. Option D is the correct answer because it suggests using Customer 360 Data Manager to sync product and pricing information from product master database to Salesforce. Option A is incorrect because building a custom integration for two-way sync of product and pricing information between product master and Salesforce can introduce data conflicts and duplication issues, as both systems can update the same data independently. Option B is incorrect because building a custom integration for one-way sync of product and pricing information from product master to Salesforce can be costly and time-consuming, as it requires custom development and maintenance. Option C is incorrect because implementing a manual process to update the products from an extract from the products master on a weekly basis can result in data latency and errors, as the products information may change more frequently than once a week.

Universal Containers (UC) has 50 million customers and stores customer order history on an ERP system. UC also uses Salesforce to manage opportunities and customer support.

In order to provide seamless customer support, UC would like to see the customer's order history when viewing the customer record during a sales or support call.

What should a data architect do in order to provide this functionality, while preserving the user experience?

A.
Use an Apex callout to populate a text area field for displaying the order history.
A.
Use an Apex callout to populate a text area field for displaying the order history.
Answers
B.
Use Salesforce Connect and an external object to display the order history in Salesforce
B.
Use Salesforce Connect and an external object to display the order history in Salesforce
Answers
C.
Import the order history into a custom Salesforce object, update nightly
C.
Import the order history into a custom Salesforce object, update nightly
Answers
D.
Embed the ERP system in an iframe and display on a custom tab.
D.
Embed the ERP system in an iframe and display on a custom tab.
Answers
Suggested answer: B

Explanation:

According to Trailhead2, Salesforce Connect is a feature that allows administrators to integrate external data sources with Salesforce without copying or synchronizing the data. Salesforce Connect can use external objects to display the external data in Salesforce as if it were stored in Salesforce objects, enabling seamless user experience and real-time access. Option B is the correct answer because it suggests using Salesforce Connect and an external object to display the order history in Salesforce. Option A is incorrect because using an Apex callout to populate a text area field for displaying the order history can be inefficient and unreliable, as it requires making an HTTP request for each customer record and storing the order history as unstructured text. Option C is incorrect because importing the order history into a custom Salesforce object, update nightly can consume a lot of storage space and cause data latency, as the order history may change more frequently than once a night. Option D is incorrect because embedding the ERP system in an iframe and displaying on a custom tab can degrade the user experience and security, as it requires switching between tabs and authenticating with another system.

A large automobile manufacturer has decided to use Salesforce as its CRM. It needs to maintain the following dealer types in their CRM:

Local dealers

Regional distributor

State distributor

Service dealer

The attributes are different for each of the customer types. The CRM users should be allowed to enter only attributes related to the customer types. The processes and business rules for each of the customer types could be different.

How should the different dealers be maintained in Salesforce?

A.
Use Accounts for dealers, and create record types for each of the dealer types.
A.
Use Accounts for dealers, and create record types for each of the dealer types.
Answers
B.
Create dealers as Accounts, and build custom views for each of the dealer types.
B.
Create dealers as Accounts, and build custom views for each of the dealer types.
Answers
C.
Use Accounts for dealers and custom picklist field for each of the dealer types
C.
Use Accounts for dealers and custom picklist field for each of the dealer types
Answers
D.
Create Custom objects for each dealer types and custom fields for dealer attributes.
D.
Create Custom objects for each dealer types and custom fields for dealer attributes.
Answers
Suggested answer: A

Explanation:

According to Trailhead2, record types are a feature that allows administrators to create different business processes, page layouts, and picklist values for different types of records within an object. Record types can be used to maintain different dealer types in Salesforce by creating record types for each of the dealer types and assigning them appropriate attributes, processes, and rules. Option A is the correct answer because it suggests using Accounts for dealers, and creating record types for each of the dealer types. Option B is incorrect because creating dealers as Accounts, and building custom views for each of the dealer types does not allow CRM users to enter only attributes related to the customer types, nor does it enable different processes and business rules for each of the customer types. Option C is incorrect because using Accounts for dealers and custom picklist field for each of the dealer types does not allow CRM users to enter only attributes related to the customer types, nor does it enable different processes and business rules for each of the customer types. Option D is incorrect because creating Custom objects for each dealer types and custom fields for dealer attributes can be unnecessary and complex, as it requires creating multiple objects and relationships instead of using the standard Account object.

Universal Containers (UC) needs to move millions of records from an external enterprise resource planning (ERP) system into Salesforce.

What should a data architect recommend to be done while using the Bulk API in serial mode instead of parallel mode?

A.
Placing 20 batches on the queue for upset jobs.
A.
Placing 20 batches on the queue for upset jobs.
Answers
B.
Inserting 1 million orders distributed across a variety of accounts with potential lock exceptions.
B.
Inserting 1 million orders distributed across a variety of accounts with potential lock exceptions.
Answers
C.
Leveraging a controlled feed load with 10 batches per job.
C.
Leveraging a controlled feed load with 10 batches per job.
Answers
D.
Inserting 1 million orders distributed across a variety of accounts with lock exceptions eliminated and managed.
D.
Inserting 1 million orders distributed across a variety of accounts with lock exceptions eliminated and managed.
Answers
Suggested answer: B

Explanation:

According tothis article, inserting 1 million orders distributed across a variety of accounts with potential lock exceptions is a scenario where using the Bulk API in serial mode can help to prevent the lock contention issue that can occur in parallel mode.

A data architect is working with a large B2C retailer and needs to model the consumer account structure in Salesforce.

What standard feature should be selected in this scenario?

A.
Individual Accounts
A.
Individual Accounts
Answers
B.
Account Contact
B.
Account Contact
Answers
C.
Contacts
C.
Contacts
Answers
D.
Person Accounts
D.
Person Accounts
Answers
Suggested answer: D

Explanation:

According tothis article, person accounts are designed to store information about individual people by combining certain account and contact fields into a single record. This is suitable for a large B2C retailer that needs to model the consumer account structure in Salesforce.

Universal Containers (UC) has built a custom application on Salesforce to help track shipments around the world. A majority of the shipping records are stored on premise in an external data source. UC needs shipment details to be exposed to the custom application, and the data needs to be accessible in real time. The external data source is not OData enabled, and UC does not own a middleware tool.

Which Salesforce Connect procedure should a data architect use to ensure UC's requirements are met?

A.
Write an Apex class that makes a REST callout to the external API.
A.
Write an Apex class that makes a REST callout to the external API.
Answers
B.
Develop a process that calls an inviable web service method.
B.
Develop a process that calls an inviable web service method.
Answers
C.
Migrate the data to Heroku and register Postgres as a data source.
C.
Migrate the data to Heroku and register Postgres as a data source.
Answers
D.
Write a custom adapter with the Apex Connector Framework.
D.
Write a custom adapter with the Apex Connector Framework.
Answers
Suggested answer: D

Explanation:

According tothis article, the Apex Connector Framework enables developers to create custom adapters for Salesforce Connect to access data from external systems that are not OData enabled. This can meet UC's requirements of exposing shipment details to the custom application and accessing the data in real time.

Universal Containers is establishing a call center that will use Salesforce. UC receives 10 million calls and creates 100 million cases every month. Cases are linked to a custom call object using lookup relationship. UC would like to run reports and dashboard to better understand different case types being created on calls to better serve customers.

What solution should a data architect recommend to meet the business requirement?

A.
Archive records to a data warehouse and run analytics on the data warehouse.
A.
Archive records to a data warehouse and run analytics on the data warehouse.
Answers
B.
Leverage big objects to archive records and Einstein Analytics to run reports.
B.
Leverage big objects to archive records and Einstein Analytics to run reports.
Answers
C.
Leverage custom objects to store aggregate data and run analytics.
C.
Leverage custom objects to store aggregate data and run analytics.
Answers
D.
Leverage out-of-the-box reports and dashboard on case and interactive voice response (IVR) custom object.
D.
Leverage out-of-the-box reports and dashboard on case and interactive voice response (IVR) custom object.
Answers
Suggested answer: B

Explanation:

According tothis article, big objects can store and manage massive amounts of data on the Salesforce platform. This can help UC to archive records from other objects or bring massive datasets from outside systems into a big object. According tothis article, Einstein Analytics can be used to create dashboards and lenses to analyze big object data and get insights from advanced AI-driven analytics.

Universal Containers (UC) owns several Salesforce orgs across a variety of business units. UC management has declared that it needs the ability to report on Accounts and Opportunities from each org in one place. Once the data is brought together into a global view, management would like to use advanced Al-driven analytics on the dataset.

Which tool should a data architect recommend to accomplish this reporting requirement?

A.
Run standard reports and dashboards.
A.
Run standard reports and dashboards.
Answers
B.
Install a third-party AppExchange tool for multi-org reporting.
B.
Install a third-party AppExchange tool for multi-org reporting.
Answers
C.
Use Einstein Analytics for multi-org.
C.
Use Einstein Analytics for multi-org.
Answers
D.
Write a Python script to aggregate and visualize the data.
D.
Write a Python script to aggregate and visualize the data.
Answers
Suggested answer: C

Explanation:

According tothis article, Einstein Analytics for multi-org can help UC to report on accounts and opportunities from each org in one place. It can also provide advanced AI-driven analytics on the dataset using Einstein Discovery.

Total 260 questions
Go to page: of 26