What is the risk of loading a warehouse directly from a production database during business hours?
- A The extract competes for resources with the application and can slow real users
- B The data becomes encrypted
- C The schema changes automatically
- D Referential integrity is lost
Answer
The extract competes for resources with the application and can slow real users
Reading from a replica, or using CDC from transaction logs, avoids placing analytical load on the operational system.





