フリー問題

問題文

A modeler builds a dataset for sales analysis that will hold a sales table plus tables for products, customers, and channels. In what order does the documentation say to add the tables, and why does the order matter?

選択肢

1. The most detailed table goes in first, because that table is usually the primary one for the analysis and the rest only supply context around it.
2. The order carries no weight, because every join comes from the data source and none is inferred from column names.
3. The smallest table goes in first, because the automatic matching of column names runs against the table already on the diagram and a small table leaves fewer matches to delete.
4. The dimension tables go in first, because a fact table cannot be dropped onto the diagram until one dimension table waits there.