Previous

Next

Knowledge check

Completed

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

Check your knowledge

1.

Which protocol is used by Microsoft Entra ID 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

You must answer all questions before checking your work.

Continue