Get Quality Preparation with QlikView Business Analyst (QV12BA) Certification
- Palak Mazumdar
- Oct 29, 2022
- 3 min read
QlikView Business Analyst certification questions and exam summary helps you to get focused on the exam. This guide also helps you to be on QV12BA exam track to get certified with good score in the final exam.
QlikView Business Analyst (QV12BA) Certification Summary
● Exam Name: QlikView Business Analyst
● Exam Code: QV12BA
● Exam Duration: 120 minutes
● Exam Questions: 50
● Passing Score: 65%
● Exam Price: $250 (USD)
● Books: Business Analyst
QlikView Business Analyst (QV12BA) Certification Exam Syllabus
Gather and Interpret Requirements (12% of the exam)
- Given a set of business objectives, determine KPIs, dimensions, or measures
Identify and Analyze Data Sources (12% of the exam)
- Given a dataset, determine the relationships among data
Design and Develop the QlikView Application User Interface (76% of the exam)
- Determine the result of a given function or complex expression
- Identify where alternate uses of expressions are appropriate
- Given a scenario, determine the appropriate function or complex expression to use
- Explain how to implement Actions/Triggers in the QlikView interface
- Given a scenario, determine the appropriate object or chart type to use
- Explain the purpose/functionality of common object properties
- Given a scenario, determine the appropriate application User Interface performance tuning option to use
- Given user requirements, identify the appropriate screen resolution
QlikView Business Analyst (QV12BA) Certification Questions
01. A business analyst has two identical QlikView documents, Document_A and Document_B.
The analyst would like to create a button object in Document_A, which when clicked, will open Document_B with the same selections as Document_A. On the Actions tab, the analyst adds the action, Open QlikView Document, and selects Document_B.
What other selection should the business analyst make to achieve this behavior?
a) Check Transfer State
b) Add the action, Dynamic Update
c) Add the action, Copy State Contents
d) Check Apply state on top of current
02. An application contains a chart with the expression:
Sum(Qty*Amount - Qty*DiscountAmount)
What should a business analyst modify to optimize the chart?
a) The load script to: Qty* (Amount - DiscountAmount) as LineItemTotal and modify the expression to LineItemTotal
b) The expression to: Sum (Qty* (Amount - DiscountAmount) )
c) The load script to: Qty* (Amount - DiscountAmount) as LineItemTotal and modify the expression to Sum(LineItemTotal)
d) The expression to: Sum (Qty*Amount) - Sum (Qty*DiscountAmount)
03. A business analyst needs a KPI to show sales of all years since year 2000. Assume the current year is 2017. Which expression should the business analyst use?
a) Sum( { $<Year={2000+}>} Sales)
b) Sum( { $<Year={ ">2000"}>} Sales )
c) Sum( { $<Year={ "2" }>} Sales)
d) Sum( { $<Year={2000-2017}>} Sales)
04. A business analyst creates a document that shows data from various countries. The users want to select one or more different countries to complete their analysis.
Which three objects meet these requirements?
(Select three.)
a) Table box
b) Statistics box
c) Text box
d) Slider
e) List box
05. A business analyst needs to analyze sales using a hierarchical dimension of region, country, and city. Which chart should be used?
a) Pie chart
b) Block chart
c) Combo chart
d) Scatter chart
06. A business user needs to analyze different KPIs such as sales amount, price, and discount by product group. Which chart type should be used?
a) Block chart
b) Pie chart
c) Line chart
d) Scatter chart
07. A business user opens a QlikView application on an iPad, and scroll bars are displayed on the right side of the screen. What should the business analyst do to remove the scroll bars?
a) Select View > Fit Zoom to iPad
b) Apply the correct Theme for the iPad
c) Rotate the iPad from landscape to portrait view
d) Redesign the application with consideration of the tool bar and tab row
08. A business analyst creates a document with two sheets. The analyst needs to create a trigger to perform an action when the document opens in QlikView Desktop.
Where should the analyst add the trigger?
a) In Document Properties, under Sheet Event Triggers
b) In Sheet Properties, under Sheet Event Triggers
c) In Document Properties, under Document Event Triggers
d) In Sheet Properties, under Document Event Triggers
09. A business analyst wants to get a better understanding of the relationship between revenue, margin dollars, and growth percentage for each product they sell.
Which object should the business analyst use?
a) Bar chart
b) Pie chart
c) Combo chart
d) Scatter chart
10. A business analyst needs to create a KPI dashboard with three gauges to measure the performance of a sales organization.
Which three measures are the most appropriate for a business analyst to use?
(Select three.)
a) Total Cost by Product
b) Margin Month over Month
c) Sales Year over Year
d) Cost Year to Date
e) Total Sales by Region
Answers:
Question: 01: Answer: a
Question: 02: Answer: c
Question: 03: Answer: c
Question: 04: Answer: a, c, e
Question: 05: Answer: b
Question: 06: Answer: d
Question: 07: Answer: d
Question: 08: Answer: c
Question: 09: Answer: d
Question: 10: Answer: b, c, d
Comments