FA6 - Sheet1

Question 1

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

Answer 1

EXTRACT TRANSFORM LOAD

Question 2

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

Answer 2

PIVOT

Question 3

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

Answer 3

MOLAP

Question 4

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

Answer 4

OLAP CUBE

Question 5

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

Answer 5

INCREMENTAL LOAD

Question 6

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

Answer 6

INCREMENTAL LOAD

Question 7

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

Answer 7

INITIAL LOAD

Question 8

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)

Answer 8

Partial Extraction (with update notification)

Question 9

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

Group of answer choices

ROLAP

HOLAP

MOLAP

DOLAP

Answer 9

ROLAP

Question 10

The HOLAP system is a blend of _______ and MOLAP.

Group of answer choices

DOLAP

WOLAP

SOLAP

ROLAP

Answer 10

ROLAP

Question 11

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

Answer 11

t

Question 12

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

True

False

Answer 12

True

Question 13

Clustering is an unsupervised learning.
Group of answer choices

True

False

Answer 13

t

Question 14

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

Answer 14

t

Question 15

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

Answer 15

False

Question 16

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

Answer 16

REGRESSION

Question 17

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

Answer 17

UNSUPERVISED LEARNING

Question 18

Classification technique is a(n) ________ learning.

Group of answer choices

SUPERVISED

UNSUPERVISED

Answer 18

SUPERVISED

Question 19

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

Answer 19

Data understanding

Question 20

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

Group of answer choices

CLUSTERING

REGRESSION

ASSOCIATION

CLASSIFICATION

Answer 20

CLASSIFICATION

Question 21

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

Answer 21

DRILL-DOWN

Question 22

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

Answer 22

ROLAP

Question 23

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

Answer 23

INITIAL LOAD

Question 24

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

Answer 24

DATA WAREHOUSE

Question 25

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

Answer 25

OLAP CUBE

Question 26

An ETL loading type that populates all the data warehouse tables. Group of answer choices INCREMENTAL LOAD FULL LOAD FULL REFRESH LOAD INITIAL LOAD

Answer 26

INITIAL LOAD

Question 27

The full form of DOLAP acronym is ________ OLAP. Group of answer choices DRONE DESKTOP DEVICE DYNAMIC

Answer 27

DESKTOP

Question 28

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

Answer 28

SOLAP

Question 29

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

Answer 29

True

Question 30

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

Question 31

Clustering technique is an unsupervised learning. Group of answer choices True False

Answer 31

True

Question 32

Classification technique is a supervised learning. Group of answer choices True False

Answer 32

t

Question 33

Clustering technique is a supervised learning. Group of answer choices True False

Answer 33

False

Question 34

Clustering technique is a(n) _________ learning. Group of answer choices SUPERVISED UNSUPERVISED

Answer 34

UNSUPERVISED

Question 35

It refers to the numeric study of data relationships. Group of answer choices Not in the options MACHINE LEARNING STATISTICS ALGORITHMS

Answer 35

STATISTICS

Question 36

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

Answer 36

SLICE

Question 37

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

Answer 37

ROLAP

Question 38

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

Answer 38

Not in the options

Question 39

An OLAP system that utilizes multi-dimensional database for storing and analyzing information. Group of answer choices MOLAP SOLAP WOLAP HOLAP

Answer 39

MOLAP

Question 40

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

Answer 40

False

Question 41

The Naïve Bayes algorithm is a _________ data mining. Group of answer choices CLUSTERING ASSOCIATION REGRESSION CLASSIFICATION

Answer 41

CLASSIFICATION

Question 42

What is the 4th step in CRISP-DM? Group of answer choices EVALUATION DATA PREPARATION ANALYSIS MODELING

Answer 42

MODELING

Question 43

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.

Answer 43

SOLAP

Question 44

An OLAP operation that performs the analysis by taking one level of information for display. Group of answer choices DRILL-DOWN DICE PIVOT SLICE

Answer 44

SLICE

Question 45

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

Answer 45

FULL REFRESH LOAD

Question 46

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

Answer 46

False

Question 47

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

Answer 47

False

Question 48

KDD stands for: Group of answer choices Knowledge Database and Discovery Knowledge in Discovering Data Knowledge Discovered Database Knowledge Discovery in Databases

Answer 48

Knowledge Discovery in Databases

Question 49

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

Answer 49

E-COMMERCE

Question 50

What is the full form of the acronym OLAP?

Answer 50

ONLINE ANALYTICAL PROCESSING

Question 51

Classification technique is an unsupervised learning. Group of answer choices True False

Question 52

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

Answer 52

ANOMALY DETECTION

Question 53

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

Answer 53

NAIVE BAYES

Question 54

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

Answer 54

DATA MINING

Question 55

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

Answer 55

PIVOT

Question 56

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

Answer 56

PREDICTIVE

Question 57

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

Answer 57

ROLL-UP

Question 58

An OLAP operation that performs analysis in deeper among the dimensions of data. Group of answer choices SLICE DRILL-DOWN DICE PIVOT

Answer 58

DRILL-DOWN

Question 59

Unsupervised learning is a predictive analysis. Group of answer choices True False

Answer 59

False

Question 60

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

Answer 60

DESCRIPTIVE ANALYSIS

Question 61

A data mining algorithm that requires a label or target. Group of answer choices UNSUPERVISED LEARNING SUPERVISED LEARNING

Answer 61

SUPERVISED LEARNING

Question 62

The full form of DOLAP acronym is ________ OLAP.

Answer 62

DESKTOP

Question 63

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

Answer 63

MACHINE LEARNING