Data Analyst Technical Interview Questions

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

 

 

Which SQL join returns all matching records from both tables and null for non-matches?
INNER JOIN
LEFT JOIN
RIGHT JOIN
FULL OUTER JOIN
How do you create a dynamic range in Excel?
Use OFFSET function
Use VLOOKUP
Use Pivot Table
Use Charts
Which SQL function is used to extract a date part from a date?
DATEPART()
EXTRACT()
PART()
SPLIT()
How does a primary key differ from a unique key?
Data type
Null values allowed
Indexing
Uniqueness across tables
What is the main purpose of a JOIN in SQL?
To combine rows from two or more tables
To filter data
To sort data
To aggregate data
What is the purpose of indexing in databases?
To improve query performance
To encrypt data
To compress data
To validate data
Which SQL clause is used to filter groups after aggregation?
HAVING
WHERE
GROUP BY
ORDER BY
Which SQL function returns the largest value in a set of values?
MAX()
LARGEST()
TOP()
HIGHEST()
What is the primary purpose of data masking?
To clean data
To obfuscate sensitive data
To analyze data
To visualize data
What does the TRIM function do in Excel?
Removes extra spaces
Removes leading zeros
Removes trailing zeros
Removes non-numeric characters
What is the main principle of the K-Nearest Neighbors algorithm?
Maximize distance between clusters
Minimize intra-cluster variance
Classify based on closest training examples
Reduce dimensionality
What type of chart is typically used to display the results of a regression analysis?
Pie chart
Bar chart
Scatter plot
Line chart
Which is NOT a best practice for data visualization?
Clear labeling
Appropriate chart type
Consistent color scheme
Overcrowding with information
What is the main goal of data governance?
To ensure data is managed as an enterprise asset
To increase data volume
To improve query performance
To create more databases
What is the purpose of the GROUP BY clause in SQL?
To group rows that have the same values
To filter rows
To sort rows
To join tables
What is the primary use of LAG() and LEAD() functions in SQL?
To join tables
To access data from previous or subsequent rows
To filter rows
To create indexes
What is NOT a common application of machine learning in data analysis?
Predictive modeling
Pattern recognition
Anomaly detection
Data encryption
Which chart type is best for showing the changes in a value's ranking over time?
Bump chart
Pie chart
Bar chart
Line chart
What is the purpose of the AVERAGEIF function in Excel?
Averages all cells
Conditional average
Calculates mean
Finds median
What is the main difference between descriptive and inferential statistics?
Descriptive summarizes data, inferential makes predictions
They are the same
Descriptive uses probability, inferential doesn't
Inferential summarizes data, descriptive makes predictions
Which SQL function returns the largest value in a set of values?
MAX()
TOP()
HIGHEST()
GREATEST()
What is the primary purpose of collaborating with other departments?
To avoid work
To understand business needs and context
To delegate all tasks
To complicate the analysis process
What is the difference between INNER JOIN and CROSS JOIN in SQL?
INNER JOIN returns matching rows, CROSS JOIN returns Cartesian product
They are the same operation
INNER JOIN is always faster
CROSS JOIN can only be used with two tables
Which SQL function returns the length of a string?
SIZE()
LENGTH()
LEN()
COUNT()
What does CSV stand for in data formats?
Comma Separated Values
Computer Sorted Variables
Calculated Summary View
Centralized Storage Vector
Score: 0/25