Common report types in BI: do they include static, dynamic/parameterized, ad-hoc query, and OLAP drill-down?
-
AValid statement — these are standard report types
-
BInvalid statement — OLAP is unrelated to reporting
-
CValid only for real-time streaming warehouses
-
DTrue only if the database is normalized to 3NF
-
EDepends on whether the report exports to PDF
Answer
Correct Answer: Valid statement — these are standard report types
Explanation
Introduction / Context:BI platforms typically support multiple consumption modes. This question checks recognition of standard report types: static (fixed layout), dynamic/parameterized (user inputs), ad-hoc query, and OLAP (interactive pivoting and drill-down).
Given Data / Assumptions:
- Static reports are scheduled and unchanging except for data refresh.
- Dynamic/parameterized reports allow user inputs (date ranges, regions).
- Query/ad-hoc lets users build their own result sets.
- OLAP provides multi-dimensional exploration.
Concept / Approach:These categories are standard across BI suites and courseware. OLAP is often considered a reporting/analysis interaction mode, so including it under “report types” is reasonable.
Step-by-Step Solution:List common types: static, dynamic, query, OLAP.Verify each aligns with typical BI functionality.Conclude the statement is valid.
Verification / Alternative check:Review product documentation: each mode appears as a first-class feature.
Why Other Options Are Wrong:OLAP is connected to reporting/analysis; normalization level and export format do not define report typology.
Common Pitfalls:Equating “report” strictly with PDFs; interactive OLAP views are also reports to many users.
Final Answer:Valid statement — these are standard report types