nerdexam
Microsoft

70-473 · Question #43

You have a Microsoft Azure SQL database that is used for reporting. You discover that some reports complete more quickly than other reports, even though the reports retrieve approximately the same amo

The correct answer is D. Azure SQL Database Index Advisor. To reduce the completion time for reports on an Azure SQL database where some reports are slower despite similar data, you should utilize automated tools specifically designed for optimizing database performance in Azure.

Monitor and manage an Azure data platform solution

Question

You have a Microsoft Azure SQL database that is used for reporting. You discover that some reports complete more quickly than other reports, even though the reports retrieve approximately the same amount of data and use queries that have the same table structure. You need to reduce the amount of time it takes to complete the reports. What should you use?

Options

  • AIndex Tuning Wizard
  • BDatabase Engine Tuning Advisor
  • CAzure Throughput Analyzer
  • DAzure SQL Database Index Advisor

How the community answered

(25 responses)
  • A
    4% (1)
  • B
    16% (4)
  • C
    8% (2)
  • D
    72% (18)

Why each option

To reduce the completion time for reports on an Azure SQL database where some reports are slower despite similar data, you should utilize automated tools specifically designed for optimizing database performance in Azure.

AIndex Tuning Wizard

The Index Tuning Wizard is an older, deprecated tool primarily for on-premises SQL Server and is not the current or recommended solution for optimizing an Azure SQL database.

BDatabase Engine Tuning Advisor

Database Engine Tuning Advisor is a tool for on-premises SQL Server to analyze workloads and recommend index and partitioning strategies, but it is not the primary or most appropriate automated tool for Azure SQL Database.

CAzure Throughput Analyzer

Azure Throughput Analyzer is not a standard Azure tool or service for optimizing SQL database query performance by recommending index changes.

DAzure SQL Database Index AdvisorCorrect

The Azure SQL Database Index Advisor (part of Azure SQL Database intelligent performance) actively monitors query workloads and recommends new indexes, or drops unused ones, to improve query performance based on historical usage patterns, directly addressing slow-running reports caused by missing or inefficient indexes. This automated advisor is specifically designed for Azure SQL Database to optimize performance by suggesting index changes, which directly impacts report execution times.

Concept tested: Azure SQL Database performance optimization - indexing

Source: https://learn.microsoft.com/azure/azure-sql/database/intelligent-tuning-how-to-manage?view=azuresql

Topics

#Azure SQL Database#performance tuning#index advisor#query optimization

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full 70-473 Practice