QV12BA無料問題集「QlikView 12 Business Analyst Certification」

質問 1

Refer to the exhibit.

The Sales table shown represents the entire data set A business analyst adds an expression in a document:

Next, the analyst selects Year = '2010' and RegionID = '2\. What is the result of the expression with these selections?

（A）650

（B）750

（C）250

（D）850

正解：D 解答を投票する

質問 2

A business analyst wants to represent the relationship between two key performance indicators <KPI) over time. The value ranges of the KPIs differ widely and the relative scale between each KPI is NOT required to be maintained.
How should the business analyst meet these requirements?

（A）Create a bar chart with a logarithmic scale

（B）Create a matrix chart with two different symbols

（C）Create a table chart with rounding function

（D）Create a combo chart with two different scales

正解：B 解答を投票する

質問 3

A business analyst has data for these fields
* Year
* Sales Amount
* Product Number
* Country
* Order Number
How many dimensions and measures exist?

（A）Four dimensions and one measure

（B）Two dimensions and three measures

（C）One dimension and four measures

（D）Three dimensions and two measures

正解：C 解答を投票する

質問 4

A data architect needs to develop a dashboard to represent the previous year's sales performance in a simple KPI object Which expression should be used to calculate this value?

（A）Sum({<Year={Max(Year)-!}>}Sales)

（B）Sum(Aggr<Sum(Sales),Max(Year-l)))

（C）Sum({<Year={$(=Max(Year)-I)}>}Sales)

（D）Sum(Aggr(Sum(Sales),Max(Year)-1))

正解：C 解答を投票する

質問 5

Refer to the exhibits.

A business analyst has an application showing sales performance. The analyst will enter an expression in the search box of a filter pane to show only Salesman who generate more than $200,000 in sales.
Which is the correct expression?

（A）=Firstname(Salesman=,Rob,, 'Tom', 'Helen', 'Rock', 'Leif')

（B）= If (WildMatch (Salesman, 'Rob*' , "Tom"', 'Helen* ', 'Rock*' , 'Leif"' ) , Sales)

（C）=Sum(Sales) >200000

（D）=If(Sum(Sales)>200000, Salesman)

正解：B 解答を投票する

QV12BA 無料問題集「QlikView 12 Business Analyst Certification」

弊社を連絡する

関連リンク

トップ試験