Practice Library
All MCQs
Browse exam-wise, subject-wise, and country-wise MCQs with explanations.
Choose an option to check your answer.
A.
A subject- or department-focused subset of analytical data
B.
A log of uncommitted database transactions
C.
A utility that repairs corrupted indexes
D.
A tool used only to create charts
Show Answer
Correct Answer: A. A subject- or department-focused subset of analytical data
Explanation:
A data mart serves a focused business area such as finance or marketing.
Choose an option to check your answer.
A.
Only one employee is allowed to create reports
B.
The warehouse contains exactly one table
C.
All business measures must have identical values
D.
Users rely on governed, consistent definitions and reconciled data
Show Answer
Correct Answer: D. Users rely on governed, consistent definitions and reconciled data
Explanation:
A governed BI platform standardizes data and metric definitions.
Choose an option to check your answer.
A.
It guarantees that every source uses the same software
B.
It processes point-of-sale transactions faster than OLTP
C.
It provides an enterprise-wide integrated analytical platform
D.
It eliminates the need for business definitions
Show Answer
Correct Answer: C. It provides an enterprise-wide integrated analytical platform
Explanation:
A warehouse brings data from multiple business areas into a common environment.
Choose an option to check your answer.
A.
Users update warehouse rows during every sales transaction
B.
Loaded records are mainly read and appended rather than continually overwritten
C.
Old data is deleted whenever new data arrives
D.
All queries must run inside write transactions
Show Answer
Correct Answer: B. Loaded records are mainly read and appended rather than continually overwritten
Explanation:
Nonvolatile means warehouse data is stable after it is loaded.
Choose an option to check your answer.
A.
To support analysis of changes and trends over time
B.
To prevent users from viewing older records
C.
To make every transaction update immediately
D.
To remove the need for dimension tables
Show Answer
Correct Answer: A. To support analysis of changes and trends over time
Explanation:
Time-variant data lets analysts compare performance across periods.
Choose an option to check your answer.
A.
Write optimization
B.
Volatile storage
C.
Process isolation
D.
Subject orientation
Show Answer
Correct Answer: D. Subject orientation
Explanation:
A subject-oriented warehouse is structured around major business subjects.
Choose an option to check your answer.
A.
Nonvolatile data
B.
Real-time transaction locking
C.
Integrated data
D.
Physical data compression
Show Answer
Correct Answer: C. Integrated data
Explanation:
Integration resolves naming, coding, and structural differences among sources.
Choose an option to check your answer.
A.
Replacing all operational databases with spreadsheets
B.
Transforming organizational data into useful information for decisions
C.
Writing source code for transaction-processing systems
D.
Encrypting every record before it enters a database
Show Answer
Correct Answer: B. Transforming organizational data into useful information for decisions
Explanation:
BI combines processes and tools that turn data into actionable insight.
Choose an option to check your answer.
A.
A centralized repository of integrated, historical data designed for analysis
B.
A temporary cache used only during transactions
C.
A database that stores only current operational records
D.
A spreadsheet containing departmental budgets
Show Answer
Correct Answer: A. A centralized repository of integrated, historical data designed for analysis
Explanation:
A data warehouse consolidates data from multiple sources for analytical use.
Medium
Choose an option to check your answer.
A.
Technical competence combined with ethical judgment, communication, and awareness of societal impact
B.
Willingness to collect all available data without limits
C.
Exclusive focus on training accuracy
D.
Ability to maximize model complexity regardless of consequences
Show Answer
Correct Answer: A. Technical competence combined with ethical judgment, communication, and awareness of societal impact
Explanation:
Future data scientists must build effective systems while considering privacy, fairness, security, and human consequences. Responsible practice integrates these concerns throughout the data-science lifecycle.
Hard
Choose an option to check your answer.
A.
Humans should be able to review, question, and intervene in consequential decisions
B.
Humans must approve every arithmetic operation
C.
It allows the model to operate without documentation
D.
Oversight guarantees that bias is impossible
Show Answer
Correct Answer: A. Humans should be able to review, question, and intervene in consequential decisions
Explanation:
Human oversight creates opportunities to catch unusual cases, apply context, and provide recourse. It must be genuinely empowered rather than a symbolic approval step.
Medium
Choose an option to check your answer.
A.
Accuracy alone excuses harmful outcomes
B.
The algorithm is responsible and humans have no obligations
C.
Responsibility ends immediately after deployment
D.
Identifiable people or organizations remain responsible for its design, use, monitoring, and consequences
Show Answer
Correct Answer: D. Identifiable people or organizations remain responsible for its design, use, monitoring, and consequences
Explanation:
Accountability requires ownership, governance, auditability, and mechanisms to address failures or harm. Automation does not transfer moral or institutional responsibility to software.
