Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

3 TSY 23-24 > FA5 - Sheet1 > Flashcards

FA5 - Sheet1 Flashcards

1
Q

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

A

Barry Devlin

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Data warehouse architecture with data marts.

A

Hub and spoke

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

Data mining tool is an example of:

Group of answer choices

END-USER ACCESS TOOL

QUERY MANAGER

WAREHOUSE MANAGER

LOAD MANAGER

A

END-USER ACCESS TOOL

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

Data warehouse architecture with data marts.

Group of answer choices

ODS

DW with staging area

Sandboxes

Hub and spoke

A

Hub and spoke

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

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

A

Barry Devlin

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

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

True

False

A

False

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

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

True

False

A

True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

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

True

False

A

False

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

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

True

False

A

False

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

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

True

False

A

False

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

The acronym ODS stands for : __________________.

Group of answer choices

OPERATION DATA STORAGE

OPERATION DATA STORE

OPERATIONAL DATA STORE

OPERATIONAL DATA STORAGE

A

OPERATIONAL DATA STORE

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

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

Group of answer choices

OLAP

OLAP CUBE

DATA MART

ODS

A

OLAP CUBE

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

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

A

Online Transactions Processing Databases

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

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

A

OLAP

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

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

A

REPORTING LAYER

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

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

A

DIMENSION

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

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

A

FACT DATA

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

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

A

SNOWFLAKE SCHEMA

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

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

True

False

A

True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

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

True

False

A

False

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
21
Q

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

A

LOAD MANAGER

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
22
Q

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

A

Applications of Data Warehouse

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
23
Q

Client-side front end tools is in ______ tier.

Group of answer choices

TOP

NO TIER

MIDDLE

BOTTOM

A

TOP

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
24
Q

The ________ is also known as backend component.

Group of answer choices

LOAD MANAGER

TRANSACTION MANAGER

QUERY MANAGER

WAREHOUSE MANAGER

A

QUERY MANAGER

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
25
Q

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

True

False

A

False

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
26
Q

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

True

False

A

True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
27
Q

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

True

False

A

True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
28
Q

Type of data warehouse which is refreshed in real time.

Group of answer choices

DATA MART

EDW

Not in the options

ODS

A

ODS

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
29
Q

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

Group of answer choices

INDEPENDENT

HYBRID

DEPENDENT

A

HYBRID

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
30
Q

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

Group of answer choices

DEPENDENT

INDEPENDENT

HYBRID

A

INDEPENDENT

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
31
Q

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

Group of answer choices

Accessing

Designing

Managing

Constructing

A

Constructing

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
32
Q

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

Group of answer choices

TRANFORM

TRANSACTIONS

TRANSFER

TOOL

A

TRANSACTIONS

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
33
Q

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

A

FOREIGN

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
34
Q

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

A

DIMENSION

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
35
Q

OLAP Server is in _______ tier.

Group of answer choices

BOTTOM

TOP

MIDDLE

NOT IN TIER

A

MIDDLE

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
36
Q

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

A

Murphy

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
37
Q

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

True

False

A

False

38
Q

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

ELT

ETL

A

ETL

39
Q

An EDW architecture with data mart level

Group of answer choices

One-Tier

Two-Tier

Three-Tier

Not in Tier

A

Two-Tier

40
Q

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

Group of answer choices

OLTP

OLAP

A

OLTP

41
Q

A schema where multiple fact tables share dimension tables.

A

GALAXY

42
Q

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

A

FACT

43
Q

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

True

False

A
44
Q

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

A

True

45
Q

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

A

BOTTOM

46
Q

He was considered as father of Data Warehouse.

A

INMON BILL

47
Q

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

A

Advantages of data warehouse

48
Q

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

A

Business Intelligence Solution

49
Q

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

True

False

A

False

50
Q

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

True

False

A

True

51
Q

The ______tool transform data in the staging area before EDW.

Group of answer choices

Data Mining

End-user

DATA WAREHOUSE

ETL

A

ETL

52
Q

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

A

One-tier

53
Q

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

A

Accessing

54
Q

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.

A

FACT TABLE

55
Q

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

True

False

A

False

56
Q

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

A

Executive Information System

57
Q

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

True

False

A

True

58
Q

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

True

False

A

True

59
Q

An EDW architecture with OLAP

Group of answer choices

Not in Tier

Three-Tier

One-Tier

Two-Tier

A

Three-Tier

60
Q

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

A

DAILY

61
Q

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

Group of answer choices

DATA MART

STAGING

ODS

OLAP SERVERS

A

DATA MART

62
Q

Galaxy schema is also know as ________.

A

FACT CONSTELLATION SCHEMA

63
Q

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

True

False

A

False

64
Q

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

True

False

A

False

65
Q

Client-side front end tools is in ______ tier.

A

TOP

66
Q

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

A

Executive Information System

67
Q

The QUERY MANAGER is also known as the _____ component.

Group of answer choices

FRONT

BACKEND

A

BACKEND

68
Q

He was considered as father of Data Warehouse.

Group of answer choices

Imnon Bill

Immon Bill

Innon Bill

Inmon Bill

A

Inmon Bill

69
Q

The Star Schema is also know as _______.

A

STAR JOIN SCHEMA

70
Q

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

True

False

A

True

71
Q

The ________ is also known as backend component.

A

QUERY MANAGER

72
Q

The middle tier consists of the _______ servers.

A

OLAP

73
Q

The _______ is also called the front component.

Group of answer choices

LOAD MANAGER

WAREHOUSE MANAGER

EXTRACTION MANAGER

TRANSACTION MANAGER

A

LOAD MANAGER

74
Q

The LOAD MANAGER is also called the ______ component.

Group of answer choices

BACKEND

FRONT

A

FRONT

75
Q

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

True

False

A

True

76
Q

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

True

False

A
77
Q

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

Group of answer choices

INDEPENDENT

DEPENDENT

HYBRID

A

DEPENDENT

78
Q

The fact table measures those that contain ________ facts.

A

QUANTITATIVE

79
Q

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

A

STAR

80
Q

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

True

False

A

True

81
Q
A

19/19 bcs idk ung contain __ faacts

82
Q

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

A

SIMPLE WITH STAGING AREA

83
Q

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

A

SCHEMA

84
Q

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

True

False

A

True

85
Q

The load manager is also known as _______ component.

A

FRONT

86
Q

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

A

SIMPLE

87
Q

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

A

DATA WAREHOUSE

88
Q

Raising ownership, dimensional technique and extra reporting are some ______ of data warehouse.

Group of answer choices

DISADVANTAGES

ADVANTAGES

A

DISADVANTAGES

89
Q

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

True

False

A

True

90
Q

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.

A

DATA WAREHOUSING

91
Q

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

A

STAR

3 TSY 23-24 (17 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions