Font size
WorksheetsData Warehousing and Data Mining LAB
Total questions: 69
Worksheet time: 37mins
Data Mining is the set of methodologies used in analyzing data from various dimensions and perspectives, finding previously unknown hidden patterns, classifying and grouping the data and summarizing the identified relationships
True
False
What should be written in the blue box?
Transformed data
Pattern/model
Preprocessed data
Raw data
What should be written in the blue box?
Transformed Data
Preprocessed Data
Pattern/model
Raw data
Using features to predict unknown or future values of the same or other feature is known as ___________ power of data mining
Clustering
Predictive
Associative
Descriptive
"Use data mining to find interesting, human-interpretable patterns that describe the data". What is the type of data mining to achieve this objective?
Association
Anomaly
Descriptive
Categorisation
"Process of sifting through large data sets to identify and describe patterns, discover and establish relationships with an intent to predict future trends based on those patterns and relationships". What does this statement explain about?
Visualization
Representation
Data mining
Business intelligence
Fraud-detection models and risk mitigation models-these are examples of data mining solution for which discipline?
Health
Insurance
Banking
Retail
Select the skills mainly required as a competent data analyst/scientist/miner
SQL
R
Python
Java
Select the tools that can be used for data mining
KNIME
WEKA
RATTLE
TANAGRA
Data mining process includes reporting and analysis
True
False
Focus on the specific organisation data to detect patterns
True
False
If during data mining, some data is incomplete, the team should seeking out the incomplete data
True
False
Techniques such as Self-Organizing-Maps (SOM’s), help to map missing data based by visualizing the model of multi-dimensional complex data.
True
False
A scoreboard, on a manager or supervisor’s computer, fed with real-time from data as it flows in and out of various databases within the company’s environment. Choose below which explains this best.
Data visualization
Dashboard
Anomaly detection
Data analysis
_______ is helpful to automatically find patterns within the text embedded in hordes of text files, word-processed files, PDFs, and presentation files.
SQL
Text Analysis
Ctrl+F
Visualization
Associations/co-relations between product sales, & prediction based on such association is called ____________
Customer profiling
Target marketing
Customer requirement analysis
Cross-market analysis
Class label is unknown: Group data to form new classes, e.g., cluster houses to find distribution patterns
Predictive Analysis
Anomaly Detection
Association Mining
Cluster analysis
A pattern is interesting if it is easily understood by humans, valid on new or test data with some degree of certainty, potentially useful, novel, or validates some hypothesis that a user seeks to confirm
True
False
Data mining is driven by the following:
-Kinds of data to be mined
-Kinds of knowledge to be discovered
-Kinds of techniques utilized
-Kinds of applications adapted
-Kinds of given mining duration
-Kinds of mining period
True
False
Data mining depends on
-Kinds of data to be mined
-Kinds of knowledge to be discovered
-Kinds of techniques utilized
-Kinds of applications adapted
True
False
Choose which data mining task is suitable for the following scenario: first buy digital camera, then buy large SD memory cards
Classification
Sequential pattern analysis
Association rule
Prediction
Choose which data mining task is the most suitable for the following scenario: Identifying an unexpected/unusual amount of spending
Prediction
Sequential pattern analysis
Association rules
Anomaly detection
Choose which data mining task is the most suitable for the following scenario: diagnosing the level of flood severity
Prediction
Classification
Anomaly detection
Association rules
Choose which data mining task is the most suitable for the following scenario: detecting the dosage of medicine for a certain treatment
Prediction
Classification
Association rules
Sequential pattern analysis
Choose which data mining task is the most suitable for the following scenario: grouping participants in a weight loss campaign
Classification
Clustering
Prediction
Association rules
Choose which data mining task is the most suitable for the following scenario: determining the stock value of a certain company
Prediction
Classification
Clustering
Association rules
Choose which data mining task is the most suitable for the following scenario: determining the best location to be recommended to a tourist club members
Association rules
Clustering
Classification
Prediction
Choose which data mining task is the most suitable for the following scenario: determining the rating when a location is recommended to a tourist club member
Classification
Prediction
Clustering
Association rules
Choose which data mining task is the most suitable for the following scenario: determining which tour group is suitable to a new member based on her past location ratings
Prediction
Classification
Clustering
Anomaly detection
Choose which data mining task is the most suitable for the following scenario: determining the thumbs up/thumbs down of a social media post
Prediction
Association rules
Classification
Clustering
Choose which data mining task is the most suitable for the following scenario:
To identify items that are bought concomitantly by a reasonable fraction of customers so that they can be shelved.
Classification
Association rules
Clustering
Prediction
Choose which data mining task is the most suitable for the following scenario:
To subdivide a market into distinct subset of customers where each subset can be targeted with a distinct marketing mix
Classification
Prediction
Clustering
Association rules
Choose which data mining task is the most suitable for the following scenario:
To find groups of documents that are similar to each other based on important terms appearing in them
Classification
Clustering
Prediction
Association rules
Choose which data mining task is the most suitable for the following scenario:
To reduce cost of mailing by targeting a set of consumers likely to buy a new cell phone product
Classification
Association rules
Clustering
Prediction
Choose which data mining task is the most suitable for the following scenario:
Predict fraudulent cases in credit card transactions
Classification
Association rules
Anomaly detection
Clustering
Choose which data mining task is the most suitable for the following scenario:
To guess wind velocities based on temperature, humidity, air pressure, etc
Classification
Association rules
Prediction
Anomaly detection
Choose which data mining task is the most suitable for the following scenario:
Given a set of n points or objects, and k, the expected number of outliers, find the top k objects that considerably dissimilar, exceptional or inconsistent with the remaining data
Classification
Association rules
Clustering
Anomaly detection
Choose which data mining task is the most suitable for the following scenario:
Based on past usage patterns, develop model for authorized credit card transactions
Classification
Association rules
Clustering
Anomaly detection
Choose which data mining task is the most suitable for the following scenario:
Given is a set of objects, with each object associated with its own time of events, find rules that predict strong sequential dependencies among different events
Classification
Sequential pattern analysis
Clustering
Association rules
Choose which data mining task is the most suitable for the following scenario:
Given the records of books that a group of people read, find relationship of the genre pattern
Classification
Association rules
Clustering
Prediction
Why was data warehousing proposed?
To keep track of transactional data
To keep summarized historical information
To manage data from heterogeneous sources
To produce management reports
In data warehousing, what is time-variant data?
Data in the warehouse is only accurate and valid at some point in time or over time interval
Data in the warehouse is always accurate and valid
Data in the warehouse is only accurate sometimes
Data in the warehouse is not accurate
Is the data in a data warehouse generally updated in real-time?
Yes
No
. An operational system is which of the following?
A system that is used to run the business in real time and is based on historical data.
A system that is used to run the business in real time and is based on current data.
A system that is used to support decision making and is based on current data.
A system that is used to support decision making and is based on historical data.
Which schema is best for data warehouse development?
The data collected in data warehouse can be used for analyzing purposes.
True
False
Which of the following are the characteristics of a data warehouse?
Subject-oriented.
Integrated.
Non-volatile.
All of the above.
A basic concept of data warehouse is which of the following?
Can be updated by end users.
Contains numerous naming conventions and formats.
Store the data in formats suitable for easy access for decision making.
Contains only current data.
What does OLTP stand for?
Online transaction processing
Offline transaction processing
Outline trajectory processing
Online traffic processing
A snowflake schema is a normalized star schema
TRUE
FALSE
"A fact table is narrow, but deep" means
Number of columns is high, number of rows is high
Number of columns is high, number of rows is low
Number of columns is low, number of rows is high
Number of columns is low, number of rows is low
What is the mode?
# occurring the most
the average
greatest - least
the middle #
4 7 5 9 8 6 7 7 8 5 6 9 8 5 8 7 4 7 3 6 8 9 7 6 9
What is the mode?
5,11,2,12,4,2
4,2,7,4,3
3, 5, 7, 9, 11, 8, 3
2, 57, 38, 42, 6
12, 5, 9, 18, 22, 25, 5
The number of miles that Kyle biked each week for a 7-week period is shown:
36, 42, 28, 52, 48, 36, 31
What is the median number of miles Kyle biked?
24
36
39
52
