Remove Unnecessary Data Quiz

What you'll be asked

1. Which of the following is the primary benefit of removing unnecessary columns from a dataset before loading it into a model?
2. When analyzing a large fact table for optimization, which column type is the best candidate for removal?
3. You have a table containing both 'OrderDate' and 'OrderDateTime'. You only need to report at the day level. What is the most efficient approach to optimize this model?
4. A developer identifies that a 'Description' column with long text strings is taking up significant space in the model but is rarely used. What is the recommended strategy?
5. In a star schema, you have a large fact table with a 'Comments' field. After auditing, you find that 95% of the values are null and the column is never queried. What is the most efficient way to optimize?

Answers and explanations come after you submit.