Practice Library
All MCQs
Browse exam-wise, subject-wise, and country-wise MCQs with explanations.
Choose an option to check your answer.
A.
One row per account at the end of each month
B.
One row for each individual ATM withdrawal
C.
One row repeatedly updated as an order progresses
D.
One row for every customer attribute change
Show Answer
Correct Answer: A. One row per account at the end of each month
Explanation:
Periodic snapshots capture the state of a process at regular intervals.
Choose an option to check your answer.
A.
One row per month for each product
B.
One row updated through the entire order lifecycle
C.
Only dimension version changes
D.
One row for each individual business event at its lowest chosen grain
Show Answer
Correct Answer: D. One row for each individual business event at its lowest chosen grain
Explanation:
Transaction facts store discrete events such as sales lines or payments.
Choose an option to check your answer.
A.
A Customer dimension containing names and addresses
B.
A staging table containing rejected rows
C.
A table recording student attendance using only dimension keys and no numeric measure
D.
A summary table containing monthly revenue
Show Answer
Correct Answer: C. A table recording student attendance using only dimension keys and no numeric measure
Explanation:
Factless facts record the occurrence of an event or coverage relationship.
Choose an option to check your answer.
A.
It prevents all date filtering
B.
It supplies reusable calendar, fiscal, holiday, and period attributes
C.
It removes the need for a fact timestamp
D.
It guarantees that every month has equal sales
Show Answer
Correct Answer: B. It supplies reusable calendar, fiscal, holiday, and period attributes
Explanation:
A Date dimension gives users rich, standardized time attributes.
Choose an option to check your answer.
A.
It has consistent meaning, keys, and attributes across multiple fact tables or data marts
B.
It contains only one row
C.
It is used by one report only
D.
It is copied independently with different definitions
Show Answer
Correct Answer: A. It has consistent meaning, keys, and attributes across multiple fact tables or data marts
Explanation:
Conformed dimensions enable facts from different processes to be analyzed together.
Choose an option to check your answer.
A.
A generated integer with no business meaning
B.
A measure calculated in a cube
C.
A partition number assigned by the database
D.
A business identifier supplied by a source system, such as CustomerCode
Show Answer
Correct Answer: D. A business identifier supplied by a source system, such as CustomerCode
Explanation:
Natural keys identify entities in operational business contexts.
Choose an option to check your answer.
A.
They make all descriptive attributes unique
B.
They eliminate the need for ETL lookups
C.
They provide stable warehouse identifiers independent of changing source keys
D.
They are always meaningful to business users
Show Answer
Correct Answer: C. They provide stable warehouse identifiers independent of changing source keys
Explanation:
Surrogate keys insulate the warehouse from source-key reuse and change.
Choose an option to check your answer.
A.
Type 2 unlimited historical rows
B.
Type 3 additional previous-value attribute
C.
Type 1 overwrite with no prior value
D.
A periodic snapshot fact
Show Answer
Correct Answer: B. Type 3 additional previous-value attribute
Explanation:
Type 3 stores limited history in additional columns on the same row.
Choose an option to check your answer.
A.
Type 2 historical rows
B.
Type 1 overwrite
C.
Type 0 fixed attribute
D.
Deleting the customer dimension row
Show Answer
Correct Answer: A. Type 2 historical rows
Explanation:
Type 2 creates a new dimension row with a new surrogate key for each version.
Choose an option to check your answer.
A.
Type 2 new row
B.
Type 3 previous-value column
C.
Factless fact insertion
D.
Type 1 overwrite
Show Answer
Correct Answer: D. Type 1 overwrite
Explanation:
Type 1 replaces the existing attribute value.
Choose an option to check your answer.
A.
Fact constellation removal
B.
Vertical partitioning
C.
Role-playing dimension
D.
Bridge elimination
Show Answer
Correct Answer: C. Role-playing dimension
Explanation:
One physical dimension can serve several logical roles in a business process.
Choose an option to check your answer.
A.
Create a new fact table for each flag
B.
Combine them into a junk dimension
C.
Store them only in report filters
D.
Remove the flags from the warehouse
Show Answer
Correct Answer: B. Combine them into a junk dimension
Explanation:
A junk dimension groups miscellaneous small categorical attributes.
