Azure Data Fundamentals · 23% of the exam

Identify considerations for relational data on Azure: free practice questions

5 sample questions from our 15-question bank for this domain — answers and explanations included. These are the same scenario-based style as the real Azure exam.

1. An e-commerce schema stores the product name and price in the products table only; order lines reference products by ID. A price change is made in exactly one place. Which benefit of normalization does this demonstrate?

  • A. Elimination of update anomalies caused by duplicated data✓ Correct
  • B. Faster full-table scans
  • C. Automatic encryption of prices
  • D. Support for unstructured media files
Explanation

Because the price exists once, updating it can't leave stale copies scattered through order records — the update anomaly normalization exists to prevent. Normalization doesn't speed full scans (B); if anything joins add work. Options C and D have nothing to do with schema normalization.

2. Which Azure services provide fully managed hosting for OPEN-SOURCE relational database engines?

  • A. Azure Database for PostgreSQL and Azure Database for MySQL✓ Correct
  • B. Azure Cosmos DB for NoSQL and Azure Table Storage
  • C. Azure Blob Storage and Azure Files
  • D. Azure SQL Managed Instance only
Explanation

Azure offers managed PaaS versions of the popular open-source relational engines: PostgreSQL, MySQL (and MariaDB). Cosmos DB and Table Storage (B) are NoSQL. Blob and Files (C) are storage services, not databases. SQL Managed Instance (D) hosts Microsoft SQL Server, which is not open-source.

3. In a relational database, customer orders reference the customer who placed them. Which mechanism creates and enforces this relationship?

  • A. A foreign key in the orders table referencing the customers table's primary key✓ Correct
  • B. Storing the full customer record inside every order row
  • C. A shared file system folder
  • D. Naming both tables with the same prefix
Explanation

Relational integrity comes from keys: each customer row is uniquely identified by a primary key, and the orders table stores that value as a foreign key, which the engine can enforce. Option B duplicates data — exactly what normalization eliminates. Options C and D are organizational conventions with no enforcement whatsoever.

4. Which characteristics define RELATIONAL data? (Select 2)

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

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

5. Which pair correctly distinguishes DDL from DML?

  • A. DDL defines or changes structure (CREATE, ALTER, DROP); DML reads and changes data (SELECT, INSERT, UPDATE, DELETE)✓ Correct
  • B. DDL deletes data; DML defines tables
  • C. DDL is used only in NoSQL databases; DML only in relational ones
  • D. DDL and DML are interchangeable terms
Explanation

Data Definition Language manipulates the schema — tables, views, indexes — while Data Manipulation Language works with the rows inside them. Option B swaps the definitions. Option C invents a NoSQL/relational split that doesn't exist. Option D is false — the distinction is fundamental SQL vocabulary the exam expects.

10 more questions in this domain

Practice the full bank with instant grading, flashcards, and a timed mock exam.

Start practicing free
Identify considerations for relational data on Azure — Free Azure Data Fundamentals Practice Questions | DataCertPrep — Certification Prep