午夜精品久久久久久久99老熟妇,天堂中文www官网,未满十八18勿进黄网站,太粗太深了太紧太爽了,天天爽夜夜爽夜夜爽

考試報(bào)名
考試報(bào)名
考試內(nèi)容
考試大綱
在線客服
返回頂部

備考刷題,請(qǐng)到

CDA認(rèn)證小程序

Pivot analysis means observing different measures from different dimensions. Which of the following statements is correct?
A. Dimensions are filtered by measures
B. Dimensions, measures, aggregation rules are three pivoting essentials
C. Measure fields must be numeric
D. The table where measures come from is called dimension table
上一題
下一題
收藏
點(diǎn)贊
評(píng)論
題目解析
題目評(píng)論(0)

Dimensions filter measures, not the opposite; Measure fields can be text or numeric; The table where measures come from is the fact table.

正確答案是B: Dimensions, measures, aggregation rules are three pivoting essentials。

專業(yè)分析:
- A: 維度(Dimensions)是數(shù)據(jù)分析中的分類(lèi)標(biāo)準(zhǔn),而度量(Measures)是具體的數(shù)值數(shù)據(jù)。通常,度量會(huì)根據(jù)維度進(jìn)行匯總和分析,但維度并不會(huì)被度量過(guò)濾。
- B: 在數(shù)據(jù)透視分析中,維度(Dimensions)、度量(Measures)和聚合規(guī)則(Aggregation rules)是三大要素。維度決定分析的分類(lèi)方法,度量提供具體的數(shù)值數(shù)據(jù),聚合規(guī)則決定如何對(duì)度量進(jìn)行計(jì)算和匯總。
- C: 度量字段不一定必須是數(shù)值型數(shù)據(jù),雖然在大多數(shù)情況下,度量字段是用于數(shù)值計(jì)算的數(shù)據(jù),但也可以是其他類(lèi)型的數(shù)據(jù),只要這些數(shù)據(jù)可以進(jìn)行某種形式的聚合。
- D: 度量字段通常來(lái)自事實(shí)表(Fact table),而維度字段通常來(lái)自維度表(Dimension table)。維度表用于描述事實(shí)表中的數(shù)據(jù)。

因此,選項(xiàng)B正確地描述了數(shù)據(jù)透視分析的三個(gè)基本要素。