Brainscape's Knowledge GenomeTM


Top Flashcards (Certified)
All Flashcards

Database Reviewer > FORMATIVE 5 > Flashcards

FORMATIVE 5 Flashcards

1
Q

OLAP Server is in (MIDDLE) tier.

True or False

A

True

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

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

A

WAREHOUSE MANAGER

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

The middle tier consists of the ______.

OLAP SERVERS

WAREHOUSE MANAGER

LOAD MANAGER

QUERY MANAGER

A

OLAP SERVERS

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

The _____ is also known as backend component.

LOAD MANAGER

WAREHOUSE MANAGER

QUERY MANAGER

TRANSACTION MANAGER

A

QUERY MANAGER

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

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

True or False

A

True

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

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

True or False

A

False

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

The acronym OLAP stands for Online Analysis Processing.

True or False

A

False

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

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

True or False

A

False

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

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

True or False

A

False

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

The acronym ODS stands for: _______

OPERATIONAL DATA STORE

OPERATIONAL DATA STORAGE

OPERATION DATA STORE

OPERATION DATA STORAGE

A

OPERATION DATA STORE

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

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

ETL

ELT

A

ETL

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

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

Designing

Constructing

Accessing

Managing

A

Constructing

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

An EDW architecture with OLAP

One-Tier

Two-Tier

Three-Tier

Not in Tier

A

Three-Tier

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

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

DAILY

DAY TO DAY

ROUTINE

All the options

A

DAY TO DAY

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

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

A

STAR

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

(SNOWFLAKE SCHEMA)

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

True or False

A

True

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

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

True or False

A

True

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

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

True or False

A

False

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

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

(WAREHOUSE MANAGER)

True

False

A

True

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

What is the full form of the acronym BIS?

Business Intelligent Solution

Business Intelligence Solution

Business Intelligent System

Business Intelligence System

A

Business Intelligence System

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

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

Murphy

Inmon

Devlin

Bill

A

Murphy

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

The LOA MANAGER is also called the _____ component.

FRONT

BACKEND

A

FRONT

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

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

True

False

24
Q

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

True

False

25
Q

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

DEPENDENT

INDEPENDENT

HYBRID

A

INDEPENDENT

26
Q

Type of data warehouse which is refreshed in real time.

EDW

ODS

DATA MART

Not in the options

27
Q

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

DEPENDENT

INDEPENDENT

HYBRID

28
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

Designing

Constructing

Accessing

Managing

29
Q

A _____ is a specific type of database that reprensents data from multiple dimensions.

DATA MART

ODS

OLAP

OLAP CUBE

30
Q

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

True

False

31
Q

Galaxy schema is also known as (FACT CONSTELLATION SCHEMA)

True

False

32
Q

The Fact Table Measure is also known as numeric data.

True

False

33
Q

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

True

False

34
Q

Data warehouse architecture with data marts.

(HUB AND SPOKE)

True

False

35
Q

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

True

False

36
Q

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

DISADVANTAGES

ADVANTAGES

A

DISADVANTAGES

37
Q

The QUERY MANAGER is also known as the ______ component.

FRONT

BACKEND

38
Q

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

True

False

39
Q

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

True

False

40
Q

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

True

False

41
Q

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

A

Online Transactions Processing Databases

42
Q

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

OLAP

OLTP

43
Q

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

True

False

44
Q

The fact table measures those that contain (DIRECT) facts.

True

False

Not Sure

45
Q

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

True

False

46
Q

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

True

False

47
Q

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

True

False

48
Q

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

True

False

49
Q

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

DEPENDENT

INDEPENDENT

HYBRID

50
Q

An EDW architecture with data mart level

One-Tier

Two-Tier

Three-Tier

Not in Tier

51
Q

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

OLAP

OLTP

52
Q

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

A

Executive Information System

53
Q

The _______ is also called the front component.

LOAD MANAGER

WAREHOUSE MANAGER

EXTRACTION MANAGER

TRANSACTION MANAGER

A

LOAD MANAGER

54
Q

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

True

False

55
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.

(FACT TABLE)

True

False

56
Q

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

True

False

Database Reviewer (6 decks)

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