A data analyst at a university needs to create a dashboard showing student enrollment trends by department over the past five years. The data is stored in a SQL database. Which steps should the analyst take?

Ask the data engineer to create a new data pipeline to ingest the data.

Configure a backup policy for the SQL database.

Use Azure Data Factory to transform the data and then store it in Blob Storage.

Write a SQL query to aggregate enrollment by department and year, then build a Power BI dashboard with a line chart.

A company runs a critical application on an Azure SQL Database. The recovery point objective (RPO) is 15 minutes and the recovery time objective (RTO) is 1 hour. The database administrator must ensure that if the primary region fails, the database can be failed over automatically with minimal data loss. What should the DBA configure?

A read-only replica in the same region using a load balancer.

Long-term backup retention with a weekly full backup.

A failover group with automatic failover policy and active geo-replication.

Automated backups with geo-restore enabled.

A data analyst has completed an analysis of customer churn and found that customers who contact support more than three times in a month are 50% more likely to cancel. What should the analyst do to generate a business insight?

Send the raw data to the database administrator for backup.

Ask the data engineer to build a pipeline to collect more customer data.

Store the analysis results in a data lake for future use.

Create a Power BI report that highlights this pattern and recommend a proactive outreach program for high-contact customers.

A company is migrating its on-premises SQL Server databases to Azure SQL Managed Instance. The DBA must minimize downtime during migration and ensure that after migration, the database is automatically backed up and performance is monitored. Which plan should the DBA follow?

Replicate the database using log shipping, then manually monitor performance with custom scripts.

Use Azure Data Factory to copy data, then disable automatic backups to save costs.

Use Azure Database Migration Service with online migration mode, then configure automated backups and set up performance monitoring alerts.

Perform a full backup and restore to the managed instance, then manually create a backup schedule.

What is a primary responsibility of a data engineer?

Creating visual dashboards for executives

Conducting user interviews for product design

Building and maintaining data pipelines

Writing marketing copy for a product

Microsoft Certified:Azure Data Fundamentals

Domain 1Objective 4

Identify Roles and Responsibilities for Data Workloads DP-900 Practice Questions (Page 1)

Part of the Describe core data concepts domain, which accounts for 25–30% of the DP-900 exam. Microsoft does not publish an official question count, but from its 45-minute exam (~20–30 total, ~5–9 in this domain), expect 1–2 from this objective — we provide 52 practice questions to prepare you well beyond it. (estimate)

52questions here

11free pages

10concepts

25–30%of the exam

Questions 1–5

1application · easy
A data analyst at a university needs to create a dashboard showing student enrollment trends by department over the past five years. The data is stored in a SQL database. Which steps should the analyst take?
Select an answer first
2application · medium
A company runs a critical application on an Azure SQL Database. The recovery point objective (RPO) is 15 minutes and the recovery time objective (RTO) is 1 hour. The database administrator must ensure that if the primary region fails, the database can be failed over automatically with minimal data loss. What should the DBA configure?
Select an answer first
3application · easy
A data analyst has completed an analysis of customer churn and found that customers who contact support more than three times in a month are 50% more likely to cancel. What should the analyst do to generate a business insight?
Select an answer first
4expert · hard
A company is migrating its on-premises SQL Server databases to Azure SQL Managed Instance. The DBA must minimize downtime during migration and ensure that after migration, the database is automatically backed up and performance is monitored. Which plan should the DBA follow?
Select an answer first
5foundation · easy
What is a primary responsibility of a data engineer?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to DP-900

Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by Microsoft. “DP-900” is a trademark of its owner, used for identification only.