QlikView 12 Business Analyst Certification Exam (QV12BA) Free Practice Test

Question 1

A business analyst has a ProductCode field that contains the value 'AB1980T60'. Which is the correct expression to extract all the numbers from this string?

A. =Right(ProductCode,7) - "T"

B. =KeepChar(ProductCode,* 016S9')

C. =SubField(Num# (ProductCode))

D. =Mid(ProductCode,3,4) + Mid(9,2>

Correct Answer: C

Question 2

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

A. Product Number and Average Sales

B. Average Sales and Year

C. Year

D. Average Sales

Correct Answer: A

Question 3

Which is the most appropriate object to display a picture and launch an external task?

A. Extension object

B. Container object

C. Image object

D. Text object

Correct Answer: A

Question 4

A business analyst creates a document with sales data for different regions, products, and salespeople. The analyst needs to create an object that will show the percentage of the total sales when one or more values are selected.
Which two objects can the analyst use to meet these requirements? (Select two.)

A. Gauge chart

B. Text box

C. Mekko chart

D. Table box

E. Statistics box

Correct Answer: B,D

Question 5

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?

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

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

C. A pie chart of sales by Month Year and a line chart 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

Correct Answer: C

Welcome to TestSimulate

QlikView 12 Business Analyst Certification (QV12BA) Free Practice Test