You need to design the database permissions for access from 

第1题：

第2题：

You need to design the retrieval of advertising statistics without compromising security. What should you do?（）

• A、Design a Notification Services solution that sends the advertising statistics to specified subscribers by e-mail.
• B、Design a SQL Server Web service that runs a stored procedure to return the statistics on a call from the advertisers application.
• C、Design a Database Mail solution that sends the advertising statistics to e-mail addresses that are specified in a table.
• D、Design a stored procedure to return the statistics on a call from the advertisers application.
• E、Design a user-defined function to return the statistics on a call from the advertisers application.

第3题：

第4题：

You have a Web application that is configured for personalization. You need to access personalization data from one of the pages of the Web application by using the minimum amount of administrative effort. What should you do? （）

• A、Access the personalization data from the Session property of the HttpContext object.
• B、Access the personalization data from the Application property of the HttpContext object.
• C、Access the personalization data from the Cache property of the HttpContext object.
• D、Access the personalization data from the Profile property of the HttpContext object.

第5题：

You have an Exchange Server 2010 organization.  You need to recommend a client access solution that meets the following requirements： .Reduces the time required for users to reconnect to user mailboxes if a single Client Access server fails .Prevents users from being prompted for authentication if a single Client Access server fails What should you recommend？（）

• A、Client Access server array and hardware load-balancer
• B、database availability group （DAG） and hardware load-balancer
• C、failover clustering and database availability group （DAG）
• D、Windows Network Load Balancing and failover clustering

第6题：

Redo log files are multiplexed in your database. The disk in which you have one of the redo log members is highly fragmented. In the process of defragmentation you lose the redo log member， which is not a member of the current group. How would you recover from the loss of the redo log member？（）

• A、SMON would automatically restore the lost file.
• B、You would need to restore the whole database from the last backup.
• C、You would need to restore the file from the last full database backup.
• D、You would need to use flashback technology to restore the lost redo log member.
• E、You would need to use Recovery Manager （RMAN） to restore the lost redo log member.
• F、You would need to restore the missing log file by copying one of the remaining files from the same group.

第7题：

Which of the following statements allows BOB to revoke access to the SAMPLE database from user TOM?（）

• A、REVOKE ACCESS ON DATABASE FROM USER bob
• B、REVOKE CONNECT ON DATABASE FROM USER tom
• C、REVOKE tom FROM ACCESS ON DATABASE BY USER bob
• D、REVOKE tom FROM CONNECT ON DATABASE BY USER bob

第8题：

第9题：

You are the network administrator for your company. Your network consists of a single Active   Directory domain. Three security groups named Accountants， Processors， and Management are located in an organizational unit （OU） named Accounting. All of the user accounts that belong to these three  groups are also in the Accounting OU. You create a Group Policy object （GPO） and link it to the  Accounting OU. You configure the GPO to disable the display options under the User Configuration  section of the GPO. You need to achieve the following goals： You need to ensure that the GPO applies to  all user accounts that are members of the Processors group. You need to prevent the GPO fromapplying  to any user account that is a member of the Accountants group. You need to prevent the GPO from  applying to any user account that is a member of the Management group， unless the user account is also  a member of the Processors group. What should you do？（）

• A、 Modify the discretionary access control list （DACL） settings of the GPO to assign the Accountants and Management security groups the Deny - Read and the Deny - Apply Group Policy permissions. Modify the DACL of the GPO to assign the users who are in both the Accountants and Management security groups the Allow - Read and the Allow - Apply Group Policy permissions.
• B、 Modify the discretionary access control list （DACL） settings of the GPO to assign the Accountants and Management security groups the Deny - Read and the Deny - Apply Group Policy permissions. Create a new security group named Mixed that contains all the user accounts from the Processors group and the specific user accounts from the Management group to which you want the GPO to apply. Modify the DACL of the GPO to assign the Mixed security group the Allow - Read and the Allow - Apply Group Policy permissions.
• C、 Modify the discretionary access control list （DACL） settings of the GPO to assign the Accountants security group the Deny - Read and the Deny - Apply Group Policy permissions. Modify the DACL settings of the GPO to remove the Authenticated Users special group. Modify the DACL settings of the GPO to add the Processors group and assign the Allow - Read and the Allow - Apply Group Policy permissions.
• D、 Modify the discretionary access control list （DACL） settings of the GPO to assign the Accountants security group the Deny - Read and the Allow - Apply Group Policy permissions. Modify the DACL settings of the GPO to assign the Management security group the Deny - Read and the Deny - Apply Group Policy permissions.

第10题：

You need to design an administrative model that meets the business and technical requirements. What should you do？（）

• A、Assign permissions to manage Mailbox and Exchange Server configuration to the server-admins group
• B、Assign permissions to manage Mailbox and Exchange Server configuration to the domain-admins group
• C、Assign permissions to manage Mailboxes to the server-admins group. Assign permissions to manage Exchange Servers configuration to the domain-admins group
• D、Assign permissions to manage Mailboxes to the domain-admins group. Assign permissions to manage Exchange Servers configuration to the server-admins group