gs gs116 Security - Data Cryptography - Quiz No.1
gs gs116 Microsoft SQL Server Quiz
This quiz belongs to book/course code gs gs116 Microsoft SQL Server of gs organization. We have 100 quizzes available related to the book/course Microsoft SQL Server. This quiz has a total of 10 multiple choice questions (MCQs) to prepare and belongs to topic Security. NVAEducation wants its users to help them learn in an easy way. For that purpose, you are free to prepare online MCQs and quizzes.
NVAEducation also facilitates users to contribute in online competitions with other students to make a challenging situation to learn in a creative way. You can create one to one, and group competition on an topic of a book/course code. Also on NVAEducation you can get certifications by passing the online quiz test.
Question 1: Which of the field must be 1 using an authenticator in the following code?
EncryptByKey ( key_GUID , { 'cleartext' | @cleartext } [, { add_authenticator | @add_authenticator } , { authenticator | @authenticator } ] )
@add_authenticator
@cleartext
key_GUID
None of the mentioned
Question 2: Point out the wrong statement.
EncryptByKey uses a symmetric key
EncryptByKey returns NULL if the key is not open
You can use encryption in SQL Server for connections, data, and stored procedures
All of the mentioned
Question 3: Which of the following script creates master key?
CREATE MASTER KEY BY PASSWORD='MyStrongPassword'; CREATE MASTER KEY ENCRYPTION BY PASSWORD='MyStrongPassword'; CREATE MASTER ENCRYPTION BY PASSWORD='MyStrongPassword';
All of the mentioned
Question 4: Which of the statement is used to create a new certificate with a valid subject in SQL Server?
CREATE CERTI MySQLCert WITH SUBJECT='MyDatabase DEK'; CREATE CERTIFICATE MySQLCert WITH SUBJECT='MyDatabase DEK'; CREATE CERTIFICATE MySQLCert WITH SUBJ='MyDatabase DEK';
None of the mentioned
Question 5: Point out the wrong statement.
Encryption should be considered for all data or connections
Any use of encryption should also include a maintenance strategy for passwords, keys, and certificates
TDE is essentially an enterprise-oriented feature and is available only in the following editions of SQL Server
None of the mentioned
Question 6: Like data compression, TDE database encryption is performed at the ______ level.
Page
Domain
Column
Row
Question 7: Which of the following is valid code to backup a certificate?
USE Master GO BACKUP CERTIFICATE MySQLCert TO FILE = 'C:\temp\MySQLCert' WITH PRIVATE KEY (file='C:\temp\MySQLCertKey', ENCRYPTION BY PASSWORD='MyStrongPassword2') USE Master GO BACK CERTIFICATE MySQLCert TO FILE = 'C:\temp\MySQLCert' WITH PRIVATE KEY (file='C:\temp\MySQLCertKey', ENCRYPTION BY PASSWORD='MyStrongPassword2') USE Master GO BACKUP CERTIFICATE MySQLCert TO FILE = 'C:\temp\MySQLCert' WITH PUBLIC KEY (file='C:\temp\MySQLCertKey', ENCRYPTION BY PASSWORD='MyStrongPassword2') USE Master GO BACKUP CERTIFICATE MySQLCert TO SUBJECT = 'C:\temp\MySQLCert' WITH PRIVATE KEY (file='C:\temp\MySQLCertKey', ENCRYPTION BY PASSWORD='MyStrongPassword2')
Question 8: Which of the following catalog view is used to monitor TDE?
sys.certificates
sys.certificate
DMVs
All of the mentioned
Question 9: ___________ encryption was introduced in SQL Server 2005 and is available in all editions of SQL Server.
Column-level Encryption
Transparent Data Encryption
BitLocker
None of the mentioned
Question 10: Which of the following functions decrypts data by using a symmetric key?
DECRYPTBYSYMKEY
DECRYPTBYKEYAUTOASYMKEY
DECRYPTBYASYMKEY
DECRYPTBYKEYAUTOCERT
Online Quizzes of gs116 Microsoft SQL Server
Developing with SQL Server - Error Handling - Quiz No.1
gs gs116
Microsoft SQL Server Online Quizzes
Laying the Foundation - Aggregation of Data - Quiz No.1
gs gs116
Microsoft SQL Server Online Quizzes
Laying the Foundation - Joins in SQL Server - Quiz No.1
gs gs116
Microsoft SQL Server Online Quizzes
Laying the Foundation - Views in SQL Server - Quiz No.1
gs gs116
Microsoft SQL Server Online Quizzes
