Microsoft Certified:Azure Data Fundamentals
Domain 1Objective 4
Identify Roles and Responsibilities for Data Workloads DP-900 Practice Questions (Page 9)
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 41–45
- 41
A data engineering team is building a pipeline to ingest streaming data from IoT devices and batch data from a data lake. The pipeline must process streaming data in near real-time and also run daily batch jobs to aggregate historical data. The team wants to minimize operational overhead and use a single platform for both streaming and batch processing. Which Azure service should they choose?
Select an answer first - 42
What is a key responsibility of a database administrator in the area of security?
Select an answer first - 43
A data analyst at a marketing company needs to create a weekly report that shows sales trends by region and product category. The report will be viewed by non-technical stakeholders who need to filter and drill down into the data. Which tool should the analyst use to build this interactive report?
Select an answer first - 44
A database administrator is responsible for an Azure SQL Database that supports a mission-critical application. The database is currently in the General Purpose service tier. The application experiences occasional spikes in read-heavy workloads, and the DBA needs to improve read performance without changing the application. The DBA also needs to ensure that the database remains available during planned maintenance. Which action should the DBA take?
Select an answer first - 45
A data analyst has created a Power BI report that shows sales by region. The report is published to a Power BI workspace. The analyst needs to share the report with external stakeholders who do not have Power BI licenses. The stakeholders need to view the report in a web browser without signing in. What should the analyst do?
Select an answer first
Finished these 5 questions?
Review the revealed explanations, or continue through the curriculum.
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.