1.
What is the difference between structured and unstructured data?
Structured data is organized in a predefined format, while unstructured data has no predefined format
Unstructured data is organized in a predefined format, while structured data has no predefined format
Structured data is always numerical, while unstructured data is always textual
Unstructured data is always numerical, while structured data is always textual
2.
What is the purpose of data wrangling?
To protect sensitive data from unauthorized access
To clean, transform, and prepare data for analysis
To store the actual data values in a database
To develop marketing strategies based on customer data
3.
What is a key advantage of using a box plot in data analysis?
It shows trends over time
It displays the correlation between two variables
It summarizes the distribution, central tendency, and variability of a dataset
It breaks down categorical data
4.
Which of the following describes a "normal distribution"?
A distribution that is skewed to the left
A symmetrical distribution where most values cluster around the mean
A distribution with multiple peaks
A random distribution with no specific pattern
5.
What is the purpose of a primary key in a database table?
To store the most important data in the table
To uniquely identify each row in the table
To create a relationship between two tables
To sort the data in the table in a specific order
6.
What is the difference between a bar chart and a histogram?
A bar chart is used for categorical data, while a histogram is used for numerical data
A histogram is used for categorical data, while a bar chart is used for numerical data
Bar charts and histograms are the same thing
Bar charts are used for univariate analysis, while histograms are used for bivariate analysis
7.
What is the purpose of using a data model in database design?
To visualize data trends
To define how data is connected and organized within the database
To clean and prepare data for analysis
To automate data entry processes
8.
In data visualization, what is the purpose of a pie chart?
To show trends over time
To compare different categories' sizes as parts of a whole
To display data distribution
To illustrate relationships between variables
9.
In predictive modeling, what is overfitting?
A model that captures noise instead of the actual pattern
A model that generalizes well to new data
A model with too few variables
A model that only works for large datasets
10.
What is the primary responsibility of a Data Analyst?
Designing and developing software applications
Managing and maintaining databases
Collecting, cleaning, and interpreting data to extract meaningful insights
Developing marketing strategies based on customer data
Questions Answered: 0/10