Online Access Free 070-447 Practice Test

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

The security for the HR database should be set to support present security needs. And the impact of future security changes that might be caused by user and table additions should be cut to the least. From the four actions, which two should be performed? (Choose more
than one)

• A.A Hiring_Managers role should be created, and then all hiring managers should be added to this role, at last the role the SELECT, INSERT, UPDATE, and DELETE permissions should be granted on the five tables that the hiring managers need to manage.
• B.A HR_Readers role should be created, and then all employees in the HR department should be added to this role, at last the SELECT permission should be granted on all present tables to this role.
• C.The SELECT permission on all current tables should be granted to the public database role.
• D.All hiring managers should be added to the db_datawriter database role.
• E.All employees should be added to the db_datareader database role.

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. The users report the slow performance of a SQL Server 2005 application. You are required to identify the queries which perform slowly because of blocking. Which action should you perform?

• A.In a query execution plan, you should look for queries with missing or out-of-date statistics.
• B.In a SQL Trace log file, you should look for queries with high duration values and low read and write values.
• C.In a SQL Trace log file, you should look for queries with low duration values and high read and write values.
• D.In a query execution plan, you should look for queries with a large number of table scans.

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.An alert should be created for the SQL Server in SQL Server Agent: Databases Percent Log Used object.
• C.The DBCC SQLPERF(LOGSPACE) command should be run in SQL Server Management Studio.
• D.An alert should be created on the Logical Disk % Free Space counter in the Performance Logs and Alerts console.