Special Summer Sale - Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: 65percent

Welcome To DumpsPedia
  1. Home
  2. Qlik
  3. QlikView Business Analyst
  4. QV12BA
  5. QlikView 12 Business Analyst Certification Exam Questions and Answers

QV12BA Sample Questions Answers

Questions 4

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

Options:

A.

List box

B.

Multi box

C.

Table box

D.

Statistics box

E.

Straight table

Buy Now
Questions 5

What are two ways to calculate the Sales for the ProductCategory. Shoes? {Select two )

Options:

A.

Money(Sum(SaIes) )

B.

Money(Sum({}Sales))

C.

Money(Sum(Sales))

D.

Money(Sum({<{ProductCategory > = 'Shoes'>}Sales))

E.

Money(Sum({}Sales) )

Buy Now
Questions 6

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?

Options:

A.

250

B.

750

C.

850

D.

650

Buy Now
Questions 7

Refer to the exhibit.

Which is the highest performing expression to accurately count the number of Account Owners?

Options:

A.

COUNT (%AccountOwnerId)

B.

COUNT(AccountOwnerld)

C.

COUNT(DISTINCT %AccountOwnerId)

D.

COUNT(TOTAL %AccountOwnerId)

Buy Now
Questions 8

A customer specified that the QlikView application should be designed to fit a screen resolution of 1280 x 800 as a standard.

Which option will assist a business analyst while creating the user interface?

Options:

A.

View > Resize Window > 1280 x 800

B.

View > Fit Zoom to Window > 1280 x 800

C.

Settings > User Preferences > Design Tab and select 1280 x 800

D.

Settings > User Preferences > Design Tab and select Display Grid Lines

Buy Now
Questions 9

Two of the tables in the QlikView data model are InvoiceHeader (one million rows) and InvoiceDetail (nine million rows) InvoicelD links the two Invoice tables.

This expression is used several times in the QlikView application, count (distinct invoiceiT)

How can a business analyst optimize this expression for use in the application?

Options:

A.

In the load script, sort the InvoiceDetail table by InvoicelD. Add if (Peek(invoiceiD)=invoiceiD, 0,1) as DistinctlnvoicelD. Change the expression to Sum(DistinctinvoiceiD)

B.

In the load script, add I as DistinctlnvoicelD to the InvoiceDetail table. Change the expression to Sum(DistinctlnvoicelD)

C.

In the load script, sort the InvoiceDetail table by InvoicelD. Add if (?eek(invoiceiD)=invoiceiD, 1,0) as DistinctlnvoicelD. Change the expression to Sum (DistinctlnvoicelD)

D.

In the load script, add l as DistinctlnvoicelD to the InvoiceHeader table Change the expression to Sum(DistinctlnvoicelD)A.

Buy Now
Questions 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 )

Options:

A.

Bar chart

B.

Grid chart

C.

Gauge chart

D.

Scatter chart

E.

Straight table

Buy Now
Questions 11

Which two objects are created with ONLY measures? (Select two.)

A)

B)

C)

D)

E)

Options:

A.

Exhibit A

B.

Exhibit B

C.

Exhibit C

D.

Exhibit D

E.

Exhibit E

Buy Now
Questions 12

An Invoices table has a DaysOverdue field A chart is required to analyze overdue invoices in 30 day intervals Which function should a business analyst use to meet this requirement?

Options:

A.

Aggr (DaysOverdue,30)

B.

Class(DaysOverdue, 30)

C.

GroupBy(DaysOverdue,30)

D.

IntervalMatch(DaysOverdue,30)

Buy Now
Questions 13

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?

Options:

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

Buy Now
Questions 14

Refer to the exhibits.

Chart_1 has been transformed into Chart_2

Which action did the business analyst take to transform the chart?

Options:

A.

In the Dimensions tab. set '' 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 '' as the Line Style of the expression

D.

In the Expressions tab. selected Dashed Line from the Style drop-down menu

Buy Now
Questions 15

Refer to the exhibit.

A business analyst needs to implement document chaining into the "orders" document using a button. The business analyst wants to open the "order_details" document and continue working with the selection made in the "orders" document. However, the button does not work as expected

Which two changes must be made to meet this requirement? (Select two.)

Options:

A.

Check Transfer State

B.

Add the server name to the Document field

C.

Uncheck Apply state on top of current

D.

Remove the ".qvw" extension from the Document field

E.

Add Close This Document as the second action on this button

Buy Now
Exam Code: QV12BA
Exam Name: QlikView 12 Business Analyst Certification Exam
Last Update: Mar 27, 2025
Questions: 50
$57.75  $164.99
$43.75  $124.99
$36.75  $104.99
buy now QV12BA