WorksheetsOverview of Data Mining
Total questions: 15
Worksheet time: 8mins
What is data mining?
Data mining is the process of discovering patterns and knowledge from large amounts of data.
Data mining is the analysis of data to improve software performance.
Data mining involves creating new data from existing datasets.
Data mining is the technique of storing data in a database.
Data Mining is often referred to as a specific step in a larger process called:
SDLC (Software Development Life Cycle)
ETL (Extract, Transform, Load)
ERP (Enterprise Resource Planning)
KDD (Knowledge Discovery in Databases)
What is the primary goal of data mining?
To store data in a structured format for easy access.
To visualize data trends through graphical representations.
To extract useful patterns and knowledge from large data sets.
To ensure data security and prevent unauthorized access.
Define the term 'data preprocessing' in data mining.
Data preprocessing is the method of analyzing data patterns without any modifications.
Data preprocessing involves the direct use of raw data for immediate analysis.
Data preprocessing refers to the visualization of data without any prior adjustments.
Data preprocessing is the process of cleaning and transforming raw data into a suitable format for analysis in data mining.
In the KDD process, "Data Cleaning" refers to:
ADeleting the entire database.
Converting data into a format suitable for mining.
Removing noise and inconsistent data.
Presenting the final results to stakeholders.
Which of these is NOT a primary motivation for using Data Mining in business?
Market Basket Analysis
Manual payroll calculation
Fraud detection
Customer Retention (Churn prediction)
What is a "Data Warehouse"?
A physical building where servers are kept.
A repository of data collected from multiple sources, stored under a unified schema
A temporary folder on a desktop
A specialized software for editing photos
Data that is stored in rows and columns (like a SQL table) is known as:
Structured Data
Unstructured Data
Semi-structured Data
Metadata
What is the significance of data visualization in data mining?
Data visualization is irrelevant in data mining and hinders understanding.
Data visualization only serves aesthetic purposes without practical value.
Data visualization is significant in data mining as it simplifies complex data, reveals patterns, and enhances communication of insights.
Data visualization complicates data analysis and obscures insights.
How does data mining differ from traditional data analysis?
Data mining discovers patterns and insights from large datasets, while traditional data analysis summarizes and interprets existing data.
Data mining only focuses on small datasets, while traditional analysis handles large datasets.
Data mining is limited to statistical methods, while traditional analysis uses machine learning techniques.
Data mining is a manual process, whereas traditional analysis uses automated tools.
'single piece of information'
data
datum
info
file
Edgar Frank “Ted” Codd developed __
Network data model
Relational Database
Hierarchical Data Model
File-Based Model
Network data model is developed by _
Dennis Ritchie
Edgar Frank “Ted” Codd
James Peterson
Charles Bachman
Identify a real-world application of data mining.
Social media sentiment analysis.
Sales forecasting in finance.
Website traffic optimization.
Customer behavior analysis in retail.
SQL stands for
Structure Query Language
Structured Query Language
Structured Queries Language
Structure Queries language
