You work as the database administrator at Domain.com. The Domain.com network consists of a single Active Directory domain named Domain.com. All servers on the Domain.com network run Windows Server2003. The Domain.com network contains two member servers named Certkiller -SR15 and Certkiller -SR16, as well as a single SQL Server 2005 database server named Certkiller -DB01. Certkiller -DB01 hosts a database named CK_Projects that contains mission critical data.
You need to provide fault tolerance and improve the availability of the CK_Projects database. Your solution must provide zero down time and the highest level of recovery. You are unable to acquire any additional hardware. You verify the Certkiller -SR15 and Certkiller -SR16 exceeds the recommended hardware requirements for SQL Server 2005. You then install SQL Server 2005 on Certkiller -SR15 and Certkiller -SR16.
What should you do next?

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 consists of two domains named Certkiller -north.com and Certkiller -south.com. There is no trust relationship between Certkiller -north.com and Certkiller -south.com.
Certkiller -north.com consists of a server named Certkiller -DB01 and Certkiller -south.com contains a server named Certkiller -DB02. Certkiller -DB01 and Certkiller -DB02 is both configured to run SQL Server 2005. The SQL Server instance on Certkiller -north.com makes use of the Certkiller -north.com SQLService1 service account and the SQL Server instance on Certkiller -DB02 makes use of the Certkiller -south.com SQLService2 service account. You have been informed by the CIO that there are no mirroring endpoints on either server. Certkiller -DB01 contains a database named CK_DATA. The CIO wants you to mirror CK_DATA to Certkiller -DB02 by using high-protection mode without a witness. You need to create the database mirroring endpoints as well as configuring security on all participating server instances.
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. The Domain.com network contains a SQL Server 2005 computer named Certkiller -DB01.
You have received instruction from the CIO to create an HTTP endpoint that will be used to provide customer data to external applications. A Domain.com user named Andy Booth is a junior technician appointed in the Research and Development department. You instruct him to create a stored procedure named dbo.usp_GetResData to retrieve the information in the CK_R&D database. Andy Booth creates the endpoint by using the following code.
CREATE ENDPOINT SQLEP_R&DData
AS HTTP
(PATH = ‘/R&DData’,
AUTHENTICATION = (INTEGRATED),
PORTS = (CLEAR),
SITE = ‘ Certkiller -DB01’)
FOR SOAP
(WEBMETHOD ‘PersonData’
(NAME=’ Certkiller .dbo.usp_GetResData’),
BATCHES = DISABLED,
WSDL = DEFAULT,
DATABASE = ‘CK_R&D’,
NAMESPACE = ‘http:// Domain.com/R&D’)
You receive various complaints by users stating that they are unable to get any data when they connect to the endpoint. As the administrator you connect to the endpoint and discover that it is not responding. You instruct Andy Booth to modify the endpoint in order that data is returned as expected.
What should he 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. The Marketing department and the Sales department are located in different buildings. However, the two departments are connected by a 2 megabit network. The two departments both make use of SQL Server 2005.
The sales department records all sales activities in a database named Certkiller -DB01. Certkiller -DB01 consists of 380 tables and has a size of 10 GB. The marketing department has read-only access to four tables in Certkiller -DB01. This is for reporting purposes. Queries are run by the marketing department throughout the day. The marketing department requires that the data be as current as possible.
You have received several complaints from the users in the marketing department informing you that the report execution is slow. In order to optimize network capacity the CIO decides to provide copies of these four tables to the marketing department. You request that you are supplied with copies of these tables. You need to accomplish this objective by using the copy method that makes use of the minimum network bandwidth.
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. Domain.com has multiple servers in a distributed environment.
Your duties at Domain.com encompass administrating two SQL Server 2005 computers named Certkiller -DB01 and Certkiller -DB02. Every server makes use of SQL Server Authentication and they use different logins. You need to write a distributed query that joins the data on Certkiller -DB01 with the data on Certkiller -DB02.
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 two SQL Server 2005 database named Certkiller -DB01 and Certkiller -DB02.
A Domain.com employee named Clive writes various ad hoc queries against the company databases. Clive has access to the Client database on Certkiller -DB01. Clive does not have any access to the Marketing database on Certkiller -DB02. You need to make sure that Clive is able to write queries that join data from both Certkiller -DB01 and Certkiller -DB02.
What should you do?

Domain.com has employed you as a database administrator. The Domain.com network consists of a single Active Directory domain named Domain.com. You have been informed by the CIO that your application should access data that is located on two SQL Server 2005 computers. The two SQL Servers are named Certkiller -DB02 and Certkiller -DB03. The CIO informs you that you have the permissions to create a stored procedure on Certkiller -DB02 to support the application. However, on Certkiller -DB03, you only have permissions to select data.
A Domain.com user named Andy Reid is a member of the Research and Development department. You instruct Andy Reid to write the stored procedure on Certkiller -DB02. The stored procedure accesses Certkiller -DB03 by using the OPENQUERY Transact-SQL statement. Andy Reid discovers that the query fails when it is executed. Andy Reid needs to troubleshoot the origin of the error.
What should he do?

You work as a database administrator at Domain.com. The Domain.com network consists of a single Active Directory domain named Domain.com. Domain.com has multiple servers in a distributed environment.
Your duties at Domain.com encompass administrating two SQL Server 2005 computers named Certkiller -DB01 and Certkiller -DB02. Every server makes use of SQL Server Authentication and they use different logins. You write a distributed query that joins the data on Certkiller -DB01 with the data on Certkiller -DB02.
What should you do?

You work as a database administrator at Domain.com. The Domain.com network consists of a single Windows 2000 domain named Domain.com. All servers on the Domain.com network run Windows 2000 Server and all client computers run Windows XP Professional. Domain.com currently uses an ODBC-compliant proprietary Relational Database Management System (RDBMS) to store business information.
You have been instructed to migrate some of the databases in the proprietary RDBMS to SQL Server 2005. You need to ensure that Domain.com users can access data in the RDBMS databases during the migration process. You deploy SQL Server client tools on all Domain.com client computers. You want to ensure that Domain.com users can access data in both database systems by running ad hoc queries against SQL Server.
What should you do?