Data Analyst Technical Interview Questions

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

 

 

Which metric is commonly used to measure data accuracy?
Data volume
Error rate
Processing speed
Storage cost
Which file format is commonly used when importing data from databases into Excel?
.doc
.pdf
.csv
.jpg
Which Python library is primarily used for data manipulation?
pandas
matplotlib
scikit-learn
TensorFlow
What is the primary use of the WITH clause in SQL?
To join tables
To define named subqueries
To filter rows
To create indexes
Which of these is a common measure of central tendency?
Range
Variance
Mean
Standard deviation
Which tool is NOT typically used for data analysis and presentation?
Adobe Photoshop
Tableau
Power BI
Excel
What does the SUM function do in Excel?
Adds a range of cells
Multiplies a range of cells
Counts cells in a range
Averages a range of cells
What is the purpose of the DBSCAN algorithm?
To find clusters of arbitrary shape
To find only spherical clusters
To perform hierarchical clustering
To perform dimensionality reduction
Which of these is NOT a common type of data quality dimension?
Accuracy
Completeness
Consistency
Psychic ability
What is the main purpose of a data warehouse?
To store current transactional data
To perform real-time analytics
To store historical data for reporting and analysis
To process online transactions
Which Excel feature is used to apply formatting based on cell values?
Conditional Formatting
Cell Styles
Format Painter
Auto Format
Which of these is NOT a common type of database constraint?
Primary Key constraint
Foreign Key constraint
Unique constraint
Psychic constraint
Data analysts use a problem-oriented approach to identify, _____, and solve problems.
ignore
complicate
analyze
avoid
What is machine learning?
A method of data analysis that automates analytical model building
A way to clean data
A type of database
A data visualization technique
Which data visualization tool is best for showing the distribution of a continuous variable?
Bar chart
Pie chart
Histogram
Scatter plot
What does the LEFT JOIN do in SQL?
Returns all rows from the left table and matching rows from the right table
Returns only matching rows between two tables
Returns all rows from both tables
Returns all rows from the right table and matching rows from the left table
Which of these is NOT a common type of database index?
B-tree index
Bitmap index
Hash index
Psychic index
What is the main purpose of data tokenization?
To create multiple copies of data
To replace sensitive data with non-sensitive equivalents
To delete all data
To visualize all data
What is an absolute cell reference in Excel?
A reference that changes when copied
A reference that doesn't change when copied
A reference to another sheet
A reference to another workbook
What is a key difference between clustered and non-clustered indexes?
Data type supported
Physical order of data
Number of columns allowed
Update frequency
What is the purpose of the SUMPRODUCT function in Excel?
Multiplies ranges
Sums products of ranges
Calculates weighted average
Performs matrix multiplication
Which of the following is NOT typically a component of an ETL process?
Extracting data from source systems
Transforming data to fit operational needs
Loading data into the end target
Visualizing the extracted data
Which SQL operator is used to compare a value to a range of values?
BETWEEN
IN
LIKE
EXISTS
What does DATEDIF calculate?
Difference between two dates
Current date
Date formatting
Date validation
What is the main difference between correlation and causation?
There is no difference
Correlation implies causation
Causation implies correlation
Correlation does not imply causation
Score: 0/25