Microsoft Azure Data Fundamentals DP-900 Practice Question
You are reviewing objects in an Azure SQL Database. Which database object is primarily used to pre-compute and persist an ordered data structure that the query optimizer can use to accelerate data retrieval, without storing duplicate copies of the table's rows?
An index stores key values and row pointers in an ordered structure that the query optimizer can quickly search, reducing the I/O needed to locate requested rows. Views are virtual tables that hold no persisted structure, triggers run automatically in response to data-modification events, and stored procedures are reusable batches of T-SQL code. None of these alternatives provide the persisted, searchable ordering that an index supplies, so they do not speed data access in the same way.
Ask Bash
Bash is our AI bot, trained to help you pass your exam. AI Generated Content may display inaccurate information, always double-check anything important.
What is the purpose of an index in a database?
Open an interactive chat with Bash
How does an index differ from a view in Azure SQL Database?
Open an interactive chat with Bash
What types of indexes exist in Azure SQL Database?
Open an interactive chat with Bash
Microsoft Azure Data Fundamentals DP-900
Identify considerations for relational data on Azure
Your Score:
Report Issue
Bash, the Crucial Exams Chat Bot
AI Bot
Loading...
Loading...
Loading...
Pass with Confidence.
IT & Cybersecurity Package
You have hit the limits of our free tier, become a Premium Member today for unlimited access.
Military, Healthcare worker, Gov. employee or Teacher? See if you qualify for a Community Discount.
Monthly
$19.99
$19.99/mo
Billed monthly, Cancel any time.
3 Month Pass
$44.99
$14.99/mo
One time purchase of $44.99, Does not auto-renew.
MOST POPULAR
Annual Pass
$119.99
$9.99/mo
One time purchase of $119.99, Does not auto-renew.
BEST DEAL
Lifetime Pass
$189.99
One time purchase, Good for life.
What You Get
All IT & Cybersecurity Package plans include the following perks and exams .