DP-900Domain 2: Identify Considerations for Relational Data on AzureRelational Data on AzuremediumSingle choice
An analyst should query a predefined JOIN of customers and orders WITHOUT seeing the underlying query or table structure. Which database object provides this?
A.Index
Indexes speed lookups — they don't expose query results.
B.View
Saved query as a virtual table = view. Correct.
C.Stored procedure
Procedures run logic — they're not queryable result sets per se.
D.Trigger
Triggers fire on data changes — unrelated.
Why this answer
A view is a saved query exposed as a virtual table — abstracts complexity, restricts which columns/rows users see. Stored procedures EXECUTE logic; a view presents a reusable queryable result.
Correct answer: B · 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