Test Online Free QlikView QV12BA Exam Questions and Answers

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

Show Answer

• A. =Right(ProductCode,7) - "T"
• B. =SubField(Num# (ProductCode))
• C. =KeepChar(ProductCode,* 016S9')
• D. =Mid(ProductCode,3,4) + Mid(9,2>

Show Answer

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

Show Answer

• 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

Show Answer

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

Show Answer

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

Show Answer

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

Show Answer

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)

Show Answer

• 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

Show Answer

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

Show Answer