WHAT IS THE QUERY PERFORMANCE IMPACT WHEN USING CELL-LEVEL ENCRYPT...

12. What is the query performance impact when using cell-level encryption?

A. There is a positive query performance impact since there are only specific

columns that are encrypted.

B. There is a negative query performance impact since data types have to be

converted from varbinary to the correct data type and primary keys and

indexes are not used, resulting in full table scans.

C. There is a negative query performance impact unless TDE has been

enabled.

D. There is a positive query performance impact as long as TDE has been

The correct answer is B. Answers A, C, and D are incorrect since these con-

figurations would not have an impact on query performance.