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 a database administrator for your company. There is a user in the Windows SalesManagers group, and he is called Simon. A Reporting Services report is required by Simon to have annual sales information displayed by territory. There is another user in the Windows Sales group, and he is called Jack. He is responsible to report to Simon. A report is required by Jack, and the report is limited to his sales territory, but the same detailed sales data is still displayed, and the detailed sales data is on Simon's report. A secure solution should be designed to meet the requirements of the users listed above, and the least amount of server resources should be utilized. Which action should be performed?

• A.First, all territory information should be contained by a parameterized report which is designed for Simon. Second, a linked report that links to Simons report should be designed for Jack.
• B.First, two data regions should be contained by a report which is designed for Simon. Second, one data region should be utilized for summary sales data. Third, the other data region should be utilized for the detailed sales data for each sales representative. Four, a report that displays the detailed sales data should be designed for Jack.
• C.First, the territory information should be contained by a report which is designed for Simon. Second, a report which detailed sales data for Jack's territories is contained should be designed for Jack. Third, Simon??s report should be set to have the data in Jacks report contained.
• D.First, two reports should be designed for Simon. Second, the territory information should be contained by one, and the detailed sales data should be contained by another. At last, a report that displays the detailed sales data for Jack's territories should be designed for Jack.

The new server named SQLCLUST is set with test versions of the Research, Engineering, and Parts databases. The data in these databases is merely utilized for testing and is not present. According to the company requirements, the new Research, Engineering, and Parts databases should be moved from the test stage to the production stage with the highest efficiency level. Before making the databases accessible to all users, which three actions should be performed? (Choose more than one)

• A.One or more jobs should be scheduled to move all data from the mainframe computer databases to the new databases.
• B.All data should be manually moved from the mainframe computer to the new databases by utilizing the SELECT INTO command.
• C.All indexes should be built, and the statistics should be updated on all tables.
• D.The DELETE statement should be utilized to move all test data from the three databases.
• E.Scripts should be run on the production server to build all tables, views, and stored procedures.

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.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.
• D.The Login auditing setting should be set to not only failed but also successful logins.

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 database named DB1 is used by the company. The SQL statements used to create the Sales table in DB1, an existing index, and the two most common queries executed against this table are shown in the exhibit. The existing indexes have just been rebuilt. The VideoID and VideoTitle fields are highly selective. The RetailPrice, WholesalePrice and Genre fields have low selectivity. Since you are the technical support, the company asks you to optimize the performance of both queries. The company also requires that you must reduce the size of the index to the least when trying to achieve this goal. What action should you perform to accomplish your task?

• A.On the VideoTitle field, drop the clustered index. On the VideoTitle field, a nonclustered index should be created.
• B.On the VideoTitle and RetailPrice columns, a clustered index should be created.
• C.On the Barcode and VideoID fields, a nonclustered index should be created. The WholesalePrice and Genre fields should be included.
• D.On the VideoTitle, Barcode, VideoID, WholesalePrice, and Genre fields, a nonclustered index should be created.
• E.You should use the REORGANIZE option to change the existing nonclustered index.

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. More than a month ago, the SQL 2005 Server computer is deployed in operation. There are some query performance problems last week. Therefore, you perform an investigation on the locking contention. From the sys.dm_os_wait_stats dynamic management view (DMV), you can see a high value in the max_wait_time_ms column. You want to check out whether this value is a factor which leads to the current performance problems. In addition, the impact on database users should e cut to the least. Which action should be performed to achieve the goal?

• A.To achieve the goal, the SQL Server Service should be restarted.
• B.To achieve the goal, the UPDATE STATISTICS command should be excuted.
• C.To achieve the goal, the statistics in the dynamic management view (DMV) should be reset.
• D.To achieve the goal, the SQL Server computer should be restarted.