New Year Special Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: 70special

Qlik QV12BA QlikView 12 Business Analyst Certification Exam Exam Practice Test

Page: 1 / 5
Total 50 questions

QlikView 12 Business Analyst Certification Exam Questions and Answers

Testing Engine

  • Product Type: Testing Engine
$37.5  $124.99

PDF Study Guide

  • Product Type: PDF Study Guide
$33  $109.99
Question 1

A business analyst wants to represent the relationship between two key performance indicators

How should the business analyst meet these requirements?

Options:

A.

Create a bar chart with a logarithmic scale

B.

Create a table chart with rounding function

C.

Create a combo chart with two different scales

D.

Create a matrix chart with two different symbols

Question 2

A customer needs to measure sales by assigned sales representative

All previous and current sales representative assignments must be included so that sales representatives receive credit for sales activities on both previous and current sales.

Which type of dimension is described by the sales representative assigned to the client?

Options:

A.

Composite dimension

B.

Slowly changing dimension

C.

Historical lookup dimension

D.

Interval matching dimension

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?

Options:

A.

Pivot table without automatic pivoting

B.

Bar chart with groups of dimension and expression

C.

Table box without drop-down selection

D.

Straight table with interactive sorting

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?

Options:

A.

Year

B.

Average Sales

C.

Average Sales and Year

D.

Product Number and Average Sales

Question 5

Refer to the exhibit.

Which is the highest performing expression to accurately count the number of Account Owners?

Options:

A.

COUNT (%AccountOwnerId)

B.

COUNT(AccountOwnerld)

C.

COUNT(DISTINCT %AccountOwnerId)

D.

COUNT(TOTAL %AccountOwnerId)

Question 6

Which three options can be used to change the background on a bar chart? (Select three )

Options:

A.

Color

B.

Image

C.

Multicolored

D.

Dynamic Image

E.

Persistent Colors

Question 7

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.)

Options:

A.

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

B.

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

C.

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

D.

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

E.

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

Page: 1 / 5
Total 50 questions