CDA LEVELⅠ TEST 2数据分析考察表格关系-CDA考试官方模拟题库

备考刷题，请到

CDA认证小程序

The diagram below describes the connection relationships between various tables related to a company's sales business. Please observe the diagram to answer the following questions:

Primary Chinese-English Correspondence. "产品" ："Product" "产品编号" ： "Product ID" "产品经理" ："Product Manager" “产品类型”： “Product Type” “产品系列”：“Product Series” “城市编号”：“ City Code” “城市经理编号”：“ City Manager ID” “城市名”： “City Name” “区域编号“：“Regional Code” “区域经理“：“Regional Manager” “区域名“：“Regional Name“ “第三方评级“：“Third-party Rating” “金额”：“Amount” “商机编号”： “Business Opportunity ID” “上周销售阶段”：“ Last Week's Sales Stage” “所属领域“：“Relevant Domain” “所属行业“：“Industry Affiliation” “预计签约日“：“Expected Signing Date” The correct description of the filtering relationship between the Product table and the Region table is:

A. Products can filter regions.

B. Regions can filter products.

C. There is no filtering relationship between them.

D. It is impossible to confirm the filtering relationship.

上一题

下一题

题目解析

题目评论(0)

Since the Opportunity Records cannot filter products or regions, there is no filtering relationship between regions and products.

正确答案是：B: Regions can filter products.

专业分析：

从图表中可以看出，“产品”表（Product）和“区域”表（Region）之间并没有直接的连接关系。但是，通过其他表格的连接关系可以间接地进行过滤。

具体来说，“产品”表通过“商机”表（Business Opportunity）连接到“城市”表（City），再通过“城市”表连接到“区域”表（Region）。这意味着一个区域可以通过城市来过滤相关的产品。例如，如果我们选择一个特定的区域，通过该区域下的城市可以找到相关的商机，进而找到与这些商机相关的产品。

因此，区域可以间接地过滤产品，所以答案是B: Regions can filter products。