11/15/24, 9:00 PM SRI KRISHNA COLLEGE OF ENGINEERING AND TECHNOLOGY
SRI KRISHNA COLLEGE OF ENGINEERING AND TECHNOLOGY
Department of AI&DS
The respondent's email (727723euai020@[Link]) was recorded on submission of this form.
DWM QUIZ
DATAWARE HOUSING AND MINING
NAME *
BHARATHWAJ P R
REG-NO *
727723EUAI020
[Link] 1/17
11/15/24, 9:00 PM SRI KRISHNA COLLEGE OF ENGINEERING AND TECHNOLOGY
PHONE NUMBER *
9942603545
What is a data warehouse? * 1 point
What is a data warehouse?
A. A place to store hardware
B. A system used for daily transaction processing
C. A centralized repository for integrated data from multiple sources
D. A tool for network security
[Link] 2/17
11/15/24, 9:00 PM SRI KRISHNA COLLEGE OF ENGINEERING AND TECHNOLOGY
Which of the following is a key characteristic of a data warehouse? * 1 point
A. Volatile
B. Real-time data processing
C. Non-volatile
D. Processes transactional data
What is the primary difference between a database and a data warehouse? * 1 point
A. Databases store structured data, while data warehouses store unstructured data
B. Databases handle transactional data, while data warehouses handle analytical data
C. Data warehouses are smaller than databases
D. There is no difference
[Link] 3/17
11/15/24, 9:00 PM SRI KRISHNA COLLEGE OF ENGINEERING AND TECHNOLOGY
What does ETL stand for in data warehousing? * 1 point
A. Extract, Transfer, Load
B. Execute, Transform, Load
C. Extract, Transform, Load
D. Execute, Test, Link
What does OLAP stand for? * 1 point
A. Online Analytical Processing
B. Offline Analytical Processing
C. Online Linear Application Processing
D. Open Layer Analytical Process
[Link] 4/17
11/15/24, 9:00 PM SRI KRISHNA COLLEGE OF ENGINEERING AND TECHNOLOGY
Which of the following is NOT a type of OLAP system? * 1 point
A. MOLAP
B. ROLAP
C. HOLAP
D. ZOLAP
What is a star schema? * 1 point
A. A network structure for storing data
B. A type of database designed for faster transactions
C. A data model where the fact table is at the center and connected to dimension tables
D. A data model used for unstructured data
[Link] 5/17
11/15/24, 9:00 PM SRI KRISHNA COLLEGE OF ENGINEERING AND TECHNOLOGY
Which schema is more normalized: star schema or snowflake schema? * 1 point
A. Star schema
B. Snowflake schema
C. Both are the same
D. Neither is normalized
In a data warehouse, what is a fact table? * 1 point
A. A table containing descriptive data
B. A table that stores transactional or quantitative data
C. A table that stores metadata
D. A table containing personal information
[Link] 6/17
11/15/24, 9:00 PM SRI KRISHNA COLLEGE OF ENGINEERING AND TECHNOLOGY
What is a data mart? * 1 point
A. A data processing tool
B. A subset of a data warehouse
C. A system for managing logs
D. A database management tool
What is data mining? * 1 point
A. The process of searching for patterns in large datasets
B. Extracting data from databases
C. Building databases from scratch
D. Storing large amounts of data
[Link] 7/17
11/15/24, 9:00 PM SRI KRISHNA COLLEGE OF ENGINEERING AND TECHNOLOGY
What is the primary difference between data mining and machine learning? * 1 point
A. Data mining is about storing data; machine learning is about analyzing data
B. Data mining involves extracting patterns; machine learning involves learning from data
C. There is no difference
D. Machine learning is a subset of data mining
Which of the following is a key step in the data mining process? * 1 point
A. Data replication
B. Data visualization
C. Data cleaning
D. Data uploading
[Link] 8/17
11/15/24, 9:00 PM SRI KRISHNA COLLEGE OF ENGINEERING AND TECHNOLOGY
What is clustering in data mining? * 1 point
A. Predicting future trends
B. Grouping similar data points together based on certain features
C. Analyzing transactional data
D. Performing ETL operations
How does classification work in data mining? * 1 point
A. It segments data into smaller databases
B. It groups data based on user-specified categories
C. It filters irrelevant data
D. It visualizes the data
[Link] 9/17
11/15/24, 9:00 PM SRI KRISHNA COLLEGE OF ENGINEERING AND TECHNOLOGY
What is an association rule in data mining? * 1 point
A. A rule that governs database operations
B. A rule used to predict how likely one event is to be associated with another
C. A regulation in data governance
D. A formula for data storage
Which of the following is a common algorithm used in data mining? * 1 point
A. Regression Trees
B. Relational Algebra
C. Dijkstra’s Algorithm
D. Shell Sort
[Link] 10/17
11/15/24, 9:00 PM SRI KRISHNA COLLEGE OF ENGINEERING AND TECHNOLOGY
Why is data pre-processing important in data mining? * 1 point
A. It makes data smaller
B. It cleans and organizes data for analysis
C. It compresses data
D. It transforms data into visual form
What is the difference between supervised and unsupervised learning in data mining? * 1 point
A. Supervised learning uses labeled data; unsupervised learning does not
B. Unsupervised learning is faster
C. Supervised learning is only used in data warehousing
D. There is no difference
[Link] 11/17
11/15/24, 9:00 PM SRI KRISHNA COLLEGE OF ENGINEERING AND TECHNOLOGY
What is the role of patterns in data mining? * 1 point
A. Patterns are used to store data
B. Patterns help in discovering trends and insights from large datasets
C. Patterns are irrelevant to data mining
D. Patterns slow down the analysis process
What is a dataset? * 1 point
A. A group of algorithms for data analysis
B. A collection of data organized in rows and columns
C. A tool used for managing databases
D. A process of mining data from warehouses
[Link] 12/17
11/15/24, 9:00 PM SRI KRISHNA COLLEGE OF ENGINEERING AND TECHNOLOGY
Which of the following formats is commonly used to store datasets? * 1 point
A. PDF
B. CSV
C. DOCX
D. MP3
What is the difference between a structured and unstructured dataset? * 1 point
A. Structured datasets contain labeled data, while unstructured datasets do not
B. Structured datasets are organized in a tabular format (rows and columns), while unstructured datasets do not have a predefined structure
C. Structured datasets are smaller in size than unstructured datasets
D. There is no difference
[Link] 13/17
11/15/24, 9:00 PM SRI KRISHNA COLLEGE OF ENGINEERING AND TECHNOLOGY
Which of the following is an example of an unstructured dataset? * 1 point
A. SQL table
B. Excel sheet
C. Social media posts
D. CSV file
What is the purpose of data cleaning in a dataset? * 1 point
A. To convert data into graphs
B. To remove errors, duplicates, and inconsistencies from the dataset
C. To increase the size of the dataset
D. To visualize the data
[Link] 14/17
11/15/24, 9:00 PM SRI KRISHNA COLLEGE OF ENGINEERING AND TECHNOLOGY
What is a feature in a dataset? * 1 point
A. A specific data point in the dataset
B. A column representing a variable or attribute in the dataset
C. A collection of rows in a dataset
D. A tool for data mining
What is a target variable in a dataset used for machine learning? * 1 point
A. The column that contains the results or outcomes to be predicted
B. The first column in a dataset
C. A random variable in the dataset
D. The index of the dataset
[Link] 15/17
11/15/24, 9:00 PM SRI KRISHNA COLLEGE OF ENGINEERING AND TECHNOLOGY
What is missing data in a dataset? * 1 point
A.. Data that is duplicated multiple times
B. Data that contains errors
C. Data points that are not recorded or have empty values
D. Data that is incorrectly formatted
Which of the following is an example of a continuous variable in a dataset? * 1 point
A. Product category
B. Customer satisfaction rating (on a scale of 1 to 5)
C. Age in years
D. Gender
[Link] 16/17
11/15/24, 9:00 PM SRI KRISHNA COLLEGE OF ENGINEERING AND TECHNOLOGY
What does dimensionality reduction mean in the context of a dataset? * 1 point
A. Increasing the size of the dataset
B. Reducing the number of features or columns in a dataset
C. Decreasing the number of rows in a dataset
D. Removing all missing data from the dataset
This form was created inside of Sri Krishna College of Engineering and Technology.
Forms
[Link] 17/17
