Question

Point out the wrong statement.

(a) Computed columns that participate in a partition function must be explicitly marked PERSISTED

(b) The new, higher limit of 15,000 partitions affects memory, partitioned index operations, DBCC commands, and queries

(c) Partitioning column is the process by which the query optimizer accesses only the relevant partitions to satisfy the filter criteria of the query

(d) All of the mentioned

This question was posed to me during an online exam.

This interesting question is from Partitioning topic in portion Performance Tuning and Optimization of SQL Server

Answer 1

The correct choice is (c) Partitioning column is the process by which the query optimizer accesses only the relevant partitions to satisfy the filter criteria of the query

For explanation I would say: Partition elimination is the process by which the query optimizer accesses only the relevant partitions to satisfy the filter criteria of the query.