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

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

Question 1

Refer to the exhibits.

Question # 1

A business analyst creates a button to change the list box on the top into the list box on the bottom

Which actions are configured to make the changes?

Options:

A.

Clear Field then Unlock Field

B.

Unlock Field, then Clear Field

C.

Clear Field then Dynamic Update

D.

Dynamic Update then Clear Field

Question 2

How many dimensions and measures are required to create a scatter chart?

Options:

A.

One dimension and one measure

B.

One dimension and two measures

C.

Two dimensions and one measure

D.

Three dimensions and one measure

Question 3

A business analyst wants to display sales by country region, city and customers. All the dimensions needs to be shown. Which chart can display a hierarchy without a drill-down dimension?

Options:

A.

Pivot table with allow pivoting

B.

Line chart with style option fill

C.

Straight table with dimension limit

D.

Radar chart with style option stacked

Question 4

A business analyst has data for these fields

• Year

• Sales Amount

• Product Number

• Country

• Order Number

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

Options:

A.

Average Sales Per Year

B.

Total Sales by Country

C.

Total Sales by Customer

D.

Average Order Sales Amount

E.

Total Customer Count by Country

Question 5

Refer to the exhibit.

Question # 5

The TOTAL in Table_1 equals 35 instead of 52

What will this indicate about a data model?

Options:

A.

There is at least one synthetic key in the data model

B.

The Expression Total is selected as Total Mode in Table_1

C.

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

D.

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

Question 6

An Invoices table has a DaysOverdue field A chart is required to analyze overdue invoices in 30 day intervals Which function should a business analyst use to meet this requirement?

Options:

A.

Aggr (DaysOverdue,30)

B.

Class(DaysOverdue, 30)

C.

GroupBy(DaysOverdue,30)

D.

IntervalMatch(DaysOverdue,30)

Question 7

Refer to the exhibit.

Question # 7

A data architect loads the tables into OlikView without making any modifications What can the data architect detect in the table viewer after the load process?

Options:

A.

One circular reference

B.

Two circular references

C.

One circular reference and one synthetic key

D.

Two circular references and one synthetic key

Page: 1 / 5
Total 50 questions