ExamGecko
Home Home / Salesforce / Certified Data Architect

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

Question list
Search
Search

List of questions

Search

Related questions











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
A.
Load only the data that the users is permitted to access
Answers
B.
Add custom indexes on frequently searched account and contact objects fields
B.
Add custom indexes on frequently searched account and contact objects fields
Answers
C.
Limit data loading to the 2000 most recently created records.
C.
Limit data loading to the 2000 most recently created records.
Answers
D.
Create a skinny table to represent account and contact objects.
D.
Create a skinny table to represent account and contact objects.
Answers
Suggested 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.

Universal Containers is experiencing frequent and persistent group membership locking issues that severely restricts its ability to manage manual and a automated updates at the same time.

What should a data architect do in order to restore the issue?

A.
Enable granular locking
A.
Enable granular locking
Answers
B.
Enable parallel sharing rule calculation.
B.
Enable parallel sharing rule calculation.
Answers
C.
Enable defer sharing calculation
C.
Enable defer sharing calculation
Answers
D.
Enable implicit sharing
D.
Enable implicit sharing
Answers
Suggested answer: A

Explanation:

Enabling granular locking allows concurrent sharing rule calculations and group membership updates to run without locking each other1. This can help resolve the group membership locking issues that UC is experiencing.

UC needs to load a large volume of leads into salesforce on a weekly basis. During this process the validation rules are disabled.

What should a data architect recommend to ensure data quality is maintained in salesforce.

A.
Activate validation rules once the leads are loaded into salesforce to maintain quality.
A.
Activate validation rules once the leads are loaded into salesforce to maintain quality.
Answers
B.
Allow validation rules to be activated during the load of leads into salesforce.
B.
Allow validation rules to be activated during the load of leads into salesforce.
Answers
C.
Develop custom APEX batch process to improve quality once the load is completed.
C.
Develop custom APEX batch process to improve quality once the load is completed.
Answers
D.
Ensure the lead data is preprocessed for quality before loading into salesforce.
D.
Ensure the lead data is preprocessed for quality before loading into salesforce.
Answers
Suggested answer: D

Explanation:

Ensuring the lead data is preprocessed for quality before loading into Salesforce is the best way to maintain data quality2. Activating validation rules after the load or developing a custom Apex batch process may not catch all the errors or may require additional time and resources. Allowing validation rules to be activated during the load may cause failures or delays.

UC has one SF org (Org A) and recently acquired a secondary company with its own Salesforce org (Org B). UC has decided to keep the orgs running separately but would like to bidirectionally share opportunities between the orgs in near-real time.

Which 3 options should a data architect recommend to share data between Org A and Org B?

Choose 3 answers.

A.
Leverage Heroku Connect and Heroku Postgres to bidirectionally sync Opportunities.
A.
Leverage Heroku Connect and Heroku Postgres to bidirectionally sync Opportunities.
Answers
B.
Install a 3rd party AppExchange tool to handle the data sharing
B.
Install a 3rd party AppExchange tool to handle the data sharing
Answers
C.
Develop an Apex class that pushes opportunity data between orgs daily via the Apex schedule.
C.
Develop an Apex class that pushes opportunity data between orgs daily via the Apex schedule.
Answers
D.
Leverage middleware tools to bidirectionally send Opportunity data across orgs.
D.
Leverage middleware tools to bidirectionally send Opportunity data across orgs.
Answers
E.
Use Salesforce Connect and the cross-org adapter to visualize Opportunities into external objects
E.
Use Salesforce Connect and the cross-org adapter to visualize Opportunities into external objects
Answers
Suggested answer: A, D, E

Explanation:

Leveraging Heroku Connect and Heroku Postgres, middleware tools, or Salesforce Connect and the cross-org adapter are all viable options to share data between Org A and Org B in near-real time3. Installing a 3rd party AppExchange tool may not provide bidirectional sync or may have additional costs. Developing an Apex class that pushes opportunity data between orgs daily via the Apex schedule may not meet the near-real time requirement.

Universal container (UC) would like to build a Human resources application on Salesforce to manage employee details, payroll, and hiring efforts. To adequately and store the relevant data, the application will need to leverage 45 custom objects. In addition to this, UC expects roughly 20,00 API calls into Salesfoce from an n-premises application daily.

Which license type should a data architect recommend that best fits these requirements?

A.
Service Cloud
A.
Service Cloud
Answers
B.
Lightning platform Start
B.
Lightning platform Start
Answers
C.
Lightning Platform plus
C.
Lightning Platform plus
Answers
D.
Lightning External Apps Starts
D.
Lightning External Apps Starts
Answers
Suggested answer: C

Explanation:

Lightning Platform Plus is the license type that best fits UC's requirements, as it allows up to 50 custom objects and 40,000 API calls per user per 24-hour period4. Service Cloud does not provide enough custom objects or API calls. Lightning Platform Start only allows up to 10 custom objects and 5,000 API calls per user per 24-hour period. Lightning External Apps Start is for external users and does not provide enough API calls.

Universal Container (UC) has accumulated data over years and has never deleted data from its Salesforce org. UC is now exceeding the storage allocations in the org. UC is now looking for option to delete unused from the org.

Which three recommendations should a data architect make is order to reduce the number of records from the org?

Choose 3 answers

A.
Use hard delete in Bulk API to permanently delete records from Salesforce.
A.
Use hard delete in Bulk API to permanently delete records from Salesforce.
Answers
B.
Use hard delete in batch Apex to permanently delete records from Salesforce.
B.
Use hard delete in batch Apex to permanently delete records from Salesforce.
Answers
C.
Identify records in objects that have not been modified or used In last 3 years.
C.
Identify records in objects that have not been modified or used In last 3 years.
Answers
D.
Use Rest API to permanently delete records from the Salesforce org.
D.
Use Rest API to permanently delete records from the Salesforce org.
Answers
E.
Archive the records in enterprise data warehouse (EDW) before deleting from Salesforce.
E.
Archive the records in enterprise data warehouse (EDW) before deleting from Salesforce.
Answers
Suggested answer: A, C, E

Explanation:

Using hard delete in Bulk API, identifying records that have not been modified or used in last 3 years, and archiving the records in EDW before deleting from Salesforce are all good recommendations to reduce the number of records from the org1.Using hard delete in batch Apex or Rest API may not be as efficient or scalable as Bulk API

A casino is implementing salesforce and is planning to build a customer 360 view for a customer who visits its resorts. The casino currently maintained the following systems that records customer activity:

1. Point of sales system: All purchases for a customer.

2. Salesforce: All customer service activity and sales activity for a customer.

3. Mobile app: All bookings, preferences and browser activity for a customer.

4. Marketing: All email, SMS and social campaigns for a customer.

Customer service agents using salesforce would like to view the activities from all system to provide supports to customers. The information has to be current and real time.

What strategy should the data architect implement to satisfy this requirement?

A.
Explore external data sources in salesforce to build 360 view of customer.
A.
Explore external data sources in salesforce to build 360 view of customer.
Answers
B.
Use a customer data mart to view the 360 view of customer.
B.
Use a customer data mart to view the 360 view of customer.
Answers
C.
Migrate customer activities from all 4 systems into salesforce.
C.
Migrate customer activities from all 4 systems into salesforce.
Answers
D.
Periodically upload summary information in salesforce to build 360 view.
D.
Periodically upload summary information in salesforce to build 360 view.
Answers
Suggested answer: A

Explanation:

Exploring external data sources in Salesforce to build 360 view of customer is the best strategy to satisfy the requirement, as it allows real-time access to data from other systems without storing it in Salesforce3. Using a customer data mart may not provide real-time information or may require additional integration efforts. Migrating customer activities from all 4 systems into Salesforce may exceed the storage limits or cause data quality issues. Periodically uploading summary information in Salesforce may not provide current or detailed information.

During the implementation of Salesforce, a customer has the following requirements for Sales Orders:

1. Sales Order information needs to be shown to users in Salesforce.

2. Sales Orders are maintained in the on-premises enterprise resource planning (ERP).

3. Sales Order information has more than 150 million records.

4. Sales Orders will not be updated in Salesforce.

What should a data architect recommend for maintaining Sales Orders in salesforce?

A.
Us custom objects to maintain Sales Orders in Salesforce.
A.
Us custom objects to maintain Sales Orders in Salesforce.
Answers
B.
Use custom big objects to maintain Sales Orders in Salesforce.
B.
Use custom big objects to maintain Sales Orders in Salesforce.
Answers
C.
Use external objects to maintain Sales Order in Salesforce.
C.
Use external objects to maintain Sales Order in Salesforce.
Answers
D.
Use Standard order object to maintain Sale Orders in Salesforce
D.
Use Standard order object to maintain Sale Orders in Salesforce
Answers
Suggested answer: C

Explanation:

Using external objects to maintain Sales Order in Salesforce is the best recommendation for maintaining Sales Orders in Salesforce, as it allows users to access large volumes of data stored outside Salesforce without copying or synchronizing it. Using custom objects, custom big objects, or standard order object may not be feasible or optimal for storing more than 150 million records that will not be updated in Salesforce.

Universal Containers (UC) has a very large and complex Salesforce org with hundreds of validation rules and triggers. The triggers are responsible for system updates and data manipulation as records are created or updates by users. A majority of the automation tool within UC'' org were not designed to run during a data load. UC is importing 100,000 records into Salesforce across several objects over the weekend.

What should a data architect do to mitigate any unwanted results during the import?

A.
Ensure validation rules, triggers and other automation tools are disabled.
A.
Ensure validation rules, triggers and other automation tools are disabled.
Answers
B.
Ensure duplication and matching rules and defined.
B.
Ensure duplication and matching rules and defined.
Answers
C.
Import the data in smaller batches over a 24-hour period.
C.
Import the data in smaller batches over a 24-hour period.
Answers
D.
Bulkily the trigger to handle import leads.
D.
Bulkily the trigger to handle import leads.
Answers
Suggested answer: A

Explanation:

Ensuring validation rules, triggers and other automation tools are disabled is the best way to mitigate any unwanted results during the import, as it prevents any errors or conflicts that may occur due to the existing logic. Ensuring duplication and matching rules are defined may not be sufficient or relevant for preventing unwanted results. Importing the data in smaller batches over a 24-hour period may not be necessary or efficient. Bulkifying the trigger to handle import leads may not be possible or desirable if the triggers were not designed to run during a data load.

Universal Container require all customers to provide either a phone number of an email address when registering for an account.

What should the data architect use to ensure this requirement is met?

A.
validation Rule
A.
validation Rule
Answers
B.
required Fields
B.
required Fields
Answers
C.
Apex Class
C.
Apex Class
Answers
D.
Process Builder
D.
Process Builder
Answers
Suggested answer: A

Explanation:

Using a validation rule is the best way to ensure that all customers provide either a phone number or an email address when registering for an account, as it allows defining a formula that evaluates whether a record meets certain criteria. Using required fields may not work if both phone number and email address are required. Using an Apex class or a Process Builder may be more complex or cumbersome than using a validation rule.

Total 260 questions
Go to page: of 26