MCQ Collection
Data Warehousing and Business Intelligence MCQs
Practice Data Warehousing and Business Intelligence questions with answers and explanations.
Choose an option to check your answer.
A.
Extracting, transforming, and loading data
B.
Designing network firewalls
C.
Creating only multidimensional calculations
D.
Managing employee access cards
Show Answer
Correct Answer: A. Extracting, transforming, and loading data
Explanation:
SSIS is Microsoft’s platform for data integration and workflow orchestration.
Choose an option to check your answer.
A.
The grain of the fact table
B.
The index fill factor
C.
The dashboard refresh color
D.
The transaction isolation level
Show Answer
Correct Answer: A. The grain of the fact table
Explanation:
Grain declares the exact meaning and level of detail of each fact row.
Choose an option to check your answer.
A.
Descriptive archiving
B.
Diagnostic analytics
C.
Operational transaction capture
D.
Data encryption analysis
Show Answer
Correct Answer: B. Diagnostic analytics
Explanation:
Diagnostic analysis seeks causes and contributing factors behind observed results.
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.
Choose an option to check your answer.
A.
Scanning five years of sales by region
B.
Updating the status of one customer order
C.
Calculating annual market share across all products
D.
Building a cube aggregation design
Show Answer
Correct Answer: B. Updating the status of one customer order
Explanation:
OLTP transactions are typically short, focused, and affect few rows.
Choose an option to check your answer.
A.
Create every physical index immediately
B.
Identify business questions, users, measures, scope, and priorities
C.
Select chart colors before meeting users
D.
Load all source data without profiling it
Show Answer
Correct Answer: B. Identify business questions, users, measures, scope, and priorities
Explanation:
Requirements define what decisions and processes the warehouse must support.
Choose an option to check your answer.
A.
Let developers overwrite production at any time
B.
Coordinate versioned changes to ETL, schemas, models, and reports
C.
Prevent all future enhancements
D.
Store transaction data in dashboard files
Show Answer
Correct Answer: B. Coordinate versioned changes to ETL, schemas, models, and reports
Explanation:
Warehouse components are interdependent and must be deployed in a controlled sequence.
Choose an option to check your answer.
A.
Recording individual customer transactions
B.
Building semantic models and analytical structures for fast multidimensional or tabular analysis
C.
Creating operating-system accounts
D.
Repairing damaged storage devices
Show Answer
Correct Answer: B. Building semantic models and analytical structures for fast multidimensional or tabular analysis
Explanation:
SSAS provides tabular and multidimensional analytical models.
Choose an option to check your answer.
A.
Account balance measured at month end
B.
Sales amount recorded for each transaction line
C.
Profit margin percentage
D.
Average selling price
Show Answer
Correct Answer: B. Sales amount recorded for each transaction line
Explanation:
Transaction sales amounts can be summed across all relevant dimensions.
Choose an option to check your answer.
A.
Data entry validation
B.
Schema normalization
C.
Predictive analytics
D.
Index rebuilding
Show Answer
Correct Answer: C. Predictive analytics
Explanation:
Predictive analytics uses patterns in historical data to estimate future outcomes.
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.
Insert one new payment record
B.
Change one customer’s shipping address
C.
Compare quarterly profit by region for the last six years
D.
Cancel a single pending order
Show Answer
Correct Answer: C. Compare quarterly profit by region for the last six years
Explanation:
OLAP queries analyze substantial historical data across dimensions.
