問題文
The equipment serial number must be protected with Always Encrypted because plant operators should not see it, yet the shop-floor application still has to find one machine by its exact serial number using an index. Which configuration meets both needs?
選択肢
- Leave the column in plaintext and rely on transparent data encryption, which protects the column without changing how queries are written.
- Use randomized encryption on the serial number column and create a nonclustered index on it, since randomized encryption is the stronger option.
- Use deterministic encryption on the serial number column, which covers point lookups and equality joins, and create the index on that column.
- Leave the column in plaintext, add a dynamic data mask to it, and let the application keep using the existing index.