Microsoft-Upgrade Transition Your MCITP SQL Server 2005 DBA to MCITP SQL Server 2008 (2) Set 1

You are the administrator of your company network. Now you're in charge of a SQL Server 2008 instance. A user called Jack is running a query and he reports that he is waiting for it to complete. So you have to identify whether the query is blocked. So which tool should you use to achieve this?

You are the administrator of your company network. You have to install a SQL Server 2008 instance for a new application on an existing server. The server contains a default SQL Server 2005 instance. You must make sure that certified third-party applications have access to their respective database instances. You have to ensure that when you take measures to achieve this, the existing application environments will not be changed, and you should use as little database administrative effort as possible. So what should you do?

You are the administrator of your company network. You're in charge of a SQL Server 2008 cluster in a high security environment. Now you intend to configure and use encrypted connections for the clustered virtual SQL Server. You have to install the certificate which will be used for encryption. So what should you do?

You are the administrator of your company network. You are in charge of three SQL Server 2008 instances named Instance1, Instance2, and Instance3. Each of them runs on a separate server. Between Instance1 and Instance2, a mission-critical database is mirrored. At present Instance1 currently acts as the Principal, while Instance3 acts as the witness. You intend to apply a patch on both servers. The server needs to restart itself. You have to identify the sequence of steps necessary to ensure that the patching process is completed with the minimum time and the database is online on the partner that currently does not apply the patch. Besides this two, you have to ensure that the database does not failover to the other partner during this time.So what should you do?

You are the administrator of your company network. You are in charge of checking the performance of a SQL Server 2008 instance. Now you have to identify the longest-running common language runtime (CLR) queries. So which dynamic management view should you use?

You are the administrator of your company network. You are performing the migration of an application from Microsoft SQL Server 2000 to Microsoft SQL Server 2008. You have to monitor the SQL Server instance to record the use of features that will be discontinued. So what should you do? Lead your way to certificates!

You are the administrator of your company network. You are in charge of a SQL Server 2008 instance. A management data warehouse uses the data collector to collect performance data. You intend to maintain the management data warehouse. You have to implement a process that routinely gathers and uploads data in the management data warehouse on different schedules. What data collection process should you implement?

You are the administrator of your company network. You are in charge of a SQL Server 2008 instance which contains various SQL Server Agent jobs. The jobs use seven shared schedules to run each job every day. You have to make sure that a job named Job1 doesn't run Wednesdays any longer. So what should you do to achieve this?

You are the administrator of your company network. You are in charge of a SQL Server 2008 instance which is configured to use the CT1204 and CT1222 trace flags during startup. What should you do to ensure that your failure recovery plan backs up the use of the trace flags? Lead your way to certificates!

You are the administrator of your company network. You are in charge of a SQL Server 2008 instance. You have to make sure that the names of all user-defined stored procedures contain the prefix usp_ on all instances. Besides this, you have to make sure that you cannot create stored procedures that do not contain this prefix. So what should you do?