Brainscape's Knowledge GenomeTM

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


See full index

3 TSY 23-24 > FA6 - Sheet1 > Flashcards

FA6 - Sheet1 Flashcards

1
Q

ETL is an acronym for : ______, _________,________. Note: Separate each word by a space.

A

EXTRACT TRANSFORM LOAD

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

The ______ operation perform the analysis that can gain a new view of data by rotating the data axes of the cube.

A

PIVOT

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

An OLAP system that utilizes multi-dimensional database for storing and analyzing information. Note: Write only the acronym.

A

MOLAP

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

A ______ is a data structure that allows fast analysis of data according to the multiple dimensions that define a business problem.

A

OLAP CUBE

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

ETL loading type that applies ongoing changes as when needed periodically.

A

INCREMENTAL LOAD

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

An ETL loading type that applies ongoing changes as when needed periodically.

Group of answer choices

FULL LOAD

PARTIAL LOAD

FULL REFRESH LOAD

INCREMENTAL LOAD

A

INCREMENTAL LOAD

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

Which type of ETL Loading process populates all the data warehouse tables?

Group of answer choices

INITIAL FULL LOAD

INITIAL LOAD

FULL REFRESH LOAD

FULL LOAD

A

INITIAL LOAD

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

This strategy is also known delta, where only the data being changed is extracted and update data warehouses.

Group of answer choices

Partial Extraction (without update notification)

Partial Extraction (with update notification)

A

Partial Extraction (with update notification)

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

The type of OLAP system that works on the information that resides in a relational database.

Group of answer choices

ROLAP

HOLAP

MOLAP

DOLAP

A

ROLAP

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

The HOLAP system is a blend of _______ and MOLAP.

Group of answer choices

DOLAP

WOLAP

SOLAP

ROLAP

A

ROLAP

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

The predictive analysis provides answers of the future queries that move across using historical data as the chief principle for decisions.
Group of answer choices

True

False

A

t

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

Machine Learning refers to the algorithms that can learn from data to make predictions.
Group of answer choices

True

False

A

True

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

Clustering is an unsupervised learning.
Group of answer choices

True

False

A

t

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

The DEPLOYMENT phase of CRISP-DM that consists of presenting the results in a useful and understandable manner, and by achieving this, the project should achieve its goals.
Group of answer choices

True

False

A

t

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

The descriptive analysis provides answers of the future queries that move across using historical data as the chief principle for decisions.
Group of answer choices

True

False

A

False

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

A data mining technique that is used to make predictions based on relationships within the data set.

Group of answer choices

REGRESSION

CLUSTER ANALYSIS

ANOMALY DETECTION

CLASSIFICATION

A

REGRESSION

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

A DM algorithm that do not require a predefined set of outputs but rather look for patterns or trends without any label or target.

Group of answer choices

UNSUPERVISED LEARNING

SUPERVISED LEARNING

A

UNSUPERVISED LEARNING

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

Classification technique is a(n) ________ learning.

Group of answer choices

SUPERVISED

UNSUPERVISED

A

SUPERVISED

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

The CRISP-DM phase that sets the initial data collection and proceeds with activities in order to get familiar with the data.

Group of answer choices

Data collection

Data preparation

Business understanding

Data understanding

A

Data understanding

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

Decision Tree is an example of a(n) _________ algorithm.

Group of answer choices

CLUSTERING

REGRESSION

ASSOCIATION

CLASSIFICATION

A

CLASSIFICATION

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

An OLAP operation that performs analysis in deeper among the dimensions of data.

A

DRILL-DOWN

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

The HOLAP system is a blend of _______ and MOLAP. Note: Write only the acronym.

A

ROLAP

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

The ________ type of ETL Loading process populates all the data warehouse tables.

A

INITIAL LOAD

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

OLAP is located in between Front-end tools and _____________.

A

DATA WAREHOUSE

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

A ______ is a data structure that allows fast analysis of data according to the multiple dimensions that define a business problem.
Group of answer choices

DIMENSION TABLE

OLAP SERVER

OLAP CUBE

FACT TABLE

A

OLAP CUBE

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

An ETL loading type that populates all the data warehouse tables.

Group of answer choices

INCREMENTAL LOAD

FULL LOAD

FULL REFRESH LOAD

INITIAL LOAD

A

INITIAL LOAD

27
Q

The full form of DOLAP acronym is ________ OLAP.

Group of answer choices

DRONE

DESKTOP

DEVICE

DYNAMIC

28
Q

An OLAP system that is created to facilitate management of both spatial and non-spatial data in a Geographic Information system.

Group of answer choices

SOLAP

HOLAP

WOLAP

MOLAP

29
Q

Decision Tree is an example of a classification algorithm.
Group of answer choices

True

False

30
Q

The EVALUATION phase of CRISP-DM that consists of presenting the results in a useful and understandable manner, and by achieving this, the project should achieve its goals.
Group of answer choices

True

False

31
Q

Clustering technique is an unsupervised learning.
Group of answer choices

True

False

32
Q

Classification technique is a supervised learning.
Group of answer choices

True

False

33
Q

Clustering technique is a supervised learning.
Group of answer choices

True

False

34
Q

Clustering technique is a(n) _________ learning.

Group of answer choices

SUPERVISED

UNSUPERVISED

A

UNSUPERVISED

35
Q

It refers to the numeric study of data relationships.

Group of answer choices

Not in the options

MACHINE LEARNING

STATISTICS

ALGORITHMS

A

STATISTICS

36
Q

An OLAP operation that performs the analysis by taking one level of information for display.

37
Q

The type of OLAP system that works on the information that resides in a relational database. Note: Write only the acronym.

38
Q

An OLAP operation that is also known as consolidation, use to summarize operation data along with the dimension.

Group of answer choices

DICE

DRILL-UP

SLICE

Not in the options

A

Not in the options

39
Q

An OLAP system that utilizes multi-dimensional database for storing and analyzing information.

Group of answer choices

MOLAP

SOLAP

WOLAP

HOLAP

40
Q

In the 9-step KDD process, choosing a data mining task is the same as choosing data mining algorithm.
Group of answer choices

True

False

41
Q

The Naïve Bayes algorithm is a _________ data mining.

Group of answer choices

CLUSTERING

ASSOCIATION

REGRESSION

CLASSIFICATION

A

CLASSIFICATION

42
Q

What is the 4th step in CRISP-DM?

Group of answer choices

EVALUATION

DATA PREPARATION

ANALYSIS

MODELING

43
Q

An OLAP system that is created to facilitate management of both spatial and non-spatial data in a Geographic Information system. Note: Write only the acronym.

44
Q

An OLAP operation that performs the analysis by taking one level of information for display.

Group of answer choices

DRILL-DOWN

DICE

PIVOT

SLICE

45
Q

An ETL loading type that erase the contents of one or more tables and reloading with fresh data.

Group of answer choices

PARTIAL LOAD

INITIAL LOAD

FULL REFRESH LOAD

INCREMENTAL LOAD

A

FULL REFRESH LOAD

46
Q

Decision Tree is an example of an association algorithm.
Group of answer choices

True

False

47
Q

Artificial Intelligence refers to the algorithms that can learn from data to make predictions.
Group of answer choices

True

False

48
Q

KDD stands for:

Group of answer choices

Knowledge Database and Discovery

Knowledge in Discovering Data

Knowledge Discovered Database

Knowledge Discovery in Databases

A

Knowledge Discovery in Databases

49
Q

Data mining is applied in _________ websites to offer cross-sells and up-sells through their websites.

Group of answer choices

E-COMMERCE

SUPERMARKETS

SERVICE PROVIDERS

RETAIL

A

E-COMMERCE

50
Q

What is the full form of the acronym OLAP?

A

ONLINE ANALYTICAL PROCESSING

51
Q

Classification technique is an unsupervised learning.
Group of answer choices

True

False

52
Q

A data mining technique that is used to determine when something is noticeably different from the regular pattern.

Group of answer choices

CLASSIFICATION

REGRESSION

ANOMALY DETECTION

CLUSTER ANALYSIS

A

ANOMALY DETECTION

53
Q

A DM algorithm that has an assumption: Every feature of the data being classified is independent of all other features given the class.

Group of answer choices

DECISION TREE

NAIVE BAYES

APRIORI

K-MEANS

A

NAIVE BAYES

54
Q

The ________ is about processing data and identifying patterns and trends in that information so that you can decide or judge.

Group of answer choices

MACHINE LEARNING

ARTIFICIAL INTELLIGENCE

DATA MINING

STATISTICS

A

DATA MINING

55
Q

The ______ operation perform the analysis that can gain a new view of data by rotating the data axes of the cube.
Group of answer choices

PIVOT

ROLL-UP

SLICE & DICE

DRILL-DOWN

56
Q

The _______ analysis provides answers of the future queries that move across using historical data as the chief principle for decisions.

Group of answer choices

DESCRIPTIVE

PREDICTIVE

A

PREDICTIVE

57
Q

An OLAP operation that is also known as consolidation, use to summarize operation data along with the dimension.

58
Q

An OLAP operation that performs analysis in deeper among the dimensions of data.

Group of answer choices

SLICE

DRILL-DOWN

DICE

PIVOT

A

DRILL-DOWN

59
Q

Unsupervised learning is a predictive analysis.
Group of answer choices

True

False

60
Q

A type of data mining algorithm that is used to mine data and provide the latest information on past or recent events.

Group of answer choices

PREDICTIVE ANALYSIS

DESCRIPTIVE ANALYSIS

A

DESCRIPTIVE ANALYSIS

61
Q

A data mining algorithm that requires a label or target.

Group of answer choices

UNSUPERVISED LEARNING

SUPERVISED LEARNING

A

SUPERVISED LEARNING

62
Q

The full form of DOLAP acronym is ________ OLAP.

63
Q

These are algorithms that can learn from data to make predictions.
Group of answer choices

Not in the options

MACHINE LEARNING

ARTIFICIAL INTELLIGENCE

DATA MINING ALGORITHMS

A

MACHINE LEARNING

3 TSY 23-24 (17 decks)

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