Datawarehouse 3(A)

Which process involves running a question against the database to retrieve results?

• Query Optimization

• Query Execution

• Query Navigation

• Query Sharing

What is the main goal of query optimization?

• To make queries easier to write

• To find errors in queries

• To speed up query processing

• To remove unnecessary data

Which feature allows users to filter, drill down, and customize how data is explored?

• Query Execution

• Query Navigation

• Metadata Repository

• Aggregation

What is the purpose of query visualization?

• To secure data

• To share queries

• To monitor system performance

• To make results easier to understand

Which feature helps teams work together by allowing them to exchange queries and results?

• Query Sharing

• Query Execution

• Aggregation

• ETL

Security and access control ensure that:

• All users can access all data

• Only authorized users can view specific data

• Data is always visualized in charts

• Data is aggregated automatically

Which feature tracks execution times, resource usage, and system bottlenecks?

• Performance Monitoring

• Query Navigation

• Query Sharing

• ETL

What is metadata often called?

• Data dictionary

• Query result

• Aggregation

• Dimension

Which of the following is an example of a dimension in OLAP?

• Total Sales

• Profit Margin

• Time

• Average Revenue

Which OLAP concept shows different levels of detail like year → quarter → month → day?

• Metadata

• Hierarchies

• Measures

• Aggregations