Q: When designing a data warehouse, BI professionals take into account which of the following considerations? Select all that apply.
or
Q: Which of the following factors is taken into account by BI specialists when constructing a data warehouse? Choose every option that pertains.
- The visualization tools that will be used for the dashboard
- The business needs (CORRECT)
- The shape and volume of the data (CORRECT)
- The model that the data warehouse will follow (CORRECT)
Explanation: Understanding the business needs ensures that the data warehouse is designed to provide relevant and actionable insights that align with the organization’s goals. The structure (shape) and size (volume) of the data determine the architecture, storage capacity, and processing power required for the data warehouse. Deciding on the data warehouse model (e.g., star schema, snowflake schema) influences how data will be organized, stored, and accessed within the warehouse.