ExamGecko
Question list
Search
Search

List of questions

Search

Related questions











Question 50 - Certified Data Architect discussion

Report
Export

DreamHouse Realty has a data model as shown in the image. The Project object has a private sharing model, and it has Roll-Up summary fields to calculate the number of resources assigned to the project, total hours for the project, and the number of work items associated to the project.

There will be a large amount of time entry records to be loaded regularly from an external system into Salesforce.

What should the Architect consider in this situation?

A.
Load all data after deferring sharing calculations.
Answers
A.
Load all data after deferring sharing calculations.
B.
Calculate summary values instead of Roll-Up by using workflow.
Answers
B.
Calculate summary values instead of Roll-Up by using workflow.
C.
Calculate summary values instead of Roll-Up by using triggers.
Answers
C.
Calculate summary values instead of Roll-Up by using triggers.
D.
Load all data using external IDs to link to parent records.
Answers
D.
Load all data using external IDs to link to parent records.
Suggested answer: A

Explanation:

According to the exam guide, one of the objectives is to 'describe the use cases and considerations for deferring sharing calculations'1. This implies that option A is the correct way to load large amounts of data into Salesforce without affecting performance and data integrity.Deferring sharing calculations allows the data to be loaded first and then the sharing rules to be applied later2.Option B is not correct because workflows are not recommended for calculating summary values, as they can cause performance issues and data skew3. Option C is not correct because triggers are also not recommended for calculating summary values, as they can cause governor limit errors and data inconsistency. Option D is not correct because external IDs are used to link records from different systems, not to improve data loading performance.

asked 23/09/2024
Djordje Novakovic
36 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first