Practice Free QlikView QV12BA Exam Questions Online, QV12BA Free Demo

Question No : 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'?

A.0
B.910.000
C.40.000.000
D.85 000 000

Answer:

Question No : 2
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.=SubField(Num# (ProductCode))
C.=KeepChar(ProductCode,* 016S9')
D.=Mid(ProductCode,3,4) + Mid(9,2>

Answer:

Question No : 3
Refer to the exhibits.

Chart_1 has been transformed into Chart_2
Which action did the business analyst take to transform the chart?

A.In the Dimensions tab. set '<S2>' as the Line Style of the dimension
B.In the Style tab. selected Dashed Line from the Style drop-down menu
C.In the Expressions tab. set '<S2>' as the Line Style of the expression
D.In the Expressions tab. selected Dashed Line from the Style drop-down menu

Answer:

Question No : 4
A business analyst wants to represent the relationship between two key performance indicators <KPI) over time. The value ranges of the KPIs differ widely and the relative scale between each KPI is NOT required to be maintained.
How should the business analyst meet these requirements?

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

Answer:

Question No : 5
Refer to the exhibit

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

What will be the result?

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

Answer:

Question No : 6
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?

A.The star schema has been transformed into a normalized schema.
B.The star schema has been transformed into a de-normalized schema
C.The snowflake schema has been transformed into a normalized schema
D.The snowflake schema has been transformed into a de-normalized schema

Answer:

Question No : 7
Refer to the exhibit.

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

Next, the analyst selects Year = '2010' and RegionID = '2\.
What is the result of the expression with these selections?

A.250
B.750
C.850
D.650

Answer:

Question No : 8
Refer to the exhibits.

A business analyst has an application showing sales performance. The analyst will enter an expression in the search box of a filter pane to show only Salesman who generate more than $200,000 in sales.
Which is the correct expression?

A.=Sum(Sales) >200000
B.=If(Sum(Sales)>200000, Salesman)
C.=Firstname(Salesman=,Rob,, 'Tom', 'Helen', 'Rock', 'Leif')
D.= If (WildMatch (Salesman, 'Rob*' , "Tom"', 'Helen* ', 'Rock*' , 'Leif"') , Sales)

Answer:

Question No : 9
A business analyst has data for these fields
• Year
• Sales Amount
• Product Number
• Country
• Order Number
Which three KPIs may be calculated? (Select three.)

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

Answer:

Question No : 10
A business analyst needs to create a dashboard showing only numerical values. There is NO need to filter data or select any
dimensions.
Which three objects can the business analyst use? (Select three)

A.Bar chart
B.Grid chart
C.Gauge chart
D.Scatter chart
E.Straight table

Answer:

Test Online Free QlikView QV12BA Exam Questions and Answers