20764C Administering a SQL Database Infrastructure Quiz 1

Q1. You are the database administrator for a company. You have to enable a user to view the code definition of the stored procedure. Which permission should you use?

• VIEW DEFINITION

• ALTER

Q2. Which role grants permissions to perform any action on the server?

• sysadmin

• processadmin

• serveradmin

• securityadmin

Q3. Which of the following server scoped permissions grants SELECT permissions on server level dynamic management objects?

• VIEW SERVER STATE

• ALTER ANY LOGIN

• ALTER TRACE

• ALTER SERVER STATE

Q4. Which security protocol is used to provide security policies such as strong passwords, account locking and password expiration?

• None

• TCP/IP

• HTTP

• Kerberos

Q5. Which of the following statement identifies and authorizes login tokens?

• SELECT FROM sys.login_token;

• SELECT * FROM sys.userlogin_token;

• SELECT * FROM sys.loginuser_token;

• SELECT * FROM sys.user_token;