اختبار شهادة مايكروسوفت Microsoft Power BI Data Analyst

You plan to create a Power BI semantic model to analyze attendance at a school. Data will come from two separate views named View1 and View2 in an Azure SQL database.

View1 contains:

Attendance Date
Student ID
Period Number
Class ID

View2 contains:

Class ID
Class Name
Class Subject
Teacher ID
Teacher First Name
Teacher Last Name
Period Number
School Year
Period Start Time
Period End Time

The views can be related based on the Class ID column.

Class ID is the unique identifier for the specified class, period, teacher, and school year.

You need to design a star schema data model. The solution must facilitate the following analysis:

The count of classes that occur by period
The count of students in attendance by period by day
The average number of students attending a class each month

In which table should you include the Teacher First Name and Period Number fields?