Quiz on performance and table partitioning

Q1. Fill in the blank

The correct word is singular, not plural.

The partitioning key will be added to the _________  of an aligned index on a partitioned table, if you do not specify it.

key

Q2. Fill in the blank

The answer has 11 letters.

When SQL Server is able to access only a subset of partitions in a table, it is called partition ________ .

elimination

Q3. Table partitioning may notably speed up queries when you are using….

  •  Rowstore indexes
  •  Columnstore indexes
  •  Implicit conversions
  •  Computed columns
Columnstore indexes

Q4. When you partition a table, how many columns can you choose at the partitioning key for the clustered index?

  •  One
  •  Up to 1,024
  •  Up to 8,192
  •  Up to three
One

Q5. Fill in the blank

The answer has seven letters.

If I create a non-partitioned index on a partitioned table, it is called non-  ___________.

aligned

Q6. Fill in the blank

The answer has six letters.

One thing that is often problematic with partitioned tables is creating __________  indexes on columns that are not the partitioning key.

unique

Q7. Fill in the blank

The answer has six letters.One place where partitioning shines is the ability to ___________ a partition of data in or out of the table.

switch

Q8. You can’t specify a specific partition with DBCC CHECKTABLE, but you can use a different command to check a

  •  Data file
  •  Log file
  •  Error file
  •  Filegroup
Filegroup

Q9. You can back up a filegroup from one database and restore it to another– and it’s supported.

  •  True
  •  False
False
Back to: Why Table Partitioning Does Not Speed Up Query Performance – With One Exception (52 minutes) > Quiz

Share a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Menu