DP-900 Question 45

Community Discussion

Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.

• 1

  Answer- Yes – No – Yes Normalization reduces redundancy, so writes are usually more efficient Analytics systems usually use denormalized schemas (star/snowflake) Normalization splits data into more tables, so more joins are needed

• 1

  YES/NO/YES 1. YES - Normalizing a database increases the throughput of writing transactions: Yes Normalization involves organizing data to reduce redundancy. In a highly normalized database, a specific piece of data is stored in only one place. This means that when a write (insert, update, or delete) occurs, the database engine only needs to modify that single instance, making write operations faster and more efficient compared to a denormalized system where the same data might need to be updated in multiple places. 2. NO 3. YES

• 1

  Increasing throughput for writing transactions means improving the ability of the system to process more write operations (inserts, updates, deletes) per second! In fact, normalization can sometimes decrease throughput for writes because it often involves more complex operations! so the first one is NO