Salesforce Certified Data Architecture Practice Test

Which three characteristics of a Skinny table aid in enhancing report and query performance?

1. Skinny tables can contain frequently used fields and thereby help avoid joins.

2. Skinny tables can be used to create custom indexes on multi-select picklist fields.

3. Skinny tables provide a view across multiple objects for easy access to combined data.

4. Skinny tables do not include records that are available in the recycle bin.

The correct answer is: Skinny tables can contain frequently used fields and thereby help avoid joins.

The chosen characteristic emphasizes that skinny tables enhance report and query performance primarily by containing frequently used fields. This design minimizes the need for complex joins across multiple tables, which can significantly slow down query performance. By consolidating commonly accessed data into a single table, skinny tables streamline data access and retrieval. Users can run reports more efficiently because the system doesn't have to process multiple joins, which can complicate and slow down queries. The other characteristics, while they may offer some related benefits, do not directly contribute to enhancing performance in the same way. Custom indexes on multi-select picklist fields, although useful, do not guarantee performance improvements for general queries like the presence of frequently used fields and avoidance of joins. A view across multiple objects may simplify access, but it does not inherently improve the performance of report generation and query execution. Lastly, not including records in the recycle bin pertains more to data visibility rather than performance. Focusing on frequently accessed fields and reducing the complexity of data retrieval through fewer joins is the key factor in enhancing performance with skinny tables.