Which design should you use?

Posted by: Pdfprep Category: 70-467 Tags: , ,


You need to extend the schema design to store the product dimension data.

Which design should you use? To answer, drag the appropriate table or tables to the correct location or locations in the answer area. (Fill from left to right. Answer choices may be used once, more than once, or not all.)



/ The schema design must be extended to include the product dimension data.

* DimProduct table need to contain a foreign key to the DimSubCategory table. No further SubCategory data should be stored in the DimProduct table.

* No time related columns (StartDate, EndDate) should be included in the DimProduct table.

Leave a Reply

Your email address will not be published.