Qlik QV12BA Exam Practice Test Instant Access

Question 1

A business analyst has data for these fields

* Year

* Sales Amount

* Product Number

* Country

* Order Number

Which three KPIs may be calculated? (Select three.)

AAverage Sales Per Year

BTotal Sales by Country

CTotal Sales by Customer

DAverage Order Sales Amount

ETotal Customer Count by Country

Answer : A, D, E

Question 2

A business analyst needs to sort the values for the Product dimension explicitly as "Planes", then "Trains", then "Automobiles" The analyst needs a highly optimized solution to provide the best performance for an application with between 900 million and 1 billion records

Which solution should the analyst use?

AUse the Ord function in the user interface to sort in a custom order

BBuild nested IF statements in the user interface to assign numeric values, then sort numerically

CCreate a new calculated dimension in the Ul named ProductSort, then sort the Product field by the new ProductSort field

DAssign a numeric value to the Product values using the DUAL function during the data load, then sort numerically in the Ul

Answer : C

Question 3

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.)

AText box

BTable box

CGauge chart

DMekko chart

EStatistics box

Answer : A, B

Question 4

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?

AComposite dimension

BSlowly changing dimension

CHistorical lookup dimension

DInterval matching dimension

Answer : C

Question 5

How many dimensions and measures are required to create a scatter chart?

AOne dimension and one measure

BOne dimension and two measures

CTwo dimensions and one measure

DThree dimensions and one measure

Answer : B

Question 6

Refer to the exhibit.

The dataset shown has been loaded into a QhkView application The user has selected the year 7015' to analyze

This expression is used to calculate a value:

Num((Sum({!<[Month] = {'May'} >> SalesAmt-COGS)/Sum({1<[Month] = {'May*} >} SalesAmt)), #,##0.0**)

What is the result?

A13 5%

B22.5%

C34.8%

D77.5%

Answer : D

Question 7

A business analyst needs to calculate the average order value by country. Which two objects meet this requirement? (Select two.)

AList box

BMulti box

CTable box

DStatistics box

EStraight table

Answer : B, C

QlikView 12 Business Analyst Certification QV12BA Exam Practice Test