Domain.com has multiple servers in a distributed environment. You work with two SQL Server 2005 computers named SQL1 and SQL2. Each server uses SQL Server Authentication and they use different logins.
You need to write a distributed query that joins the data on SQL1 with the data on SQL2.
What should you do?

You configure a new SQL Server 2005 computer to use TCP/IP with all default settings. Your corporate policy requires that each server use a firewall. You find that you can connect to the SQL Server instance from the local computer. However, client computers cannot connect to the SQL Server instance.
You need to identify the most likely cause of the connection issues. What should you do first?

Your application must access data that is located on two SQL Server 2005 computers. One of these servers is named SQL1 and the other is SQL2. You have permissions to create a stored procedure on SQL1 to support your application. However, on SQL2 you only have permissions to select data.
You write the stored procedure on SQL1. The stored procedure accesses SQL2 by using the OPENQUERY Transact-SQL statement. However, the query fails when executed. You need to troubleshoot the cause of the error. 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 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)