Qlik QV12BA Quiz 1 Topic 6 Questions 1-5

Question: 1

A business analyst has data for these fields

* Year

* Sales Amount

* Product Number

* Country

* Order Number

How many dimensions and measures exist?

AOne dimension and four measures

BTwo dimensions and three measures

CThree dimensions and two measures

DFour dimensions and one measure

Show Answer

Question: 2

What are two ways to calculate the Sales for the ProductCategory. Shoes? {Select two )

AMoney(Sum(<ProductCategory={ ' Shoes * }>SaIes) )

BMoney(Sum({<ProductCategory={'Shoes*}>}Sales))

CMoney(Sum(<?roductCategory={Shoes}>Sales))

DMoney(Sum({<{ProductCategory > = 'Shoes'>}Sales))

EMoney(Sum({<?roductCategory={Shoes}>}Sales) )

Show Answer

Question: 3

Refer to the exhibits.

q3_QV12BA

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=Sum(Sales) >200000

B=If(Sum(Sales)>200000, Salesman)

C=Firstname(Salesman=,Rob,, 'Tom', 'Helen', 'Rock', 'Leif')

D= If (WildMatch (Salesman, 'Rob*' , 'Tom'', 'Helen* ', 'Rock*' , 'Leif'' ) , Sales)

Show Answer

Question: 4

A business analyst has data for these fields

â€¢ Year

â€¢ Sales Amount

â€¢ Product Number

â€¢ Country

â€¢ Order Number

How many dimensions and measures exist?

AOne dimension and four measures

BTwo dimensions and three measures

CThree dimensions and two measures

DFour dimensions and one measure

Show Answer

Question: 5

A business analyst has data for these fields

â€¢ Year

â€¢ Sales Amount

â€¢ Product Number

â€¢ Country

â€¢ Order Number

Which three KPIs may be calculated? (Select three.)

AAverage Sales Per Year

BTotal Sales by Country

CTotal Sales by Customer

DAverage Order Sales Amount

ETotal Customer Count by Country

Show Answer

Qlik QV12BA Quiz:1 Topic:6 Questions:1-5