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 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.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.
• 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.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.
• D.A trigger should be created. The SQL Server Integration Services (SSIS) packages should be run by this trigger.

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.

According to the company business and technical requirements,a management plan should be created for the goldengenius_biz database. The action which should be taken is needed to be specified, before manually inserting data through a bulk load process. The availability and recoverability business requirements should be met, and the least amount of administrative effort should be utilized. From the following four actions, which one should be specified to finish the task?

• A.To finish the task, a database snapshot should be created.
• B.To finish the task, replication should be configured.
• C.To finish the task, a full backup should be created.
• D.To finish the task, a differential backup should be 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 administrator of a SQL Server 2005 computer, and the SQL Server 2005 computer is called SQL01. SQL01 is in a Microsoft Active Directory domain. No rights or privileges are assigned to you to have domain administration performed. However, the company has granted you membership in the local Administrators group on SQL01. Most of the management of SQL01 is performed from your administrative workstation. However, according to the company security requirements, you intend to have all attempts for interactive logons and network connections to SQL1 tracked. Which action should be performed?

• A.The SQL Server Profiler should be run and a standard default template should be utilized.
• B.The local security policy of SQL1 should be edited. Then, success and failure auditing should be set on the Audit logon events setting.
• C.The SQL Server service should be set on SQL01 to audit all successful and failed logon attempts.
• D.A Group Policy object (GPO) should be created, and the GPO is set to audit success and failure of the Audit account logon events setting. And then, the domain administrator should be requested to link the GPO to the object including SQL01.

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. In the company, a SQL Server 2005 database experiences frequent blocking. You are asked to minimize the impact that caused by the blocking. Therefore, the database needs to be modified. You must make sure that no dirty reads are allowed. So what action should you perform?

• A.The Snapshot isolation level should be implemented.
• B.The database should be configured to use the Read Committed Snapshot option.
• C.The Read Uncommitted isolation level should be implemented.
• D.The database should be configured to use the Auto Close option.