Learn with Microsoft : 70-447 training material for 100% pass

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 a financial services company. Replication is configured between two SQL Server 2005 computers, and the servers are respectively named SQL1 and SQL2. Real-time transactional data is stored by the SQL1. And SQL2 is utilized for reporting. The data on SQL01 should not be changed by SQL2. The publication contains a large amount of data. Since you are the database administrator, you need to make sure that data is replicated from SQL1 to SQL2 in as near real-time as possible to confirm accurate reporting during replication. In addition, you need to make sure that this data is replicated securely. Which action should be performed?

• A. Transactional replication should be set on SQL1. And then, SQL2 should be set as a standard subscriber for an updateable subscription.
• B. Snapshot replication should be set on SQL1. And then SQL2 should be set as a standard subscriber for a standard subscription.
• C. Transactional replication should be set on SQL1. And then, SQL2 should be set as a standard subscriber for a standard subscription.
• D. Merge replication should be set on SQL1. And then SQL2 should be set as a standard subscriber for an updateable subscription.

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. All indexes should be built, and the statistics should be updated on all tables.
• C. All data should be manually moved from the mainframe computer to the new databases by utilizing the SELECT INTO command.
• D. The DELETE statement should be utilized to move all test data from the three databases.
• 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 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. 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.
• C. 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.
• D. 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.

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 view the activity of specific business analysts by using the Activity Monitor.
• 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 gather database activity by running SQL Trace system stored procedures.

In order to satisfy the business requirements of the company, the recovery plan for the CRM database needs to be modified. The company assigns this task to you. What action should you perform to accomplish your task?

• A. In order to accomplish your task, the log backups should be changed to run twice per hour.
• B. In order to accomplish your task, use full backups to take the place of the nightly differential backups.
• C. In order to accomplish your task, the log backups should be changed to run once every two hours.
• D. In order to accomplish your task, the full backups should be changed to run every night.
• E. In order to accomplish your task, every three hours, differential backups should be added.