What is the primary role of a primary key in a relational database table?

To uniquely identify each row in the table

To establish a relationship with another table

To speed up query performance on large tables

To store large amounts of unstructured data

What is the primary purpose of an index in a relational database?

To improve the speed of data retrieval operations

To enforce data integrity constraints

A database designer is normalizing a table that stores employee assignments. The table has columns: AssignmentID (primary key), EmployeeID, EmployeeName, DepartmentID, DepartmentName, ProjectID, ProjectName. Each employee belongs to one department, and each project has one name. The designer wants to achieve Third Normal Form (3NF). Which change is required?

Add a composite primary key of AssignmentID and EmployeeID.

Remove EmployeeID and DepartmentID from the table.

Remove DepartmentName and ProjectName into separate Department and Project tables.

Combine DepartmentName and ProjectName into a single column.

Microsoft Certified:Azure Data Fundamentals

Domain 2Objective 1

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

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 6–10

6foundation · easy
What is the primary role of a primary key in a relational database table?
Select an answer first
7foundation · easy
Which normal form requires that every non-key attribute is fully functionally dependent on the primary key?
Select an answer first
8foundation · easy
What is the primary purpose of an index in a relational database?
Select an answer first
9application · hard
A database designer is normalizing a table that stores employee assignments. The table has columns: AssignmentID (primary key), EmployeeID, EmployeeName, DepartmentID, DepartmentName, ProjectID, ProjectName. Each employee belongs to one department, and each project has one name. The designer wants to achieve Third Normal Form (3NF). Which change is required?
Select an answer first
10foundation · easy
Which SQL statement is used to remove rows from a table?
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.

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

Questions 6–10

What is the primary role of a primary key in a relational database table?

Which normal form requires that every non-key attribute is fully functionally dependent on the primary key?

What is the primary purpose of an index in a relational database?

Which SQL statement is used to remove rows from a table?

Keep studying — Identify considerations for relational data on Azure