Previous

Next

Knowledge check

Completed

Choose the best response for each of the questions below. Then select Check your answers.

Check your knowledge

1.

Where is the data from data classification stored in SQL Server 2019?

In the extended properties for each object

In the sys.sensitivity_classifications catalog view

In the sys.all_columns catalog view

2.

Which server-level action group audits queries and stored procedures executed against an Azure SQL Database?

BATCH_STARTED_GROUP

BATCH_COMPLETED_GROUP

SENSITIVE_BATCH_COMPLETED_GROUP

3.

Which block predicate prevents users from updating rows to values that violate its row-level security predicate?

AFTER INSERT

BEFORE UPDATE

AFTER UPDATE

4.

Which of the following features can be used to automate data discovery through the provision of data scanning and classification as a service?

Database auditing

Dynamic data masking

Azure Purview

You must answer all questions before checking your work.

Continue