Typically, in a star schema all ________ are given a simple, ...

[s.tung]

Typically, in a star schema all ________ are given a simple, non-composite system-generated key, also called a surrogate key.
 
  A) Fact tables
  B) Dimension tables
  C) Time columns
  D) Transaction identifiers

Question 2

Write an SQL query on the table STUDENT that lists the student ID for each student whose name is Connor.
 
  What will be an ideal response?

[nixon_s]

Answer to Question 1

B

Answer to Question 2

SELECT studentid
FROM student
WHERE name = 'Connor';

[s.tung]

Great answer, keep it coming

[Sarahjh]

Thanks for the timely response, appreciate it