FA5 - Sheet1

Question 1

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

Answer 1

Barry Devlin

Question 2

Data warehouse architecture with data marts.

Answer 2

Hub and spoke

Question 3

Data mining tool is an example of:

Group of answer choices

END-USER ACCESS TOOL

QUERY MANAGER

WAREHOUSE MANAGER

LOAD MANAGER

Answer 3

END-USER ACCESS TOOL

Question 4

Data warehouse architecture with data marts.

Group of answer choices

ODS

DW with staging area

Sandboxes

Hub and spoke

Answer 4

Hub and spoke

Question 5

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

Group of answer choices

Inmon Bill

Barry Devlin

Barry Inmon

Barry Murphy

Answer 5

Barry Devlin

Question 6

An EDW architecture with data mart level is a three-tier architecture.
Group of answer choices

True

False

Answer 6

False

Question 7

The OLTP is used to manage dynamic data in real-time.
Group of answer choices

True

False

Answer 7

True

Question 8

The acronym OLAP stands for: Online Analysis Processing.
Group of answer choices

True

False

Answer 8

False

Question 9

An EDW with OLAP level is a two-tier architecture.
Group of answer choices

True

False

Answer 9

False

Question 10

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

True

False

Answer 10

False

Question 11

The acronym ODS stands for : __________________.

Group of answer choices

OPERATION DATA STORAGE

OPERATION DATA STORE

OPERATIONAL DATA STORE

OPERATIONAL DATA STORAGE

Answer 11

OPERATIONAL DATA STORE

Question 12

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

Group of answer choices

OLAP

OLAP CUBE

DATA MART

ODS

Answer 12

OLAP CUBE

Question 13

What is the full form of the acronym OLTP?

Group of answer choices

Online Transactions Procedural Databases

Online Transactions Processing Databases

Online Loading Transactions Processing Databases

Online Transformation Processing Databases

Answer 13

Online Transactions Processing Databases

Question 14

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

Group of answer choices

OLAP

OLTP

Answer 14

OLAP

Question 15

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

Group of answer choices

REPORTING LAYER

ETL

STAGING AREA

DATAWAREHOUSE DATABASE

Answer 15

REPORTING LAYER

Question 16

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

Answer 16

DIMENSION

Question 17

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

Answer 17

FACT DATA

Question 18

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

Answer 18

SNOWFLAKE SCHEMA

Question 19

The Fact table measures is also known as fact data.
Group of answer choices

True

False

Answer 19

True

Question 20

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

True

False

Answer 20

False

Question 21

Data warehouse component that transforms data in preparation for entering the data warehouse.

Answer 21

LOAD MANAGER

Question 22

Data warehouse in Banking, Telecommunication, Financial Services are examples of __________.

Group of answer choices

Advantages of Data Warehouse

Tools for Data Warehouse

Benefits of Data Warehouse

Applications of Data Warehouse

Answer 22

Applications of Data Warehouse

Question 23

Client-side front end tools is in ______ tier.

Group of answer choices

TOP

NO TIER

MIDDLE

BOTTOM

Answer 23

TOP

Question 24

The ________ is also known as backend component.

Group of answer choices

LOAD MANAGER

TRANSACTION MANAGER

QUERY MANAGER

WAREHOUSE MANAGER

Answer 24

QUERY MANAGER

Question 25

The ‘T’ in the acronym OLTP, stands for: TRANSFORM. Group of answer choices True False

Answer 25

False

Question 26

ODS support only daily operations, so their view of historical data is very limited. Group of answer choices True False

Answer 26

True

Question 27

The ODS is a type of data warehouse that is refreshed in real time. Group of answer choices True False

Answer 27

True

Question 28

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

Answer 28

ODS

Question 29

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

Answer 29

HYBRID

Question 30

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

Answer 30

INDEPENDENT

Question 31

Data Mart implementation step that involves creating the physical database and the logical structures. Group of answer choices Accessing Designing Managing Constructing

Answer 31

Constructing

Question 32

The ‘T’ in the acronym OLTP, stands for: ___________. Group of answer choices TRANFORM TRANSACTIONS TRANSFER TOOL

Answer 32

TRANSACTIONS

Question 33

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

Answer 33

FOREIGN

Question 34

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

Answer 34

DIMENSION

Question 35

OLAP Server is in _______ tier. Group of answer choices BOTTOM TOP MIDDLE NOT IN TIER

Answer 35

MIDDLE

Question 36

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

Answer 36

Murphy

Question 37

An EDW with data mart level is a three-tier architecture. Group of answer choices True False

Answer 37

False

Question 38

The tool that transform data in the staging area before EDW. Group of answer choices ELT ETL

Answer 38

ETL

Question 39

An EDW architecture with data mart level Group of answer choices One-Tier Two-Tier Three-Tier Not in Tier

Answer 39

Two-Tier

Question 40

ODS uses _______ systems to manage dynamic data in real-time. Group of answer choices OLTP OLAP

Answer 40

OLTP

Question 41

A schema where multiple fact tables share dimension tables.

Answer 41

GALAXY

Question 42

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

Answer 42

FACT

Question 43

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

Question 44

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

Answer 44

True

Question 45

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

Answer 45

BOTTOM

Question 46

He was considered as father of Data Warehouse.

Answer 46

INMON BILL

Question 47

Enhanced Business Intelligence, query process and timely access to data are examples of ________. Group of answer choices Data warehouse process Advantages of data warehouse Applications of Data Warehouse Data warehouse components

Answer 47

Advantages of data warehouse

Question 48

What is the full form of the acronym BIS? Group of answer choices Business Intelligence Solution Business Intelligence System Business Intelligent Solution Business Intelligent System

Answer 48

Business Intelligence Solution

Question 49

The Designing step of Data Mart implementation involves creating the physical database and the logical structures. Group of answer choices True False

Answer 49

False

Question 50

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

Answer 50

True

Question 51

The ______tool transform data in the staging area before EDW. Group of answer choices Data Mining End-user DATA WAREHOUSE ETL

Answer 51

ETL

Question 52

An EDW with database directly connected with the analytical interfaces where the end user can make queries. Group of answer choices One-tier No tier Two-tier Three-tier

Answer 52

One-tier

Question 53

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

Answer 53

Accessing

Question 54

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.

Answer 54

FACT TABLE

Question 55

The fact table contains the primary key column that allows joins with dimension tables. Group of answer choices True False

Answer 55

False

Question 56

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

Answer 56

Executive Information System

Question 57

The acronym OLAP stands for: Online Analytical Processing. Group of answer choices True False

Answer 57

True

Question 58

An EDW with data mart level is a two-tier architecture. Group of answer choices True False

Answer 58

True

Question 59

An EDW architecture with OLAP Group of answer choices Not in Tier Three-Tier One-Tier Two-Tier

Answer 59

Three-Tier

Question 60

ODS support only ______ operations, so their view of historical data is very limited. Group of answer choices ROUTINE DAILY All the options DAY TO DAY

Answer 60

DAILY

Question 61

An EDW with _________ level is a two-tier architecture. Group of answer choices DATA MART STAGING ODS OLAP SERVERS

Answer 61

DATA MART

Question 62

Galaxy schema is also know as ________.

Answer 62

FACT CONSTELLATION SCHEMA

Question 63

The disadvantage of the snowflake schema it uses large disk space. Group of answer choices True False

Answer 63

False

Question 64

Galaxy schema is also know as STAR CONSTELLATION SCHEMA. Group of answer choices True False

Answer 64

False

Question 65

Client-side front end tools is in ______ tier.

Answer 65

TOP

Question 66

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

Answer 66

Executive Information System

Question 67

The QUERY MANAGER is also known as the _____ component. Group of answer choices FRONT BACKEND

Answer 67

BACKEND

Question 68

He was considered as father of Data Warehouse. Group of answer choices Imnon Bill Immon Bill Innon Bill Inmon Bill

Answer 68

Inmon Bill

Question 69

The Star Schema is also know as _______.

Answer 69

STAR JOIN SCHEMA

Question 70

Galaxy schema is also know as FACT CONSTELLATION SCHEMA. Group of answer choices True False

Answer 70

True

Question 71

The ________ is also known as backend component.

Answer 71

QUERY MANAGER

Question 72

The middle tier consists of the _______ servers.

Answer 72

OLAP

Question 73

The _______ is also called the front component. Group of answer choices LOAD MANAGER WAREHOUSE MANAGER EXTRACTION MANAGER TRANSACTION MANAGER

Answer 73

LOAD MANAGER

Question 74

The LOAD MANAGER is also called the ______ component. Group of answer choices BACKEND FRONT

Answer 74

FRONT

Question 75

The ETL tool transform data in the staging area before EDW. Group of answer choices True False

Answer 75

True

Question 76

Data mart has a more implementation time compared to data warehouse systems. Group of answer choices True False

Question 77

A _______ data mart allows sourcing organization’s data from a single data warehouse. Group of answer choices INDEPENDENT DEPENDENT HYBRID

Answer 77

DEPENDENT

Question 78

The fact table measures those that contain ________ facts.

Answer 78

QUANTITATIVE

Question 79

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

Answer 79

STAR

Question 80

A Data Warehouse system can have one or more fact tables. Group of answer choices True False

Answer 80

True

Answer 81

19/19 bcs idk ung contain __ faacts

Question 82

A data warehouse architecture where operational data must be cleaned and processed before being put in the warehouse. Group of answer choices SIMPLE WITH STAGING AREA SIMPLE HUB & SPOKE SANDBOXES

Answer 82

SIMPLE WITH STAGING AREA

Question 83

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

Answer 83

SCHEMA

Question 84

The Fact table measures is also known as numeric data. Group of answer choices True False

Answer 84

True

Question 85

The load manager is also known as _______ component.

Answer 85

FRONT

Question 86

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

Answer 86

SIMPLE

Question 87

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

Answer 87

DATA WAREHOUSE

Question 88

Raising ownership, dimensional technique and extra reporting are some ______ of data warehouse. Group of answer choices DISADVANTAGES ADVANTAGES

Answer 88

DISADVANTAGES

Question 89

The Star schema can have one fact table and a number of associated dimension tables. Group of answer choices True False

Answer 89

True

Question 90

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.

Answer 90

DATA WAREHOUSING

Question 91

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

Answer 91

STAR