Practice Library
All MCQs
Browse exam-wise, subject-wise, and country-wise MCQs with explanations.
Choose an option to check your answer.
A.
Governed enterprise metrics are embedded in repeatable decision processes
B.
Each department maintains unrelated spreadsheet definitions
C.
Reports are created without owners or documentation
D.
Data quality problems are handled only after executive complaints
Show Answer
Correct Answer: A. Governed enterprise metrics are embedded in repeatable decision processes
Explanation:
Mature BI combines governance, trusted data, adoption, and measurable business use.
Choose an option to check your answer.
A.
Modify database storage pages directly
B.
Guarantee causal conclusions from every chart
C.
Avoid considering data quality
D.
Interpret, question, and communicate with data appropriately
Show Answer
Correct Answer: D. Interpret, question, and communicate with data appropriately
Explanation:
Data literacy includes understanding measures, context, limitations, and evidence.
Choose an option to check your answer.
A.
A large number of charts regardless of relevance
B.
Restricting training to database administrators
C.
Reports and measures aligned with user decisions and business processes
D.
Changing metric definitions every week
Show Answer
Correct Answer: C. Reports and measures aligned with user decisions and business processes
Explanation:
Users adopt BI when it answers real questions in understandable terms.
Choose an option to check your answer.
A.
Thousands of tiny updates to individual order rows per second
B.
Complex read-intensive queries scanning large historical datasets
C.
Frequent locking of the same account balance row
D.
Interactive entry of customer addresses
Show Answer
Correct Answer: B. Complex read-intensive queries scanning large historical datasets
Explanation:
Warehouse workloads emphasize reads, joins, and aggregations over substantial history.
Choose an option to check your answer.
A.
A warehouse is optimized for historical analysis, while an operational database supports current transactions
B.
A warehouse cannot store numeric data
C.
An operational database contains no keys
D.
A warehouse is always smaller than an operational database
Show Answer
Correct Answer: A. A warehouse is optimized for historical analysis, while an operational database supports current transactions
Explanation:
Warehouses support analytical scans, aggregation, and historical comparison.
Choose an option to check your answer.
A.
Every query returns the same number regardless of filters
B.
Revenue no longer needs a time dimension
C.
Source systems can stop recording sales
D.
Users interpret and compare the measure consistently
Show Answer
Correct Answer: D. Users interpret and compare the measure consistently
Explanation:
Conformed definitions apply the same business logic wherever the measure appears.
Choose an option to check your answer.
A.
The full history of sales transactions
B.
A table of customer lifetime values
C.
A controlled list of country and currency codes
D.
A cube containing profit measures
Show Answer
Correct Answer: C. A controlled list of country and currency codes
Explanation:
Reference data provides stable code sets used to classify other data.
Choose an option to check your answer.
A.
A record of one customer purchase yesterday
B.
The governed definition of each customer used across business systems
C.
A temporary ETL error message
D.
A monthly total calculated in a dashboard
Show Answer
Correct Answer: B. The governed definition of each customer used across business systems
Explanation:
Master data represents core business entities shared across processes.
Choose an option to check your answer.
A.
It shows how the value moved and changed from source to report
B.
It guarantees that the number meets its target
C.
It increases the number of chart colors
D.
It prevents all data from being refreshed
Show Answer
Correct Answer: A. It shows how the value moved and changed from source to report
Explanation:
Lineage traces data origins, transformations, and destinations.
Choose an option to check your answer.
A.
Only database storage utilization
B.
Only quarterly revenue totals
C.
Only employee attendance records
D.
Multiple perspectives such as financial, customer, process, and learning
Show Answer
Correct Answer: D. Multiple perspectives such as financial, customer, process, and learning
Explanation:
A balanced scorecard avoids evaluating strategy through one measure alone.
Choose an option to check your answer.
A.
A complete list of every product in the catalog
B.
A copy of all raw sales transactions
C.
A list of warehouses whose stockout rate exceeds the approved threshold
D.
A dictionary of database column names
Show Answer
Correct Answer: C. A list of warehouses whose stockout rate exceeds the approved threshold
Explanation:
Exception reports focus attention on values outside expected limits.
Choose an option to check your answer.
A.
Hide uncertainty by showing only one chart
B.
Combine evidence, visuals, and narrative to communicate a meaningful conclusion
C.
Replace all numerical analysis with text
D.
Add decorative graphics unrelated to the data
Show Answer
Correct Answer: B. Combine evidence, visuals, and narrative to communicate a meaningful conclusion
Explanation:
Data storytelling organizes findings into a clear analytical message.
