Free Microsoft 70-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 your company. A new stored procedure is created by you. You find an error when running the stored procedure. The company asks you to collect and process any error information that is generated while running the procedure. Error logging must use the least possible resources while providing the needed functionality. You have to find out what caused the error. The appropriate error functions need to be included in the new stored procedure. What action should you perform?

• A.  A GOTO statement should be used.
• B.  The @@error function should be used.
• C.  TRY...CATCH blocks should be used.
• D.  The XACT_ABORT command should be set to off.

You work as the database administrator for your company. A SQL Server 2005 database is utilized to have online sales tracked. It is reported by employees who run the In-Stock that they are experiencing slow performance. After detailed analysis, you find that the contention between the In-Stock report and high volume of data entry to the tables that are accessed in this report causes the performance problem. The company intends to have the In-Stock report returned instantly even though the data might be changed by other employees within their data-entry transactions. The employees who are running the In-Stock report should be able to see any changes which are made in other transactions when the report is running.
Since you are the database administrator, you are required to implement a solution to accomplish this task. Which action should be performed?

• A.  The database should be set to enable the Read Committed snapshot option.
• B.  The transaction isolation level should be modified for the report transaction to snapshot.
• C.  The transaction isolation level should be modified for the report transaction to Read Uncommitted.
• D.  The transaction isolation level should be modified for the report transaction to serializable.

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 receive report from users saying that some reports are performing poorly. You are sure that your tables have the appropriate indexes and that your queries should be performing optimally. After a SHOWPLAN statement is executed on the poorly performing reports, you find that incorrect indexes are being used in some cases. You want the SQL Server 2005 query optimizer to select the correct indexes automatically. So what action should be performed?

• A.  A maintenance plan should be created. An Update Statistics task should be included in this plan.
• B.  A maintenance plan should be created. A Check Database Integrity task should be included in this plan.
• C.  The indexes should be rebuilt and the server should be restarted.
• D.  All poorly performing queries should be rewritten so that they use query hints.

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 recently the server performs gradually slowly. The indexing environment is troubleshooted by you. The clustered indexes are rebuilt by you, and the clustered indexes are utilized the most frequently. The most frequently accessed nonclustered index will be optimized by you. The sys.dm_db_index_usage_stats dynamic management view (DMV) is accessed by you. You can see the results from the table listed below.

When the entire index is not read, the nonclustered index which is being utilized the most frequently should be identified. From the following four object_id and index_id combinations, which one should be utilized to finish the task?

• A.  To finish the task, the object_id 309576141 and the index_id 1 should be utilized.
• B.  To finish the task, the object_id 869578136 and the index_id 1 should be utilized.
• C.  To finish the task, the object_id 2066106401 and the index_id 1 should be utilized.
• D.  To finish the task, the object_id 2066106401 and the index_id 2 should be utilized.
• E.  To finish the task, the object_id 869578136 and the index_id 5 should be utilized.

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. The company uses a SQL Server 2005 computer. Reporting Services are run by this computer. The server runs reports which include only data from the previous days sales. When reports are run during business hours, you notice that an OLTP database application runs slowly and that reports sometimes time out. Since you are the technical support, you have to resolve the problem and prevent it from recurring. So what action should you perform to achieve the goal?

• A.  In order to achieve the goal, the reports should be configured to run under the Snapshot isolation level.
• B.  In order to achieve the goal, the reports should be configured to use report snapshots. The report snapshots should be scheduled to run after business hours.
• C.  In order to achieve the goal, the size of the ReportServerTempDB database should be increased.
• D.  In order to achieve the goal, the report definitions should be stored on a separate server.