You work as a database administrator at Domain.com. The Domain.com network consists of a single Active Directory domain named Domain.com. Your duties include administrating a database named CK_DATA. CK_DATA is one of 15 databases located on a SQL Server 2005 computer named Certkiller -DB03. You have received several e-mail messages from users working on CK_DATA stating that they are experiencing long query execution times. As the administrator you want to reproduce and analyze this problem in a test environment that holds all copies of the production databases.
You need to record the workload for an entire day on Certkiller -DB03 for later execution on the test server. You need to make certain that all events are captured without skipping any, even though Certkiller -DB03 is under stress.
What should you do?

You work as a database administrator at Domain.com. The Domain.com network consists of a single Active Directory domain named Domain.com. Your duties at Domain.com encompass the configuration and maintaining the backup jobs for a SQL Server 2005 computer named Certkiller -DB02.
At present the backup files are written to a tape drive that is linked to the database server. Your department will in the nearby future install a new backup server. The backup files will then be written to disk on the new server. You are required to simplify the maintenance. You need to configure the backup jobs so that minimal changes will be necessary in order to back up to the new server.
What should you do?

You work as a database administrator at Domain.com. The Domain.com network consists of a single Active Directory domain named Domain.com. Your duties at Domain.com include managing a SQL Server 2005 database named Certkiller -DB02.
Certkiller -DB02 stores the financial information of Domain.com. You notice that several values in nchar columns in the database tables contain preceding or trailing spaces. You have received instruction from the CIO to implement a mechanism that selects the data from the tables without leading and trailing spaces. It is important that your solution is available for reuse in the Transact-SQL statements and views.
What should you do?

You work as a database administrator at Domain.com. The Domain.com network consists of a single Active Directory domain named Domain.com. You detect that all indexes of the Marketing table on the SQL Server 2005 database server are heavily fragmented.
You are required to decrease the fragmentation of all the indexes of the Marketing table to a minimum. This needs to be accomplished whilst keeping the Marketing table is accessible to all users.
What should you do?

You are employed as a database administrator at Domain.com. The Domain.com network consists of a single Active Directory domain named Domain.com. Domain.com uses Service Broker to manage data requests between SQL Server 2005 databases. You have received instruction from the CIO to make changes to objects for an existing service. You need to make sure that no messages can be received by the service until the changes are complete.
What should you do?

You are employed as a database administrator at Domain.com. The Domain.com network consists of a single Active Directory domain named Domain.com. Your duties include administrating a SQL Server 2005 database server named Certkiller -DB01.
You have received instruction from the CIO to write a query that returns data from tables in a Certkiller -DB01. Several data is stored in relational columns and in XML data type columns. You need to write a query that return a relational result set that consists of data from relational fields and attribute values from the XML data type columns.
Which methods should you use? (Choose all that apply)

You are employed as a database administrator at Domain.com. The Domain.com network consists of a single Active Directory domain named Domain.com. Domain.com makes use of a mission-critical database named CK_DATA. CK_DATA is located on a server named Certkiller -DB01. You have received instruction from the CIO to mirror CK_DATA on a second server named Certkiller -DB02. Prior to establishing database mirroring you need to prepare CK_DATA and the servers for mirroring.
What actions should you implement?

You work as the database administrator at Domain.com. The Domain.com network consists of a single Active Directory domain named Domain.com. Your duties at Domain.com are the administrating of the SQL Server 2005 computer named Certkiller -DB01. You need to configure Certkiller -DB01 to use TCP/IP with all default settings. A Domain.com employee named Rory Allen works in the Finance department. Domain.com policy requires that every server make use of a firewall. You inform Rory Allen that you are able to connect to the SQL Server instance from the local workstation. However, the client computers are unable to connect to the SQL Server instance. Rory Allen needs to identify the most likely cause of the connection issues.
What should he do?

You are work as a database administrator at Domain.com. The Domain.com network consists of a single Active Directory domain named Domain.com. The Domain.com network contains a SQL Server 2005 database server named Certkiller -DB01. Your duties at Domain.com include administrating Certkiller -DB01.
Domain.com has a Web site that has a page for customers to send feedback about Domain.com’s products. You use a database CK_Products to store the comments in the Comments column of a table named Feedback.
You want to implement full-text searching so that you can run reports on the Comments column.
What should you do? (Each correct answer presents part of the solution. Choose TWO.)