Microsoft 070-447 actual dump : UPGRADE:MCDBA Skills to MCITP DB Admin by Using MS SQL 2005

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 administer a SQL Server 2005 computer named SQL01. There are SQL Server transaction log files on a mirrored volume that is 80-GB in size. 85 percent of the 80-GB volume is full. New databases have been added to SQL01. At present you are unable to to upgrade the volume or to have more disk space added. If the unused disk space on the 80-GB volume is less than 5 GB, an alert should be sent to you. What action should you perform to achieve this?

• A. An alert should be created on the Logical Disk % Free Space counter in the Performance Logs and Alerts console.
• B. The Microsoft Windows Management Instrumentation (WMI) query SELECT FreeSpace FROM Win32_LogicalDisk should be executed in the Wmic.exe utility.
• C. An alert should be created for the SQL Server in SQL Server Agent: Databases Percent Log Used object.
• D. The DBCC SQLPERF(LOGSPACE) command should be run in SQL Server Management Studio.

According to the company requirements, a unique nonclustered index will be created on
the CustomerID, LastName, and FirstName columns of the CustomerData.Customers table in the CRM database. The variables should be identified to help estimate the space requirements for the index.
Estimated number of rowsClustered index key Number of columns in the indexFixed data sizeNumber of variable-length columnsAverage variable-length data size.
The most significant additional variable that will enhance the estimated index size should be identified. From the following four additional variables, which one should be identified to accomplish the task?

• A. To accomplish the task, fill factor should be identified.
• B. To accomplish the task, automatically generated uniqueifier value should be identified.
• C. To accomplish the task, null bitmap should be identified.
• D. To accomplish the task, current number of rows should be identified.

According to the company requirement, a high-availability solution should be implemented for SQL06 and SQL07, the company assigns this task to you. You have to achieve this goal with using as little expense as possible. What action should you perform to accomplish this task?

• A. In order to achieve the goal, a four-node failover cluster should be used.
• B. In order to achieve the goal, database mirroring should be used.
• C. In order to achieve the goal, log shipping should be used.
• D. In order to achieve the goal, a three-node failover cluster should be used.

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. Transaction information for the company's Web-based order system is stored by a database on one of the company's SQL Server 2005 computers. The company configures the database to utilize the full recovery model. Quite few orders are received between the hours of 19:00 and 04:00. And the risk for data loss which the company can accept should not be longer than an hour. The company requires performing the Database backups in the shortest time. A maintenance plan should be developed to administrate this risk. Which action should be performed?

• A. A Back Up Database task should be set to do a full backup at 09:00 and 14:00. And then, a second Back Up Database task should be set to do transaction log backups every hour.
• B. A Back Up Database task should be set to do a full backup of the database every day at
  19:00.
  And then, a second Back Up Database task should be set to do differential backups at 09:00 and 14:00. At last, a Check Database Integrity task should be set to run every hour.
• C. A Back Up Database task should be set to do a full backup of the database every day at
  19:00.
  And then, a second Back Up Database task should be set to do differential backups at 09:00 and 14:00. At last, a third Back Up Database task should be set to do transaction log backups every hour.
• D. A Back Up Database task should be set to do a full backup of the database every hour. And then, a Check Database Integrity task should be set to run every hour.

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 are a database administrator for your company. The company's manufacturing floor has three automated testing areas for finished items. Each testing area uses SQL Server 2005 to store test results. You need to develop a replication strategy to ensure that test results flow continuously from the testing areas to the central SQL Server as quickly as possible. The test results are used for reporting. What should you do?

• A. At each of the testing areas, a separate transactional publication should be created at each of the testing areas for the test results. On each distributor, a merge subscription should be created to the central server.
• B. At each of the testing areas, a separate snapshot publication should be created for the test results. On the central server, a pull subscription should be created to each of the testing area publications.
• C. At each of the testing areas, a separate snapshot publication should be created for the test results. On each distributor, a merge subscription should be created to the central server.
• D. At each of the testing areas, a separate transactional publication should be created for the test results. On each of the testing areas, push subscriptions should be created to the central server.