Practice Library
All MCQs
Browse exam-wise, subject-wise, and country-wise MCQs with explanations.
Choose an option to check your answer.
A.
Rerunning the same successful input does not create unintended duplicates or changes
B.
It can run only once
C.
It always performs a full extraction
D.
It requires manual key assignment
Show Answer
Correct Answer: A. Rerunning the same successful input does not create unintended duplicates or changes
Explanation:
Idempotence makes retries safe after uncertain failures.
Choose an option to check your answer.
A.
Every source table has the same number of columns
B.
All dashboards use identical filters
C.
Every index has zero fragmentation
D.
Warehouse counts and totals agree with authorized source controls after transformations
Show Answer
Correct Answer: D. Warehouse counts and totals agree with authorized source controls after transformations
Explanation:
Reconciliation confirms completeness and numerical consistency across the load.
Choose an option to check your answer.
A.
Dashboard background color and font size
B.
User’s current browser window dimensions
C.
Load batch identifier, source system, and load timestamp
D.
Number of report pages printed
Show Answer
Correct Answer: C. Load batch identifier, source system, and load timestamp
Explanation:
Audit attributes show when and how a row entered the warehouse.
Choose an option to check your answer.
A.
Silently load them into production facts
B.
Quarantine them with error details for review and controlled reprocessing
C.
Delete them without an audit trail
D.
Change their values randomly until they pass
Show Answer
Correct Answer: B. Quarantine them with error details for review and controlled reprocessing
Explanation:
A reject process protects warehouse quality while preserving evidence.
Choose an option to check your answer.
A.
Create or use an inferred customer member, then update it later
B.
Discard the fact permanently
C.
Assign the key of an unrelated customer
D.
Wait indefinitely and block the entire warehouse load
Show Answer
Correct Answer: A. Create or use an inferred customer member, then update it later
Explanation:
An inferred member preserves the event while maintaining a valid foreign key.
Choose an option to check your answer.
A.
Overwrite the existing row without history
B.
Delete all facts referencing the old version
C.
Reuse the same row and remove effective dates
D.
Expire the old version and insert a new row with a new surrogate key
Show Answer
Correct Answer: D. Expire the old version and insert a new row with a new surrogate key
Explanation:
Type 2 preserves both old and new attribute states as separate dimension rows.
Choose an option to check your answer.
A.
By each dashboard user independently
B.
Inside every source application using different rules
C.
Within the controlled warehouse loading process
D.
From the current fact measure value
Show Answer
Correct Answer: C. Within the controlled warehouse loading process
Explanation:
Warehouse-controlled generation keeps keys unique and independent of source systems.
Choose an option to check your answer.
A.
Calculate a chart title
B.
Find the warehouse surrogate key corresponding to a source natural key
C.
Delete all historical dimension versions
D.
Choose the table partition size
Show Answer
Correct Answer: B. Find the warehouse surrogate key corresponding to a source natural key
Explanation:
Facts store surrogate dimension keys rather than source identifiers.
Choose an option to check your answer.
A.
Derivation of a new attribute or measure
B.
Source extraction
C.
Index rebuilding
D.
Dashboard filtering
Show Answer
Correct Answer: A. Derivation of a new attribute or measure
Explanation:
A derived field is calculated from one or more source values.
Choose an option to check your answer.
A.
A dashboard alignment check
B.
An index fragmentation check
C.
A report subscription check
D.
A domain or business-rule check
Show Answer
Correct Answer: D. A domain or business-rule check
Explanation:
Domain and business rules verify that values fall within valid conditions.
Choose an option to check your answer.
A.
Replace every missing value with zero regardless of context
B.
Delete the entire source system
C.
Apply a documented rule that reflects the meaning of the missingness
D.
Guess values manually without recording the method
Show Answer
Correct Answer: C. Apply a documented rule that reflects the meaning of the missingness
Explanation:
Missing values can mean unknown, not applicable, delayed, or erroneous.
Choose an option to check your answer.
A.
Aggregation
B.
Standardization
C.
Partition switching
D.
Role-playing
Show Answer
Correct Answer: B. Standardization
Explanation:
Standardization converts equivalent source representations into a common format.
