Practice Library
All MCQs
Browse exam-wise, subject-wise, and country-wise MCQs with explanations.
Choose an option to check your answer.
A.
Drill-through
B.
Roll-up
C.
Data masking
D.
Index compression
Show Answer
Correct Answer: A. Drill-through
Explanation:
Drill-through moves from an aggregate result to detailed source or fact records.
Choose an option to check your answer.
A.
Fixed batch processing
B.
Transaction rollback
C.
Schema replication
D.
Ad hoc analysis
Show Answer
Correct Answer: D. Ad hoc analysis
Explanation:
Ad hoc analysis supports questions not predefined in standard reports.
Choose an option to check your answer.
A.
It can display only one measure at a time
B.
It contains no historical values
C.
It explicitly tracks measures against strategic objectives and targets
D.
It is used only by database developers
Show Answer
Correct Answer: C. It explicitly tracks measures against strategic objectives and targets
Explanation:
Scorecards connect KPIs to goals, targets, and strategic performance.
Choose an option to check your answer.
A.
To replace the database transaction log
B.
To present important measures in a concise, monitorable visual form
C.
To define every source-system table
D.
To store raw files for long-term archival
Show Answer
Correct Answer: B. To present important measures in a concise, monitorable visual form
Explanation:
Dashboards highlight current status, trends, and exceptions in key measures.
Choose an option to check your answer.
A.
They make cross-functional analysis inconsistent and difficult
B.
They automatically improve enterprise data quality
C.
They guarantee common definitions across departments
D.
They remove the need for data reconciliation
Show Answer
Correct Answer: A. They make cross-functional analysis inconsistent and difficult
Explanation:
Silos store related data under different structures and definitions.
Choose an option to check your answer.
A.
A five-year profitability trend by product line
B.
A forecast of next year’s customer churn
C.
A comparison of strategic KPIs across divisions
D.
A list of today’s unshipped customer orders
Show Answer
Correct Answer: D. A list of today’s unshipped customer orders
Explanation:
Operational reports support immediate day-to-day activities using current detail.
Choose an option to check your answer.
A.
Transaction capture
B.
Database recovery
C.
Tactical decision
D.
Schema deployment
Show Answer
Correct Answer: C. Tactical decision
Explanation:
Tactical decisions translate strategy into medium-term plans and resource allocation.
Choose an option to check your answer.
A.
Approving a single customer refund
B.
Deciding whether to enter a new national market next year
C.
Recording a barcode scan at checkout
D.
Correcting a typographical error in an invoice
Show Answer
Correct Answer: B. Deciding whether to enter a new national market next year
Explanation:
Strategic decisions have long-term, organization-wide consequences.
Choose an option to check your answer.
A.
Inconsistent business definitions
B.
Excessive index selectivity
C.
Overuse of transaction locks
D.
Insufficient cube partitions
Show Answer
Correct Answer: A. Inconsistent business definitions
Explanation:
Different metric definitions create contradictory analytical results.
Choose an option to check your answer.
A.
The visual size of a dashboard chart
B.
The number of database users
C.
The encryption strength of a backup
D.
The level of detail represented by each fact row
Show Answer
Correct Answer: D. The level of detail represented by each fact row
Explanation:
Granularity states exactly what one row in a fact table represents.
Choose an option to check your answer.
A.
The number of columns in a dimension table
B.
The time required to design a dashboard layout
C.
The delay between a source event and its availability for analysis
D.
The distance between two data centers
Show Answer
Correct Answer: C. The delay between a source event and its availability for analysis
Explanation:
Latency measures how current analytical data is relative to source events.
Choose an option to check your answer.
A.
It prevents all users from creating visualizations
B.
It maintains trusted definitions, security, and appropriate data use
C.
It forces every analysis to be performed by database administrators
D.
It removes the need for data ownership
Show Answer
Correct Answer: B. It maintains trusted definitions, security, and appropriate data use
Explanation:
Governance balances analytical flexibility with consistency and control.
