You are creating a SQL Server 2005 application that will store and manage legal documents.

The original documents are stored as XML documents on a file server. The application will be used to insert the

documents into the database. Later, the documents must be retrieved from the database. These documents must be

identical to the originals.

You need to design a table to store the document data.

What should you do?

TestKing.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?

You are preparing for a new installation of SQL Server 2005. You need to select the protocols that client computers might use to connect to the server.
Which two protocols can you use to achieve this goal? (Each correct answer presents a complete solution. Choose two.)

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 work in San Francisco at the main office of your company. You are responsible for managing a SQL

Server 2005 database.

The sales department wants a report that compares customer activity in the previous quarter between the main

office in San Francisco and the branch office in Paris. They want the data sorted by surname and first name.

You restore a recent backup of the Paris database onto your server. You write queries to build the report, ordering

the data by the Surname and FirstName columns. You review the data and notice that the customer list from the

Paris database is sorted differently. The sales department needs the revised data within 15 minutes for a

presentation.

You need to implement the fastest possible solution that ensures that the data from both databases is sorted

identically.

What should you do?

You are responsible for maintaining scheduled jobs for the SQL Server 2005 databases in your department. One of the jobs aggregates data from multiple sources for reports. This job runs daily. The job consists of multiple steps.
Each step aggregates data for a specific report. A user reports that the data for some of the reports has not been updated recently. You need to ensure that every step of the job that aggregates data executes even when errors occur. What should you do?

A power failure occurs on the storage area network (SAN) where your SQL Server 2005 database server is located. You need to check the allocation as well as the structural and logical integrity of all databases, including their system catalogs. What should you do?

You are responsible for maintaining scheduled jobs for the SQL Server 2005 databases in your department. One of the jobs aggregates data from multiple sources for reports. This job runs daily. The job consists of multiple steps. Each step aggregates data for a specific report. A user reports that the data for some of the reports has not been updated recently. You need to ensure that every step of the job that aggregates data executes even when errors occur. What should you do?

You are moving a SQL Server 2005 database named Timesheet to a new database server. The Timesheet database is used by the TimeEntry application. You need to minimize the amount of time that the TimeEntry application is unavailable while you move the database. What should you do?