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….
- Rowstore indexes
- Columnstore indexes
- Implicit conversions
- Computed columns
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
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
- Data file
- Log file
- Error file
- Filegroup
Q9. You can back up a filegroup from one database and restore it to another– and it’s supported.
- True
- 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