DP-900Domain 2: Identify Considerations for Relational Data on AzureRelational Data on AzureeasySingle choice
Which SQL statement retrieves rows matching a condition without changing any data?
A.INSERT
INSERT adds rows — a write op.
B.SELECT ... WHERE
Read + filter = SELECT/WHERE. Correct.
C.UPDATE
UPDATE modifies rows.
D.DELETE
DELETE removes rows.
Why this answer
SELECT retrieves data; WHERE filters rows. INSERT/UPDATE/DELETE are DML write operations. DP-900 expects you to recognize basic SQL statement roles — SELECT, INSERT, UPDATE, DELETE, plus DDL like CREATE/ALTER/DROP.
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