Data Analyst Aptitude Test
Questions Answered: 0/10
1.
What is the purpose of a left join in SQL?
To retrieve all records from the left table and matching records from the right table
To retrieve only matching records from both tables
To retrieve only records from the right table
To combine records from both tables without matching
2.
What is the purpose of a hypothesis test in statistics?
To prove that a hypothesis is true
To determine whether there is enough evidence to reject a null hypothesis
To collect data to support a hypothesis
To visualize the relationship between two variables
3.
In a dataset, what does the term "variance" measure?
The average of all values
The degree of spread or dispersion of data points around the mean
The total number of data points
The relationship between two variables
4.
Which of the following best describes data sampling?
Collecting all available data
Selecting a subset of data for analysis
Ignoring missing data
Sorting data alphabetically
5.
Which of the following best describes the primary goal of data normalization?
To reduce redundancy and improve data integrity
To increase the size of the dataset
To combine multiple data sources
To make data more complex
6.
What is the difference between a primary key and a foreign key in a database?
A primary key uniquely identifies each record in a table, while a foreign key is a field in one table that refers to the primary key in another table
A foreign key uniquely identifies each record in a table, while a primary key is a field in one table that refers to the primary key in another table
Primary keys and foreign keys are the same thing
Primary keys are used for quantitative data, while foreign keys are used for qualitative data
7.
In data modeling, what does ER stand for in ER diagrams?
Entity Relationship
Effective Range
Error Ratio
Estimated Results
8.
What type of analysis helps in identifying patterns, trends, or correlations in data using historical data?
Prescriptive analysis
Predictive analysis
Descriptive analysis
Diagnostic analysis
9.
Which of the following is an example of categorical data?
Sales revenue
Age in years
Product categories
Height in centimeters
10.
In a box plot, what does the line inside the box represent?
The mean
The standard deviation
The median
The range
Questions Answered: 0/10
Copyright © 2024