Instantly download 070-447 training test engine

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. You utilize the SP:Recompile event class to run SQL Server Profiler. You find that a great amount of recompiles occurring. The possible causes of the large number of recompiles should be identified. From the flowing four options, which one is the most possible cause of the problem?

• A. A database administrator executed UPDATE STATISTICS statements on all tables, and the most common stored procedures reference all the tables.
• B. Ad hoc batches are not being recovered from the procedure cache.
• C. The sp_executesql batches are not being recovered from the procedure cache.
• D. One new stored procedure is created by a database administrator.

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. Two user databases are contained in SQL01. The publisher database is also contained in SQL01 for a transactional replication publication. A full backup is made of all databases nightly. For both user databases, transaction log backups are made twice each day. The company has configured SQL01 to use SQL Server and Windows authentication. Client applications use SQL Server login accounts to connect. Since a complete failure occurs on the disk subsystem on SQL01, you replace the failed hardware; reinstall Microsoft Windows Server 2003 and SQL Server 2005. The company requires that SQL01 is operating normally as quickly as possible and with a minimum loss of data. Hence you have to make sure of this. Your must make client applications be able to access the user databases as soon as those databases are restored. What action should you perform first?

• A. First all of the system databases should be restored.
• B. First the transactional replication publication should be re-created.
• C. First only the two user databases should be restored.
• D. First only the publisher database should be restored.

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 are lots of complex SQL Server Integration Services (SSIS) packages for you. These SSIS packages move data among your servers. They have data imported and exported to and from trading partners of the company. Only after certain conditions are met that exist outside of SQL Server, can the SSIS packages run. A third-party tool to schedule the running of nightly scripts is scheduled to test for these conditions with the use of a third-party tool by your department. SSIS needs to be run from your scripts as seamlessly as possible. So what action should you perform?

• A. You should make the scripts write a status code to a text file that the SQL Server Integration Services (SSIS) packages look for and act upon.
• B. At the time that conditions are met in the scripts, the SQL Server Integration Services (SSIS) packages should be run by making the scripts execute the DTUtil utility.
• C. A trigger should be created. The SQL Server Integration Services (SSIS) packages should be run by this trigger.
• D. At the time that conditions are met in the scripts, the SQL Server Integration Services (SSIS) packages should be run by making the scripts execute the DTExec utility.

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

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 computer is named SQL1. Two user databases are included by the SQL01. In addition, the publisher database should be included by the SQL1 for a transactional replication publication. A full backup is performed to all databases every night. And Transaction log backups are performed twice a day for both user databases. SQL1 is set so as to utilize SQL Server and Windows authentication. Client applications connect by using SQL Server login accounts. A complete failure is experienced by the disk subsystem on SQL01. The failed hardware should be replaced, Microsoft Windows Server 2003 should be reinstalled, and SQL Server 2005should be reinstalled. Since you are the database administrator, you are required to confirm that SQL1 is operating normally in a fastest possible way, and a least number of data losses are allowed.
After the solution is implemented, the user databases should be available to client applications once those databases are restored. Which action should be performed first to achieve the goal?

• A. To achieve the goal, only the publisher database should be restored.
• B. To achieve the goal, only the two user databases should be restored.
• C. To achieve the goal, all of the system databases should be restored.
• D. To achieve the goal, the transactional replication publication should be re-created.