Prepare a backup and recovery plan

As the data warehouse administrator, prepare a backup and recovery plan. Indicate the backup methods and schedules. Explore the recovery options.

Describe the scope of the backup function.

How will you ensure the readiness to recover from disasters?

1. List the types of statistics collected for monitoring the functioning of the data warehouse.

2. Describe any six different types of action for growth planning prompted by the statistics collected.

3. How do the statistics help in fine-tuning the data warehouse?

Solution: