03 DP300 - Implement a secure environment for a database service

1. Which protocol is used by Azure Active Directory for Authorization?

• Kerberos
• LDAP
• Oauth

2. Which database stores the information about logins in SQL Server?

• master
• model
• msdb

3. Which role allows users to create users within a database?

• db_datareader
• db_accessadmin
• db_securityadmin

4. Which permission allows the user to perform any option against a database object?

• Control
• Delete
• View Definition

5. What feature allows a user to execute a stored procedure without having permission to access the tables referenced in the stored procedure?

• Ownership chaining
• Principle of least privilege
• Granular security

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

• Credential
• Master Key
• User

7. 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

8. Which TLS version offers the most secure option for encryption?

• TLS 1.1 version
• TLS 1.0 version
• TLS 1.2 version

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

• Network Endpoints
• Private Link
• Database Firewall

10. 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