Q. It is a good practice to load the fact tables before loading the dimension tables.

View solution

Q. Always checkpoint the load jobs.

View solution

Q. Passwords must be cryptic and arbitrary.

View solution

Q. Backing up the data warehouse is not necessary under any conditions because you can recover data from the source systems.

View solution

Q. A pilot data mart is necessary when the users are already very familiar with data warehousing.

View solution

Q. Remote deployment of desktop tools is usually faster.

View solution

Q. The key of the fact table is independent of the keys of the dimension tables.

View solution

Q. It is a good practice to drop the indexes before the initial load.

View solution

Q. What is an important step in the recovery process for a data warehouse?

View solution

Q. What is a consideration when estimating average downtime for recovery in a data warehouse?

View solution

Q. In a practical backup schedule for a data warehouse, what factors may influence the frequency of backups for active and static data?

View solution

Q. In the data warehouse environment, why might the night slots, typically used for backups in OLTP systems, be challenging for scheduling backups?

View solution

Q. What is a significant factor that influences decisions about backup and recovery for a data warehouse?

View solution

Q. In addition to full backups, what other types of backups are recommended for a data warehouse?

View solution

Q. What is a key consideration when choosing the medium for backing up a data warehouse?

View solution

Q. In a data warehouse, what is the purpose of separating the current from the historical data in the backup strategy?

View solution

Q. What is a crucial factor that plays a key role in backup and recovery for a data warehouse?

View solution

Q. What is a key consideration in designing a backup strategy for a data warehouse?

View solution

Q. What is a key reason backing up the data warehouse is critical?

View solution

Q. Why is recreating the data from the source systems during recovery almost always impractical for a data warehouse?

View solution