1. . Data warehousing is:
(A) A system used to store and manage large volumes of historical and current data for analysis and reporting
(B) A method to compress data only
(C) A technique to encrypt data
(D) A backup system only
2. . The main purpose of a data warehouse is:
(A) Support decision-making through analytical queries and reporting
(B) Encrypt all database tables
(C) Compress tables for storage
(D) Delete old records automatically
3. . Characteristics of a data warehouse include:
(A) Only encrypted
(B) Subject-oriented, integrated, non-volatile, and time-variant
(C) Only compressed
(D) Only real-time transactional data
4. . OLAP (Online Analytical Processing) is used for:
(A) Compressing data
(B) Encrypting data
(C) Analyzing data in a data warehouse quickly
(D) Backup of tables only
5. . Data mining is:
(A) Encrypting database files
(B) The process of discovering patterns, relationships, and knowledge from large datasets
(C) Compressing files only
(D) Deleting old records
6. . Knowledge discovery in databases (KDD) is:
(A) A process that includes data selection, preprocessing, mining, and interpretation
(B) Only encrypting data
(C) Only compressing data
(D) Only deleting data
7. . Types of data mining tasks include:
(A) Backup tasks only
(B) Only encryption
(C) Only compression
(D) Classification, clustering, regression, association rule mining, and anomaly detection
8. . Classification in data mining means:
(A) Encrypting files
(B) Compressing tables
(C) Assigning data items to predefined categories
(D) Deleting old records
9. . Clustering in data mining means:
(A) Compressing files
(B) Encrypting tables
(C) Grouping data items with similar characteristics without predefined labels
(D) Backup only
10. . Association rule mining is used to:
(A) Encrypt data
(B) Discover relationships or patterns between items in large datasets
(C) Compress tables
(D) Delete old records
11. . Regression in data mining is used for:
(A) Predicting numerical values based on relationships between variables
(B) Encrypting files
(C) Compressing data
(D) Backup only
12. . Anomaly detection in data mining is used to:
(A) Backup tables
(B) Encrypt tables
(C) Compress data
(D) Identify unusual or abnormal data points
13. . Data cleaning in data mining involves:
(A) Backup only
(B) Encrypting tables
(C) Compressing tables
(D) Removing noise, inconsistencies, and errors from data
14. . Data integration in data warehousing means:
(A) Combining data from multiple heterogeneous sources into a unified format
(B) Encrypting data
(C) Compressing data
(D) Deleting old records
15. . Star schema in data warehousing consists of:
(A) Backup tables only
(B) Only encrypted tables
(C) Only compressed tables
(D) A central fact table connected to multiple dimension tables
16. . Snowflake schema differs from star schema because:
(A) Dimension tables are normalized into multiple related tables
(B) Fact tables are encrypted
(C) Fact tables are compressed
(D) Only backup tables
17. . Fact tables in data warehousing store:
(A) Compressed data only
(B) Metadata only
(C) Quantitative data for analysis, such as sales or revenue
(D) Encrypted data only
18. . Dimension tables in data warehousing store:
(A) Quantitative measures only
(B) Descriptive attributes for analyzing fact data
(C) Compressed tables only
(D) Encrypted tables only
19. . Data warehousing improves decision-making by:
(A) Compressing tables only
(B) Providing historical, integrated, and consistent data for analysis
(C) Encrypting tables only
(D) Backup only
20. . The main purpose of Data Warehousing & Data Mining is to:
(A) Compress data only
(B) Extract useful knowledge and insights from large volumes of data for decision support
(C) Encrypt data only
(D) Delete old records automatically