| 1)
|
You would like to alter the content of a column in the SALES table that stores data in the XML type. Which method should you use? |
|
|
| 2)
|
You have just installed Microsoft SQL Server 2005 Enterprise Edition for use in the company. You need to set up security to allow access to the server to the employees of the company. The server will contain several databases, some of which contain sensitive information. How do you configure access to the server? |
|
|
| 3)
|
A production server has implemented partitioning, using a function that divides the data into four sections and reserves a fifth partition for future expansion; the fifth partition is currently unused. You need to query the utilization of the four currently used partitions. How would you perform the query? |
|
|
| 4)
|
You are diagnosing performance problems with one particular table in a major production database. A large amount of data has just been imported. You would like to repair any fragmentation and integrity issues and provide query response based on the newly imported data. Which statements would you use? |
|
|
| 5)
|
How to use HTTP naming conventions to create services locally and to allow them to be registered from remote systems? |
|
Choose best answer |
| 6)
|
You would like to produce a grouped report of sales, by city. You only want included on the report groups that have sales within the last calendar year (2005). Which of the following query elements would you use to solve the problem? |
|
|
| 7)
|
An application needs to query different data, based on user-selected criteria. The interface is presented to the user via a Windows application interface. After the selection is made, the data is drawn from the server and returned to a grid layout on the user's computer. What technology would be used for the implementation? |
|
|
| 8)
|
Several users are complaining of problems with updating of data through their application. You suspect that locks placed by other users and applications are preventing updates from occurring. Which of the following will help locate current locks and blocking? |
|
|
| 9)
|
You manage a database that contains a table that has many indexes. You notice that data modification performance has degraded over time. You suspect that some of the indexes are unused. You need to identify which indexes were not used by any queries since the last time SQL Server 2005 started. Which dynamic management view should you use? |
|
|
| 10)
|
Users report with increasing frequency that they receive deadlock error messages. You need to monitor which objects and SQL Server session IDs are involved when deadlock conditions occur. You want information about each participant in the deadlock. What should you do? |
|
|
| 11)
|
You are attempting to create an index on an existing view, created in a database. When the view was initially created, no preparation was done for indexing. You want to maintain the condition that was originally attached to the WHERE clause of the view. How do you implement the index? |
|
|
| 12)
|
Someone has created 60 jobs on the server to perform a variety of functions. You need to create a backup of the jobs so that they can be easily re-created in the event of a failure. What should you do? |
|
|
| 13)
|
You are performing a BCP operation to import data from text files prepared on another system. The pipe (|) character has been used as a field delimiter, and a colon (:) is the record delimiter. How do you accommodate this file? |
|
|
| 14)
|
Choose a configuration to install Microsoft SQL Server 2005 Enterprise Edition for test purposes and have moderate storage capabilities - |
|
|
| 15)
|
Your accounting system works with string variables that are aligned to the left in some cases and to the right in others. Space filling is used on all fields in the interface. You need to remove excess spaces from the strings prior to accepting the value into a table. What functions would you use? |
|
|
| 16)
|
A message is defined using the VALIDATION clause with VALID_XML. What checks are performed against the message before it is delivered? |
|
|
| 17)
|
You have a mission-critical application that runs in the context of the company's server. Database activity is high during the day because sales transactions are entered through network point-of-sale terminals. Sales clerks are reporting that transactions are taking too much time and customers are annoyed with the waiting period for updates to information. What would you do to diagnose the situation? |
|
|
| 18)
|
A bulk data load process has to be repeated often. Data will be exported from one server and imported into the other. To speed up the process, data should be imported in the primary key sequence. How to implement this so that it will occur as quickly as possible? |
|
|
| 19)
|
You work in a finance company where changes to the values in the Finance table are made quickly, and you want these incremental changes to be propagated to subscribers as they occur. The subscribers are always connected to the publisher with a reliable connection. Which type of replication do you use when you want updated changes at the server in almost real-time? |
|
|
| 20)
|
You need to store a large amount of data in an xml data type column of a database. The column must be indexed. You want to establish the fewest possible indexes and still provide the best performance for queries that utilize a lot of XQuery path operations. How would you set up the indexing? |
|
|