フリー問題

問題文

A BI tool will connect to Snowflake and let business users drag dimensions onto a report without writing SQL. Which model shape best supports that usage?

選択肢

1. A Data Vault model with hubs, links, and satellites exposed directly to the business users.
2. A single wide table holding every attribute and measure, with the raw semi-structured documents kept in a VARIANT column.
3. A fully normalized model in which every attribute lives in its own table to avoid any repetition of values.
4. A dimensional model with a fact table of measures surrounded by dimension tables that hold the descriptive attributes.