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?

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 want to obtain hardware configurations, such as the processor type of all SQL Server 2008 computers. So you have to develop a solution to achieve this. The solution you develop must be hosted on the central computer and can verify hardware configurations for multiple servers. You have to choose a technology that satisfy the two requirements above, while using as little development effort 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. The instance contains a database named RCC. Uses report that when executing reports, it makes response quite slowly. So you want to develop a monitoring strategy to monitor the performance. The strategy captures and stores the data such as Counters for disk, CPU, and memory, blocking and deadlock information, and executed Transact-SQL statements and query activity. When running the monitoring process, you must use as little administrative effort 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. 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 SQL Server 2008 instance.
Now you intend to deploy a new database which asks for capacity requirements. It requires 280 GB for the database data file and 50 GB for the transaction log file. The storage array has six disk drives available for the database. The capacity of the six disk drives are all 100 GB and are attached to a redundant array of independent disks (RAID) controller which supports RAID levels 0,1, 5, and 10. You have to optimize the write performance of the transactional log.
And you also have to protect the database and transaction log files if a drive failure occurs. You have to design the storage system. So which storage configuration should you use?