Q#1: Data warehousing primarily involves:
(A) Collecting, storing, and managing large volumes of historical data for analysis
(B) Backup operations only
(C) Indexing only
(D) Transaction processing
Answer: (A) Collecting, storing, and managing large volumes of historical data for analysis
Q#2: A data warehouse is typically:
(A) Subject-oriented, integrated, time-variant, and non-volatile
(B) Transaction-oriented
(C) Only backup storage
(D) Only index storage
Answer: (A) Subject-oriented, integrated, time-variant, and non-volatile
Q#3: ETL in data warehousing stands for:
(A) Extract, Transform, Load
(B) Encrypt, Transfer, Log
(C) Extract, Test, Link
(D) Evaluate, Transform, Load
Answer: (A) Extract, Transform, Load
Q#4: Data marts are:
(A) Subsets of a data warehouse focused on a particular business area
(B) Backup copies of databases
(C) Index files only
(D) Transaction tables
Answer: (A) Subsets of a data warehouse focused on a particular business area
Q#5: OLAP stands for:
(A) Online Analytical Processing
(B) Online Automated Processing
(C) Offline Analytical Processing
(D) Only Log Analysis Processing
Answer: (A) Online Analytical Processing
Q#6: OLTP stands for:
(A) Online Transaction Processing
(B) Online Text Processing
(C) Offline Transaction Processing
(D) Only Table Processing
Answer: (A) Online Transaction Processing
Q#7: Difference between OLAP and OLTP:
(A) OLAP is for analysis and decision-making; OLTP is for daily transactions
(B) OLTP is for analysis; OLAP is for transactions
(C) Both are same
(D) Both are for backups
Answer: (A) OLAP is for analysis and decision-making; OLTP is for daily transactions
Q#8: Fact tables in a data warehouse:
(A) Contain measurable, quantitative data for analysis
(B) Contain only backup information
(C) Contain indexes only
(D) Contain only primary keys
Answer: (A) Contain measurable, quantitative data for analysis
Q#9: Dimension tables in a data warehouse:
(A) Contain descriptive attributes related to facts
(B) Contain indexes only
(C) Contain backup data only
(D) Contain primary keys only
Answer: (A) Contain descriptive attributes related to facts
Q#10: Star schema in data warehousing:
(A) Has a central fact table connected to dimension tables
(B) Only uses indexes
(C) Only stores backup
(D) Uses normalized tables only
Answer: (A) Has a central fact table connected to dimension tables
Q#11: Snowflake schema differs from star schema in that:
(A) Dimension tables are normalized
(B) Fact table is absent
(C) Only backup is stored
(D) Indexing is not used
Answer: (A) Dimension tables are normalized
Q#12: Data warehouse supports:
(A) Decision support and business intelligence
(B) Only transaction processing
(C) Backup only
(D) Encryption only
Answer: (A) Decision support and business intelligence
Q#13: Granularity in data warehouse refers to:
(A) Level of detail stored in the fact table
(B) Index level
(C) Backup frequency
(D) Table size
Answer: (A) Level of detail stored in the fact table
Q#14: Metadata in data warehousing:
(A) Describes the structure, source, and transformations of data
(B) Stores backup data
(C) Stores indexes
(D) Stores only keys
Answer: (A) Describes the structure, source, and transformations of data
Q#15: Incremental loading in ETL means:
(A) Loading only new or updated records
(B) Loading entire dataset every time
(C) Backup only
(D) Indexing only
Answer: (A) Loading only new or updated records
Q#16: Full extraction in ETL involves:
(A) Extracting the complete dataset from the source
(B) Extracting only updates
(C) Backup only
(D) Indexing only
Answer: (A) Extracting the complete dataset from the source
Q#17: Data cleansing in ETL refers to:
(A) Removing inconsistencies, errors, and duplicates
(B) Backup only
(C) Indexing only
(D) Encrypting data
Answer: (A) Removing inconsistencies, errors, and duplicates
Q#18: Data warehouse architecture includes:
(A) Source layer, ETL layer, data storage layer, presentation layer
(B) Only backup layer
(C) Only indexing layer
(D) Only transaction layer
Answer: (A) Source layer, ETL layer, data storage layer, presentation layer
Q#19: Types of OLAP include:
(A) MOLAP, ROLAP, HOLAP
(B) Only MOLAP
(C) Only ROLAP
(D) Only backup
Answer: (A) MOLAP, ROLAP, HOLAP
Q#20: MOLAP stores data in:
(A) Multidimensional cubes
(B) Flat files
(C) Backup only
(D) Indexes only
Answer: (A) Multidimensional cubes
Q#21: ROLAP stores data in:
(A) Relational tables
(B) Multidimensional cubes
(C) Backup only
(D) Indexes only
Answer: (A) Relational tables
Q#22: HOLAP is a combination of:
(A) MOLAP and ROLAP
(B) MOLAP and backup
(C) ROLAP and indexing
(D) Backup and encryption
Answer: (A) MOLAP and ROLAP
Q#23: Data warehouse is mainly used for:
(A) Analysis and reporting, not transactional operations
(B) Daily transaction processing
(C) Only backup
(D) Only indexing
Answer: (A) Analysis and reporting, not transactional operations
Q#24: Drill-down in OLAP means:
(A) Viewing data at a more detailed level
(B) Viewing backup only
(C) Viewing indexes only
(D) Encrypting data
Answer: (A) Viewing data at a more detailed level
Q#25: Roll-up in OLAP means:
(A) Viewing data at a summarized or higher level
(B) Viewing backups
(C) Viewing indexes
(D) Encrypting data
Answer: (A) Viewing data at a summarized or higher level
Q#26: Slicing in OLAP refers to:
(A) Selecting a single dimension from the cube
(B) Backup only
(C) Indexing only
(D) Normalization only
Answer: (A) Selecting a single dimension from the cube
Q#27: Dicing in OLAP refers to:
(A) Selecting a subcube by choosing multiple dimensions
(B) Backup only
(C) Indexing only
(D) Normalization only
Answer: (A) Selecting a subcube by choosing multiple dimensions
Q#28: Slowly Changing Dimensions (SCD) in data warehousing handle:
(A) Changes in dimension attributes over time
(B) Backup only
(C) Indexing only
(D) Encryption only
Answer: (A) Changes in dimension attributes over time
Q#29: Data warehouse improves:
(A) Decision-making and business intelligence
(B) Only transaction processing
(C) Only backup
(D) Only encryption
Answer: (A) Decision-making and business intelligence
Q#30: Main goal of data warehousing is:
(A) Consolidate data for analysis, reporting, and informed decision-making
(B) Backup only
(C) Encrypt data only
(D) Index data only
Answer: (A) Consolidate data for analysis, reporting, and informed decision-making