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. You detect that all indexes of the Marketing table on the SQL Server 2005 database server are heavily fragmented.
You are required to decrease the fragmentation of all the indexes of the Marketing table to a minimum. This needs to be accomplished whilst keeping the Marketing table is accessible to all users.
What should you do?
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 uses Service Broker to manage data requests between SQL Server 2005 databases. You have received instruction from the CIO to make changes to objects for an existing service. You need to make sure that no messages can be received by the service until the changes are complete.
What should you do?
Which methods should you use?
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 include administrating a SQL Server 2005 database server named Certkiller -DB01.
You have received instruction from the CIO to write a query that returns data from tables in a Certkiller -DB01. Several data is stored in relational columns and in XML data type columns. You need to write a query that return a relational result set that consists of data from relational fields and attribute values from the XML data type columns.
Which methods should you use? (Choose all that apply)
What actions should you implement?
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 mission-critical database named CK_DATA. CK_DATA is located on a server named Certkiller -DB01. You have received instruction from the CIO to mirror CK_DATA on a second server named Certkiller -DB02. Prior to establishing database mirroring you need to prepare CK_DATA and the servers for mirroring.
What actions should you implement?
What permission set should you use?
You are employed as a database administrator at Domain.com. Your duties at Domain.com are the administrating of the SQL Server 2005 database computer named Certkiller -DB07.
The application developers in the Research and Development department have created an assembly that contains a CLR function. The purpose of the CLR function is to read data from a spreadsheet, perform several calculations and returning the information to Certkiller -DB07. You need to register the assembly with Certkiller -DB07 by using the CREATE ASSEMBLY statement and the least privileged security permission set.
What permission set should you use?
What should he do?
You work as the database administrator at Domain.com. The Domain.com network consists of a single Active Directory domain named Domain.com. Your duties at Domain.com are the administrating of the SQL Server 2005 computer named Certkiller -DB01. You need to configure Certkiller -DB01 to use TCP/IP with all default settings. A Domain.com employee named Rory Allen works in the Finance department. Domain.com policy requires that every server make use of a firewall. You inform Rory Allen that you are able to connect to the SQL Server instance from the local workstation. However, the client computers are unable to connect to the SQL Server instance. Rory Allen needs to identify the most likely cause of the connection issues.
What should he do?
What should you do?
You are work 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 database server named Certkiller -DB01. Your duties at Domain.com include administrating Certkiller -DB01.
Domain.com has a Web site that has a page for customers to send feedback about Domain.com’s products. You use a database CK_Products to store the comments in the Comments column of a table named Feedback.
You want to implement full-text searching so that you can run reports on the Comments column.
What should you do? (Each correct answer presents part of the solution. Choose TWO.)
What should you do?
You work as the database administrator at Domain.com. All servers on the Domain.com network run Windows Server 2003 and all database servers run SQL Server 2005. The Domain.com network contains a database server named Certkiller -DB01 B01 that has two RAID-5 arrays for storing data files. Certkiller -DB01 hosts a database named CK_Products that stores data on the products sold by Domain.com.
Domain.com wants to allow prospective customers search for information in the CK_Products database via a Web-based interface. The prospective customers will use key words and phrases to search the CK_Products database. You decide to implement a Full-Text Search on the database. You install the Full-Text Search component on Certkiller -DB01 and start the Microsoft Search service. You then create the required catalog and full-text index. You modify the full-text index by running the following Transact-SQL statement:
ALTER FULLTEXT INDEX ON CK_Products.Description
ADD (shortName)
WITH NO POPULATION
Later you discover that you cannot perform full-text queries against the shortName column. You need to ensure that full-text queries can be performed against the shortName column.
What should you do?
What Transact-SQL statements should he use?
You work as the 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.
A Domain.com employee named Andy Booth is appointed as a junior technician in the Research and Development department. You have received a query from various users stating that the report execution is slow. You instruct Andy Booth to troubleshoot the error. Andy Booth discovers that some queries do not use optimal execution plans.
It has come to your attention that some optimizer statistics are missing while others are out of date. Andy Booth needs to solve this problem in order for the reports to be executed faster. Andy Booth needs to identify the Transact-SQL statements that need to be used.
What Transact-SQL statements should he use? (Choose all that apply)
What Transact-SQL statement should you use to recreate the table?
You work as the database administrator at Domain.com. All servers on the Domain.com network run Windows Server 2003 and all database servers run SQL Server 2005. The Domain.com network contains a database server named Certkiller -DB01.
Certkiller -DB01 hosts a database named CK_News that stores news items from the company. The CK_News database has a table named NewsStories that stores the news story text. These news stories are written in Microsoft Word. A data capturer uses an application to copy the news story to the CK_News database. You need to redesign the NewsStories table so that you can implement full-text searches on it. You backup the CK_News database and drop the NewsStories table. What Transact-SQL statement should you use to recreate the table?