2025-26-1S-COGNATES3-IST3-SFEXAM
Authored by Rosso Cuyos
others
University
Used 1+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
100 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
10 sec • 1 pt
A slowly changing dimension (SCD) Type 2 captures __________ history.
a. Current only
b. Full
c. No
d. Random
2.
MULTIPLE CHOICE QUESTION
10 sec • 1 pt
A role-playing dimension allows one dimension to serve __________ roles.
a. One
b. Multiple
c. Static
d. None
3.
MULTIPLE CHOICE QUESTION
10 sec • 1 pt
A junk dimension groups __________ attributes into one table.
a. Numeric
b. Miscellaneous
c. Historical
d. Time
4.
MULTIPLE CHOICE QUESTION
10 sec • 1 pt
Degenerate dimensions are stored in the __________ table.
a. Dimension
b. Fact
c. Log
d. Metadata
5.
MULTIPLE CHOICE QUESTION
10 sec • 1 pt
A mini-dimension is used to handle __________ attributes.
a. Static
b. Rapidly changing
c. Numeric
d. Random
6.
MULTIPLE CHOICE QUESTION
10 sec • 1 pt
Conformed dimensions are shared across __________ fact tables.
a. One
b. Multiple
c. Zero
d. Static
7.
MULTIPLE CHOICE QUESTION
10 sec • 1 pt
A snowflake schema normalizes __________ tables.
a. Fact
b. Dimension
c. Log
d. Cache
Access all questions and much more by creating a free account
Create resources
Host any resource
Get auto-graded reports
Continue with Google
Continue with Email
Continue with Microsoft
or continue with
%20(1).png)
Apple
Others
Already have an account?
