Data Analyst Technical Interview Questions

Data Analyst Technical Interview Questions and Answers (MCQ): Test Your Knowledge!

 

 

What does a box plot show?
Distribution and outliers
Trends over time
Composition of a whole
Relationships between variables
What is the primary purpose of data lineage?
To encrypt data during transmission
To track data from its origin to its destination
To compress data for storage
To clean and transform data
What is the purpose of the SQL TRUNCATE command?
To delete specific rows
To delete all rows
To delete a column
To delete a table
What does a p-value of 0.05 indicate?
5% chance of Type I error
5% chance of Type II error
95% confidence in the null hypothesis
95% confidence in the alternative hypothesis
How is categorical data typically handled in machine learning models?
Used as is
Converted to numerical format (e.g., one-hot encoding)
Removed from the dataset
Treated as continuous data
Which SQL join returns only the rows that have matching values in both tables?
LEFT JOIN
RIGHT JOIN
INNER JOIN
FULL OUTER JOIN
What is the purpose of the REVOKE statement in SQL?
To remove specific privileges from a user
To grant privileges to a user
To create a new user
To delete a user
What does API stand for?
Advanced Programming Interface
Application Programming Interface
Automated Protocol Integration
Advanced Protocol Interface
What is a relative cell address in Excel?
A cell reference that doesn't change
A cell reference that changes when copied
An absolute cell reference
A mixed cell reference
What is the primary role of a data steward?
To perform data analysis
To manage and ensure the quality and integrity of data assets
To develop software
To design databases
What is the primary goal of cluster analysis?
To predict future values
To classify data into predefined categories
To group similar data points together
To reduce dimensionality
What is the main purpose of the VLOOKUP function in Excel?
To create charts
To search for a value in a table and return a corresponding value
To clean data
To perform statistical tests
What is the purpose of the K-means algorithm?
To perform clustering
To perform classification
To perform regression
To reduce dimensionality
What is the purpose of a choropleth map?
To display statistical data using color-coded geographical areas
To show trends over time
To compare categories
To display the distribution of a single variable
Which function finds the day of the week for a date?
DATE
WEEKDAY
DAY
WEEKNUM
What is the significance level commonly used in hypothesis testing?
0.05
0.5
0.01
1.0
Which of these is NOT a common type of database backup?
Full backup
Differential backup
Transaction log backup
Psychic backup
What does the REPT function do in Excel?
Repeats text
Reports data
Replaces values
Replicates cells
What is the primary function of a foreign key in a database?
To ensure data integrity
To speed up queries
To reduce storage space
To encrypt data
What is the difference between DELETE and TRUNCATE in SQL?
DELETE can use WHERE clause, TRUNCATE removes all rows
They are the same
DELETE is always faster
TRUNCATE can use WHERE clause
How does a pie chart differ from a donut chart?
Color scheme
Pie charts show percentages, donut charts don't
Donut charts have a hole in the center
They are exactly the same
Which function would you use to return the number of characters in a text string?
CHARCOUNT
LENGTH
TEXTLENGTH
COUNT
Which machine learning algorithm is commonly used for dimensionality reduction?
t-SNE
Linear regression
Logistic regression
Decision trees
What is the primary purpose of a data warehouse?
To store historical data for reporting and analysis
To process real-time transactions
To clean data
To visualize data
Which of these is NOT a common type of database constraint?
Primary Key constraint
Foreign Key constraint
Unique constraint
Psychic constraint
Score: 0/25