Skinny Tables Flashcards
What is a skinny table?
A custom table that uses a subset of fields.
How is a skinny table created?
By contacting Salesforce support
True/False:
A skinny table can be created on the following Object: Account Contact Lead Opportunity Case
True
True/False:
A skinny table can be created on any custom Object?
True
True/False:
A skinny table can contain a checkbox and a date field?
true
True/False:
A skinny table can contain a datetime field?
true
True/False:
A skinny table can contain email, number, percent, and phone fields?
true
True/False:
A skinny table can contain a URL field?
true
What text type fields can be added to a skinny table?
Text
Text Area
Text Area (long)
True/False:
Skinny tables can contain encrypted data?
true
True/False:
Skinny indexes can contain encrypted data?
true
What is the maximum number of columns allowed on a skinny table?
100
True/False:
Skinny Tables can contain fields on other objects?
false
True/False:
Skinny tables are copied to Full sandboxes?
true
True/False:
Skinny tables are copied to developer/dev pro sandboxes?
false
True/False:
Skinny tables are copied to partial copy sandboxes?
false
What advantage, in terms of the number of rows, does a skinny table provide?
Skinny tables may return more rows per DB fetch, increasing throughput when reading from a large table
T/F: Skinny Tables include soft-deleted rows.
false
T/F: Skinny tables include custom indexes from the base table.
true
Under what condition is a skinny table most useful?
When the base object contains millions of rows.
In what modalities does skinny table offer a benefit?
In SOQL, Reports and List Views.
If Skinny tables are implemented and used for a report, and the report must be modified to include a new field, what must happen?
Contact SF support to have the field added to the table
T/F: altering the data type on a base table invalidates the skinny table.
True
What advantage, in terms of its structure, does a skinny table provide?
A skinny table does not need to join to retrieve standard and custom fields in the underlying metadata architecture.
T/F: A skinny table can contain a CLOB
False
T/F: A skinny table can contain a lookup field
False
