Qlik QV12BA Exam Questions Instant Access

Question 1

Refer to the exhibit.

The straight table does NOT show all rows from the Field1 list box What does this indicate about the dataset?

AField2 is a synthetic key

BA synthetic key is required

CField2 contains null values

DField2 contains blank values

Answer : A

Question 2

For a gauge, in which two places in the chart properties can expressions be entered? (Select two )

AAuto Minimize of the object

BShow Condition of the object

CX and Y position of the object

DCalculation Condition of the object

ENumber of major/minor units for the scale

Answer : B, D

Question 3

A business analyst will compare sales growth between this year and last year by country. The analyst is given the sales values and must calculate the growth.

Which two charts can be used? (Select two.)

ATable box with country as dimension and sales per year as expression

BBar chart with country and year as dimensions and sales as expression

CGauge chart with country as dimension and sales per year as expression

DPivot table with country and year as dimensions and sales as expression

EFunnel chart with country and year as dimensions and sales as expression

Answer : D, E

Question 4

A business analyst needs to analyze average sales by product number and country by year. Which measure(s) should the business analyst use?

AYear

BAverage Sales

CAverage Sales and Year

DProduct Number and Average Sales

Answer : D

Question 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=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)

Answer : D

Question 6

Refer to the exhibits

Schema A displayed in the exhibit has been transformed into Schema B

How can the before and after schemas be described?

AThe star schema has been transformed into a normalized schema.

BThe star schema has been transformed into a de-normalized schema

CThe snowflake schema has been transformed into a normalized schema

DThe snowflake schema has been transformed into a de-normalized schema

Answer : C

Question 7

Refer to the exhibit.

A business analyst creates a straight table to display net sales and commissions. The table uses the Anal font by default. The analyst will use a Text Format Expression to show commissions greater than $200 in Arial Bold font.

Which is the correct expression?

A=If(Conroission > 200, *<B>')

B=If(Conroission > 200, 'Bold1)

C=If(Conroission > 200, 'Arial Bold')

D=If (Coitinission > 200, * <B>Commissior.</B>' )

Answer : A

QlikView 12 Business Analyst Certification QV12BA Exam Questions