FORMATIVE 6 Flashcards
An OLAP system that utilizes multi-dimensional database for storing and analyzing information.
(MOLAP)
True or False
True
The full form of the acronym OLAP is (ONLINE ANALYTICAL PROCESS)
True
False
True
The acronym for ETL is (EXTRACT TRANSFORM LOAD)
True
False
True
(SLICE) is a OLAP operation that performs the analysis by taking one level of information for display.
True or False
True
OLAP is located in between Front-end tools and (DATA WAREHOUSE)
True or False
True
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
PIVOT
The HOLAP system is a blend of ______ and MOLAP.
WOLAP
ROLAP
SOLAP
DOLAP
ROLAP
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
SOLAP
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
Classification technique is a supervised learning.
True or False
True
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
Clustering is an unsupervised learning.
True or False
True
Decision Tree is an example of a classifcation algorithm.
True or False
True
Data mining is applied in _________ websites to offer cross-sells and up-sells through their websites.
E-COMMERCE
SERVICE PROVIDERS
SUPERMARKETS
RETAIL
E-COMMERCE
It refers to the numeric study of data relationships.
MACHINE LEARNING
Not in the options
STATISTICS
ALGORITHMS
STATISTICS
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
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
