Data Mining in Government Quiz

What is data warehousing?

• A collection of tools and techniques for data analysis.

• A type of database for current transactions.

• A method for cleaning data.

• A process for collecting customer data.

What is the primary purpose of a data warehouse?

• To store current transactions.

• To store historical data for analysis.

• To manage customer relationships.

• To track ingredient usage.

What does ETL stand for in data processing?

• Extract, Transform, Load

• Evaluate, Transform, Load

• Extract, Transfer, Load

• Evaluate, Transfer, Load

What is one advantage of using a data warehouse?

• It allows for real-time data processing.

• It enhances data quality and consistency.

• It is less expensive than databases.

• It requires more IT support.

What is the difference between OLAP and OLTP?

• OLAP is for analytical processing, OLTP is for transactional processing.

• OLAP is for real-time data, OLTP is for historical data.

• OLAP is used by clerks, OLTP is used by executives.

• OLAP has a smaller database size than OLTP.

What is data mining?

• The process of cleaning data.

• The analysis of data to extract useful information.

• The storage of data in a warehouse.

• The integration of data from multiple sources.

What is the first step in the knowledge discovery process?

• Data Cleaning

• Data Integration

• Data Selection

• Data Transformation

What does a data warehouse provide?

• Real-time data access.

• Historical data for analysis.

• Current transaction processing.

• Limited data access.

What is the role of Business Intelligence (BI) in data warehousing?

• To store data.

• To analyze data and make decisions.

• To clean data.

• To collect data.

What is a key feature of a data warehouse?

• It is volatile.

• It is subject-oriented.

• It is only for current data.

• It is not integrated.