OLTP 3NF vsData Warehouse 3NF — Learn free

Self-check

Questions 1–10 of 10

1. What common assumption causes confusion between OLTP 3NF and data warehouse 3NF?
Question 1A. That 3NF cannot be used in a data warehouseB. That because both systems use Third Normal Form, they must be conceptually the sameC. That OLTP systems never use normalisationD. That data warehouses only use star schemasE. That 3NF removes all history
2. What is the primary objective of an OLTP 3NF system?
Question 2A. Historical preservationB. Analytical traceabilityC. Operational efficiency for high-volume, real-time transactionsD. Pre-aggregating KPIsE. Long-term trend analysis
3. In an OLTP 3NF system, what happens when a customer changes their address?
Question 3A. A new row is inserted and the old address is keptB. The old address is overwrittenC. The record is archived to a data warehouseD. The change is rejected until the end of the dayE. Both addresses are stored in the same column
4. Which philosophy is dominant in a 3NF data warehouse?
Question 4A. Update-in-placeB. Delete-and-reloadC. Insert-onlyD. Overwrite-on-changeE. Truncate-daily
5. Which question can a data warehouse answer that an OLTP system typically cannot?
Question 5A. What is the customer's current address?B. How many orders are open right now?C. What was the product price at the time of sale last year?D. Which payment was just processed?E. What is today's inventory count?
6. How does Slowly Changing Dimension (SCD) Type 2 differ from Type 1?
Question 6A. Type 1 introduces a new version of the record; Type 2 overwritesB. Type 1 allows overwriting; Type 2 introduces a new version of the record while preserving the old oneC. Type 1 deletes history; Type 2 deletes the current recordD. Type 1 applies only to facts; Type 2 only to dimensionsE. There is no difference; the terms are interchangeable
7. Does the Slowly Changing Dimension philosophy apply to 3NF data warehouses, or only to dimensional models?
Question 7A. Only to dimensional modelsB. Only to OLTP systemsC. It applies to 3NF warehouses too: changes are captured through controlled inserts rather than destructive updatesD. Only to data lakesE. It applies nowhere outside star schemas
8. Which of the following is characteristic of data warehouse 3NF rather than OLTP 3NF?
Question 8A. Rows are frequently updatedB. Data represents only the current truthC. Transaction speed is paramountD. Storage growth is expected and historical versions are preservedE. Storage efficiency is critical
9. What is the risk of designing a data warehouse like an OLTP system?
Question 9A. It can destroy historical intelligenceB. It can cripple transactional performanceC. It makes normalisation impossibleD. It doubles storage costsE. It prevents the use of SCD Type 1
10. According to the strategic insight on OLTP 3NF versus data warehouse 3NF, what is the true differentiator between the two?
Question 10A. The normalisation form usedB. The number of tablesC. The intent behind the designD. The database vendorE. The size of the data