Quiz on performance and table partitioning

Grab a pen and notepad, and jot down your answers as you go, then check your answers at the key at the bottom of the page.

Questions

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.

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 ________ .

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

  1. Rowstore indexes
  2. Columnstore indexes
  3. Implicit conversions
  4. Computed columns

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

  1. One
  2. Up to 1,024
  3. Up to 8,192
  4. Up to three

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-  ___________.

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.

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.

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

  1. Data file
  2. Log file
  3. Error file
  4. Filegroup

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

  1. True
  2. False

Scroll down for the answer key :point_down:

  

  

  

  

  

  

  

  

  

  

  

  

  

  

  

  

  

  

  

  

Answer Key

  • A1. key
  • A2. elimination
  • A3. 2. Columnstore indexes
  • A4. 1. One
  • A5. aligned
  • A6. unique
  • A7. switch
  • A8. 4. Filegroup
  • A9. 2. False