What is a primary responsibility of a data analyst?

Writing application code for a mobile app

Building and maintaining data pipelines

Creating visualizations and reports to communicate insights

Installing and configuring database servers

What is a key responsibility of a data engineer regarding data storage?

Designing and implementing data storage solutions

Conducting user training sessions

Creating marketing reports from stored data

Setting up employee workstations

Which of the following tasks is typically performed by a data analyst?

Developing data ingestion connectors

Cleaning and preparing data for analysis

Designing the physical schema of a database

An e-commerce company has a data pipeline that ingests clickstream data from a website into Azure Data Lake Storage. The data engineer needs to ensure that the pipeline runs every hour and that any failures are retried automatically. Which tool should the data engineer use to orchestrate this pipeline?

Azure Synapse Analytics serverless SQL pool

Azure Blob Storage lifecycle management

Which activity is considered part of routine database maintenance?

Applying software patches and updates

Conducting employee performance reviews

Microsoft Certified:Azure Data Fundamentals

Domain 1Objective 4

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

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 26–30

26foundation · easy
What is a primary responsibility of a data analyst?
Select an answer first
27foundation · easy
What is a key responsibility of a data engineer regarding data storage?
Select an answer first
28foundation · easy
Which of the following tasks is typically performed by a data analyst?
Select an answer first
29application · medium
An e-commerce company has a data pipeline that ingests clickstream data from a website into Azure Data Lake Storage. The data engineer needs to ensure that the pipeline runs every hour and that any failures are retried automatically. Which tool should the data engineer use to orchestrate this pipeline?
Select an answer first
30foundation · easy
Which activity is considered part of routine database maintenance?
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.