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 ________ .elimination
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?
- 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- ___________.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
Q9. You can back up a filegroup from one database and restore it to another– and it’s supported.