Crucial Exams

Microsoft Azure Data Fundamentals DP-900 Practice Question

A development team stores customer orders in a single table that repeats each customer's name and email in every row. They plan to move customer details to a separate Customers table and reference it from the Orders table with a foreign key. Which benefit of normalization does this change provide most directly?

  • It improves query plan caching by forcing parameterized statements.

  • It encrypts sensitive customer data at rest without additional configuration.

  • It reduces data redundancy and prevents update anomalies.

  • It enables eventual consistency across geographically distributed replicas.

Microsoft Azure Data Fundamentals DP-900
Identify considerations for relational data on Azure
Your Score:
Settings & Objectives
Random Mixed
Questions are selected randomly from all chosen topics, with a preference for those you haven’t seen before. You may see several questions from the same objective or domain in a row.
Rotate by Objective
Questions cycle through each objective or domain in turn, helping you avoid long streaks of questions from the same area. You may see some repeat questions, but the distribution will be more balanced across topics.

Check or uncheck an objective to set which questions you will receive.

Wipe Score
Bash, the Crucial Exams Chat Bot
AI Bot