WorksheetsDatawarehouse BSIS 3(B)
Total questions: 10
Worksheet time: 4mins
In a bustling corporate office, Noah often finds himself overwhelmed with data from various departments. To streamline operations and enhance decision-making, he decides to implement a (a) that acts as a safe electronic storage facility for company information.
In a data management project, Scarlett is tasked with gathering data from various sources, cleaning it, and then loading it into a data warehouse. This process is commonly referred to as (a) .
In a data analysis project, Nora decided to implement a (a) schema that uses a central fact table connected to dimension tables, making queries simple and fast.
In a company meeting, the manager emphasized that one of the main benefits of a data warehouse is improved (a) , which provides a unified and accurate view of data.
In a large corporation, Priya is tasked with creating a (a) data warehouse that will serve the entire organization, ensuring it acts as a single source of truth for all departments.
Elijah is studying the history of data management. He wonders, in which decade did data warehousing begin?
1960s
1970s
1980s
1990s
In a company, Mia is tasked with designing a data warehouse architecture that involves three layers: source, reconciled, and warehouse. Which architecture should she choose?
Hybrid
Three-tier
Two-tier
Single-tier
In a company, the Sales department needs to analyze its performance and customer data separately from other departments. Which type of data warehouse would they use to focus specifically on their needs?
Data Mart
Operational Data Store
Data Lake
Enterprise Data Warehouse
In a large retail company, the management team is concerned about the accuracy and reliability of the data being used for decision-making. They want to ensure that all stored data is standardized, reliable, and error-free. Which benefit of data warehousing would address their concerns?
Scalability
Data Consistency & Quality
Regulatory Compliance
Enhanced Reporting
In evaluating data warehousing, which metric focuses on query response time and ETL load performance?
Usability Evaluation
Security & Compliance Evaluation
Performance Evaluation
Cost-Benefit Analysis
