You are the administrator of your company network. And you’re in charge of SQL Server 2008 instance. You intend to deploy a new database to the instance. The data will have lots of schemas and will be subject to frequent inserts and updates. One schema will contain plenty of reference data. In order to optimize backup performance, you have to design the physical database structure. So what should you do?

You are the administrator of your company network. You are in charge of a SQL Server 2008 instance which contains a database named Funds. And the Funds database is being used in single-user mode. The backup strategy for the Finance database meets the following two requirements:
1. At 09:00 every day, full database backup to a file called funds.bak is performed.
2. Since 09:15 every day, a transaction log backup to a file named funds_HHMM.trn is performed every 15 minutes.
A user came to report that a query deleted some important data by accident. The query was executed at 09:24. You are asked to recover the database to its original state. So which Transact-SQL statement(s) should you use to achieve this?

You are the administrator of your company network. There’s a SQL Server 2008 database solution which is log-shipped for high-availability purposes. The transaction log files of the database are located on drive E. The data files of the database are located on drive D. You are developing a recovery test plan for the log-shipping solution which has to satisfy the requirements bellow. The data should be in a consistent state. The data loss should be reduced to the least. The secondary database is brought online as quickly as possible. When drive D fails, you must choose what you should do first for the recovery plan. So which step should you do?

You are the administrator of your company network. And you’re in charge of a SQL Server 2008 infrastructure. Now you develop a corporate a backup and recovery strategy. The recovery strategy needs to be validated. If any single database experiences a disastrous failure, you must make sure that you can perform a successful recovery while no backup data center in a different location is needed. So which three actions should you perform? (Each correct answer presents part of the solution. Choose three.)

You are the administrator of your company network. You are in charge of a SQL Server 2008 infrastructure. There’s an instance that hosts a database named MAJOR1 which includes Filestream data. Users must be able to access this database uninterruptedly with no data loss. You have to carry out a high-availability solution for the site. So which solution should you use?

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?