ExamGecko
Question list
Search
Search

List of questions

Search

Related questions











Question 107 - Certified Data Architect discussion

Report
Export

What makes Skinny tables fast? Choose three answers.

A.
They do not include soft-deleted records
Answers
A.
They do not include soft-deleted records
B.
They avoid resource intensive joins
Answers
B.
They avoid resource intensive joins
C.
Their tables are kept in sync with their source tables when the source tables are modified
Answers
C.
Their tables are kept in sync with their source tables when the source tables are modified
D.
They can contain fields from other objects
Answers
D.
They can contain fields from other objects
E.
They support up to a max of 100 of columns
Answers
E.
They support up to a max of 100 of columns
Suggested answer: A, B, C

Explanation:

Skinny tables are custom tables that contain frequently used fields from a standard or custom object. They are used to improve performance by reducing the number of database joins required for queries.Skinny tables have the following characteristics1:

They do not include soft-deleted records, which means they only contain active records and save space.

They avoid resource intensive joins by storing data from multiple objects in one table, which reduces the query time and complexity.

Their tables are kept in sync with their source tables when the source tables are modified, which ensures data consistency and accuracy.

asked 23/09/2024
Johny Nguyen
29 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first