Đang chuẩn bị nút TẢI XUỐNG, xin hãy chờ
Tải xuống
The Real MTCS SQL Server 2008 Exam 70/432 Prep Kit- P37: Congratulations on your journey to become certified in SQL Server 2008. This book will help prepare you for your exam and give you a practical view of working with SQL Server 2008. | 162 Chapter 4 Managing Security Self Test 1. Which of the following is considered a Principal A. SQL Server B. SQL Server Integration Services C. SQL Server Login D. SQL Server Agent 2. Which of the following is a securable object in a database schema A. Database User B. Database C. Service D. Procedure 3. Which of the following fixed server-level roles enables a member to add and remove linked servers A. Securityadmin B. Setupadmin C. Serveradmin D. Dbcreator 4. You have a team member who needs the ability to manage SQL Server logins and you do not want them to have permissions to perform any task on the server. Their responsibilities include resetting logins as well as granting denying and revoking database-level and server-level permissions. Which of the following server-level roles best fits their permissions requirement A. Serveradmin B. Sysadmin C. Securityadmin D. Processadmin 5. Which of the following can be added to a server-level role A. Windows group B. Database User Managing Security Chapter 4 163 C. Database-level role D. Domain server account 6. Which of the following database-level roles limits a user s permissions to reading all data from all user tables A. db_owner B. db_datareader C. db_datawriter D. db_securityadmin 7. You have a user that requires the permissions to drop a database and perform any configuration and maintenance tasks. Which of the following actions would violate The Principle of Least Privilege A. Adding the user to the db_datareader role B. Adding the user to the db_owner role C. Adding the user to the sysadmin role D. Giving the user permission to modify tables 8. Which of the following can be mapped to a database User A. Windows account B. Login C. Windows group D. Domain account 9. Although T-SQL can be used to create database users which of the following SQL Server management tools can also be used A. SQL Server Configuration Manager B. The Surface Area Configuration Fact C. Microsoft Visual Studio D. SQL Server Management .
