考试报名
考试报名
考试内容
考试大纲
在线客服
返回顶部

备考刷题,请到

CDA认证小程序

Please answer the following questions based on the data in the diagram: If these four tables are used to build a multidimensional analysis model, which model would it belong to?If the Retail table is connected to the Store Daily Target table, which statement is incorrect?
A. A connection relationship can be established, and the correspondence is many-to-many.
B. There is more than one common field that can be used.
C. After establishing a connection between the two tables, the aggregated calculation results have no practical reference significance.
D. A connection relationship can be established and used for aggregated calculations.
上一题
下一题
收藏
点赞
评论
题目解析
题目评论(0)

In a many-to-many connection relationship, there will be issues of duplicate calculations when performing aggregated calculations.

正确答案是:D: A connection relationship can be established and used for aggregated calculations。

专业分析:

1. **多维分析模型**:从图中四个表(Retail, Store, Product, Store Daily Target)来看,这些表之间存在多对多的关系,尤其是在Retail表和Store Daily Target表之间。因此,这种模型通常属于星型或雪花型模型,用于多维数据分析。

2. **表之间的连接关系**:
- **A: A connection relationship can be established, and the correspondence is many-to-many**:这是正确的。从图中可以看出,Retail表和Store Daily Target表之间可以建立多对多的连接关系。
- **B: There is more than one common field that can be used**:这是正确的,图中显示有多个共同字段可以用于连接。
- **C: After establishing a connection between the two tables, the aggregated calculation results have no practical reference significance**:这是正确的,因为多对多关系可能导致聚合计算结果失去实际意义。
- **D: A connection relationship can be established and used for aggregated calculations**:这是不正确的。由于多对多的关系,直接进行聚合计算可能会导致结果失真或无意义。

因此,选项D是不正确的,因为尽管可以建立连接关系,但由于多对多的关系,直接进行聚合计算是不合适的。