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. 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. 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. And you’re in charge of a SQL Server 2008 infrastructure. You check and find that the performance of the instance is degrading. And this may because of deadlocks, excessive CPU usage or server processes paging. You have to work out a solution to monitor and identify performanceproblems. Your solution should provide information, including detailed deadlock information. You have to do this with as little administrative effort as possible. So which tool should you use?

You work as a database administrator at TestKing.com. You are responsible for managing a SQL Server 2008 instance that hosts a database named TK_Process. You have implemented the following backup strategy for TK_Process:
1. A full database backup that takes approximately 90 minutes to complete is performed at
21:00 every Tuesday, Thursday and Saturday.
2. A differential backup that takes approximately 40 minutes to complete is performed at 21:00 every Monday, Wednesday and Sunday.
3. A transaction log backup that takes less than 5 minutes to complete is performed every hour.
You schedule a batch process to run at 21:00 on Tuesday. This process requires approximately 100 minutes to complete. However, a TestKing.com user modifies some data at
21:03 on the same day and the batch process is invalidated. You want to restore the database to its origin state as quickly as possible.
What should you do?

You are the administrator of your company network. You are in charge of a default SQL Server 2008 instance. You intend to configure FILESTREAM data to meet the following requirements:
1. Enable FILESTREAM for file I/O streaming access.
2. Allow remote client computers to have streaming access to FILESTREAM data. You must make sure that FILESTREAM data is enabled.
Which service should you configure?

You are the administrator of your company network. You are in charge of a SQL Server 2008 instance which has to be configured to use a single thread for queries. The queries have an estimated execution cost less than 3. So which sp_configure configuration option should you set?

You are the administrator of your company network. You are in charge of a SQL Server 2008 instance which contains a database named Funds. You set the recovery model of the Finance database to Full. Every day at 2:00 a full database backup of all the user databases is performed. Every 15 minutes the transaction log backup is performed while A differential backup is performed every 4 hours. You intend to perform a full backup of the Funds database at 11:00. You must ensure that when you perform the backup, the overall backup and restore procedures for the Funds database will not be affected. Besides this, you have to ensure that the backup files are restored in proper sequence. So which Transact-SQL statement should you use?

You are the administrator of your company network. You are in charge of a SQL Server 2008 instance which contains a database named Funds. At 14:00 every day, the latest full backup was performed, and at 15:00, a differential backup was performed. At 16:00 and 17:00, database snapshots were created. Both the backups and the snapshots are stored on a different disk from the database files. The hard disk which contains the database files at 17:03. so what should you do to recover the Funds database while reducing the data loss?

You are the administrator of your company network. And you’re in charge of a SQL Server 2008 infrastructure. Now you intend to design a maintenance strategy for a mission-critical database.
And the database has a large table named DPT. Index maintenance operations are also included in the design plan. When designing the strategy, you must consider the following matters:The DPT table contains a column of the xml data type and is constantly accessed. New rows are frequently added to the DPT table. The average fragmentation for the clustered index of the Orders table is less than 2 percent. In order to optimize the performance of the queries on the table, you have to run the strategy. So what should you do?