March Sale Special Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: 70percent

Qlik QV12BA QlikView 12 Business Analyst Certification Exam Exam Practice Test

Demo: 7 questions
Total 50 questions

QlikView 12 Business Analyst Certification Exam Questions and Answers

Question 1

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

Options:

A.

Money(Sum(SaIes) )

B.

Money(Sum({}Sales))

C.

Money(Sum(Sales))

D.

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

E.

Money(Sum({}Sales) )

Question 2

Refer to the exhibit.

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

Question 3

Refer to the exhibit

A customer has loaded the two tables and then added the script:

What will be the result?

Options:

A.

The Interval table will be joined with the Transactions table

B.

The TransactionTime table will be joined with the Interval table

C.

The Interval table will be associated with the Transactions table on the TransactionTime field and with the TimePeriods table by a synthetic table

D.

The Interval table will be associated with the Transactions table on the TimePeriods field, and with the TransactionTime table by a synthetic table

Question 4

A customer needs to see sales data by month, with a rolling six month average of margin percent for any selected twelve month period. Which chart will meet these requirements?

Options:

A.

A combo chart of sales as bars and rolling six month average margin percent as a line by Month Year

B.

A pie chart of sales by Month Year and a line chart of rolling six month average margin percent by MonthYear

C.

A bar chart of sales by month by year and a straight table of rolling six month average margin percent by MonthYear

D.

A trellis chart of bar charts as sales by month by year and a pivot table of rolling six month average margin percent by month by year

Question 5

Refer to the exhibit

A business analyst needs to present the actual sales of the current year in a KPI on a dashboard. The expression in the Text field is NOT working

Which two changes will correct the expression? (Select two )

Options:

A.

Remove the $ sign before Year

B.

Remove the $ sign between {and (

C.

Add single quotes around the whole expression

D.

Change Representation from Text to Expression

E.

Add a = sign at the beginning of the expression

Question 6

Refer to the exhibit.

A business analyst creates a water fall chart to understand how an initial value is affected by a series of intermediate positive and negative values.

Which two actions must a business analyst perform to create the water fall chart shown? (Select two )

Options:

A.

Add five dimensions *

B.

Add five measures

C.

Check "Show as water fall" on the Style tab of the bar chart properties

D.

On the dimension limit properties sheet set limit to only show the first five values .

E.

Use the Bar Offset property with the correct expression

Question 7

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

Demo: 7 questions
Total 50 questions