DP-900Domain 2: Identify Considerations for Relational Data on AzureRelational Data on AzuremediumSingle choice
Queries filtering on customer region are slow on a 200M-row table. Which database object most directly improves read performance on that filter?
A.An index on the region column
Filter acceleration = index. Correct.
B.A view
Views are saved queries — no inherent speedup.
C.A stored procedure
Procs encapsulate logic — not access paths.
D.A foreign key
FKs enforce referential integrity.
Why this answer
Indexes speed lookups/filters at the cost of write overhead and storage. Views are saved queries (convenience/security); stored procedures encapsulate logic; foreign keys enforce integrity — none primarily accelerate reads.
Correct answer: A · Last reviewed 2026-11-05
Official AWS references
Practice this interactively
Answer without seeing the solution first in the Relational Data on Azure practice session.
Practice Relational Data on Azure