Study with 070-447 most valid questions & verified 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 a database administrator for your company. A mission-critical customer relationship management (CRM) database is hosted by a new SQL Server 2005 computer, and the new SQL Server 2005 computer is called SQL2. The CRM database is available to all of the company's 500 employees in the sales and marketing departments. The purchase of new hardware and software should not exceed the annual budget for your department. A monitoring strategy should be devised, and the strategy enables you to make decisions about the history of server performance. In addition, how to arrange the most efficient method to allocate funds for hardware upgrades should be suggested by the monitoring strategy. Which action should be performed?

• A. A series of performance alerts should be created to notify you when the acceptable thresholds are exceeded by %Processor Time, Average Disk Queue Length, Pages/sec, and Bytes Total/sec.
• B. SQL Server Profiler should be utilized to capture information to a SQL Server database table. And then, this task should be performed at regular intervals during periods of peak server activity.
• C. System Monitor in graph mode should be utilized to display information about %Processor Time, Average Disk Queue Length, Pages/sec, and Bytes Total/sec. And then, this task should be performed at regular intervals during periods of peak server activity.
• D. A counter log should be set to capture information about %Processor Time, Average Disk Queue Length, Pages/sec, and Bytes Total/sec. And then, the log should be scheduled to execute at regular intervals, and the information should be stored in a comma-delimited text file.

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 database is utilized in your company. And a table named Inventory is contained by the database. A column named Price is included by the table. According to the company policy, you cannot reduce more than 10 percent the value in the Price column in any single database operation. Through many kinds of method, the company makes updates to the Price column. For instance, the utilization of ad hoc queries is one of the methods. Since you are the database administrator, you should confirm that this company policy takes its effect.which action should be performed?

• A. On the Price column, a check constraint should be created, and a specified minimum value is required by the check constraint.
• B. A stored procedure should be created, and changes are disallowed by the procedure to the Price column that violates company policy.
• C. A trigger should be created, and changes are rolled back by the trigger to the Price column that violates company policy.
• D. On the Price column, a foreign key constraint is created to a table that valid prices are included.

According to the company requirements, the list of expected services for SQLCLUST should be reviews and any nonessential services should be disabled. From the following two services, which one should be disabled? (Choose more than one)

• A. Server service should be disabled.
• B. World Wide Web Publishing service should be disabled.
• C. SQL Server Agent service should be disabled.
• D. Cluster service should be disabled.
• E. Messenger service should be disabled.

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. Scripts should be run on the production server to build all tables, views, and stored procedures.
• B. The DELETE statement should be utilized to move all test data from the three databases.
• C. All data should be manually moved from the mainframe computer to the new databases by utilizing the SELECT INTO command.
• D. All indexes should be built, and the statistics should be updated on all tables.
• E. One or more jobs should be scheduled to move all data from the mainframe computer databases to the new 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, and the computer is called SQL01. Three instances of SQL Server are run by the SQL01. After implementing the recovery plan, the dedicated administrative connection is available on each instance of SQL Server. After the ability is tested, a problem has been found that the dedicated administrative connection on SQL01s default instance can be connected, while the dedicated administrative connection on the two other instances on SQL1 cannot be connected. You confirm that the instances are running and the instances can be accessed by the client applications. In addition, the dedicated administrative connection is enabled for all instances. What??s more, there is no connection that is tried to by other administrators to any dedicated administrative connections on SQL1.
Since you are the administrator, you are required to make sure the dedicated administrative connection can be connected on all three instances. To achieve the goal, which action should be utilized?

• A. The SQL Server Browser service should be started. And then, the service should be set to start automatically.
• B. The non-default instances of SQL Server should be stopped and restarted.
• C. The default instance should be set to utilize an administrative port number which differs from 1434.
• D. The Sqlcmd.exe tool should be utilized to make the dedicated administrative connection.