Chapter 5, Designing a Data Model

1. Which type of table relationship describes a scenario where each unique value in one table occurs only once in another table?
   1. Many-to-many
   2. One-to-one
   3. One-to-many
   4. Unique relationship
2. What is the DAX formula needed to build a quick measure to calculate the weighted average per category?
   1. AVG(CATEGORY).
   2. AVGW(CATEGORY).
   3. AVERAGE([QUERY].[CATEGORY]).
   4. DAX isn't needed for a quick measure.
3. If your data has sales by store by day, are you able to find sales by hour?
   1. No.
   2. Yes.
   3. Sort of, it will be averaged by store by day.
   4. Sort of, it will be averaged by store by hour.