Practice Library
All MCQs
Browse exam-wise, subject-wise, and country-wise MCQs with explanations.
Choose an option to check your answer.
A.
Fast multidimensional analysis of measures by dimensions and hierarchies
B.
A transactional screen for entering customer orders
C.
A storage location for unprocessed log files
D.
A replacement for all relational databases
Show Answer
Correct Answer: A. Fast multidimensional analysis of measures by dimensions and hierarchies
Explanation:
A cube organizes measures so users can analyze them across multiple business perspectives.
Choose an option to check your answer.
A.
Designing visual themes for reports
B.
Normalizing every dimension table
C.
Replacing all data-quality checks with alerts
D.
Coordinating task order, schedules, dependencies, retries, and monitoring across a pipeline
Show Answer
Correct Answer: D. Coordinating task order, schedules, dependencies, retries, and monitoring across a pipeline
Explanation:
Orchestration controls how multiple data tasks run as a reliable workflow.
Choose an option to check your answer.
A.
Insert rows one at a time through a dashboard
B.
Recalculate every report after each row
C.
Use set-based bulk loading with appropriate minimal logging and index strategy
D.
Create many unnecessary indexes before the load
Show Answer
Correct Answer: C. Use set-based bulk loading with appropriate minimal logging and index strategy
Explanation:
Bulk, set-based operations reduce per-row overhead and exploit database throughput.
Choose an option to check your answer.
A.
ELT performs no extraction
B.
Data is loaded before major transformations are executed in the target platform
C.
ELT cannot cleanse data
D.
ELT stores only aggregated results
Show Answer
Correct Answer: B. Data is loaded before major transformations are executed in the target platform
Explanation:
ELT uses the target system’s scalable processing engine for transformations.
Choose an option to check your answer.
A.
The permitted time period in which scheduled data processing should complete
B.
The number of rows displayed in a report
C.
The date range selected by a user
D.
The amount of free space in an index page
Show Answer
Correct Answer: A. The permitted time period in which scheduled data processing should complete
Explanation:
The load window is constrained by source availability and reporting deadlines.
Choose an option to check your answer.
A.
A gradual increase in dashboard users
B.
Movement of rows between date partitions
C.
A change in index page order
D.
An unexpected change in source columns, types, or structure
Show Answer
Correct Answer: D. An unexpected change in source columns, types, or structure
Explanation:
Source structures can evolve without coordinated warehouse changes.
Choose an option to check your answer.
A.
Random deletion of similar names
B.
Summing all customer keys
C.
Probabilistic or fuzzy matching across multiple attributes
D.
Indexing only the city column
Show Answer
Correct Answer: C. Probabilistic or fuzzy matching across multiple attributes
Explanation:
Fuzzy matching scores similarity across names, addresses, dates, and other fields.
Choose an option to check your answer.
A.
Color, font, margin, animation, and sound
B.
Accuracy, completeness, consistency, validity, timeliness, and uniqueness
C.
CPU, RAM, disk, keyboard, and monitor
D.
Table, view, trigger, cursor, and login
Show Answer
Correct Answer: B. Accuracy, completeness, consistency, validity, timeliness, and uniqueness
Explanation:
Data quality is evaluated through several complementary characteristics.
Choose an option to check your answer.
A.
Resolve dimension keys and insert measures at the declared grain
B.
Store every source description inside the fact
C.
Generate a new dimension row for every measure
D.
Remove all source transaction identifiers
Show Answer
Correct Answer: A. Resolve dimension keys and insert measures at the declared grain
Explanation:
A fact row combines measures with the correct dimensional context.
Choose an option to check your answer.
A.
Dimensions require fact measures to generate names
B.
Facts cannot contain numeric columns until dimensions are compressed
C.
Reports can display only dimension tables
D.
Fact foreign keys must resolve to valid dimension surrogate keys
Show Answer
Correct Answer: D. Fact foreign keys must resolve to valid dimension surrogate keys
Explanation:
Fact loading performs lookups against dimension members.
Choose an option to check your answer.
A.
All tables can always load in any order
B.
Dependencies improve dashboard decoration
C.
Some loads require prerequisite data or successful upstream completion
D.
They prevent source systems from recording transactions
Show Answer
Correct Answer: C. Some loads require prerequisite data or successful upstream completion
Explanation:
Dimensions, facts, aggregates, and semantic models often depend on earlier tasks.
Choose an option to check your answer.
A.
Failures are hidden from operators
B.
A failed workflow can resume from a safe checkpoint instead of repeating all work
C.
Source data is automatically corrected
D.
Every package runs in parallel
Show Answer
Correct Answer: B. A failed workflow can resume from a safe checkpoint instead of repeating all work
Explanation:
Checkpoints and batch states reduce recovery time after failures.
