Preparing Practice Exam…
Please wait a moment while the system generates the exam questions, answers, and study session.
Please wait a moment while the system generates the exam questions, answers, and study session.
Microsoft Certified: Power BI Data Analyst Associate · Microsoft
Step Sequence / Reordering Question
Add and arrange the steps in the correct execution order.
Hotspot Solution:
The second question is a bit more complex. When analyzing "The count of classes that occur by period," the period must be in the attendance fact table. If the period is not in the fact table, this analysis is not possible. You cannot use the period from the class dimension to filter the occurred classes in the attendance fact because the relationship is based on class ID. In a period within the class dimension, you will have all the class IDs for that period, and then all these class IDs will filter the fact table without considering the classes that actually occurred in that period.
Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.
The second question is a bit more complex. When analyzing "The count of classes that occur by period," the period must be in the attendance fact table. If the period is not in the fact table, this analysis is not possible. You cannot use the period from the class dimension to filter the occurred classes in the attendance fact because the relationship is based on class ID. In a period within the class dimension, you will have all the class IDs for that period, and then all these class IDs will filter the fact table without considering the classes that actually occurred in that period.
I'd say the answer is: Class Dimension Attendance Fact Why? First, we need to design a star schema, which requires a fact table and several dimension tables. There are no relationships between dimension tables. The fact table is derived from View1 and includes the columns: Attendance Date, Student ID, Period Number, and Class ID.
Now, let's consider the dimensions. We can create a single class dimension that includes all the columns from View2. This might not be perfect, but it meets the requirements. Therefore, the answer to the first question is the Class dimension. If we create a teacher dimension table, the class ID field must be included; otherwise, this dimension table cannot be related to the fact table. However, the teacher ID would not be unique in this table, so we cannot consider it a teacher dimension. Instead, it should also be treated as a class dimension because the class ID is unique.