Microsoft UPGRADE:MCDBA Skills to MCITP DB Admin by Using MS SQL 2005 認定 070-447 試験問題:

1. The code is being reviewed, and the code is utilized to retrieve order data in the ASP.NET Web application. The application should be updated to satisfy the security requirements. Which action should you perform?

A) A view should be created to retrieve the order data, and then, the table name should be replaced with the view name in the ASP.NET code.
B) A SQL Server login that has a complex password should be created, and the ASP.NET code should be changed to connect by utilizing the SQL Server login.
C) A stored procedure should be created to retrieve the order data, and the ASP.NET code should be changed to call the stored procedure by utilizing parameters.
D) An HTTP endpoint that has BATCHES enabled should be created, and the ASP.NET code should be changed to connect to the HTTP endpoint.

2. According to the company business and technical requirements, a high-availaQbility strategy should be designed for the proseware_projects database. Which strategy should be utilized to achieve the goal?

A) To achieve the goal, failover clustering should be utilized.
B) To achieve the goal, database mirroring should be utilized.
C) To achieve the goal, log shipping should be utilized.
D) To achieve the goal, replication should be utilized.

3. According to the company requirement, you are asked to implement encryption for SQL01 on the basis of the technical requirements of the company. What action should you perform?

A) The acct1 database should be created, and encrypt all data should be encrypted.
B) On SQL01, the use of Kerberos authentication should be enforced.
C) On SQL01, the Server (Request Security) IPSec policy should be implemented.
D) For the SQL Server instance, encrypted connections should be enabled with the ForceEncryption option enabled.

4. Since you are the technical support, you are asked to improve the performance for the following query in the internet_rentals database. SELECT videotitle, upc_no, retailprice
FROM srvideo.videotitle WHERE releasedate BETWEEN '05-01-2005' AND '05-30-2005'
The code segment below shows the scripts that were originally used to create the existing table and indexes that are used in the query.
create table srvideo.videotitle (videoid int IDENTITY(1,1) primary key nonclustered videotitle nvarchar(100) not null , description nvarchar(255) null , videolanguage nvarchar(50) null , releasedate datetime null , isbn nvarchar(25) , upc_no nvarchar(25) , format nvarchar(25) , cost money , retailprice money) go create clustered index cl_videotitle on srvideo.videotitle (videotitle);
You must not diminish the performance on other SELECT queries that are performed on a regular basis. What action should you perform?

A) On the releasedate column, a nonclustered index should be created. The videotitle, upc_no, and retailprice columns should be added as included columns.
B) On the retailprice column, a nonclustered index should be created. The releasedate and videotitle columns should be added as included columns.
C) On the releasedate column, a nonclustered index should be created.
D) A clustered index should be added on the releasedate column.

5. You are a professional level SQL Server 2005 database administrator in an international corporation named Wiikigo. You are experienced in implementing high-availability solutions, monitoring the database server, and design deployment. In the company, you major job is the deployment, maintenance and support of Microsoft SQL Server 2005. You work as a database administrator for your company. The users report the slow performance of a SQL Server 2005 application. You are required to identify the queries which perform slowly because of blocking. Which action should you perform?

A) In a SQL Trace log file, you should look for queries with low duration values and high read and write values.
B) In a query execution plan, you should look for queries with a large number of table scans.
C) In a SQL Trace log file, you should look for queries with high duration values and low read and write values.
D) In a query execution plan, you should look for queries with missing or out-of-date statistics.

質問と回答：