Microsoft Certified: Azure Data Fundamentals Practice Exam 2025: Latest Questions

You are designing a data model for an order system. Each order can contain multiple products, and each product can appear in multiple orders. Which type of relationship is this?

A team needs a fully managed relational database on Azure for an application that uses T-SQL and requires automated backups and built-in high availability. Which service should you recommend?

A solution needs to store images, videos, and log files in a cost-effective way with HTTP-based access. Which Azure service is most appropriate?

A business wants interactive dashboards that allow users to filter and drill down into sales data. Which Azure service is designed for this purpose?

You need to ensure that when inserting a row into an Orders table, the CustomerId value must already exist in the Customers table. Which database concept enforces this rule?

A company needs a globally distributed NoSQL database that offers low-latency reads, automatic replication, and multiple APIs (such as SQL API). Which service should they choose?

You are designing a star schema for a sales analytics model. Which table type typically contains descriptive attributes such as ProductName and Category?

A data engineer needs to copy data from an on-premises SQL Server into Azure on a daily schedule and apply basic transformations during the load. Which Azure service is best suited for this orchestration task?

A relational database workload is experiencing slow performance when filtering on a non-key column that is frequently used in WHERE clauses. What is the most appropriate first step to improve query performance?

You need to ingest millions of telemetry events per second from IoT devices and then process the data in near real time for anomaly detection dashboards. Which combination best fits this requirement?

You are designing a data model for an order processing system. You need to ensure each order row always references a valid customer row. Which relational concept should you use?

A team wants to store application logs as JSON documents. The schema may change frequently, and the app requires fast reads by document ID and partitioning at scale. Which Azure data service is the best fit?

You need to identify a workload where the primary goal is to discover patterns and trends from large volumes of historical data rather than support day-to-day transactions. Which workload is this?

A retail company stores customer data in Azure SQL Database. Analysts report that a query filtering on LastName is slow. The table contains millions of rows. Which action is most likely to improve performance for this query?

You are building an IoT solution that ingests time-stamped sensor readings. The system must store large amounts of data cheaply and allow ad hoc analysis later using an analytics engine. Which design is most appropriate?

A company needs a fully managed relational database on Azure with minimal administration. The solution must support standard SQL and built-in high availability. Which service should you recommend?

You are modeling data for a relational database. One customer can place many orders, but each order belongs to exactly one customer. Which relationship type best describes this?

A solution stores data in Azure Cosmos DB. Some operations are failing with an error indicating the request rate is too large. What is the most likely cause?

You must choose a partition key for an Azure Cosmos DB container that stores customer orders. The primary query pattern is to retrieve orders for a single customer, and you need to minimize cross-partition queries. Which partition key is the best choice?

A data engineer designs an analytics solution with a star schema in a data warehouse. Users will run aggregations such as total sales by product category and month. Which statement best describes why a star schema is used for this scenario?

You need to store product images and PDF manuals for a web application. The files are unstructured and must be retrieved via URL. Which Azure data service is the best fit?

A retail company uses Azure SQL Database for sales transactions. They need to ensure that an order record and its related order line records are either all written successfully or none are written. What concept should they use?

You are designing an Azure Synapse Analytics dedicated SQL pool for reporting. Users will query large fact tables by date (for example, OrderDate) to retrieve recent data efficiently. Which design technique best improves query performance in this scenario?

A team wants to analyze clickstream events arriving continuously from a website and generate near real-time aggregates (for example, clicks per minute) for dashboards. Which Azure service is best suited for this streaming analytics workload?

You have an Azure SQL Database. A developer reports that query results for certain columns show "?" or incorrect characters when storing international text (for example, Japanese and Arabic). Which action should you recommend to best support multilingual text storage?