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 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. And you’re in charge of a SQL Server 2008 infrastructure. Now you are assigned a task to enforce naming standards for the database objects, so you have to design a solution to achieve this while using as little programming and administrative efforts as possible. So what should you do?

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?

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