PrepAway - Latest Free Exam Questions & Answers

Which four actions should you perform in sequence?

DRAG DROP
You are designing a business intelligence (BI) solution for a hotel booking system. Each
hotel booking may have more than one guest.
The BI solution contains a fact table named Booking, a factless fact table named
Booking_Guest and a dimension named Guest.
Booking contains an entry for each booking. Booking_Guest contains an entry for each
guest in each booking. Guest contains an entry for each guest.
You need to define the many-to-many relationship in SQL Server Analysis Services (SSAS)
for the hotel booking system.
Which four actions should you perform in sequence? To answer, move the appropriate
actions from the list of actions to the answer area and arrange them in the correct order.

PrepAway - Latest Free Exam Questions & Answers

Answer: See the explanation

Explanation:
Box 1:

Box 2:

Box 3:

Box 4:

Ref: http://technet.microsoft.com/en-us/library/ms170463.aspx


Leave a Reply