QUESTION 11 Each of the outcomes listed below is a result of executing the following script except for one. Which one? CREATE ROLE ExampleRole; ALTER ROLE db_datareader ADD MEMBER ExampleRole; GRANT INSERT,UPDATE ON Vendors TO ExampleRole; DENY INSERT ON Vendors TO ASmith; ALTER ROLE ExampleRole ADD MEMBER ASmith; a. By being assigned to the role db_datareader, a user would be granted INSERT and UPDATE permission to the Vendors table and SELECT permission to all user tables. b. The user named ASmith cant be granted INSERT permission to the Vendors table by being assigned to the role ExampleRole. c. By being assigned to the role ExampleRole, a user would be granted INSERT and UPDATE permission to the Vendors table and SELECT permission to all user tables. d. The user named ASmith is granted UPDATE permission to the Vendors table and SELECT permission to all user tables.

QUESTION 12 Before you can delete a server role, you must a. delete the server b. delete all of its members c. DROP AUTHORIZATION d. create the DROP SERVER ROLE

QUESTION 13 To transfer a database object from one schema to another, you use the which statement? a. TRANSFER SCHEMA b. TRANSFER LOGIN c. ALTER LOGIN d. ALTER SCHEMA

QUESTION 14 Users who are involved in the administration of the server are typically assigned to one of the ________________ roles that are built into SQL Server. a. fixed database b. dbcreator c. fixed server d. sysadmin

QUESTION 15 Which option can you use to make SQL Server prompt the user for a new password the first time the login ID is used? a. CHANGE_LOGIN b. CREATE LOGIN c. CHECK_EXPIRATION d. MUST_CHANGE

QUESTION 16 The highest level at which you can grant permissions is the ________________ level. a. database b. table c. column d. server

QUESTION 17 The dbcreator role a. lets members create, alter, and drop databases b. is intended for those users who need to be able to work with database objects c. all of the above d. allows new members to be added to the role

QUESTION 18 With the ALTER LOGIN statement, you can a. change the name for a login ID b. enable or disable a login ID c. change the default database or language d. all of the above

QUESTION 19 To allow users to log on using either type of authentication, you need to set the SQL Server authentication to ________________ mode. a. database b. Windows c. server d. mixed

QUESTION 20 The users, groups, logins, and roles that have access to a server are called ________________. a. securables b. IDs c. principals d. permissions