Data Analyst Certification

1. What is the purpose of data cleaning?

To remove errors and inconsistencies

To increase the dataset size

To reduce analysis time

To improve data visualization

2. Which of these is a key responsibility of a data analyst?

Interpreting data to draw actionable insights

Developing machine learning models

Creating software applications

Cleaning and preparing data for analysis

3. What does the acronym SQL stand for?

Structured Query Language

Simple Query Language

Standard Query Language

Sequential Query Language

4. What type of chart is best for showing proportions?

Line Chart

Bar Chart

Scatter Plot

Pie Chart

5. Which of the following libraries is commonly used for data visualization in Python?

NumPy

Matplotlib

Scikit-learn

TensorFlow

6. What is the purpose of a primary key in a database?

To uniquely identify each record

To store relationships between tables

To index the data

To create a foreign key

7. Which of the following is a quantitative data type?

Gender

Age

Feedback

City

8. Which tool is primarily used for data analysis in Excel?

Histogram Chart

Goal Seek

Pivot Table

Solver

9. Which programming language is most commonly associated with data analysis?

Java

C++

PHP

Python

10. Which library in Python is used for data manipulation and analysis?

Matplotlib

Pandas

NumPy

TensorFlow

11. Which tool is commonly used for creating dashboards?

Visual Studio

Adobe Photoshop

Power BI

Notepad++

12. Which of the following tools is used for business intelligence reporting?

Microsoft Power BI

Canva

Jupyter Notebook

Google Sheets

13. In a histogram, what does the height of each bar represent?

Data frequency

Data type

Data relationship

Category name

14. What is the first step in any data analysis process?

Running statistical tests

Understanding the problem statement

Data visualization

Data cleaning

15. Which of the following is used for numerical computations in Python?

NumPy

Seaborn

Matplotlib

Pandas

16. Which library is used for creating plots in Python?

Seaborn

Matplotlib

Pandas

NumPy

17. What type of graph is best for showing trends over time?

Scatter plot

Bar graph

Line chart

Pie chart

18. Which of the following is an example of categorical data?

Customer satisfaction level (e.g., Satisfied, Neutral, Dissatisfied)

Annual income

Employee ID

Temperature in Celsius

19. Which chart is best for comparing multiple categories?

Bar chart

Histogram

Line chart

Scatter plot

Data Analyst Professional Certification