Qlik QV12BA Exam Questions Instant Access

Question 1

Refer to the exhibit.

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

Next, the analyst selects Product Category = 'Bikes' and Product Subcategory = 'Road Bikes' What is the result of the expression with these selections'?

B910.000

C 40.000.000

D85 000 000

Answer : B

Question 2

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?

ASum({<Year={$(=Max(Year)-I)}>}Sales)

BSum({<Year={Max(Year)-!}>}Sales)

CSum(Aggr(Sum(Sales),Max(Year)-1))

DSum(Aggr<Sum(Sales),Max(Year-l)))

Answer : A

Question 3

A business analyst wants to display several dimensions and key performance indicators (KPI) in one object Aggregations must be done in this object. The user must be able to change the sorting of the dimensions and KPIs quickly and easily.

Which object meets these requirements?

APivot table without automatic pivoting

BBar chart with groups of dimension and expression

CTable box without drop-down selection

DStraight table with interactive sorting

Answer : A

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

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 6

Refer to the exhibit.

The dataset shown has been loaded into a QhkView application The user has selected the year 7015' to analyze

This expression is used to calculate a value:

Num((Sum({!<[Month] = {'May'} >> SalesAmt-COGS)/Sum({1<[Month] = {'May*} >} SalesAmt)), #,##0.0**)

What is the result?

A13 5%

B22.5%

C34.8%

D77.5%

Answer : D

Question 7

Refer to the exhibit.

The TOTAL in Table_1 equals 35 instead of 52

What will this indicate about a data model?

AThere is at least one synthetic key in the data model

BThe Expression Total is selected as Total Mode in Table_1

CThere is a many-to-many relationship between Field_3 and Field_5

DDimension Limits are used in Table 1 to restrict the displayed values

Answer : A

QlikView 12 Business Analyst Certification QV12BA Exam Questions