QuestionQ87

VerifiedImplement a secure environment

You have a SQL Server instance on Azure Virtual Machines named SQL1. SQL1 contains a database named DB1.

You need to enable Transparent Data Encryption (TDE) for DB1.

Which three objects must you create in sequence?

Drag & Drop
1
2
3
Explanation

For SQL Server TDE, the DEK is created in the user database and encrypted by a server certificate in the master database. The certificate is protected by the database master key in master. The required creation order is therefore the master database master key, the master database certificate, and the DB1 database encryption key.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!