You work as the database administrator at Domain.com. The Domain.com network contains a SQL Server 2005 database server named Certkiller -DB01 that runs on a Windows Server 2003 computer. Certkiller -DB01 hosts a database named CK_Orders. Several data capturers enter data into the CK_Orders database everyday.
Domain.com wants you to implement a disaster recovery plan for the CK_Orders database. You need to ensure that data can be easily recovered. You plan to perform a full backup every Saturday at 2:00 P.M.
What should you do?

You work as the database administrator at Domain.com. All database servers run Windows Server 2003 and SQL Server 2005. All client computers run Windows XP Professional with Service Pack 2. The Domain.com network contains a database server named Certkiller -DB02 that runs SQL Server 2005 Enterprise Edition. Certkiller -DB02 hosts a database named CK_Sales. The tables in the CK_Sales database are shown in the following database diagram.

Domain.com has several Sales Representatives that use portable client computers. These portable client computers run SQL Server 2005 Express Edition. Domain.com has developed a new sales tracking application named salesTrack. The salesTrack application provides access to the Customers table in the CK_Sales database. Several Sales Representatives use the salesTrack application as part of Domain.com’s Customer Relationship Management (CRM) strategy. You need to ensure that the Sales Representatives can interact with the CK_Sales database while offline. The Sales Representatives must be able to access information about their customers while offline; must be able to add new customers while offline; and must be able to synchronize with Certkiller -DC02 on demand using Web synchronization.
exhibit What should you do? (Each correct answer presents 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 client computers run Windows XP Professional. The Domain.com network contains a SQL Server 2005 database server named Certkiller -DB01 that hosts a database named CK_Data. The tables in the CK_Data database are shown in the following database diagram.

You create a new database named CK_Staff on Certkiller -DB01. You want to transfer the list of employees from the CK_Data database to the CK_Staff database. You export the Employees table to a text file. The data must be imported as quickly as possible into the following table.

exhibit 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. The network contains a database server named Certkiller -DB01 that hosts a database named CK_Books. The CK_Books database has a table named SampleChapters that is used to store sample chapters from books published by Domain.com. The schema for the SampleChapters table is shown in the following exhibit:

The text for the sample chapters are stored in a column named SampleText. The SampleText column is defined as an xml data type column. The XML schema for the SampleText column is shown below:
<SampleChapter>
<BookTitle>title of book</BookTitle>
<Author>author of book</Author>
<ChapterText>
<ChapterTitle>title of chapter</ ChapterTitle >
<Intro>introduction or synopsis</Intro>
<Topic Title="topic title">topic text</Topic>
<Topic Title="next topic title">next topic text</Topic> </ChapterText>
</SampleChapter>
You need to create indexes that will optimize performance for search queries that are run against the SampleText column. You need to ensure best performance for a query that return the book title, author, and introduction of a specific sample chapter. The search query is shown below:
SELECT SampleText.value(‘SampleChapterBookTitle[1]’, ‘varchar’), SampleText.value(‘SampleChapterAuthor[1]’, ‘varchar’), SampleText.value(‘SampleChapterChapterTextChapterTitle[1]’, ‘varchar’),
SampleText.value(‘SampleChapterChapterTextIntro[1]’, ‘varchar’) FROM Samples
WHERE SampleID = @sampleID
You need to ensure that your solution meets Courseware Publisher’s technical and business requirements.
exhibit What should you do? (Choose all that apply.)

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 Server 2003. The Domain.com network contains a SQL Server 2005 database server named Certkiller -DB01. Certkiller -DB01 contains a database named CK_Sales. The tables in the CK_Sales database are shown in the database diagram.

Kara Lang is the manager of the Sales department. Kara Lang wants a report that indicates the performance of each sales person in the Sales department. She asks you to produce the report based on the SalesPersons and Invoices tables. The report must be presented in XML format.
exhibit 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 makes use of a SQL Server 2005 database named CK_Sales. CK_Sales is located on a database server named Certkiller -DB01.
A new Domain.com employee named Mia Hamm works in the Finance department. You have received instruction from the CIO to give a new employee, Mia Hamm, access to CK_Sales. You create a login named mhamm by using the following Transact-SQL statement. CREATE LOGIN mhamm WITH PASSWORD = Certkiller -DB01′
Mia Hamm reports that as soon as she logs in, she receives the following error message: "Login failed. You are not associated with a trusted SQL Server connection." You need to resolve the error and allow the Mia Hamm to gain access to Certkiller -DB01.
What should he do?