What is the main purpose of normalization in a relational database?

To increase the number of tables in the database

To reduce data redundancy and improve data integrity

To encrypt sensitive data in the database

To make queries run faster by denormalizing data

What does the following SQL statement do? DELETE FROM Orders WHERE OrderID = 10;

It updates the OrderID to 10 for all orders

It adds a new order with OrderID 10

It selects the order with OrderID 10

It removes the order with OrderID 10 from the Orders table

In a relational database, what is the function of a foreign key?

To store default values for columns

To create an index for faster queries

To link a row in one table to a row in another table

To uniquely identify a row within its own table

A library database has a Books table with columns: BookID (identity), Title, AuthorID, PublishedYear. The library is adding a new book: 'The Azure Journey' by author 42, published in 2024. Which SQL statement correctly adds this book?

INSERT INTO Books (BookID, Title, AuthorID, PublishedYear) VALUES (NULL, 'The Azure Journey', 42, 2024);

INSERT INTO Books VALUES ('The Azure Journey', 42, 2024);

UPDATE Books SET Title = 'The Azure Journey', AuthorID = 42, PublishedYear = 2024;

INSERT INTO Books (Title, AuthorID, PublishedYear) VALUES ('The Azure Journey', 42, 2024);

A database administrator is tuning a database that has a large Orders table. The application frequently runs the following query: SELECT * FROM Orders WHERE OrderDate >= '2024-01-01' AND OrderDate < '2024-02-01'. The administrator creates an index on the OrderDate column. After creating the index, the query performance does not improve as expected. What is the most likely reason?

The index is automatically dropped after creation.

The index was created on the wrong column.

The query uses SELECT *, which may cause the database engine to perform a key lookup for each row, making the index less effective.

The index is not used because the query has a range condition.

Microsoft Certified:Azure Data Fundamentals

Domain 2Objective 1

Describe Relational Concepts DP-900 Practice Questions (Page 3)

Part of the Identify considerations for relational data on Azure domain, which accounts for 20–25% of the DP-900 exam. Microsoft does not publish an official question count, but from its 45-minute exam (~20–30 total, ~4–8 in this domain), expect 2–4 from this objective — we provide 43 practice questions to prepare you well beyond it. (estimate)

43questions here

9free pages

13concepts

20–25%of the exam

Questions 11–15

11foundation · easy
What is the main purpose of normalization in a relational database?
Select an answer first
12foundation · easy
What does the following SQL statement do? DELETE FROM Orders WHERE OrderID = 10;
Select an answer first
13foundation · easy
In a relational database, what is the function of a foreign key?
Select an answer first
14application · medium
A library database has a Books table with columns: BookID (identity), Title, AuthorID, PublishedYear. The library is adding a new book: 'The Azure Journey' by author 42, published in 2024. Which SQL statement correctly adds this book?
Select an answer first
15expert · hard
A database administrator is tuning a database that has a large Orders table. The application frequently runs the following query: SELECT * FROM Orders WHERE OrderDate >= '2024-01-01' AND OrderDate < '2024-02-01'. The administrator creates an index on the OrderDate column. After creating the index, the query performance does not improve as expected. What is the most likely reason?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to DP-900

Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by Microsoft. “DP-900” is a trademark of its owner, used for identification only.