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 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 statistics in the dynamic management view (DMV) should be reset.
• B.  To achieve the goal, the SQL Server computer should be restarted.
• C.  To achieve the goal, the SQL Server Service should be restarted.
• D.  To achieve the goal, the UPDATE STATISTICS command should be excuted.

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. A mission-critical customer relationship management (CRM) database is hosted by a new SQL Server 2005 computer, and the new SQL Server 2005 computer is called SQL2. The CRM database is available to all of the company's 500 employees in the sales and marketing departments. The purchase of new hardware and software should not exceed the annual budget for your department. A monitoring strategy should be devised, and the strategy enables you to make decisions about the history of server performance. In addition, how to arrange the most efficient method to allocate funds for hardware upgrades should be suggested by the monitoring strategy. Which action should be performed?

• A.  SQL Server Profiler should be utilized to capture information to a SQL Server database table. And then, this task should be performed at regular intervals during periods of peak server activity.
• B.  A series of performance alerts should be created to notify you when the acceptable thresholds are exceeded by %Processor Time, Average Disk Queue Length, Pages/sec, and Bytes Total/sec.
• C.  System Monitor in graph mode should be utilized to display information about %Processor Time, Average Disk Queue Length, Pages/sec, and Bytes Total/sec. And then, this task should be performed at regular intervals during periods of peak server activity.
• D.  A counter log should be set to capture information about %Processor Time, Average Disk Queue Length, Pages/sec, and Bytes Total/sec. And then, the log should be scheduled to execute at regular intervals, and the information should be stored in a comma-delimited text file.

In order to satisfy the business requirements of the company, the recovery plan for the CRM database needs to be modified. The company assigns this task to you. What action should you perform to accomplish your task?

• A.  In order to accomplish your task, the log backups should be changed to run twice per hour.
• B.  In order to accomplish your task, the log backups should be changed to run once every two hours.
• C.  In order to accomplish your task, every three hours, differential backups should be added.
• D.  In order to accomplish your task, the full backups should be changed to run every night.
• E.  In order to accomplish your task, use full backups to take the place of the nightly differential backups.

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 database named Inventory on a SQL Server 2005 computer, and the computer is named SQL01. SQL01 is utilized to aggregate manufacturing part numbers from your company's trading partners. And the company stores the manufacturing part numbers in the Product table in the Inventory database. The company requests the users to deliver data as text files from each trading partner to SQL1 every night. The data should be imported, and no duplicate manufacturing part numbers should exist in the data which is imported from the text files, and the text files are stored in the Inventory database on SQL01.
You should cut the effect on your company's trading partners and your IT department to the least. Which action should you perform?

• A.  First, you should import the data from each text file into a staging table. Second, you should write a query to have a HAVING clause contained so as to migrate replicate values before results are inserted into the Product table.
• B.  First, you should make sure that each text file is stored in an Extensible Markup Language (XML) file. Second, you should utilize Extensible Stylesheet Language Transformations (XSLT) to automatically migrate replicates before data is imported into the Product table.
• C.  You should place a unique index on the PartNum column.
• D.  First, you should make sure that the unique key values for manufacturing part numbers are utilized by each of your company's trading partners utilizes. Second, you should import the text files into the Product table.

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.  You should use the REORGANIZE option to change the existing nonclustered index.
• 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.  On the VideoTitle and RetailPrice columns, a clustered index should be created.