Free Microsoft 070-447 Exam Dumps Questions & Answers

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 the database administrator for a SQL Server 2005 computer named SQL01. There are five databases in the company. All of them run on a single SQL Server 2005 instance. In order to minimize the amount of time required and the amount of space used in the user databases when creating and rebuilding indexes, all indexes are created with the use of the SORT_IN_TEMPDB option. You are asked to design the tempdb database for optimal performance. What action should you perform?

• A.  The tempdb database needs to be placed on a different RAID-5 volume from the user databases.
• B.  The tempdb database needs to be placed on the same RAID-5 volume as the user databases.
• C.  The tempdb database needs to be placed on a different RAID-0 volume from the user databases.
• D.  The tempdb database needs to be placed on the same RAID-0 volume as the user databases.

DRAG DROP
Drag Drop question

Correct Answer:

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 the database administrator for your company. You are in charge of a SQL Server 2005 database named DB1. You are given a SQL Server Profiler sample workload with queries to DB1 on a typical day. Now the company assigns a task to you. You are asked to evaluate the effectiveness of current indexing and the identify changes that would be appropriate. What action should be performed first?

• A.  The Index Tuning Wizard should be used with the sample workload.
• B.  A query should be created with the five stored procedures that are used the most frequently. Then click the Analyze Query in Database Engine Tuning Advisor button.
• C.  The sample workload should be run by using SQL Server Profiler.
• D.  The Database Engine Tuning Advisor (DTA) should be used with the sample workload.

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 the database administrator for your company. A SQL Server Integration Services (SSIS) package is created by you. Confidential information is contained in this package. Only two company employees will use this package. The package is stored in the msdb database. You have to make sure that the package can only be executed by the appropriate employees. The company requires that you should use as little administrative effort as possible when you try to achieve this. So what action should you perform?

• A.  The package should be configured to use the Encrypt all with password package protection level.
• B.  The package should be configured to use the Encrypt all with user key package protection level.
• C.  After the package is saved to a file. You should use the Encrypting File System (EFS) to encrypt the file.
• D.  The package should be saved to a SQL Server 2005 computer that has an IPSec Secure Server policy applied.

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 the administrator of a SQL Server 2005 computer, and the SQL Server 2005 computer is named SQL1. The company set the SQL Server service and the SQL Server Agent service to start automatically. SQL01 should be set to audit all user names and application names that try to access information from SQL01. Auditing should be performed by SQL01 at all times. And the company requires keeping the results for 10 years. Which action should be performed?

• A.  The server authentication mode should be set as SQL Server and Windows Authentication mode.
• B.  The C2 Audit Tracing setting should be disabled on the server properties.
• C.  The Login auditing setting should be set to not only failed but also successful logins.
• D.  A SQL Server Agent job should be created to run the SQL Trace stored procedure. And then, the job should be set to start when the SQL Server Agent service starts.