Adbase Quiz4

What is the main purpose of a data warehouse?

• To analyze and report data for business decisions

• To automate prediction of trends and behaviors

• To manage day-to-day operations

• To store historical data for future reference

Which characteristic of a data warehouse ensures that the data does not change once it is stored?

• Time-variant

• Integrated

• Subject-Oriented

• Non-volatile

What is the purpose of the Extraction, Transformation, and Loading Tools (ETL) in a data warehouse?

• To create consistent information on cross-functional activities

• To provide access to different kinds of DBMSs

• To eliminate unwanted data from loading into the warehouse

• To calculate summaries and derived data

Which type of OLAP is best suited to manage, store, and analyze multi-dimensional data?

• Outer detection

• Sequential Patterns

• Multi-dimensional OLAP (MOLAP)

• Relational OLAP (ROLAP)

What is the main goal of data mining?

• To retrieve important and relevant information about data

• To automate prediction of trends and behaviors

• To manage day-to-day operations

• To facilitate automated discovery of hidden patterns