Practice Questions

Question 1

Which task is a primary responsibility of a data analyst?

A. Building data pipelines
B. Managing database security
C. Creating dashboards and reports
D. Configuring storage systems

✅ Answer: C

Explanation:
Data analysts focus on visualizing data and creating reports/dashboards.

Question 2

A company wants to understand sales trends over the past year using visual reports.

Which role is MOST appropriate?

A. Data Engineer
B. Database Administrator
C. Data Analyst
D. Network Engineer

✅ Answer: C

Explanation:
Data analysts analyze historical data and create insights through reports and dashboards.

Question 3

Which tool is most commonly used by data analysts in Azure environments?

A. Azure Data Factory
B. Azure DevOps
C. Power BI
D. Azure Kubernetes Service

✅ Answer: C

Explanation:
Power BI is the primary tool for data visualization and reporting.

Question 4

Which activity is MOST associated with a data analyst?

A. Designing ETL pipelines
B. Writing SQL queries to explore data
C. Managing server infrastructure
D. Encrypting databases

✅ Answer: B

Explanation:
Data analysts commonly use SQL to query and analyze data.

Question 5

What is the main goal of a data analyst?

A. Store large volumes of raw data
B. Build machine learning models
C. Turn data into actionable insights
D. Manage database performance

✅ Answer: C

Explanation:
Data analysts focus on interpreting data and generating insights for decision-making.

Question 6

Which task is LEAST likely to be performed by a data analyst?

A. Creating a sales dashboard
B. Identifying trends in data
C. Building data ingestion pipelines
D. Summarizing business performance

✅ Answer: C

Explanation:
Building pipelines is a data engineer responsibility, not an analyst task.

Question 7

A data analyst receives cleaned and structured data from a data warehouse. What is their PRIMARY focus?

A. Data ingestion
B. Data transformation
C. Data visualization and analysis
D. Database administration

✅ Answer: C

Explanation:
Analysts work with prepared data to analyze and visualize insights.

Question 8

Which statement best describes the role of a data analyst?

A. They design physical database servers
B. They create and maintain ETL pipelines
C. They analyze data to support business decisions
D. They manage user permissions in databases

✅ Answer: C

Explanation:
Data analysts focus on interpreting data and supporting decision-making.

Question 9

Which Azure service is MOST directly associated with data analyst reporting?

A. Azure Data Lake Storage
B. Azure Synapse Analytics (SQL querying)
C. Azure Virtual Machines
D. Azure Key Vault

✅ Answer: B

Explanation:
Data analysts often query and analyze data using Azure Synapse Analytics.

Question 10

Which activity involves communicating insights from data to business stakeholders?

A. Data encryption
B. Data visualization and reporting
C. Database replication
D. Network configuration

✅ Answer: B

Explanation:
Data analysts communicate findings through visualizations, dashboards, and reports.

✅ Key Exam Takeaways

For DP-900, remember:

✔ Data analysts focus on analysis, visualization, and reporting
✔ They work with cleaned, structured data
✔ They commonly use Power BI and SQL
✔ Their goal is to support business decision-making
✔ They do NOT typically build pipelines or manage databases

Go to the DP-900 Exam Prep Hub main page.