Skinny Tables

Question 1

What is a skinny table?

Answer 1

A custom table that uses a subset of fields.

Question 2

How is a skinny table created?

Answer 2

By contacting Salesforce support

Question 3

True/False:

A skinny table can be created on the following Object:
Account
Contact
Lead
Opportunity
Case

Answer 3

True

Question 4

True/False:

A skinny table can be created on any custom Object?

Answer 4

True

Question 5

True/False:

A skinny table can contain a checkbox and a date field?

Answer 5

true

Question 6

True/False:

A skinny table can contain a datetime field?

Answer 6

true

Question 7

True/False:

A skinny table can contain email, number, percent, and phone fields?

Answer 7

true

Question 8

True/False:

A skinny table can contain a URL field?

Answer 8

true

Question 9

What text type fields can be added to a skinny table?

Answer 9

Text
Text Area
Text Area (long)

Question 10

True/False:

Skinny tables can contain encrypted data?

Answer 10

true

Question 11

True/False:

Skinny indexes can contain encrypted data?

Answer 11

true

Question 12

What is the maximum number of columns allowed on a skinny table?

Answer 12

100

Question 13

True/False:

Skinny Tables can contain fields on other objects?

Answer 13

false

Question 14

True/False:

Skinny tables are copied to Full sandboxes?

Answer 14

true

Question 15

True/False:

Skinny tables are copied to developer/dev pro sandboxes?

Answer 15

false

Question 16

True/False:

Skinny tables are copied to partial copy sandboxes?

Answer 16

false

Question 17

What advantage, in terms of the number of rows, does a skinny table provide?

Answer 17

Skinny tables may return more rows per DB fetch, increasing throughput when reading from a large table

Question 18

T/F: Skinny Tables include soft-deleted rows.

Answer 18

false

Question 19

T/F: Skinny tables include custom indexes from the base table.

Answer 19

true

Question 20

Under what condition is a skinny table most useful?

Answer 20

When the base object contains millions of rows.

Question 21

In what modalities does skinny table offer a benefit?

Answer 21

In SOQL, Reports and List Views.

Question 22

If Skinny tables are implemented and used for a report, and the report must be modified to include a new field, what must happen?

Answer 22

Contact SF support to have the field added to the table

Question 23

T/F: altering the data type on a base table invalidates the skinny table.

Answer 23

True

Question 24

What advantage, in terms of its structure, does a skinny table provide?

Answer 24

A skinny table does not need to join to retrieve standard and custom fields in the underlying metadata architecture.

Question 25

T/F: A skinny table can contain a CLOB

Answer 25

False

Question 26

T/F: A skinny table can contain a lookup field

Answer 26

False