Incorrect. This statement is false. Surrogate keys are created
when the data is loaded into the data warehouse tables.
Correct! Surrogate keys are created when the data is loaded into
the data warehouse tables.
Incorrect. This statement is false. Do not use indexes on small
tables because the gain in performance is inconsequential compared to the cost
of maintaining the index.
Correct! Do not use indexes on small tables because the gain in performance
is inconsequential compared to the cost of maintaining the index.
Incorrect. This statement is false. These values must be broken
down into the key’s individual components (meanings) for the warehouse.
Intelligent keys are not recommended for the data warehouse.
Correct! These values must be broken down into the key’s individual
components (meanings) for the warehouse. Intelligent keys are not recommended
for the data warehouse.