mcsd 70-029 试题疑问之二???

[RickeyLv]

You are implementing a logical data model for a decision support system (DSS) database. Two of the
tables in the model have a parent/child relationship. The parent table is expected to have more than 1 millions rows. The child table is expected to have more than 100 million rows. Most reports present aggregate child information grouped according to each parent row. Reports containing detailed child table information are occasionally needed. How should the tables be implemented?
A. Create the parent table and child table as described in the logical data model
B. Create the parent table that includes aggregate child information. Do not create child table
C. Create the parent table that includes aggregate child information. Create the child table as it exists on the logical data model
D. On the child table, create a non-clustered index that includes any columns that are aggregate and the foreign key referenced to the parent
Answer: D还是C ?????

[yaw]

C

[RickeyLv]

与我的答案一样，给分