NSCT – Data Warehousing & Data Mining (Introductory) MCQs 20 min Score: 0 Attempted: 0/20 Subscribe 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 onlyShow All Answers 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
