3.You need to make recommendations to help customers who use Web applications mitigate potential SQL Server security risks. What should you do?MCSE Exams

A: Recommend that data on the customers SQL Server computer should be encrypted.
B: Recommend that the customers SQL Server computer should be placed behind a hardware firewall.
C: Recommend that the customers Web server should be placed behind a firewall.
D: Recommend that the customers Web application should access data only through stored procedures.
Correct Answers:  D70-299

4.For the MarketingAnalysis database, you are adding functionality that sends the results of a query in an e-mail message to the marketing supervisors when new sales data has been entered. You need to implement a method that fulfills this requirement and minimizes the security risks. Which method should you use?
70-229
A: Database Mail
B: SQL Mail
C: a managed stored procedure
D: a command line program that is called by xp_cmdshell
Correct Answers:  A70-218

5.You need to identify the most appropriate archiving strategy for the SalesData.Orders table in the Sales database. The archiving strategy must have the minimum impact on performance. What should you do?70-220

A: Create a table named ArchivedData.Orders. Partition the SalesData.Orders table and its indexes, and use MERGE, SPLIT, and SWITCH functions every three months to move old order data into ArchivedData.Orders.
B: Create a table named ArchivedData.Orders. Every three months use an INSERT statement to copy data from the SalesData.Orders table into ArchivedData.Orders, and then use a DELETE statement to remove archived data from SalesData.Orders.70-237
C: Create a database snapshot of the Sales database every three months, and then use a DELETE statement to remove archived data from the SalesData.Orders table.
D: Back up the Sales database to tape every three months, and then use a DELETE statement to remove archived data from the SalesData.Orders table.
Correct Answers:  A 70-285

6.You need to ensure that all communication with SQL4 is as secure as possible. What are two possible ways to achieve this goal? (Each correct answer presents a complete solution. Choose two.)

A:Set the Windows IP Security Policy on the SQL Server computers to require security.
B:Use SQL Server Configuration Manager to set the ForceEncryption option.
C:Use SQL Server Configuration Manager to specify that SQL Server will listen on port 443.70-301
D:Require client computers to possess X509 certificates from a trusted certificate authority (CA).
Correct Answers:  B, C70-621

7.You need to specify the changes to the existing firewall configuration settings that are required by the HTTP endpoint that will be used by the proseware_projects database. What should you do?70-622

A: Create a Web publishing rule on ISA2 that allows HTTP traffic on port 5017 from IIS1 to the SQL Server computer.
B: Create a Web publishing rule on ISA1 that allows HTTP traffic on port 5017 from IIS1 to the SQL Server computer.
C: Create a Web publishing rule on ISA2 that allows HTTPS traffic on port 5017 from IIS1 to the SQL Server computer.
D: Create a Web publishing rule on ISA1 that allows HTTPS traffic on port 5017 from IIS1 to the SQL Server computer.
Correct Answers:  D70-631

8.You need to migrate the DeliveryVans, AirlinePreferences, and SeasonalContractors databases into the data center. What should you do?74-131

A: Install a separate instance of SQL Server 2005 for each of the databases on a single server.
B: Create a SQL Server database for each of the databases in a single instance of SQL Server 2005.
C: Import the data from each of the databases into a single database in an instance of SQL Server 2005.
D: Install a default instance of SQL Server 2005 on three separate servers. Use one server for each of the databases.
Correct Answers:  BMB5-198

9.You need to implement encryption for SQL1 based on the companys technical requirements. What should you do?MB3-430

A: Implement the Server (Request Security) IPSec policy on SQL1.
B: Enable encrypted connections for the SQL Server instance with the ForceEncryption option enabled.
C: Create the acct1 database, and encrypt all data.
D: Enforce the use of Kerberos authentication on SQL1.
Correct Answers:  B MB3-412

10.You plan to use a managed assembly in the proseware_projects database that includes a method to save the contents of an xml column as a local file. You need to import the assembly without granting it unnecessary permissions. Which permission level should you assign to the assembly?

A: EXTERNAL_ACCESS
B: the default permission level
C: SAFE
D: UNSAFE
Correct Answers:  AMB3-451

本文出自 51CTO.COM技术博客