FORMATIVE 6 Flashcards by Cloud Nine

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

(MOLAP)

True or False

True

How well did you know this?

Not at all

Perfectly

The full form of the acronym OLAP is (ONLINE ANALYTICAL PROCESS)

True

False

True

How well did you know this?

Not at all

Perfectly

The acronym for ETL is (EXTRACT TRANSFORM LOAD)

True

False

True

How well did you know this?

Not at all

Perfectly

(SLICE) is a OLAP operation that performs the analysis by taking one level of information for display.

True or False

True

How well did you know this?

Not at all

Perfectly

OLAP is located in between Front-end tools and (DATA WAREHOUSE)

True or False

True

How well did you know this?

Not at all

Perfectly

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

SLICE & DICE

DRILL-DOWN

ROLL-UP

PIVOT

How well did you know this?

Not at all

Perfectly

The HOLAP system is a blend of ______ and MOLAP.

WOLAP

ROLAP

SOLAP

DOLAP

ROLAP

How well did you know this?

Not at all

Perfectly

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

HOLAP

WOLAP

MOLAP

SOLAP

How well did you know this?

Not at all

Perfectly

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

DRILL-UP

SLICE

DICE

ROLL-UP

DRILL-UP

How well did you know this?

Not at all

Perfectly

Classification technique is a supervised learning.

True or False

True

How well did you know this?

Not at all

Perfectly

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

True or False

True

How well did you know this?

Not at all

Perfectly

Clustering is an unsupervised learning.

True or False

True

How well did you know this?

Not at all

Perfectly

Decision Tree is an example of a classifcation algorithm.

True or False

True

How well did you know this?

Not at all

Perfectly

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

E-COMMERCE

SERVICE PROVIDERS

SUPERMARKETS

RETAIL

E-COMMERCE

How well did you know this?

Not at all

Perfectly

It refers to the numeric study of data relationships.

MACHINE LEARNING

Not in the options

STATISTICS

ALGORITHMS

STATISTICS

How well did you know this?

Not at all

Perfectly

These are algorithms that can learn from data to make predictions.

MACHINE LEARNING

ARTIFICIAL INTELLIGENCE

Not in the options

DATA MINING ALGORITHMS

MACHINE LEARNING

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

DATA MINING

STATISTICS

ARTIFICIAL INTELLIGENCE

MACHINE LEARNING

DATA MINING

The ful form of DOLAP acronym is (DESKTOP) OLAP.

True

False

True

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

(DRILL-DOWN)

True

False

True

A (OLAP CUBE) is a data structure that allows fast analysis of data according to the multiple dimensions that define a business problem.

True

False

True

The full form of DOLAP acronym is _______ OLAP.

DESKTOP

DRONE

DYNAMIC

DEVICE

DESKTOP

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

FULL REFRESH LOAD

INCREMENTAL LOAD

FULL LOAD

PARTIAL LOAD

INCREMENTAL LOAD

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

FULL LOAD

FULL REFRESH LOAD

INCREMENTAL LOAD

INITIAL LOAD

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

Partial Extraction (with update notification)

Partial Extraction (without update notification)

Partial Extraction (with update notification)

An ETL loading type that erase the contents of one or more tables and reloading with fresh data. PARTIAL LOAD INITIAL LOAD INCREMENTAL LOAD FULL REFRESH LOAD

FULL REFRESH LOAD

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

False

Clustering technique is an unsupervised learning. True False

True

The Naive Bayes algorithm is a______ data mining. CLASSIFICATION REGRESSION ASSOCIATION CLUSTERING

CLASSIFICATION

A DM algorithm that has an assumption: Every feature of the data being classified is independent of all other features given the class. K-MEANS NAIVE BAYES DECISION TREE APRIORI

NAIVE BAYES

A DM algorithm that constructs a classifier in the form of a decision tree. C4.5 K-MEANS NEURAL NETWORK PAGERANK

C4.5

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

MODELING

The (INITIAL LOAD) type of ETL Loading process populates all the data warehouse tables. True False

True

he type of OLAP system that works on the information that resides in a relational database. MOLAP HOLAP DOLAP ROLAP

ROLAP

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. True False

True

KDD stands for: Knowledge Discovery in Databases Knowledge Database and Discovery Knowledge Discovered Database Knowledge in Discovering Data

Knowledge Discovery in Databases

A data mining technique that is used to make predictions based on relationships within the data set. ANOMALY DETECTION CLUSTER ANALYSIS REGRESSION CLASSIFICATION

REGRESSION

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

SLICE

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

DESCTIPTIVE ANALYSIS

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. True False

False