|
70-229: filegroups
|
|||
---|---|---|---|
#18+
============================================================ You are a database developer for a shipping company. You have a SQL Server 2000 database that stores order information. The database contains tables named Order and OrderDetails. The database resides on a computer that has four 9-GB disk drives available for data storage. The computer has two disk controllers. Each disk controller controls two of the drivers. The Order and OrderDetail tables are often joined in queries. You need to tune the performance of the database. What should you do? (Each correct answer presents part of the solution.)(Choose two.) A. Create a new filegroup on each of the four disk drivers. B. Create the clustered index for the Order table on a separate filegroup from the non-clustered indexes C. Store the data and the clustered index for the OrderDetail table on one filegroup, and create the non-clustered indexes on another filegroup D. Create the order table and its indexes on one filegroup, and create the OrderDetail table and its indexes on another filegroup E. Create two filegroups that each consist of two disk drivers connected to the same controller. ============================================================ Думаю, что D,E. Но почему-то терзают сомнения относительно A вместо E. Кто как думает? ... |
|||
:
Нравится:
Не нравится:
|
|||
31.01.2003, 18:28 |
|
|
start [/forum/topic.php?fid=34&fpage=63&tid=1552116]: |
0ms |
get settings: |
12ms |
get forum list: |
16ms |
check forum access: |
4ms |
check topic access: |
4ms |
track hit: |
51ms |
get topic data: |
12ms |
get forum data: |
3ms |
get page messages: |
36ms |
get tp. blocked users: |
1ms |
others: | 244ms |
total: | 383ms |
0 / 0 |