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.
Answer:
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.
Category table. Define an index on the foreign key column.
Download MCSD.NET - 70-300 Interview Questions And Answers
PDF