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 administrator of a SQL Server 2005 computer. An e-mail message should be sent to the company database auditing department, when the SQL Server service and the SQL Server Agent service are started, stopped, or paused. In addition, an e-mail message should be sent to them, when the users utilize the EXECUTE AS option with stored procedures and other commands.
Since you are the administrator, you are required to make sure that the e-mail messages that the auditing department needs should be sent to them. What should you do to finish the task? (Choose more than one.)

• A.To finish the task, an Event Notification should be created on the Audit Server Principal Impersonation event class.
• B.To finish the task, SQL Server Profiler should be utilized to track the Audit Server Principal Impersonation event class.
• C.To finish the task, SQL Server Profiler should be utilized to track the Audit Server Starts and Stops event class.
• D.To finish the task, an Event Notification should be created on the Audit Server Starts and Stops event class.
• E.To finish the task, SQL Server Profiler should be utilized to track the Audit Statement Permission event class.
• F.To finish the task, a Windows Group Policy Object should be created to audit System Events.

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. There is a SQL Server 2005 computer in the company. A single user database named DB01 is contained in this computer. All company employees connect to DB1. According to the requirement of the company policy, the database should be fault-tolerant and that failovers require no administrative effort. Therefore, you are asked to provide fault tolerance for the database.
Your solution must guarantee that even if a complete hardware failure occurs on the SQL Server 2005 computer, client computers are able to connect to the database, including a failure of all disks. What action should you perform to achieve your goal?

• A.Log shipping needs to be implemented to another SQL Server 2005 computer.
• B.A two-node server cluster that contains the database needs to be implemented.
• C.Database mirroring to another SQL Server 2005 computer needs to be implemented.
• D.Transactional replication needs to be implemented to another SQL Server 2005 computer.

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

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

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 SQL Server 2005 database is utilized in your company. And a table named Inventory is contained by the database. A column named Price is included by the table. According to the company policy, you cannot reduce more than 10 percent the value in the Price column in any single database operation. Through many kinds of method, the company makes updates to the Price column. For instance, the utilization of ad hoc queries is one of the methods. Since you are the database administrator, you should confirm that this company policy takes its effect.which action should be performed?

• A.A trigger should be created, and changes are rolled back by the trigger to the Price column that violates company policy.
• B.A stored procedure should be created, and changes are disallowed by the procedure to the Price column that violates company policy.
• C.On the Price column, a check constraint should be created, and a specified minimum value is required by the check constraint.
• D.On the Price column, a foreign key constraint is created to a table that valid prices are included.