Microsoft-TS Microsoft SQL Server 2008 - Implementation and Maintenance Set 9

You are managing a SQL Server 2008 instance for Company.com. There is some database which is utilized through an application which is constantly useful in the server.A user called Clerk tells you that the server performance could not run normally. Not only you should utilize the Database Engine Tuning Advisor to help the functions of the application, but also you should make sure that the performance of the production server could not connected with others when analyzing the workload. Which is the correct answer?

You are managing a SQL Server 2008 instance for Company.com's Server Agent job is not running normally when you check the job history information which is incomplete and appears to be truncated. You should make sure that the whole information created by a job is useful for browsing. Which is the correct answer?

You are managing a SQL Server 2008 instance for Company.com. you are setting one Database Mail profile which is utilized to send reports to the whole workers of your organization. You utilize the sp_send_dbmail stored procedure to send reports during business hours. It will take a lot of time to deliverer reports to the manager. You should make sure that you could give the manager reports as quickly as possibleIn order to solve the problem, which is the correct answer?

You are managing a SQL Server 2008 which includes a database called Tester for the Company.com. You decide to permit the whole programmers to utilize SQL Server Profiler to get traces to troubleshoot the application which utilizes the database Tester.In order to solve the problem, which is the correct answer?

You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a remote SQL Server 2008 instance. You notice that the application has a poor performance. On the remote SQL Server instance, you capture a workload of the remote instance to a trace table by using SQL Profiler. Now you have to use the Database Engine Tuning Advisor to analyze the workload of the remote SQL Server instance on a local SQL Server instance. So what action should you perform to achieve this goal?

You are managing a SQL Server 2008 instance which includes a database named Product for Company.com.You should run full backup at 13:00 hours and run a differential backup at 15:00 hours, .Database snapshots were developed at 20:00 hours and at 21:00hours. The backups and the database snapshots are reserved on a different disk. The hard disk which includes the database files fails at 18:30 hours. You should make sure that you recovery the Product database through ensuring minimal data loss. Which is the correct answer?

You are managing a SQL Server 2008 instance which includes a database called Products whose recovery model is set to full for Company.com.The Products database's backup method is listed below:The information reserve on different disks. The hard disks which include the user database data files are reported to have failed at 17:00 hours on Wednesday. You should make sure that Products database could be saved by minimal data loss. Which is the correct answer?

You are managing a SQL Server 2008 cluster for the Company.com. You decide to test the failover response of the cluster. You should run a failover on the cluster by hand. Which is the correct answer? (select more than one)

You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance which is named Instance01. Instance01 contains a database which is named Dworks. The bulk-logged recovery mode is used by the Dworks database. You log ship the Dworks database through a WAN link. A scheduled job rebuilds the indexes of the Dworks database. You find that the size of the log backups for log shipping has been enlarged by the job. Now you have to reduce the size of the log backup. So what action should you perform to achieve this goal?

You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a database named Dworks in the instance. The Dworks database has the Products table. Now you have to replicate the Products table to the SQL Server instances at remote locations, so you create a Merge Replication topology and a Publication to do this. The Publication has a 21-day retention period. There is a user who goes on a business trip, 30 days later he comes back and finds that data in his database is not the latest. The Windows Event log states the following error message: "Replication: expired subscription dropped." You must get the latest data in the user's database and make sure that future data changes are appropriately replicated. So what action should you perform to achieve this goal?