BI Quiz

The objective of BI is

• To support decision-making and complex problem solving.

• To support information gathering.

• To support data collection.

• To support data exploration.

What is business intelligence?

• The process of protecting sensitive business data from malicious users.

• The smarts gained from an advance business degree.

• The ability to forecast business trends using only intuition.

• The capability to analyze large quantities of business information and present it in a manner that facilitates better business decisions.

What is the difference between "data" and "information"

• Data is bits, bytes, characters, and values that mean little or nothing to human being. Information is data expressed in a format that can be understood and utilized by people.

• Data is information coming out of a computer, while information comes from television and newspapers.

• Data needs to be stored in database while information can be printed in reports, books and journals.

• Data is numerical in nature, while information is usually expressed in words.

Businesses collect a variety of data listed below except:

• regulatory data

• business process information

• public data

• personal data

What is the difference between data warehousing and data mining?

• Data warehousing and data mining are the same thing.

• Data warehousing is a strategy to keep data secure while data mining involves sharing information across a variety of networks.

• Data warehousing is a way to archive old information while data mining allows a user to lookup a specific fact.

• Data warehousing is concerned with the collection and storage of data while data mining is concerned with analyzing trends within that information.

What is the main purpose of a data warehouse?

• Storing transactional data.

• Performing real-time updates.

• Storing and analyzing historical data.

• Replacing operational databases.

Which of the following is NOT a characteristic of a data warehouse?

• Subject-oriented

• Volatile

• Time-variant

• Integrated

What is the role of the ETL process in a data warehouse?

• To generate reports.

• To update operational databases.

• To extract, transform, and load data into the data warehouse

• To store metadata

Which type of data warehouse stores real-time operational data?

• Enterprise Data Warehouse (EDW)

• Data Mart

• Operational Data Store (ODS)

• Cloud Data Warehouse

What is the key difference between OLAP and OLTP?

• OLTP is used for analytical queries, while OLAP is used for transactions.

• OLAP supports complex queries, while OLTP handles real-time transactions.

• OLAP is used only in banking systems.

• OLTP is used only for historical data analysis.