Knowledge check

Completed

Choose the best response for each of the questions below.

Check your knowledge

1.

Which security object is required in order to enable transparent data encryption?

Credential

Master Key

User

2.

Which feature prevents members of the sysadmin role from viewing the values of data in a table?

Always Encrypted

Dynamic Data Masking

Transparent Data Encryption

3.

Which TLS version offers the most secure option for encryption?

TLS 1.1 version

TLS 1.0 version

TLS 1.2 version

4.

Which feature provides a private IP address for an Azure SQL Database?

Network Endpoints

Private Link

Database Firewall

5.

Which technique can be used to create database firewall rules in Azure SQL Database?

Running a PowerShell script

Running an Azure CLI script

Executing a T-SQL statement

You must answer all questions before checking your work.