Multiple Choice Questions - Dynamic Data Masking
1. Dynamic data masking can be implemented by using the . . . . . . . syntax in either CREATE TABLE or an ALTER COLUMN statement.
A) MASK WITH
B) MASKED WITHIN
C) MASK WITHIN
D) MASKED WITH
2. Dynamic data masking works on a per-column level and is controlled by the . . . . . permission. Users with such permission will see unmasked data in the result set, while users without that permission will see obfuscated data.
A) MASK
B) UNMASK
C) ALTER
D) ALTER ANY MASK
3. A mask cannot be configured on a computed column, but if the computed column depends on a column with a MASK, then the computed column will return masked data.
A) True
B) False
4. The masking rule is controlled by the masking function. SQL Server RTM supports four masking functions namely:
A) default(), email(), random(), full()
B) default(), column(), random(), partial()
C) default(), email(), random(), partial()
D) default(), row(), random(), partial()
5. A masking rule cannot be defined for the following column types:
A) Encrypted columns (Always Encrypted)
B) Columns of type BIGINT
C) COLUMN_SET or a sparse column that is part of a column set.
D) FILESTREAM
6. In case of Dynamic data masking, a . . . . . or . . . . . can view the actual data.
A) sysadmin
B) db_owner
C) dbcreator
D) securityadmin
7. The purpose of dynamic data masking is to limit exposure of sensitive data, preventing users who should not have access to the data from viewing it.
A) True
B) False
8. In order to create a table with a dynamic data mask, only the standard . . . . . . . on schema permissions are needed.
A) CREATE TABLE and EXECUTE
B) CREATE TABLE and UPDATE
C) CREATE TABLE and ALTER
D) CREATE TABLE and CONTROL
9. The . . . . . . . permission on the database includes both the ALTER ANY MASK and UNMASK permission.
A) UPDATE
B) EXECUTE
C) ALTER
D) CONTROL
10. You can use the . . . . . view to query for table-columns that have a masking function applied to them.
A) sys.masked_columns
B) sys.masked_objects
C) sys.masked_stats
D) sys.masked_tables_columns
Answers