MCQs: Data Mining and Data Warehousing (PGDM)

Which of the following best describes Business Intelligence (BI)?

• Writing computer programs

• Collecting raw data only

• Transforming data into meaningful information for decision-making

• Storing data in databases

Which type of analytics answers the question "What has happened?"

• Predictive

• Prescriptive

• Diagnostic

• Descriptive

Data used for managerial decision-making is generally referred to as:

• Transactional data

• Operational data

• Analytical data

• Temporary data

Which of the following is an example of unstructured data?

• Sales table

• Customer master file

• Excel worksheet

• Social media posts

A data warehouse is primarily designed for:

• Daily transaction processing

• Short-term storage

• Analytical and strategic decision-making

• Data entry operations

OLTP systems are mainly used for:

• Historical analysis

• Decision support

• Routine business transactions

• Forecasting

Which process involves extracting data from sources, transforming it, and loading it into a warehouse?

• CRM

• ERP

• ETL

• OLAP

A data mart is best described as:

• A full enterprise database

• A departmental subset of a data warehouse

• A transactional database

• A temporary data store

Data mining primarily focuses on:

• Data storage

• Discovering hidden patterns in data

• Data encryption

• Data deletion

Which of the following best defines data mining?

• Data backup technique

• Process of finding useful patterns and knowledge from large datasets

• Method of data storage

• Database security process