Microsoft Certified: Azure Data Fundamentals Intermediate Practice Exam: Medium Difficulty 2025

A retail company wants to analyze daily sales by store and product category. Executives want consistent definitions for metrics like "net sales" and "gross margin" across all reports and dashboards. Which concept best addresses this requirement?

A healthcare provider collects patient data from multiple systems. They need to ensure each patient has a single, authoritative record and that downstream analytics uses the most accurate version. Which data concept is MOST relevant?

A team is designing a relational database for an order-processing system in Azure. They need automatic backups, point-in-time restore, and minimal administrative overhead. Which Azure service is the best fit?

A database contains tables for Customers, Orders, and Products. Reporting users frequently query total revenue by product category and month, and performance is becoming an issue. Which approach is MOST appropriate in a relational design to improve read performance for this analytics-style query pattern?

A SaaS provider has a multi-tenant application using Azure SQL Database. The primary database is reaching its resource limits. They want to distribute databases across multiple servers while still managing them as a group and enabling elastic scaling. What should they use?

An IoT solution receives device telemetry as JSON with occasional new fields added by firmware updates. The team wants a database that can ingest at high scale with low latency and does not require predefined schema updates for new properties. Which Azure data store is the best fit?

A company needs to store millions of image files and related metadata. The images must be stored cost-effectively, and the metadata should support flexible querying (for example, different tags per image). Which combination is MOST appropriate?

A social networking app wants to recommend "people you may know" by finding friends-of-friends and common connections. Which type of non-relational data store is MOST appropriate on Azure?

A logistics company needs near real-time dashboards showing the current location and status of deliveries. Data arrives continuously from trucks and must be processed as it streams in, with results available for reporting within seconds. Which Azure service is BEST suited for the streaming analytics portion of this workload?

A company wants to build an enterprise analytics platform. They need to store raw files (CSV/JSON), curated datasets, and also provide an MPP data warehouse for high-performance SQL analytics. Which solution best matches these requirements?