Microsoft

DP-900 practice question 2

Microsoft Azure Data Fundamentals · free question 2 of 20

Question

For each of the following statements, select Yes if the statement is true. Otherwise, select No.

Explanation

Statement 1 (No): Normalization splits data into separate tables for each entity and links them with primary and foreign keys, so it creates relationships between tables rather than eliminating them. Statement 2 (Yes): Each fact is stored once in the table for its entity instead of being repeated across rows, which reduces duplicate data. Statement 3 (Yes): Because each value is stored in one place and related through keys, updates cannot leave inconsistent copies behind, which improves data integrity.

Practice the whole free set

Answer all 20 free DP-900 questions with instant feedback, or unlock all 322 questions with Learn and Exam modes.