Data Waraehouse

Which small logical units do data warehouses keep large amounts of information in?

• Data storage

• Data Mart

• Data Mine

• Data wharehouse

Answer explanation

Data warehouses keep large amounts of information in data marts. Data marts are smaller, specialized databases that are focused on a specific subject area or department within an organization. They are designed to provide quick and easy access to relevant data for analysis and reporting purposes. By organizing data into data marts, data warehouses can efficiently store and retrieve large amounts of information, making it easier for users to access the data they need for decision-making and analysis.

What type of data formats do conventional database systems use?

• Highly Normalized

• Highly denormalized

• None

• Highly organized

Answer explanation

Conventional database systems use highly normalized data formats. Normalization is a process in database design that reduces data redundancy and improves data integrity by organizing data into separate tables and eliminating duplicate information. Highly normalized data formats ensure that each piece of data is stored in only one place, reducing the chances of inconsistencies and anomalies in the database. This improves the efficiency and reliability of the database system.

Which of the following does the active data warehouse architecture include?

• Only data mart

• Real-time-updates

• All of these

• Only data warehouse

Answer explanation

Explanation
The active data warehouse architecture includes all of the mentioned components. It includes at least 1 data mart, which is a subset of the data warehouse that is focused on a specific functional area. It also includes data that can be extracted from both internal and external sources, allowing for a comprehensive and holistic view of the data. Additionally, the active data warehouse architecture supports real-time updates, ensuring that the data is constantly up to date and accurate. Therefore, all of these components are included in the active data warehouse architecture.

A data warehouse is

• Contains all data in a DB

• Organized around important subject areas

• Organized info

• None of these

Answer explanation

Explanation
A data warehouse is organized around important subject areas. This means that the data within the warehouse is structured and categorized based on specific topics or themes. This organization allows for easier analysis and retrieval of information related to a particular subject. It helps in providing a comprehensive view of the data and enables efficient decision-making processes.

When are dimensions conformed?

• When they are ready?

• When they are either the same or one is a subset of another.

• Always

• Never

Answer explanation

Explanation
Dimensions are considered conformed when they are either the same or when one dimension is a subset of another. This means that the dimensions can be compared and related to each other in a meaningful way. If the dimensions have different values or are labeled differently, they are not considered conformed because they cannot be compared or related mathematically.

What is the system of Data Warehousing mostly used for?

• Reporting just data

• Datamining

• Datawarehouse

• Reporting and Data Analysis

Answer explanation

Explanation
The system of Data Warehousing is mostly used for reporting and data analysis. This involves gathering and storing large amounts of data from various sources, organizing it in a way that is easily accessible and understandable, and then using that data to generate reports and perform data analysis. This allows businesses to make informed decisions and gain valuable insights from their data.

What is computing in data warehouses often referred to as?

• ETL

• MOLAP/OLAP

• OLAP

• ML & DL

Answer explanation

Explanation
Computing in data warehouses is often referred to as OLAP, which stands for Online Analytical Processing. OLAP involves analyzing large volumes of data to gain insights and make informed decisions. It allows users to perform complex queries, generate reports, and perform data mining tasks. OLAP is specifically designed for data warehousing and provides a multidimensional view of data, enabling users to slice, dice, and drill down into the data for analysis.

What does the typical Extract, Transform, Load (ETL)-based data warehouse use to house its key Functions?

• Data Integration

• All answers

• Staging

• ETL

Answer explanation

A typical ETL-based data warehouse uses all of the mentioned options - staging, access layers, and data integration - to house its key functions. Staging is used to temporarily store raw data before it is transformed. Access layers provide different levels of access to the data warehouse for various users. Data integration involves combining data from different sources and transforming it into a format suitable for analysis. Therefore, all of these components are essential for the functioning of an ETL-based data warehouse.

What is reconciled data?

• Current data intended to be the single source for all decision support systems

• Current data intended to be OTHER sources for all decision support systems

• Data Cleaning

• Visualitation

Answer explanation

Explanation
Reconciled data refers to current data that is intended to be the single source for all decision support systems. This means that it is the most up-to-date and accurate information that is used for making informed decisions within an organization. It is different from data stored in one operational system or various operational systems because it is specifically selected and consolidated to ensure consistency and reliability for decision-making purposes. Reconciled data is also distinct from data selected for end-user applications as it is specifically intended for decision support systems rather than general user applications.

The main purpose of a data warehouse is to research different data.

• True

• False

Answer explanation

Explanation
The main purpose of a data warehouse is not to research different data. Instead, a data warehouse is designed to store and organize large amounts of data from various sources, making it easier for businesses to analyze and make informed decisions based on that data. Researching different data is a task that can be performed using the data stored in a data warehouse, but it is not the primary purpose of a data warehouse.