070-447 試験問題を無料オンラインアクセス

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, all of the system databases should be restored.
• C.To achieve the goal, only the two user databases should be restored.
• D.To achieve the goal, the transactional replication publication should be re-created.

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 new stored procedure is created by you. You find an error when running the stored procedure. The company asks you to collect and process any error information that is generated while running the procedure. Error logging must use the least possible resources while providing the needed functionality. You have to find out what caused the error. The appropriate error functions need to be included in the new stored procedure. What action should you perform?

• A.The @@error function should be used.
• B.A GOTO statement should be used.
• C.The XACT_ABORT command should be set to off.
• D.TRY...CATCH blocks should be used.

The new server named SQLCLUST is set with test versions of the Research, Engineering, and Parts databases. The data in these databases is merely utilized for testing and is not present. According to the company requirements, the new Research, Engineering, and Parts databases should be moved from the test stage to the production stage with the highest efficiency level. Before making the databases accessible to all users, which three actions should be performed? (Choose more than one)

• A.One or more jobs should be scheduled to move all data from the mainframe computer databases to the new databases.
• B.All indexes should be built, and the statistics should be updated on all tables.
• C.Scripts should be run on the production server to build all tables, views, and stored procedures.
• D.All data should be manually moved from the mainframe computer to the new databases by utilizing the SELECT INTO command.
• E.The DELETE statement should be utilized to move all test data from the three databases.

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, an Event Notification should be created on the Audit Server Principal Impersonation 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 Server Starts and Stops 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 named SQL01 in the company. A stores sales history data is stored in a database on SQL01 for the company's Web-based order system. Twenty of the business analysts in the company create ad hoc queries against the database. SQL01 has a slow performance all the time. Since you work as the technical support, the company asks you to identify which business analyst is causing the problem. What action should you perform to achieve this goal? (Choose more than one.)

• A.In order to achieve the goal, you should gather database activity by running SQL Trace system stored procedures.
• B.In order to achieve the goal, you should use SQL Server Profiler to create a trace that uses a predefined template.
• C.In order to achieve the goal, the sp_who system stored procedure should be run.
• D.In order to achieve the goal, you should view the activity of specific business analysts by using the Activity Monitor.