Worksheets1.1 CSA1620 DWDM Data warehouse Intro, Architecture, DSS
Total questions: 150
Worksheet time: 1hrs 15mins
What is the primary role of a data warehouse in business decision-making?
To store real-time transactional data
To organize data for operational use
To support analytical queries and decision support
To maintain historical backups of transactional data
A key difference between Operational Systems (OLTP) and Decision Support Systems (OLAP) is:
OLTP systems store historical data, whereas OLAP systems store real-time data
OLTP systems are designed for complex queries, while OLAP systems are designed for transactional operations
OLTP systems handle real-time data, whereas OLAP systems are optimized for analysis and complex querying
OLAP systems handle operational transactions, whereas OLTP systems support decision-making processes
Which of the following is NOT a feature of Decision Support Systems (DSS)?
Query processing
Real-time transaction processing
Multidimensional analysis
Data aggregation
Which of the following would most likely be stored in a data warehouse?
Customer’s recent purchase transaction
Historical sales data over several years
Inventory levels in real time
User session data for a website
What does ETL stand for in the context of data warehousing?
External, Transaction, and Loading
Extract, Transform, and Load
Extract, Transport, and Link
Encrypt, Transform, and Load
A Data Mart is best described as:
A full-scale version of a data warehouse with all historical data
A subset of a data warehouse, focused on a specific business area
The transactional database used for daily operations
A backup system for a data warehouse
What is the primary function of a Data Warehouse?
To store and process operational data
To support operational processes
To organize, consolidate, and analyze historical data for business decision-making
To backup data from transactional systems
Which of the following is a major disadvantage of a Data Warehouse?
Supports real-time operational processes
Stores and handles large volumes of transactional data
It requires large storage capacity and complex integration
Provides real-time data for decision-making
Which of the following best defines an OLAP cube?
A physical storage device used to store transactional data
A data structure that allows for efficient multidimensional analysis
A tool for real-time processing of operational data
A simple table that stores historical data
Which of the following is an example of a business question that would be best suited for a Data Warehouse?
What is the current stock level of a product?
How much revenue was generated last quarter by region?
What was the last transaction made by a customer?
Who is logged into the sales portal right now?
What is a key advantage of using a Data Warehouse in Decision Support Systems?
It handles real-time transactional data very efficiently
It stores structured data only
It supports multidimensional analysis and fast querying for decision-making
It uses a simpler database design than operational systems
In a Data Warehouse, which type of data is primarily stored?
Historical and aggregated data for analysis
Current transactional data for operational use
User-generated content from web applications
Real-time operational logs
The Extract, Transform, Load (ETL) process is important for:
Cleaning and consolidating data from multiple sources into a data warehouse
Storing large amounts of real-time transactional data
Running multidimensional queries on operational systems
Backing up the data warehouse
What is the main goal of OLAP (Online Analytical Processing)?
To facilitate real-time transactions
To support analytical querying and multidimensional analysis
To manage inventory and operational data
To provide online sales data
The term "Data Warehouse Architecture" typically refers to:
The physical design of the warehouse building where data is stored
The structure of data storage and retrieval within the system
The way the ETL process is executed
The indexing methods used in a database
A Data Warehouse differs from a Database in that it:
Stores only real-time transactional data
Is optimized for multidimensional querying and analysis
Stores data with limited history
Is used to run operational processes
Which of the following is a common method used for aggregating data in a data warehouse?
Data replication
Data normalization
Data roll-up
Data indexing
What is a "fact table" in a Data Warehouse?
A table that contains business dimensions
A table that stores raw data and numeric values like sales or profits
A table that stores historical data about the warehouse
A table used for real-time data storage
A "dimension table" in a Data Warehouse stores:
Numerical data used for aggregation
Descriptive attributes related to fact table data
Transactional data used for real-time analysis
Historical data of user activities
What type of schema is commonly used for data warehousing?
Relational schema
Star schema and Snowflake schema
Network schema
Hierarchical schema
Which of the following OLAP operations allows users to focus on a specific subset of the data?
Roll-up
Drill-down
Slice
Pivot
In a Data Warehouse, which of the following would most likely be the role of a Data Mart?
Perform detailed transactional analysis
Store data at a lower granularity for detailed reports
Store operational and transactional data
Consolidate data from multiple sources into one central system
Which of the following best describes the purpose of data transformation in the ETL process?
To encrypt sensitive data for security
To change the format of data to match the target schema
To remove duplicates from the source data
To query the data warehouse for analytical purposes
What role does the "data staging area" play in the ETL process?
It stores the final output data for reporting
It stores raw data before cleaning and transformation
It stores backup copies of the warehouse data
It stores transactional data in real-time
What is the main benefit of using OLAP for decision support?
It allows for real-time transaction processing
It speeds up querying of multidimensional data
It simplifies the data warehousing process
It stores operational data for quick access
What is a key characteristic of a Star Schema?
Dimensions are fully normalized
Fact tables are connected to dimension tables using foreign keys
The schema is structured like a snowflake
It only stores historical data without aggregation
Which of the following would typically be found in a dimension table?
Sales transaction totals
Customer names and addresses
Product prices
Aggregated revenue data
The Snowflake Schema is different from the Star Schema in that:
The Snowflake Schema uses denormalized data, while the Star Schema uses normalized data
The Snowflake Schema is better suited for reporting and querying than the Star Schema
The Snowflake Schema uses normalized dimension tables, whereas the Star Schema uses denormalized dimension tables
The Snowflake Schema has fewer tables than the Star Schema
What is the main disadvantage of using a Snowflake Schema?
It leads to high data redundancy
It requires simpler SQL queries
It involves more complex joins and can affect query performance
It is not scalable for large datasets
What is the benefit of using a Data Warehouse for historical reporting?
It provides real-time updates on business operations
It helps in providing data in a single view across multiple departments
It stores data in operational systems, reducing redundancy
It consolidates large volumes of historical data for easy access and analysis
What does the term "granularity" refer to in the context of a data warehouse?
The level of detail contained in the data stored in the warehouse
The process of normalizing data to reduce duplication
The speed of query processing in OLAP systems
The consistency of data across different tables
The term "OLAP" stands for:
Online Load and Analysis Processing
Online Logistic and Analytical Processing
Online Analytical Processing
Online Layered Analysis Processing
The term "fact" in a Data Warehouse refers to:
Descriptive data about the business dimensions
The data used for aggregation and reporting
Real-time data from operational systems
Data used for transactional processing
Which of the following tools is commonly used for performing OLAP operations?
Microsoft Excel
SQL Server Reporting Services
Tableau
All of the above
In the context of data warehousing, the term "slicing" refers to:
Removing irrelevant data from a dataset
Summarizing data at a higher level
Extracting a subset of data from a data cube based on a specific dimension
Aggregating data into smaller chunks
In a data warehouse, which of the following would typically be used to optimize query performance?
Adding indexes to frequently queried columns
Using denormalized fact tables
Using materialized views for pre-aggregated data
All of the above
In an OLAP system, which operation allows users to move through data levels for more detailed information?
Drill-down
Roll-up
Slice
Pivot
Which of the following is an advantage of using a Star Schema over a Snowflake Schema?
The schema has less redundancy in dimension tables
It is easier for users to query and understand due to its simplicity
The schema is more normalized, reducing data size
It requires fewer joins to retrieve data
What does the term "factless fact table" mean?
A fact table that has no numeric measures but records events
A table that only stores descriptive information
A table that has no indexes
A table that is not used for query processing
In the context of a data warehouse, the "fact" table typically contains:
Descriptive attributes
Data to support detailed analysis and aggregation
Historical metadata
User query logs
Which of the following is the primary function of an Operational System (OLTP)?
Analyzing historical data
Handling real-time transactional data
Supporting decision-making processes
Storing large volumes of aggregated data
A Decision Support System (DSS) is designed to support:
Day-to-day transactional processes
Long-term decision making through data analysis
Real-time customer service
Inventory management
Which of the following is a primary characteristic of Operational Systems (OLTP)?
Support for decision-making and analysis
Focus on real-time transaction processing
Use of historical and aggregated data
Complex querying for business insights
What type of data does a Decision Support System (DSS) primarily work with?
Real-time operational data
Historical and aggregated data
Transactional records
Inventory logs
Which of the following systems is typically used for strategic decision-making?
Operational Systems (OLTP)
Decision Support Systems (DSS)
Transaction Processing Systems (TPS)
Supply Chain Management Systems
Which of the following is a characteristic of OLTP systems?
Supports long-term business decisions
Deals with real-time data and transactions
Works with aggregated and historical data
Uses complex query processing for decision support
OLAP systems are commonly used in:
Transaction processing
Decision support for multidimensional analysis
Managing real-time customer orders
Handling day-to-day business operations
Decision Support Systems (DSS) can provide:
Real-time operational information
Aggregated and historical data for analysis
Detailed customer transaction logs
Day-to-day transactional data
OLTP systems are designed to:
Support complex analytics for decision making
Store large volumes of historical data
Process and manage real-time transactions
Perform multidimensional analysis
Which of the following best describes a Decision Support System (DSS)?
A system used for routine transaction processing
A system that supports complex decision-making through analysis of large datasets
A system that monitors and records operational performance
A system focused on real-time reporting
Which of the following tasks would be best suited for Operational Systems (OLTP)?
Analyzing trends in quarterly sales
Generating financial reports for executives
Processing real-time transactions like customer orders
Forecasting next year’s revenue
A key difference between OLTP and DSS is:
OLTP handles real-time transactions, while DSS handles complex analysis of historical data
OLTP handles data analytics, while DSS supports transaction processing
OLTP is for decision-making, while DSS is for operational processing
OLTP works with aggregated data, while DSS processes real-time data
Decision Support Systems (DSS) are mainly designed to help:
Customers place orders online
Managers make informed decisions using analytical data
Process and store transactional data
Track inventory in real time
OLTP systems are optimized for:
Complex queries and reports
Managing real-time business operations like order processing
Supporting decision-making and planning
Running multidimensional analysis
Which of the following is a Decision Support System (DSS) feature?
Processing real-time transactions
Running complex queries for business intelligence
Handling inventory management
Generating real-time reports for customer transactions
OLTP systems are designed for:
Decision-making support
Historical data analysis
Real-time transaction processing
Generating strategic business insights
Which of the following is typically used to improve decision-making in a DSS?
Inventory management data
Real-time operational data
Multidimensional analysis of historical data
Transaction logs
A DSS Dashboard provides:
Real-time data processing
A visual summary of key performance metrics for decision-making
Data entry and transactional reporting
A system for real-time customer interactions
Which of the following is typically a task of an OLTP system?
Aggregating data for business reports
Processing customer orders and payments in real-time
Conducting predictive market analysis
Managing historical data for reporting
What is the purpose of a Decision Support System?
To process daily transactions
To support operational reporting and monitoring
To analyze and report on historical data for decision-making
To manage real-time customer interactions
Which type of system is best suited for performing multidimensional analysis?
OLTP systems
Decision Support Systems (DSS)
Transaction Processing Systems
Inventory Management Systems
A key feature that distinguishes Decision Support Systems (DSS) from Operational Systems (OLTP) is that DSS:
Deals with real-time transaction processing
Focuses on historical data and complex analysis
Handles day-to-day operational tasks
Is optimized for transaction throughput
A Dashboard in a Decision Support System is used to:
Process customer orders in real-time
Provide a visual summary of key performance indicators (KPIs)
Store and manage transactional data
Update product information
Which of the following tasks is most suited for Operational Systems (OLTP)?
Reporting on customer purchasing trends
Generating quarterly financial reports
Processing real-time customer orders
Performing market trend analysis
What type of querying is most commonly associated with Decision Support Systems (DSS)?
Simple transaction queries
Complex analytical queries involving large datasets
Real-time inventory queries
Operational data entry queries
Which of the following is a key component of a data warehouse?
OLTP System
ETL Process
Transaction Logs
Backup Server
What does ETL stand for in data warehousing?
Extract, Transfer, Load
Extract, Transform, Load
Export, Transform, Load
Extract, Translate, Load
Which of the following is a type of data warehouse schema?
Network Schema
Star Schema
Entity-Relationship Schema
Object-Oriented Schema
What is the primary purpose of a data warehouse?
To support real-time transaction processing
To store historical data for analysis and reporting
To manage operational data
To perform data encryption
Which of the following is NOT a characteristic of a data warehouse?
Subject-oriented
Integrated
Volatile
Time-variant
What is a data mart?
A subset of a data warehouse focused on a specific business area
A tool for real-time transaction processing
A type of database used for OLTP systems
A backup system for operational databases
Which of the following is an example of a data warehouse tool?
MySQL
Apache Kafka
Snowflake
MongoDB
What is the role of a fact table in a star schema?
To store descriptive attributes
To store foreign keys and measures
To store metadata
To store raw data
Which of the following is a type of slowly changing dimension (SCD)?
SCD Type 1
SCD Type 2
SCD Type 3
All of the above
What is the purpose of metadata in a data warehouse?
To store raw data
To describe and manage data warehouse elements
To perform ETL processes
To create data marts
Which of the following is a benefit of using a cloud-based data warehouse?
Higher upfront costs
Limited scalability
On-demand resource allocation
Complex maintenance
What is the primary purpose of indexing in a data warehouse?
To reduce storage space
To improve query performance
To perform ETL processes
To manage metadata
Which of the following is a common data warehouse architecture style?
Single-tier architecture
Two-tier architecture
Three-tier architecture
Four-tier architecture
What is the role of the presentation layer in a data warehouse?
To store raw data
To perform ETL processes
To provide data for reporting and analysis
To manage metadata
Which of the following is a characteristic of a snowflake schema?
Denormalized structure
Normalized structure
Single fact table
No dimension tables
What is the primary purpose of a data warehouse refresh process?
To delete old data
To update the warehouse with new data from source systems
To create new data marts
To perform real-time analytics
Which of the following is a common challenge in data warehouse implementation?
High query performance
Data quality issues
Simplified schema design
Low storage costs
What is the primary purpose of a data warehouse dashboard?
To perform ETL processes
To provide visual insights into data
To store raw data
To manage metadata
Which of the following is an example of a data warehouse use case?
Processing online transactions
Analyzing historical sales data
Managing customer relationships in real-time
Storing operational logs
What is the primary difference between OLAP and OLTP systems?
OLAP systems are optimized for real-time transactions, while OLTP systems are optimized for analytics.
OLAP systems are optimized for analytics, while OLTP systems are optimized for real-time transactions.
OLAP systems are used for data storage, while OLTP systems are used for data transformation.
OLAP systems are used for ETL processes, while OLTP systems are used for reporting.
What is the primary role of the staging area in a data warehouse?
To store historical data
To hold raw data temporarily during ETL processes
To serve dashboards and reports
To define relationships in schemas
Which of the following OLAP operations involves reducing the level of detail by summarizing data?
Roll-Up
Drill-Down
Pivot
Slice
What is the main purpose of a surrogate key in a dimension table?
To replace natural keys for simplicity and consistency
To aggregate data for faster queries
To provide hierarchical organization
To normalize the schema
Which data warehouse architecture enables faster data retrieval by precomputing summaries?
Star Schema
Federated Data Warehouse
Materialized Views
Normalized Schema
What kind of fact table is used when there are no numeric measures, but only events are tracked?
Additive Fact Table
Semi-Additive Fact Table
Factless Fact Table
Derived Fact Table
What ensures consistency in analysis across multiple star schemas?
Conformed Dimensions
Surrogate Keys
Primary Indexes
Aggregated Data
In which type of dimension does the data change infrequently over time?
Slowly Changing Dimension
Rapidly Changing Dimension
Junk Dimension
Degenerate Dimension
What type of architecture stores both structured and unstructured data for analytical purposes?
Star Schema
Snowflake Schema
Data Lake
OLTP Database
Which of the following is a major advantage of a star schema?
Normalized dimension tables
Simplified queries and faster performance
High redundancy in data storage
Supports many-to-many relationships
What OLAP operation allows users to focus on a specific subset of data?
Drill-Through
Slice
Roll-Up
Data Mining
What is a junk dimension in a data warehouse?
A dimension with irrelevant attributes
A table combining unrelated low-cardinality attributes
Which of the following best describes incremental loading in ETL?
Replacing the entire dataset every time
Loading only new or updated data into the warehouse
Cleansing raw data from multiple sources
Creating materialized views during the ETL process
In a snowflake schema, which of the following is true about dimension tables?
They are highly denormalized.
They follow a normalized structure.
They contain numeric measures.
They are combined with fact tables.
What is the purpose of the fact table granularity in a data warehouse?
To minimize data redundancy
To define the level of detail stored for facts
To manage relationships between dimensions
To normalize the schema
Which process in ETL ensures that data formats match across different systems?
Data Cleansing
Data Transformation
Data Aggregation
Data Validation
Which of the following is a property of semi-additive measures in a fact table?
Can only be summed across all dimensions
Can be summed across some dimensions but not all
Can never be aggregated
Require no computation
What does a degenerate dimension contain?
Aggregated measures
Metadata about the database
Transactional identifiers or keys without attributes
High-cardinality data
How do surrogate keys improve the scalability of a data warehouse?
By compressing raw data
By eliminating the need for joins
By avoiding dependencies on operational systems
By creating natural key hierarchies
In OLAP, what is the benefit of creating cubes?
Efficiently handling unstructured data
Reducing storage space requirements
Pre-aggregating data for faster query performance
Generating metadata automatically
What ensures scalability in a distributed data warehouse system?
Partitioning large tables
Denormalizing dimension tables
Using a single staging area
Replacing surrogate keys with natural keys
How would you optimize an OLAP system that is experiencing slow query performance when handling large datasets?
Implement ROLAP instead of MOLAP
Increase the granularity of the fact tables
Use pre-aggregated data and materialized views
Normalize all dimension tables
Consider an OLAP system with a cube that has dimensions for Time, Region, and Product. How would you use the drill-down operation to analyze sales trends in a specific region?
Drill-down to view sales data at the product level within the region
Drill-down to view the overall sales performance across all regions
Drill-down to view yearly trends for the entire dataset
Drill-down to analyze sales data at a higher-level dimension, such as year
In an OLAP system, you have a data cube with a measure for "Sales Revenue" and dimensions for "Time," "Product," and "Store." How could you analyze the sales performance by product across multiple time periods?
Use a "slice" operation to analyze sales for a specific product
Use a "pivot" operation to view sales by different stores for each product
Use a "drill-up" operation to see sales trends for multiple products
Use a "roll-up" operation to summarize sales at the product category level
When using an OLAP data cube to analyze sales data by country, product category, and sales region, what might be the consequence of not using conformed dimensions across multiple cubes?
Improved performance when querying data
Difficulty in combining data from different cubes, leading to inconsistent analysis
Faster querying of aggregate data
Better storage optimization across different data sources
You are tasked with designing an OLAP cube for a retail company to track sales by time, region, and product. The cube needs to provide fast query performance and support aggregation at different levels. What design strategy would you recommend for this scenario?
Store the cube in a relational database and dynamically aggregate data during queries
Use MOLAP to pre-compute and store aggregated data at different levels for fast retrieval
Avoid indexing the cube to reduce storage requirements
Use ROLAP but keep all measures at the most granular level for detailed analysis
Given a sales data cube with dimensions for "Product," "Time," and "Region," how would you utilize the "slice" operation to examine sales in a specific region during a particular quarter?
Apply the slice operation to focus on a single product within the region
Apply the slice operation to isolate data for a specific quarter, filtering by region
Apply the slice operation to summarize data by product category
Apply the slice operation to aggregate sales across all products and regions
What challenges might arise when implementing a ROLAP system in an environment with large-scale transactional data? How would you address them?
ROLAP can struggle with slow query performance due to dynamic query generation; mitigate this by optimizing the database schema and indexing
ROLAP requires large amounts of memory, which can lead to system crashes
ROLAP only works with small datasets, so it cannot be used for large-scale data
ROLAP will lead to poor scalability, making it unsuitable for growing data needs
In an OLAP system, if a data cube is designed to store sales revenue by product, region, and time, how could you use the "roll-up" operation to analyze overall sales performance?
Roll-up to view sales data at the regional level across all products and time periods
Roll-up to analyze the detailed sales trends by each product and region
Roll-up to view sales trends for the entire company, regardless of region
Roll-up to see individual product sales across multiple years
How does a factless fact table in an OLAP system differ from a regular fact table, and in which scenario might it be useful?
A factless fact table contains only numeric data, while a regular fact table contains both numeric and non-numeric data
A factless fact table does not contain measures, only dimensions, and it is useful for tracking events or transactions with no numeric values (e.g., store visits, product views)
A factless fact table contains highly aggregated data, while a regular fact table contains granular data
A factless fact table is used only in ROLAP systems
Consider an OLAP data cube with a large volume of data. What strategy would you employ to ensure scalability and improve performance without losing query detail?
Use a normalized schema for better data consistency
Partition the cube across multiple servers and implement parallel processing
Store all data in a relational database to avoid scalability issues
Remove unnecessary dimensions and facts to reduce the data size
What is the primary purpose of OLAP systems in data analysis?
To perform real-time transactions
To store large amounts of raw data
To perform multi-dimensional data analysis
To perform data backups
In OLAP, which operation is used to combine data from different dimensions into a single view?
Drill-down
Roll-up
Slice
Pivot
What is the main advantage of using a data cube in OLAP?
Simplifies querying and increases performance
Reduces the data size stored in databases
Eliminates the need for indexing
Provides transactional consistency
Which OLAP operation allows users to view data at a more detailed level?
Drill-Through
Drill-Down
Slice
Roll-Up
What is a slice operation in OLAP?
It aggregates data across multiple dimensions
It filters data based on one dimension
It rotates the data cube to view different dimensions
It rolls up data to a higher level of aggregation
Which of the following describes a multi-dimensional database in the context of OLAP?
A database organized around facts and dimension tables supporting hierarchies
A transactional database optimized for row-level updates
A flat file system storing pre-joined records
A key-value store without schema constraints
What does the term "measure" refer to in an OLAP data cube?
The individual items of a dimension
The attributes used for slicing the data
The numeric values to be aggregated in the cube
The meta-data about the cube
In OLAP, which operation is used to aggregate data by increasing the level of hierarchy?
Drill-Through
Slice
Roll-Up
Pivot
What type of OLAP system uses a pre-constructed data cube stored in a database?
MOLAP
ROLAP
HOLAP
DOLAP
Which OLAP system uses relational databases to store data and generate results dynamically?
MOLAP
ROLAP
HOLAP
DOLAP
Which dimension is most likely to change slowly over time in OLAP systems?
Product
Customer
Time
Geographical Region
What is the typical function of an OLAP cube's "slice" feature?
It aggregates data
It divides data into smaller, more manageable chunks
It presents data from one perspective or level
It combines data from different sources
What does the "drill-through" operation in OLAP allow users to do?
Roll-up data for summary view
Drill into the base-level data for more detail
Pivot data across different dimensions
Slice data across multiple dimensions
Which of the following is a feature of a fully pre-aggregated MOLAP cube?
It stores only detailed data
It generates results dynamically from a relational database
It is fast in query performance due to pre-computed values
It requires more storage and computation power
Which of the following is an example of a "fact" in an OLAP cube?
Date
Time
Sales Revenue
Product Category
What type of OLAP system combines the advantages of both MOLAP and ROLAP?
HOLAP
ROLAP
MOLAP
DOLAP
What OLAP operation would be best to analyze sales data across different countries and years?
Drill-down
Pivot
Roll-up
Slice
What is the purpose of a "degenerate dimension" in an OLAP cube?
To store high-cardinality attributes
To represent transactional information such as an invoice or order number
To improve the performance of queries
To hold metadata about the cube
What is the primary advantage of using a data cube for analytical processing?
It simplifies reporting and visualizations
It supports real-time transaction processing
It reduces the complexity of relational joins
It stores non-structured data
In an OLAP data cube, what is a dimension typically used to represent?
Numeric values that need aggregation
Metadata about the database
Attributes that can be used for slicing or grouping data
Primary keys for data relationships
In OLAP, how does the "drill-up" operation differ from "drill-down"?
Drill-up increases the level of detail while drill-down decreases it
Drill-up aggregates data, while drill-down splits data
Drill-up is used to move to a more summarized view, while drill-down takes users to more granular data
Drill-up is the same as the slice operation
Which of the following is a benefit of using MOLAP systems over ROLAP systems?
MOLAP supports unstructured data
MOLAP is more flexible with large-scale datasets
MOLAP provides better performance due to pre-aggregated data
MOLAP does not require indexing
How does a data cube improve the speed of query processing in OLAP systems?
By storing all data in a flat file
By precomputing the aggregate values at multiple levels
By normalizing data across multiple databases
By using real-time data processing
Which of the following best describes the "pivot" operation in OLAP?
Moving from one hierarchical level to another
Changing the perspective of the data by rotating dimensions
Aggregating the data across one dimension
Filtering data based on a specific criterion
In OLAP, what is the "faceless" fact table used for?
To store aggregated data
To store events or transactions with no associated numerical value
To store high-cardinality data
To represent all the measures in the cube
What is the primary difference between a MOLAP cube and a ROLAP system?
MOLAP cubes use relational databases, while ROLAP uses multi-dimensional arrays
MOLAP cubes store pre-aggregated data, while ROLAP generates results dynamically
MOLAP is slower in query performance than ROLAP
ROLAP systems are used only for small datasets
What type of data storage is used in MOLAP systems?
Relational databases
Multi-dimensional arrays
Distributed file systems
Cloud storage
How does a ROLAP system handle large-scale data efficiently?
By precomputing all data
By dynamically generating queries against a relational database
By storing all data in memory
By using pre-built data cubes
Which of the following OLAP operations allows the user to move across different levels of aggregation?
Roll-up
Slice
Drill-down
Pivot
A retail store wants to optimize its data warehouse for faster query performance. Which schema should they use?
Snowflake Schema
Star Schema
Fully Normalized Schema
OLTP Schema
A sales team needs a schema with minimal joins and better reporting efficiency. Which model should they choose?
Star Schema
Snowflake Schema
3NF Schema
Key-Value Store
Which scenario best demonstrates the application of a Star Schema?
A hospital managing hierarchical patient data
An e-commerce store analyzing customer orders
A banking system tracking complex transactions
A government database managing citizen records
A business analyst wants to quickly retrieve sales data for different time periods. In a Star Schema, which table stores this information?
Fact Table
Dimension Table
Lookup Table
OLTP Table
What is the most effective way to ensure data consistency in OLAP applications
when dealing with multiple data sources?
Use data replication across all sources
Perform real-time ETL to synchronize data
Use a single data source for OLAP analysis
Implement eventual consistency in data synchronization
When developing OLAP cubes with large datasets, which technique should you use
to minimize the response time for complex queries?
Implement more complex queries for better data insights
Denormalize the schema to reduce join complexity
Use a columnar data storage format to speed up reading
Use relational tables instead of cubes
