You are the administrator of your company network. You are in charge of a SQL Server 2008 instance, each of which hosts a single database application. Now you want to perform a migration, move all the following four instances to a new SQL Server failover cluster which will hosts all four databases on a single virtual cluster IP address. The following table displays the configuration of the four instances:The four instances have been optimized and they have got no extra memory or free CPU cycles. Now you have to perform a configuration on the new cluster, so that it is able to undertake the workload of all the database applications while using as little hardware resources as possible. So which cluster configuration should you use?

You are the administrator of your company network. You are in charge of two SQL Server 2008 instances respectively named Instance1 and Instance2. On Instance1, there’s a database named Taskgo. Now you migrate the Taskgo database from Instance1 to Instance2. A user uses a SQL Server login named TEX with the password “Re#99$45” to access the database on Instance1.
On Instance2, you create the same SQL Server login. The user tries to use the SQL Server login TEX to access the Taskgo database on Instance2. But the user gets an error message, saying that the access to the AdventureWorks database is denied. Now you must make sure that the user is able to access the Taskgo database.So which Transact-SQL statements should you execute on Instance2?

You work in a company named Fabric Ltd. You are the administrator of your company network. Now you’re in charge of a SQL Server 2008 instance which contains a database named DB1. The DB1 database can be accessed by a Windows group named FABRIC\Officials that is a member of the db_owner role in the DB1 database. A Windows user named UserA is a member of the FABRIC\Managers group. You must make sure that User1 can not access the SQL Server instance. Which Transact-SQL statement(s) should you execute in the DB1 database?

You are the administrator of your company network. Now you’re in charge of a SQL Server 2008 instance which runs on a computer. The computer hosts several applications. You use the SERVER1\AGENT account to configure the SQL Server Agent service to run. You create a job called PostingList. It needs a file to be written toa file server. But since the job doesn’t have right access to the file server, it fails to run. You intend to configure the SQL Server Agent service so that only it has read and write access to the file server. So which account should you use?

You are the administrator of your company network. You are reviewing and configuring the security of a SQL Server 2008 instance. The instance includes database DB1.The security audit policy requires that only successful and failed logon attempts are recorded in log files, besides this, if records cannot be written to the log files, the SQL Server instance must be shut down. You have to configure the SQL Server instance to be coordinated with the security audit policy. Which Transact-SQL statements should you run?

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?

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?

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 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?

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?