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 at Domain.com include maintaining a SQL Server 2005 database named Certkiller -DB06.
Analysts in the Sales department of Domain.com usually make use of a view named v_ClientSales to join the Clients and the Sales tables in the Certkiller -DB06. The analysts make use of this view to combine the total sales by clients per month. You increase the performance of the view.
What should you do? (Choose all that apply)

You work as a database administrator at Domain.com. The Domain.com network consists of a single Active Directory domain named Domain.com. As the administrator you plan to import client information from the Client table and the Product table in your SQL Server 2000 database into a SQL Server 2005 database. You have received instruction from the CIO to make certain that every value in the ProductCode column of the Client table has a corresponding record in the ProductCode column in the Product table of the SQL Server 2005 database during the import process.
You need to identify a foreign key between these two tables. Referential integrity will ensure that the import routine fails if there are any records where a ProductCode value does not exist in the Product table but does exist in the Client table. You need to make sure that the import process does not fail if it comes across records that do not exist in the Product table.
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 include administrating a SQL Server 2005 database named Certkiller -DB04. It has come to your attention that schema changes were made on Certkiller -DB04. Due to these changes on Certkiller -DB04 your Web site stopped functioning. It is however unclear who made the changes. You have received mandate from the CIO that all changes to the database schema be tracked. You implement a mechanism that will track schema changes in Certkiller -DB04.
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 administrating a SQL Server 2005 database named Certkiller -DB09.
Certkiller -DB09 consists of a table that has 300 million rows of information. In this table some information is historical and some is current. You instruct him to partition the information on a single server in order to increase performance and optimize maintenance.
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 include maintaining scheduled jobs for the SQL Server 2005 databases in your department.
You establish that one of the jobs aggregates data from multiple sources for reports. This job runs daily and consists of numerous steps. Every step aggregates data for a specific report. As administrator you have received several complaints from users that the data for a number of reports has not been updated recently. You need to make sure that every step of the job that aggregates data performs even when errors occur.
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 makes use of a SQL Server 2005 named Certkiller -DB03. You have received several complaints from users in the Sales department reporting that an order processing application stopped responding in the middle of an order transaction. The SQL Server session ID of users at Domain.com is 54. You need to determine whether session 54 is blocked by another connection.
What should you do? (Choose all that apply)

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?