MCSD.NET - 70-300 Exam Question:

Download Questions PDF

Suppose You are creating the physical design for the customer category data model. For reporting
purposes, you want to optimize access to customer category data. You define a Customer table
and a Category table. What should you do next?
A. Define three foreign key columns in the Category table, such that each column references a
different parent row in the Customer table. Define indexes on the foreign key columns.
B. Define three foreign key columns in the Customer table, such that each column references a
different parent row in the Category table. Define indexes on the foreign key columns.
C. Define a foreign key column in the Category table that references the parent row in the
Customer table. Define an index on the foreign key column.
D. Define a foreign key column in the Customer table that references the parent row in the
Category table. Define an index on the foreign key column.