Browse › Relational Databases on Azure

Improve Query Performance by Using an Index
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 configure an Azure SQL database to use an index to improve performance.
- Access a pre-existing Azure SQL database
- Run a query to stress test the database
- Configure an index to improve the performance of the query
- Run the stress test query again
- Verify that the performance improved
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.
- ⏱ About 30 minutes
- Counts towards: Administering Relational Databases on Microsoft Azure (exam DP-300)