Question 1 :

A MOLAP cube is a good choice of storage technology for ?

1. A data mart.
2. An OLTP database.
3. A data lake.
4. A Data warehouse.

Question 2:

Even if you are using multiple DataMart, it is common to keep a central Data warehouse because ?

1. The data warehouse is used to resolve the dispute when two Data Marts disagree on the truth.
2. It provides a central hub, for refreshing the Data marts with fewer ETL processes.
3. The data marts only exist as staging points to feed the data warehouse.
4. Most self-service Bi requires access to all the data in the warehouse.

Question 3:

Compared to a Data Warehouse, a Data Lake is ?

1. More up to date.
2. More structured.
3. More rarely queried.
4. Easier to query.

Question 4:

What is the ETL is often scheduled to happen at night ?

1. Because people aren't using the OLAP database at that time.
2. Because people aren't using the OLTP database at that time.
3. Because then the OLAP database will represent the business state at a clear end of day checkpoint.
4. A combination of all 3 other reasons.

Question 5:

Standard ETL is preferable to Incremental ETL when ?

1. The goal is to minimize impact on the OLTP database during the working day.
2. If we want the data warehouse to be accurate up to the minute.
3. If the company runs transactions 24 x 7.
4. If the company generates too much data each day