DRAG DROP
You administer a Microsoft SQL Server 2008 R2 database named
AdventureWorks2008R2 that hosts a credit card-processing application.
You need to implement transparent data encryption.
Which four Transact-SQL statements should you use? (To answer, move the appropriate
SQL statements from the list of statements to the answer area and arrange them in the
correct order.)

Answer:

Explanation:

Note:
* Using Transparent Data Encryption To use TDE, follow these steps. Create a master key
Create or obtain a certificate protected by the master key Create a database encryption key
and protect it by the certificate Set the database to use encryption
The following example illustrates encrypting and decrypting the AdventureWorks2012
database using a certificate installed on the server named MyServerCert. USE master; GO
CREATE MASTER KEY ENCRYPTION BY PASSWORD = ‘<UseStrongPasswordHere>’; go
CREATE CERTIFICATE MyServerCert WITH SUBJECT = ‘My DEK Certificate’; go USE
AdventureWorks2012; GO CREATE DATABASE ENCRYPTION KEY WITH ALGORITHM =
AES_128 ENCRYPTION BY SERVER CERTIFICATE MyServerCert; GO ALTER
DATABASE AdventureWorks2012 SET ENCRYPTION ON; GO
Transparent
Data Encryption (TDE)