Question 62 pts

Assume a course in the data warehouse has a CourseNum of ENC1101. How many times would ENC1101 appear in the Registrations table? In other words, how many rows in the Registrations table would have ENC1101 for the CourseNum?

ENC1101 would never appear in the Registrations table.

ENC1101 would appear exactly once.

ENC1101 would appear more than once.

ENC1101 would appear once for each term.

Flag this Question

Question 72 pts

Which one of the following is not a dimension table in the star schema?

Term

Course

DayTime

Campus

Registrations

Flag this Question

Question 82 pts

We can represent three dimensions in our data warehouse as a cube. Which of the following is the operation that will enable viewing a small sub-cube taken from the original as shown below?

slice

pivot

drill-down

dice

roll-up

Flag this Question

Question 92 pts

You want to improve the Registration data warehouse by adding another dimension table. Which one of the following can be added as a dimension table given the tables in the operational database?

ProfessorAge - The age of the professor who taught the course by group. For example: 25-35 years old, 36-45 years old, 46-55 years old, etc.

ProfessorDegree - The degree of the professor teaching the course.

StudentAge - The age of students by group. For example: 18-21 years old, 22-25 years old, 26-30 years old, etc.

StudentGender - The sex (male or female) of the sudent registering for the course.

Flag this Question

Question 102 pts

Given the star schema for the Registration data warehouse and given English I has a CourseNum of ENC1101, how many times would ENC1101 appear in the Course table? In other words, how many rows in the Course table would have ENC1101 for the CourseNum?

exactly once for each student registration

it would never appear in the Coursetable

more than once

exactly once