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?

You have just been hired as the database administrator at Domain.com. Domain.com currently uses several Microsoft Access databases to store its business information. The Microsoft Access databases are stored on two application servers named Certkiller -SR04 and Certkiller -SR05.
You have been instructed to migrate some of the Microsoft Access databases on Certkiller -SR04 to SQL Server 2005. You must ensure that Domain.com users can access data in the Microsoft Access databases until all the data has been migrated to SQL Server 2005. During the migration process, Domain.com users must be able to run distributed queries against the data in both SQL Server 2005 and Microsoft Access. You install SQL Server 2005 on a member server named Certkiller -SR06. Certkiller -SR06 has limited disk space.
What should you do?

You work as the database administrator at Domain.com. The Domain.com network consists of a single Windows Server 2003 domain named Domain.com. All servers on the Domain.com network run Windows Server 2003. The Domain.com departments include a Sales department, a Purchasing department, and an Accounts department. The Domain.com network contains a SQL Server 2000 database server named Certkiller -DB01 and a SQL Server 2005 database server named Certkiller -DB02. Certkiller -DB02 contains a database named CK_Sales that stores sales data for the company.
The Sales department makes extensive use of the CK_Sales database. Domain.com users in the Purchasing department make use of a Microsoft Access database that runs on an application server named Certkiller -SR04 while users in the Accounts departments make use of a SQL Server 2000 database that run Certkiller -DB01. The manager of the Accounts department wants to be able to run distributed queries against the CK_Sales database and the databases in the Purchasing and Accounts departments. You must configure the Certkiller -SR04 and Certkiller -DB01 as linked servers on Certkiller -DB02. You need to select the required data sources to create the linked server definitions.
What should you do? (Choose all that apply.)

You work as the database administrator at Domain.com. Domain.com has five departments named Accounting, Sales, Marketing, Research and Manufacturing. The Domain.com user accounts of each department are located in a domain group named after the department. The Domain.com network consists of a single Active Directory domain named Domain.com. All servers on the Domain.com network run on Windows Server2003. The Domain.com network contains a SQL Server 2005 database server named Certkiller -DB01.
You have been instructed to create a separate database on Certkiller -DB01 for each department. Each Domain.com department will use their database to store department-related data. Users in each department must be able to read and update data in the database belonging to their department. No users must be able to access the database belonging to another department.
You need to configure access to the databases to meet these requirements. You want to use the least amount of administrative effort in accomplishing this task.
What should you do?

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 on Windows Server2003 while half the client computers run Windows XP Professional and the rest run UNIX. The Domain.com network contains a SQL Server 2000 database server named Certkiller -DB01 that runs on Windows 2000 Server. Certkiller -DB01 contains a database named CK_DB.
All Domain.com users will require access to the CK_DB database from the corporate network. You need to configure access to the CK_DB database to meet these requirements. You want to use the least amount of administrative effort in accomplishing this task.
What should you do?

You work as the database administrator at Domain.com. Domain.com has five departments named Accounting, Sales, Marketing, Research and Manufacturing. The Domain.com network consists of a single Active Directory domain named Domain.com. All servers on the Domain.com network run on Windows Server2003. The Domain.com network contains a SQL Server 2005 database server named Certkiller -DB01. Certkiller -DB01 hosts a database named CK_Sales that stores data for the Sales department. The CK_Sales database is accessed frequently throughout the day.
Mia Hamm, the manager of the Sales department is concerned that data may be lost should Certkiller -DB01 suffer hardware failure. Mia Hamm wants you to implement a recovery model and backup strategy for the CK_Sales database. You want to implement the highest level of recovery and you want to be able to restore the data for the CK_Sales database in the least possible time. What should you do? (Each correct answer provides part of the solution. Choose TWO.)

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 a SQL Server 2005 database server named Certkiller -DB01, and two Microsoft Exchange Server 2003 mail servers named Certkiller -EX01 and Certkiller -EX02. The Simple Mail Transfer Protocol (SMTP) is enabled on both mail servers.
Certkiller -DB01hosts a database named CK_Sales that is used to store sales related data for the company. The CK_Sales database contains a table named Inventory. The manager of the Purchasing department has requested a database report containing a list of the 20 most popular products and the amount of stock the company has for each of the top 20 products. You have produced the report. You attempt to send the report by e-mail using the sp_send_dbmail procedure but receive a failed return code. You verify that the mail servers are online and that the SMTP service is running on them.
You to need to send the report by e-mail from Certkiller -DB01.
What should you do?

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. You install SQL Server 2005 on a server named Certkiller -DB01 that runs on a Windows Server 2003 Service Pack 1. Certkiller -DB01 will contain a database named CK_Sales that will be used to store Internet sales transactions from the company’s e-commerce Web site.
Certkiller -DB01 has seven 120 GB hard disk drives. Two of the hard disks are configured as a mirrored volume and contains the operating system and SQL Server 2005 is installation. Another two disks are configured as a RAID-1 volume and the rest are configured as a RAID-5 volume.
You to need to plan the placement of the database and the transaction logs. You want to implement fault tolerance and best performance for the CK_Sales database.
What should you do?