A data analyst has completed an analysis of sales data and found that sales peak during the holiday season. The analyst needs to present this insight to executives in a way that clearly shows the seasonal pattern and supports decision-making for inventory planning. Which approach should the analyst take?

Use a pie chart to show the proportion of sales by product category.

Create a line chart showing monthly sales over time and highlight the holiday peaks.

Send a detailed email with the analysis methodology.

Provide a table of raw sales data for each month.

A data analyst is analyzing customer feedback text to determine overall sentiment. The analyst has a dataset of customer reviews and needs to classify each review as positive, negative, or neutral. The analyst wants to use a built-in Azure service that requires minimal coding. Which service should the analyst use?

Azure Cognitive Service for Language (Text Analytics)

A database administrator needs to grant a group of application users read-only access to specific tables in a database, while preventing them from modifying data. The administrator also wants to ensure that the users cannot see other tables in the database. What should the administrator do?

Create a database role, grant SELECT on the specific tables to the role, and add the users to the role.

Grant the users db_datareader role.

Grant the users CONTROL permission on the database.

What is the purpose of a database backup?

To protect against data loss by creating a copy of the data

Microsoft Certified:Azure Data Fundamentals

Domain 1Objective 4

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

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 46–50

46application · medium
A data analyst has completed an analysis of sales data and found that sales peak during the holiday season. The analyst needs to present this insight to executives in a way that clearly shows the seasonal pattern and supports decision-making for inventory planning. Which approach should the analyst take?
Select an answer first
47expert · hard
A data analyst is analyzing customer feedback text to determine overall sentiment. The analyst has a dataset of customer reviews and needs to classify each review as positive, negative, or neutral. The analyst wants to use a built-in Azure service that requires minimal coding. Which service should the analyst use?
Select an answer first
48application · medium
A database administrator needs to grant a group of application users read-only access to specific tables in a database, while preventing them from modifying data. The administrator also wants to ensure that the users cannot see other tables in the database. What should the administrator do?
Select an answer first
49foundation · easy
What is the purpose of a database backup?
Select an answer first
50application · medium
A data engineer is designing a storage solution for a new IoT analytics project. The solution must store high-volume, time-series sensor data and support queries that aggregate data by minute. Which storage option should the data engineer choose?
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.

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

Questions 46–50

A database administrator needs to grant a group of application users read-only access to specific tables in a database, while preventing them from modifying data. The administrator also wants to ensure that the users cannot see other tables in the database. What should the administrator do?

What is the purpose of a database backup?

A data engineer is designing a storage solution for a new IoT analytics project. The solution must store high-volume, time-series sensor data and support queries that aggregate data by minute. Which storage option should the data engineer choose?

Keep studying — Describe core data concepts