Login to manage your account

Please enter a valid email address.
Forgot Password?
Please enter a valid password.
OR

Don't have an account yet? Sign up

What is the risk of loading a warehouse directly from a production database during business hours?

  1. A The extract competes for resources with the application and can slow real users
  2. B The data becomes encrypted
  3. C The schema changes automatically
  4. 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.

All Data Warehousing MCQs

Login to manage your account

Please enter a valid email address.
Forgot Password?
Please enter a valid password.
OR

Don't have an account yet? Sign up as