AZ-204 Timed Practice Test 1 — 10 Questions

Question 1

An app must store relational state and perform transactions across multiple tables with T-SQL support. Which Azure data service should the developer choose?

Accepted Answer

Azure SQL Database. Azure SQL Database is a fully managed relational database service that supports T-SQL and ACID transactions across multiple tables, making it the correct choice for storing relational state and performing transactional operations. It provides built-in high availability, automatic backups, and elastic scaling, which are essential for enterprise applications requiring consistent, multi-table transactions.

Answer

Azure Queue Storage

Answer

Azure Cache for Redis

Answer

Azure Blob Storage

Question 2

You are monitoring an Azure App Service using Application Insights. You notice that the server response time is high for certain requests. You need to drill down to see which external dependencies (like databases or APIs) are causing the delay. Which Application Insights feature should you use?

Accepted Answer

Profiler. Profiler (C) is correct because it provides a detailed, code-level view of request processing, including the time spent on each external dependency call (e.g., SQL queries, HTTP calls to APIs). It captures execution traces that break down the total server response time into individual dependency durations, allowing you to pinpoint which external service is causing the delay.

Answer

Live Metrics

Answer

Application Map

Answer

Snapshot Debugger

Question 3

Which TWO services can be used to implement a publish-subscribe messaging pattern in Azure?

Accepted Answer

Azure Service Bus Topics. Azure Service Bus Topics and Azure Event Grid both support publish-subscribe. Option B is wrong because Storage Queues use point-to-point. Option D is wrong because Event Hubs is for event ingestion, not pub-sub. Option E is wrong because Azure Queue Storage is point-to-point.

Answer

Azure Storage Queues

Answer

Azure Event Hubs

Answer

Azure Queue Storage

Question 4

You need to monitor the CPU utilization of an Azure VM in real-time and set up an alert when it exceeds 90%. Which Azure Monitor feature should you use?

Accepted Answer

Metrics Explorer. Metrics Explorer is the correct Azure Monitor feature for real-time monitoring of CPU utilization on an Azure VM because it provides near real-time metric collection (typically every 1 minute) and supports alerting based on threshold conditions. It allows you to chart performance counters like Percentage CPU and configure metric alerts that trigger when the value exceeds 90%.

Answer

Log Analytics Workspace

Answer

Application Insights

Answer

Azure Monitor for VMs

Question 5

You are monitoring an Azure web application with Application Insights. You notice a sudden increase in the number of failed requests. You want to be notified automatically when such anomalies occur, without manually setting static thresholds. Which Application Insights feature should you use?

Accepted Answer

Enable Smart Detection for failure anomalies.. Smart Detection for failure anomalies in Application Insights uses machine learning to automatically detect unusual patterns in failed request rates without requiring manual threshold configuration. This feature is specifically designed to notify you of anomalies based on historical behavior, making it the correct choice for the scenario described.

Answer

Create a metric alert on the 'failed requests' metric with a static threshold.

Answer

Use Log Analytics to run a query every 5 minutes and trigger an action.

Answer

Create an availability test that periodically pings the application.

Question 6

You are monitoring an Azure web app using Application Insights. You need to create a query that returns the average duration of requests for each HTTP method (GET, POST, etc.) over the last hour, sorted by duration. Which Kusto query should you use?

Accepted Answer

requests | where timestamp > ago(1h) | summarize avg(duration) by method | order by avg_duration desc. Option C is correct because it first filters requests to only those from the last hour using `where timestamp > ago(1h)`, then calculates the average duration grouped by HTTP method with `summarize avg(duration) by method`, and finally orders the results by the computed average duration in descending order using `order by avg_duration desc`. This matches the requirement exactly: last hour, average duration per method, sorted by duration.

Answer

requests | summarize avg(duration) by method | order by avg_duration desc

Answer

requests | summarize avg(duration) by method | sort by method asc

Answer

requests | where timestamp > ago(1h) | summarize avg(duration) by method | sort by method

Question 7

An Azure web app is experiencing high memory usage. You want to collect memory dumps periodically to analyze the issue without restarting the app. Which Azure App Service diagnostic feature should you use?

Accepted Answer

Application Snapshot Debugger. The Application Snapshot Debugger is the correct feature because it captures memory dumps (snapshots) of a production web app at the point of an exception or high memory usage without restarting the app. It is specifically designed for debugging memory leaks and high CPU/memory issues in Azure App Service, providing a periodic snapshot of the process heap.

Answer

Application Insights Profiler

Answer

Diagnostic Settings

Answer

Auto-healing

Question 8

An Azure App Service application has availability failures. The developer needs distributed tracing across requests and dependencies. What should be enabled?

Accepted Answer

Application Insights with dependency tracking. Application Insights with dependency tracking is the correct choice because it provides distributed tracing across requests and dependencies in an Azure App Service application. It automatically collects telemetry data, including end-to-end transaction details, and maps dependencies like SQL databases, HTTP calls, and Azure services, enabling developers to diagnose availability failures by correlating traces across components.

Answer

Storage account static website logs

Answer

Azure Policy compliance scan

Answer

Cost Management budgets only

Question 9

A Cosmos DB container for session records receives hot-partition throttling because the partition key has only five possible values. What should the developer change?

Accepted Answer

Choose a partition key with higher cardinality and even request distribution. Option C is correct because a partition key with only five values leads to hot partitions, where one or a few partitions handle the majority of requests, causing throttling. By choosing a partition key with higher cardinality (many distinct values) and even request distribution, the load is spread evenly across physical partitions, eliminating hot spots and throttling.

Answer

Increase the default TTL

Answer

Enable analytical store only

Answer

Use a stored procedure for every write

Question 10

An Azure App Service application has memory pressure. The developer needs distributed tracing across requests and dependencies. What should be enabled?

Accepted Answer

Application Insights with dependency tracking. Application Insights with dependency tracking enables distributed tracing by automatically collecting telemetry across HTTP requests, database calls, and external service dependencies. This allows developers to correlate end-to-end transactions and identify the root cause of memory pressure, such as a specific dependency causing excessive resource consumption.

Answer

Azure Policy compliance scan

Answer

Cost Management budgets only

Answer

Storage account static website logs