[F5-FORMATIVE] Formative Assessment 5

A type of Data Management System that is solely intended to perform queries and analysis from large amount of historical data to support BI activities.

DATA WAREHOUSE

The Star Schema is also know as ______.

STAR JOIN SCHEMA

A Data Warehouse system can have one or more fact tables.

Group of answer choices

True

False

True

In ______ schema the dimension tables are normalized which splits data into additional tables.

SNOWFLAKE

The fact table contains the ________ key column that allows joins with dimension tables.

FOREIGN

The Fact table measures is also known as fact data.

Group of answer choices

True

False

False

Alternative name for Data Warehouse System is EIS. What is the full form of this acronym?

Group of answer choices

Enhanced Information System

Enterprise Information System

Executive Information System

Executive Intelligent System

Enterprise Information System

The fact table contains the foreign key column that allows joins with dimension tables.

Group of answer choices

True

False

True

The load manager is also known as _______ component.

FRONT

A data warehouse architecture where operational data must be cleaned and processed before being put in the warehouse.

Group of answer choices

SANDBOXES

SIMPLE WITH STAGING AREA

SIMPLE

HUB & SPOKE

SIMPLE WITH STAGING AREA

Data Warehouse uses ________ systems organize and present information in specific formats to accommodate the diverse needs of various users.

Group of answer choices

OLTP

OLAP

OLAP

A schema where multiple fact tables share dimension tables.

GALAXY SCHEMA

What is the full form of the acronym OLTP?

Group of answer choices

Online Transactions Procedural Databases

Online Loading Transactions Processing Databases

Online Transactions Processing Databases

Online Transformation Processing Databases

Online Transactions Processing Databases

Client-side front end tools is in ______ tier.

Group of answer choices

BOTTOM

NO TIER

MIDDLE

TOP

TOP

A data warehouse component that performs operations associated with the management of the data in the warehouse.

Group of answer choices

QUERY MANAGER

LOAD MANAGER

WAREHOUSE MANAGER

STAGING MANAGER

WAREHOUSE MANAGER

OLAP Server is in _______ tier.

THREE

The _______ table is a collection of reference information about a measurable in the fact table.

DIMENSION

An EDW with _________ level is a two-tier architecture.

Group of answer choices

ODS

DATA MART

STAGING

OLAP SERVERS

DATA MART

ODS support only daily operations, so their view of historical data is very limited.

Group of answer choices

True

False

True

A data warehouse component that performs operations associated with the management of the data in the warehouse.

WAREHOUSE MANAGER

The 'T' in the acronym OLTP, stands for: TRANSACTIONS.

Group of answer choices

True

False

True

The disadvantage of the snowflake schema it uses large disk space.

Group of answer choices

True

False

False

OLAP Server is in _______ tier.

Group of answer choices

MIDDLE

BOTTOM

TOP

NOT IN TIER

MIDDLE

An EDW with data mart level is a two-tier architecture.

Group of answer choices

True

False

True

The 'T' in the acronym OLTP, stands for: ___________.

Group of answer choices

TOOL

TRANSACTIONS

TRANFORM

TRANSFER

TRANSACTIONS

Type of data warehouse which is refreshed in real time.

Group of answer choices

Not in the options

ODS

DATA MART

EDW

ODS

An EDW component that refers to the tools that give end users access to data.

Group of answer choices

ETL

DATAWAREHOUSE DATABASE

REPORTING LAYER

STAGING AREA

REPORTING LAYER

The ______tool transform data in the staging area before EDW.

Group of answer choices

ETL

End-user

DATA WAREHOUSE

Data Mining

ETL

An EDW with data mart level is a three-tier architecture.

Group of answer choices

True

False

False, its only two tier

The ODS is a type of data warehouse that is refreshed in real time.

Group of answer choices

True

False

True

He was considered as father of Data Warehouse.

Group of answer choices

Innon Bill

Inmon Bill

Imnon Bill

Immon Bill

Inmon Bill

Client-side front end tools is in ______ tier.

TOP

The _______ is also called the front component.

Group of answer choices

EXTRACTION MANAGER

LOAD MANAGER

TRANSACTION MANAGER

WAREHOUSE MANAGER

LOAD MANAGER

The ________ is also known as backend component.

QUERY MANAGER

The Galaxy schema can have one fact table and a number of associated dimension tables.

Group of answer choices

True

False

False, its the star schema

The ______ Schema is also know as STAR JOIN SCHEMA).

STAR

An extension of star schema where the dimension tables are connected to one or more dimensions.

SNOWFLAKE SCHEMA

The ______ schema can have one fact table and a number of associated dimension tables.

STAR

Data Mart implementation step that involves putting the data to use: querying the data, creating reports, charts, and publishing them.

Group of answer choices

Accessing

Constructing

Managing

Designing

Accessing

The acronym OLAP stands for: Online Analytical Processing.

Group of answer choices

True

False

True

The Designing step of Data Mart implementation involves creating the physical database and the logical structures.

Group of answer choices

True

False

False, Its constructing

The ________ is also known as backend component.

Group of answer choices

QUERY MANAGER

WAREHOUSE MANAGER

TRANSACTION MANAGER

LOAD MANAGER

QUERY MANAGER

The _______ is also called the front component.

LOAD MANAGER

A data warehouse architecture where metadata, summary data, and raw data are stored within the central repository of the warehouse.

SIMPLE

The middle tier consists of the _________.

Group of answer choices

WAREHOUSE MANAGER

OLAP SERVERS

QUERY MANAGER

LOAD MANAGER

OLAP SERVERS

The LOAD MANAGER is also called the ______ component.

Group of answer choices

BACKEND

FRONT

FRONT

Data Warehousing started in the late 1980s when Paul _____ and Barry Devlin developed the Business Data Warehouse.

Group of answer choices

Devlin

Bill

Murphy

Inmon

Murphy

The QUERY MANAGER is also known as the _____ component.

Group of answer choices

FRONT

BACKEND

BACKEND

Data warehouse architecture with data marts.

Group of answer choices

Hub and spoke

Sandboxes

DW with staging area

ODS

Hub and spoke

The Data Mart is a type of data warehouse that is refreshed in real time.

Group of answer choices

True

False

False

The 'T' in the acronym OLTP, stands for: TRANSFORM.

Group of answer choices

True

False

False

The acronym OLAP stands for: Online Analysis Processing.

Group of answer choices

True

False

False

An EDW architecture with data mart level is a three-tier architecture.

Group of answer choices

True

False

False

ODS support only ______ operations, so their view of historical data is very limited.

Group of answer choices

All the options

ROUTINE

DAILY

DAY TO DAY

DAILY

An EDW architecture with data mart level

Group of answer choices

One-Tier

Two-Tier

Not in Tier

Three-Tier

Two-Tier

Data mart has a more implementation time compared to data warehouse systems.

Group of answer choices

True

False

False

A _______ data mart is created without the use of a central data warehouse.

Group of answer choices

INDEPENDENT

HYBRID

DEPENDENT

INDEPENDENT

A ______ data mart that can take data from data warehouses or operational systems.

Group of answer choices

INDEPENDENT

DEPENDENT

HYBRID

HYBRID

A _______ data mart allows sourcing organization's data from a single data warehouse.

Group of answer choices

INDEPENDENT

HYBRID

DEPENDENT

DEPENDENT

The acronym ODS stands for : __________________.

Group of answer choices

OPERATION DATA STORAGE

OPERATIONAL DATA STORAGE

OPERATIONAL DATA STORE

OPERATION DATA STORE

OPERATIONAL DATA STORE

Data Mart implementation step that involves creating the physical database and the logical structures.

Group of answer choices

Designing

Constructing

Managing

Accessing

Constructing

The fact table measures those that contain ________ facts.

NUMERIC

The fact table contains the foreign key column that allows joins with ________ tables.

DIMENSION

Galaxy schema is also know as ________.

FACT CONSTELLATION SCHEMA

The ______ table contains the foreign key column that allows joins with dimension tables.

FACT

The Star schema can have one fact table and a number of associated dimension tables.

Group of answer choices

True

False

True

Galaxy schema is also know as FACT CONSTELLATION SCHEMA.

Group of answer choices

True

False

True

Enhanced Business Intelligence, query process and timely access to data are examples of ________.

Group of answer choices

Applications of Data Warehouse

Advantages of data warehouse

Data warehouse process

Data warehouse components

Advantages of data warehouse

An electronic storage of a large amount of information by a business or organization.

Group of answer choices

OLAP SERVERS

END-USER TOOLS

DATA MARTS

DATA WAREHOUSE

DATA WAREHOUSE

Data mining tool is an example of:

Group of answer choices

LOAD MANAGER

QUERY MANAGER

END-USER ACCESS TOOL

WAREHOUSE MANAGER

END-USER ACCESS TOOL

An EDW with OLAP level is a two-tier architecture.

Group of answer choices

True

False

False, Its three-tier

The ETL tool transform data in the staging area before EDW.

Group of answer choices

True

False

True

The OLTP is used to manage dynamic data in real-time.

Group of answer choices

True

False

True

ODS uses _______ systems to manage dynamic data in real-time.

Group of answer choices

OLAP

OLTP

OLTP

An EDW architecture with OLAP

Group of answer choices

One-Tier

Not in Tier

Three-Tier

Two-Tier

Three-Tier

The tool that transform data in the staging area before EDW.

Group of answer choices

ETL

ELT

ETL

An EDW with database directly connected with the analytical interfaces where the end user can make queries.

Group of answer choices

No tier

Three-tier

One-tier

Two-tier

One-tier

A _______ is a specific type of database that represents data from multiple dimensions.

Group of answer choices

DATA MART

ODS

OLAP

OLAP CUBE

OLAP CUBE

The Fact table is consist of the key column and measures or ______.

FACT DATA

The primary key column of the fact table has uniquely identifies each dimension record or row.

Group of answer choices

True

False

False, its dimension table

These tables hold fields that represent the direct facts, as well as the foreign fields that are used to connect the fact table with other dimension tables in the Data Warehouse system.

FACT TABLE

A ________ is a logical description that describes the entire database.

SCHEMA

The Star Schema is also know as JOINT SCHEMA.

Group of answer choices

True

False

False, its Star Join Schema

The _____ tier mainly consists of the Data Sources, ETL Tool, and Data Warehouse.

BOTTOM

The Fact table measures is also known as numeric data.

Group of answer choices

True

False

False

Data Warehousing started in the late 1980s when Paul Murphy and ___________ developed the Business Data Warehouse.

BARRY DEVLIN