Azure Data Fundamentals (DP-900) · 23% practice allocation

Azure DP-900: Identify considerations for relational data on Azure Practice Questions

5 free sample questions from the Identify considerations for relational data on Azure domain, with answers and explanations. The full DP-900 bank has 62 questions across 4 domains. Questions are scenario-based and written from the official Azure exam guide.

Which characteristics define RELATIONAL data? (Select 2)

A. Data is organized into tables of rows and columns with a defined schema✓ Correct
B. Data can only be stored as free-form text documents
C. Each record may have a completely arbitrary structure
D. Relationships between entities are expressed through primary and foreign keys✓ Correct
E. Tables cannot reference other tables

Explanation

Relational data means schema-defined tables (A) linked by key relationships (D) — that pairing is the model's essence. Option C describes schemaless NoSQL flexibility. Option B describes unstructured document storage. Option E is the exact opposite of what makes the model 'relational'.

Which database object stores a predefined SQL query that presents data as a virtual table, without physically duplicating the underlying rows?

A. A stored procedure
B. A view✓ Correct
C. An index
D. A primary key

Explanation

A view is a saved query exposed as a virtual table — querying the view runs the underlying SELECT against the base tables. A stored procedure (A) is executable logic that may take parameters and perform actions, not a virtual table. An index (C) is a lookup structure for speeding searches. A primary key (D) uniquely identifies rows.

A company must lift-and-shift an application whose database uses SQL Agent jobs, cross-database queries, and other instance-level features — but wants to stop patching operating systems. Which Azure option is the BEST fit?

A. Azure SQL Managed Instance✓ Correct
B. Azure SQL Database elastic pool
C. SQL Server on an Azure VM
D. Azure Table Storage

Explanation

Managed Instance provides near-full SQL Server instance compatibility (Agent, cross-database queries) as PaaS — no OS to manage. Elastic pools (B) share resources among single databases but still lack those instance features. SQL on a VM (C) has full compatibility but brings back OS patching. Table Storage (D) isn't relational at all.

Which Azure SQL family option is a fully managed PaaS offering a single database with its own resources, ideal for a new cloud-native application that doesn't need instance-level features?

A. Azure SQL Database✓ Correct
B. SQL Server Express on a laptop
C. Azure SQL Managed Instance
D. SQL Server on an Azure virtual machine

Explanation

Azure SQL Database is the PaaS single-database service — Microsoft manages the instance layer entirely; you get a database endpoint with elastic scale options, perfect for new cloud applications. SQL on a VM (D) is IaaS with full OS/instance management. Managed Instance (C) targets migrations needing instance-scoped features. Option B isn't an Azure service.

Which SQL statement category does SELECT belong to, and what does it do?

A. DDL — it defines a new table structure
B. TCL — it commits a transaction
C. DCL — it grants permissions to users
D. DML — it retrieves rows from one or more tables✓ Correct

Explanation

SELECT is Data Manipulation Language: it queries and retrieves data (alongside INSERT, UPDATE, DELETE which modify it). DDL (A) statements like CREATE/ALTER/DROP define structure; DCL (C) like GRANT/REVOKE manages permissions; TCL (B) like COMMIT/ROLLBACK controls transactions.

Test yourself across every DP-900 domain

The free DP-900 practice test mixes about 20 questions weighted like the exam. The full 62-question bank adds instant grading, flashcards and a timed mock exam.

Take the free DP-900 practice test Practice the full bank

Study this domain

Identify considerations for relational data on Azure study guide (DP-900) →

Other DP-900 domains

← All Azure Data Fundamentals study resources