DP-900: Relational Data on Azure
Relational Data on Azure is one of the skill areas tested on the Azure Data Fundamentals (DP-900) exam. Below are free DP-900 practice questions with worked answers and a concept diagram — each with a plain-language explanation. Practice the first 10 questions of DP-900 free, no signup.
The concept, in one picture
3 free DP-900 Relational Data on Azure questions
For each statement about database normalization, choose Yes if it is correct, or No if it is not.
- Normalization removes all relationships between the tables in a database.No
- Applying normalization to a database lowers the amount of duplicated data.Yes
- Normalization enhances the integrity of the data.Yes
Normalization reduces duplicated data and strengthens data integrity. It does not remove relationships between tables; relationships are maintained through keys.
Choose the option that correctly completes the sentence. [answer choice] is a table object that physically orders and stores the table's data rows according to their key values.
- ✓ A clustered index
- A FileTable
- A foreign key
- A stored procedure
A clustered index physically orders and stores a table's rows by the index key values, which is why a table can have only one clustered index.
Choose the option that correctly completes the sentence. A relational database is a good fit for workloads that have a high volume of [answer choice].
- frequent changes to the relationships between entities
- writes spread across different geographic locations
- ✓ transactional writes
- writes whose data structure keeps changing
Relational databases favor consistency and support ACID transactions, making them appropriate for a high volume of transactional writes.
Practice DP-900 free
The first 10 questions of every exam are free. No signup, no email wall.
Start practicing →Get a free DP-900 study plan by email
A short plan to work through DP-900 by skill area, plus a note when we add new questions. Optional — the practice above stays free. No spam, unsubscribe anytime.