FORMATIVE 5

Question 1

OLAP Server is in (MIDDLE) tier.

True or False

Answer 1

True

Question 2

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

LOAD MANAGER

WAREHOUSE MANAGER

STAGING MANAGER

QUERY MANAGER

Answer 2

WAREHOUSE MANAGER

Question 3

The middle tier consists of the ______.

OLAP SERVERS

WAREHOUSE MANAGER

LOAD MANAGER

QUERY MANAGER

Answer 3

OLAP SERVERS

Question 4

The _____ is also known as backend component.

LOAD MANAGER

WAREHOUSE MANAGER

QUERY MANAGER

TRANSACTION MANAGER

Answer 4

QUERY MANAGER

Question 5

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

True or False

Answer 5

True

Question 6

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

True or False

Answer 6

False

Question 7

The acronym OLAP stands for Online Analysis Processing.

True or False

Answer 7

False

Question 8

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

True or False

Answer 8

False

Question 9

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

True or False

Answer 9

False

Question 10

The acronym ODS stands for: _______

OPERATIONAL DATA STORE

OPERATIONAL DATA STORAGE

OPERATION DATA STORE

OPERATION DATA STORAGE

Answer 10

OPERATION DATA STORE

Question 11

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

ETL

ELT

Answer 11

ETL

Question 12

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

Designing

Constructing

Accessing

Managing

Answer 12

Constructing

Question 13

An EDW architecture with OLAP

One-Tier

Two-Tier

Three-Tier

Not in Tier

Answer 13

Three-Tier

Question 14

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

DAILY

DAY TO DAY

ROUTINE

All the options

Answer 14

DAY TO DAY

Question 15

The (STAR) Schema is also know as STAR JOIN SCHEMA

Answer 15

STAR

Question 16

(SNOWFLAKE SCHEMA)

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

True or False

Answer 16

True

Question 17

The (FACT) table contains the foreign key column that allows joins withh dimension tables.

True or False

Answer 17

True

Question 18

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

True or False

Answer 18

False

Question 19

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

(WAREHOUSE MANAGER)

True

False

Answer 19

True

Question 20

What is the full form of the acronym BIS?

Business Intelligent Solution

Business Intelligence Solution

Business Intelligent System

Business Intelligence System

Answer 20

Business Intelligence System

Question 21

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

Murphy

Inmon

Devlin

Bill

Answer 21

Murphy

Question 22

The LOA MANAGER is also called the _____ component.

FRONT

BACKEND

Answer 22

FRONT

Question 23

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

True

False

Answer 23

False

Question 24

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

True

False

Answer 24

False

Question 25

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

Answer 25

INDEPENDENT

Question 26

Type of data warehouse which is refreshed in real time. EDW ODS DATA MART Not in the options

Answer 26

ODS

Question 27

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

Answer 27

HYBRID

Question 28

Data Mart implementation step that involves putting the data to use: querying the data, creating reports, charts, and publishing them. Group of answer choices Designing Constructing Accessing Managing

Answer 28

Accessing

Question 29

A _____ is a specific type of database that reprensents data from multiple dimensions. DATA MART ODS OLAP OLAP CUBE

Answer 29

OLAP CUBE

Question 30

In (SNOWFLAKE) schema the dimension tables are normalized which splits data into additional tables. True False

Answer 30

True

Question 31

Galaxy schema is also known as (FACT CONSTELLATION SCHEMA) True False

Answer 31

True

Question 32

The Fact Table Measure is also known as numeric data. True False

Answer 32

True

Question 33

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

Answer 33

False

Question 34

Data warehouse architecture with data marts. (HUB AND SPOKE) True False

Answer 34

True

Question 35

Client-side front end tools is in (TOP) tier. True False

Answer 35

True

Question 36

Raising ownerships, dimensional technique and extra reporting are some ______ of data warehouse. DISADVANTAGES ADVANTAGES

Answer 36

DISADVANTAGES

Question 37

The QUERY MANAGER is also known as the ______ component. FRONT BACKEND

Answer 37

BACKEND

Question 38

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

Answer 38

False

Question 39

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

Answer 39

True

Question 40

The ‘T’ in the acronym OLTP, stands for: TRANSACTIONS. True False

Answer 40

True

Question 41

What is the full form of the acronym OLTP? Online Loading Transactions Processing Databases Online Transformation Processing Databases Online Transactions Procedural Databases Online Transactions Processing Databases

Answer 41

Online Transactions Processing Databases

Question 42

ODS uses _____ systems to manage dynamic data in real-time OLAP OLTP

Answer 42

OLTP

Question 43

The (DIMENSION) table is a collection of reference information about a measurable in the fact table. True False

Answer 43

True

Question 44

The fact table measures those that contain (DIRECT) facts. True False Not Sure

Answer 44

Not Sure

Question 45

In Star Schema, Every dimension in a star schema is represented with the only one-dimension table. True False

Answer 45

True

Question 46

In Galaxy schema, it is possible to build this type of schema by splitting the one-star schema into more Star schemes. True False

Answer 46

True

Question 47

A (SCHEMA) is a logical description that describes the entire database. True False

Answer 47

True

Question 48

The (STAR) schema can have one fact table anda number of associated dimension tables True False

Answer 48

True

Question 49

A ______ data mart allows sourcing organization's data from single data warehouse. DEPENDENT INDEPENDENT HYBRID

Answer 49

DEPENDENT

Question 50

An EDW architecture with data mart level One-Tier Two-Tier Three-Tier Not in Tier

Answer 50

Two-Tier

Question 51

Data Warehouses uses ______ systems organize and present information in specific formats to accomoate the diverse needs of various users. OLAP OLTP

Answer 51

OLAP

Question 52

Alternative name for Data Warehouse System is EIS. What is the full form of this acronym? Enhanced Information System Executive Intelligent System Executive Information System Enterprise Information System

Answer 52

Executive Information System

Question 53

The _______ is also called the front component. LOAD MANAGER WAREHOUSE MANAGER EXTRACTION MANAGER TRANSACTION MANAGER

Answer 53

LOAD MANAGER

Question 54

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

Answer 54

True

Question 55

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) True False

Answer 55

True

Question 56

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

Answer 56

True