INFS 346 FINAL – JUKIC EXAM MOST RECENT 2026 WITH CORRECT
ACTUAL QUESTIONS AND CORRECTLY WELL DEFINED ANSWERS LATEST
ALREADY GRADED A+
What is a surrogate key? - CORRECT ANSWER-A simple, system-generated key, that numerically
represents each record. Given to each dimensional table. They have no purpose other than to serve as
a primary key in the dimensional model
What else can fact tables include beyond numerical measures and foreign keys? - CORRECT
ANSWER-transaction identifier and transaction time
What is a dimensional table called if it has multiple fact tables? - CORRECT ANSWER-A constellation
What is a detailed fact table? - CORRECT ANSWER-Each record refers to a single entity
What is an aggregate fact table? - CORRECT ANSWER-Each record summarizes multiple facts
What is a slowly changing dimension? - CORRECT ANSWER-Since dimensional tables usually contain
static information, slowly changing dimensions literally change slowly. They contain info that is
normally static but changes occassionally - like someone's zip code
What is a type 1 approach to a slowly changing dimension? - CORRECT ANSWER-It just changes the
value and replaces the old one. No history is preserved
What is a type 2 approach to a slowly changing dimension? - CORRECT ANSWER-It creates an
additional record in the dimension using the new value as a surrogate key for the old value. Often
combines with timestamps and row indicators to show history
What is a row indicator? - CORRECT ANSWER-It is a column that says whether or not a record is
currently valid
, What is a type 3 approach to a slowly changing dimension? - CORRECT ANSWER-Creates a
previous/current column in the dimension. Only used when there is a fixed number of changes per
record or they don't need much history.
What is a snowflake model? - CORRECT ANSWER-A star schema that contains normalized
dimensions. Not usually done in dimensional modeling since dimensional modeling = analytical
database = read only
What is the least effective method for creating a data warehouse? - CORRECT ANSWER-Independent
data marts
How are data warehouses typically modeled? - CORRECT ANSWER-As relational databases
DBMS (database management system) - CORRECT ANSWER-creates, reads, updates, and deletes
data in a database while controlling access and security
Database system - CORRECT ANSWER-enables efficient interaction between end-users and the
information captured in a database
conceptual database model - CORRECT ANSWER-ER modeling - visual modeling of database
structure
logical database model - CORRECT ANSWER-Relational schema - includes cardinality constraints,
relationships, and entities
Database use - CORRECT ANSWER-insertion, modification, deletion, and retrieval of data
What are the steps to implementing a database? - CORRECT ANSWER-requirements, modeling,
implementation, & deployment
database analyst - CORRECT ANSWER-a person who is responsible for defining and visualizing data
ACTUAL QUESTIONS AND CORRECTLY WELL DEFINED ANSWERS LATEST
ALREADY GRADED A+
What is a surrogate key? - CORRECT ANSWER-A simple, system-generated key, that numerically
represents each record. Given to each dimensional table. They have no purpose other than to serve as
a primary key in the dimensional model
What else can fact tables include beyond numerical measures and foreign keys? - CORRECT
ANSWER-transaction identifier and transaction time
What is a dimensional table called if it has multiple fact tables? - CORRECT ANSWER-A constellation
What is a detailed fact table? - CORRECT ANSWER-Each record refers to a single entity
What is an aggregate fact table? - CORRECT ANSWER-Each record summarizes multiple facts
What is a slowly changing dimension? - CORRECT ANSWER-Since dimensional tables usually contain
static information, slowly changing dimensions literally change slowly. They contain info that is
normally static but changes occassionally - like someone's zip code
What is a type 1 approach to a slowly changing dimension? - CORRECT ANSWER-It just changes the
value and replaces the old one. No history is preserved
What is a type 2 approach to a slowly changing dimension? - CORRECT ANSWER-It creates an
additional record in the dimension using the new value as a surrogate key for the old value. Often
combines with timestamps and row indicators to show history
What is a row indicator? - CORRECT ANSWER-It is a column that says whether or not a record is
currently valid
, What is a type 3 approach to a slowly changing dimension? - CORRECT ANSWER-Creates a
previous/current column in the dimension. Only used when there is a fixed number of changes per
record or they don't need much history.
What is a snowflake model? - CORRECT ANSWER-A star schema that contains normalized
dimensions. Not usually done in dimensional modeling since dimensional modeling = analytical
database = read only
What is the least effective method for creating a data warehouse? - CORRECT ANSWER-Independent
data marts
How are data warehouses typically modeled? - CORRECT ANSWER-As relational databases
DBMS (database management system) - CORRECT ANSWER-creates, reads, updates, and deletes
data in a database while controlling access and security
Database system - CORRECT ANSWER-enables efficient interaction between end-users and the
information captured in a database
conceptual database model - CORRECT ANSWER-ER modeling - visual modeling of database
structure
logical database model - CORRECT ANSWER-Relational schema - includes cardinality constraints,
relationships, and entities
Database use - CORRECT ANSWER-insertion, modification, deletion, and retrieval of data
What are the steps to implementing a database? - CORRECT ANSWER-requirements, modeling,
implementation, & deployment
database analyst - CORRECT ANSWER-a person who is responsible for defining and visualizing data
