Prep and try our 070-447 valid and latest training 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, and the computer is called SQL01. The users complain the slow response of all client applications which connect to SQL01. You find that the CPU and memory utilization of SQL01 is low. In addition, the disk activity is low. The cause of the performance problem should be identified. Which action should be performed?

• A. The sys.dm_db_partition_stats dynamic management view (DMV) should be examined.
• B. The sys.dm_db_index_physical_stats dynamic management function (DMF) should be examined.
• C. Task Manager should be utilized to have utilization of SQL1s network adapter examined.
• D. System Monitor should be utilized to have SQL1s cache hit ratio examined.

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. Developers need access to create, alter, and drop tables in your SQL Server 2005 database. There is a table named Valid_Production_Tables in the database. This table maintains a list of production tables. There are users who attempt to use commands to drop or alter current production tables. You must be able to automatically roll back any commands. When you try to achieve this, you must reduce the processor resources being used to the least. So what action should you perform?

• A. You should execute the FOR ALTER_TABLE, DROP_TABLE command by using Event Notification.
• B. You should execute the FOR DROP_TABLE, ALTER_TABLE command by using a DDL trigger.
• C. You should execute the FOR DDL_TABLE_EVENTS command by using Event Notification.
• D. You should execute the FOR UPDATE, DELETE command on the Valid_Production_Tables table by using a DML 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. A SQL Server 2005 computer is managed by you, and a database named Customers is included by the SQL Server 2005 computer. A table named CustInfo is included by the database. An identity column named CustID and an nvarchar column named CustName are included by the table. According to the company requirement, rows which duplicate CustName values are included should be moved from the CustInfo table every year. However, the company requests to have rows removed from the CustInfo table after the rows have been manually examined and verified as being duplicates.
Since you are the technical support, you are required to think out a method to have potential duplicate rows identified for manual examination.
The minimum amount of administrative effort should be utilized. Which action should be performed to finish the task?

• A. A trigger should be created for the CustInfo table so as to roll back INSERT queries that duplicate data is included.
• B. A new unique index should be created on the CustName column. And then, IGNORE_DUP_KEY = ON should be specified when creating index.
• C. A SELECT INTO query should be utilized, and GROUP BY and HAVING clauses should be included by the query to create a new table that contains duplicate rows from the CustInfo table.
• D. On the CustName column, a foreign key constraint should be created, and a distinct list of CustName values is referenced by the foreign key constraint.

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 named SQL1. The company set the SQL Server service and the SQL Server Agent service to start automatically. SQL01 should be set to audit all user names and application names that try to access information from SQL01. Auditing should be performed by SQL01 at all times. And the company requires keeping the results for 10 years. Which action should be performed?

• A. The C2 Audit Tracing setting should be disabled on the server properties.
• B. The server authentication mode should be set as SQL Server and Windows Authentication mode.
• C. A SQL Server Agent job should be created to run the SQL Trace stored procedure. And then, the job should be set to start when the SQL Server Agent service starts.
• D. The Login auditing setting should be set to not only failed but also successful logins.

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 local security policy of SQL1 should be edited. Then, success and failure auditing should be set on the Audit logon events setting.
• B. The SQL Server Profiler should be run and a standard default template should be utilized.
• C. 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.
• D. The SQL Server service should be set on SQL01 to audit all successful and failed logon attempts.