03 Chapter 03 DP-300T00A-Trainer-Files-Administering-Relational

Which protocol is used by Azure Active Directory for Authorization?

• Kerberos
• LDAP
• Oauth

What feature allows a user to execute a stored procedure even if she does not have permission to access the tables referenced in the stored procedure?

• Ownership Chaining
• Principal of Least Privilege
• Granular Security

Which role allows users to create users within a database ?

• db_datareader
• db_accessadmin
• db_securityadmin

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

• Private Link
• Network Endpoints
• Database Firewall

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

• Executing a T-SQL statement
• Running an Azure CLI script
• Running a PowerShell script

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

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

• In the sys.sensitivity_classifications catalog view
• In the extended properties for each object
• In the sys.all_columns catalog view

Which is NOT an option to store vulnerability assessment data?

• Physical disk
• Storage Account
• Log Analytics

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

• Azure Purview
• Dynamic Data Masking
• Database auditing