Which four Transact-SQL statements should you use?

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.)

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)



Leave a Reply 0

Your email address will not be published. Required fields are marked *