MS Exam 70-764 Flashcards Preview

Programming > MS Exam 70-764 > Flashcards

Flashcards in MS Exam 70-764 Deck (21):
1

What type of key algorithm does

ENCRYPTBYKEY() use to encrypt data?

Symmetric

2

Name the T-SQL function that encrypts data when using Column-Level Encryption?

ENCRYPTBYKEY()

3

What does sys.column_master_keys return?

Returns a row for each database master key added by using the CREATE MASTER KEY statement. Each row represents a single column master key (CMK).

4

T-SQL for opening a symmetric key named Exam70764 by a password 'Pw'?

OPEN SYMMETRIC KEY Exam70764

DECRYPTION BY PASSWORD = 'Pw';

5

T-SQL for creating a symmetric key named Exam70764 with AES_256 and a password 'Pwd' ?

CREATE SYMMETRIC KEY CreditCardCert

WITH ALGORITHM = AES_256

ENCRYPTION BY PASSWORD = 'Pwd';

6

What is a Securable?

Any object or resouce in SQL Server that can have an action performed aginst it.

7

What are Permissions?

Are actions that can be performed aginst Securables

8

What are Principals?

Objects performing

9

Does Dynamic Data Masking (DDM) persist the data to disk with the mask applied?

No.

The mask is applied on outputs and data in the database is not changed.

10

What permission must a user have granted to see unmasked data?

The Unmask permission granted under the Database securables.

11

Dynamic Data Masking:
Adding, replacing, or removing the mask of a column requires what permission?

ALTER ANY MASK

12

Dynamic Data Masking

Ture or False: Using SELECT INTO or INSERT INTO to copy data from a masked column into another table will result in masked data in the target table?

True

13

Name the four Dynamic Data Masking functions.

  1. default()
  2. random()
  3. partial()
  4. email()

14

T-SQL for adding a Dynamic Data Mask to a show only the last four digits of the column CardNumber in the already existing table dbo.CreditCards

ALTER TABLE dbo.CreditCards

ALTER COLUMN CardNumber ADD MASK WITH (FUNCTION = 'partial(0, "XX..", 4)');

15

Which Dynamic Data Masking function will output a different mask depending on the data type of a column?

default()

16

Name the two special roles for SQL Database and SQL Data Warehouse and where those roles exist.

 These database roles exist only in the virtual master database under Security.Roles

1. dbmanager

2. loginmanager

 

17

T-SQL for creating and enabling a SQL Server Audit named DatabaseSpecToEventlog targeting the Application Log.

USE [master];

GO

CREATE SERVER AUDIT DatabaseSpecToEventlog
  TO APPLICATION_LOG;

GO

ALTER SERVER AUDIT DatabaseSpecToEventlog

WITH (STATE = ON);

GO

18

T-SQL for creating and enabling a Database Audit Specification named DatabaseOpsAudit mapped to the server audit DatabaseSpecToEventLog with

DATABASE_CHANGE_GROUP

DATABASE_OBJECT_CHANGE_GROUP

AUDIT_CHANGE_GROUP

CREATE DATABASE AUDIT SPECIFICATION DatabaseOpsAudit

FOR SERVER AUDIT DatabaseSpecToEventLog

  ADD (DATABASE_CHANGE_GROUP)

, ADD (DATABASE_OBJECT_CHANGE_GROUP)

, ADD (AUDIT_CHANGE_GROUP)

GO

19

True/False:

You can have multiple specifications linked to a single audit.

FALSE

20

Under the hood, what mechanisum does SQL Server Audits emply to capture events?

Extended Events

21

What three things will cause a new Server Audit file to be created?

  1. Anytime the db Engine Starts
  2. Disable/Endable Audit
  3. File size is maxed