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

Pass the Qlik QlikView Business Analyst QV12BA Questions and answers with CertsForce

 Qlik Exams      Go to Exam Detail      Get Premium Access
Viewing page 1 out of 2 pages
Viewing questions 1-10 out of questions
Questions # 1:

Refer to the exhibits.

Question # 1

A business analyst creates a button to change the list box on the top into the list box on the bottom

Which actions are configured to make the changes?

Options:
A.

Clear Field then Unlock Field

B.

Unlock Field, then Clear Field

C.

Clear Field then Dynamic Update

D.

Dynamic Update then Clear Field

Questions # 2:

Refer to the exhibit.

Question # 2

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

Question # 2

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

Questions # 3:

A business analyst needs to open another GlikView document by trigger Which two options can be used to perform this task? (Select two.)

Options:
A.

Text box trigger

B.

Field event trigger

C.

Line object trigger

D.

Activate sheet trigger

E.

Variable event trigger

Questions # 4:

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

Questions # 5:

Refer to the exhibit

Question # 5

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

Question # 5

What will be the result?

Options:
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

Questions # 6:

Refer to the exhibits

Question # 6

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

Questions # 7:

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

Questions # 8:

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

Questions # 9:

A business analyst will compare sales growth between this year and last year by country. The analyst is given the sales values and must calculate the growth.

Which two charts can be used? (Select two.)

Options:
A.

Table box with country as dimension and sales per year as expression

B.

Bar chart with country and year as dimensions and sales as expression

C.

Gauge chart with country as dimension and sales per year as expression

D.

Pivot table with country and year as dimensions and sales as expression

E.

Funnel chart with country and year as dimensions and sales as expression

Questions # 10:

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

Viewing page 1 out of 2 pages
Viewing questions 1-10 out of questions