StationX
Start free

Browse › Relational Databases on Azure

Can You Optimize Query Performance?

Advanced

Part of Relational Databases on Azure Topic: Azure

Access

StationX Infrastructure Labs — 3 attempts per lab

🔒 Add StationX Infrastructure Labs — $149 / year · 3 attempts per lab

Already have access? Sign in.

New to this? Try a free practice lab — a scripted hacking challenge in your browser, no account needed.

What you'll do

In this challenge, you will optimize query performance in an Azure SQL database.

  1. Create an Azure virtual machine that hosts SQL Server
  2. Create an Azure SQL database
  3. Verify the Query Store configuration on the Azure SQL database
  4. Generate some test data in the Azure SQL database
  5. Add an index for query performance, and then use Query Performance Insight to analyze query performance

Note: Once you begin the challenge, you will not be able to pause, save, or exit and then return to your challenge. Please ensure that you have set aside enough time to complete the challenge before you start.