A data analyst at a retail company is asked to identify which product categories have the highest sales growth over the last quarter. The analyst has access to a data warehouse with sales transactions. Which technique should the analyst use first?

Ask the data engineer to build a new pipeline to ingest more data.

Write a SQL query to aggregate sales by category and compare current quarter to previous quarter.

Create a machine learning model to predict future sales.

Review the database backup logs to ensure data is available.

Which of the following tasks is a primary responsibility of a database administrator (DBA)?

Installing and configuring database software

Creating marketing campaigns for a product launch

Designing the user interface for a web application

Writing business requirements for a new product

Which of the following is a method used by database administrators to enforce database security?

Increasing the database server's CPU

Changing the database's default port

Encrypting data at rest and in transit

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

Creating user interface wireframes

Designing the company's marketing strategy

Microsoft Certified:Azure Data Fundamentals

Domain 1Objective 4

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

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 21–25

21application · easy
A data analyst at a retail company is asked to identify which product categories have the highest sales growth over the last quarter. The analyst has access to a data warehouse with sales transactions. Which technique should the analyst use first?
Select an answer first
22foundation · easy
Which of the following tasks is a primary responsibility of a database administrator (DBA)?
Select an answer first
23foundation · easy
Which technique is commonly used by data analysts to summarize and describe data?
Select an answer first
24foundation · easy
Which of the following is a method used by database administrators to enforce database security?
Select an answer first
25foundation · easy
Which of the following tasks is typically performed by 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.