Data Warehouse - Foundations 2

Data mining means______

• data fetching

• data accesing

• knowledge discovery

In data warehousing what is time-variant data?

• Data in the warehouse is only accurate and valid at some point in time or over time interval
• Data in the warehouse is always accurate and valid 
• Data in the warehouse is not accurate
• Data in the warehouse is only accurate sometimes

Is the data in a data warehouse generally updated in real-time?

• Yes

• No

What does OLTP stand for?

• Online transaction processing
• Offline transaction processing
• Outline trajectory processing
• Online traffic processing

What is a Star Schema?

• A star schema consists of a fact table with a single table for each dimension
• A star schema is a type of database system
• A star schema is used when exporting data from the database
• None of these

What is a Snowflake Schema?

• Each dimension table is normalized, which may create additional tables attached to the dimension tables
• A Snowflake schema is a type of database system
• A Snowflake schema is used when exporting data from the database
• None of these

What does the acronym ETL stands for?

• Explain,Transfer and Lead

• Extract,Transform and Load

• Extract,Transfer and Load

• Effect,Transfer and Load

What is the system of data warehousing mostly used for?

• Data integration and Data Mining

• Data Mining and Data Storage

• Reporting and Data Analysis

• Data Cleaning and Data Storage

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

• Data Storage

• Data Marts

• Access Layers

• Data Miners

Why data analysis is needed? (select all that apply)

• require tactical and strategic decisions

• business environment is dynamic

• search for competitive advantage

• to get more public attention