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

Viewing page 2 out of 2 pages
Viewing questions 11-20 out of questions
Questions # 11:

Refer to the exhibit.

Question # 11

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?

What is the result?

Options:

A.

13 5%


B.

22.5%


C.

34.8%


D.

77.5%


Expert Solution
Questions # 12:

A business analyst designs a sheet with a list of customers. The analyst wants to add a small image to show the company logo for each customer.

Which three objects meet this requirement? (Select three )

Options:

A.

List box


B.

Input box


C.

Muiti box


D.

Table box


E.

Statistics box


Expert Solution
Questions # 13:

Refer to the exhibit.

Question # 13

A data architect loads the three data sources without adjusting the load script. What is the result?

Options:

A.

A data model with three tables and a synthetic key


B.

A data model with three tables with a circular reference


C.

A data model with two tables that load without warnings or errors


D.

A data model with three tables that load without warnings or errors


Expert Solution
Questions # 14:

Refer to the exhibit.

Question # 14

A data architect loads the tables into OlikView without making any modifications What can the data architect detect in the table viewer after the load process?

Options:

A.

One circular reference


B.

Two circular references


C.

One circular reference and one synthetic key


D.

Two circular references and one synthetic key


Expert Solution
Questions # 15:

Refer to the exhibits.

Question # 15

Table_1 has been transformed into Table_2. Which action did the business analyst take to transform the table?

Options:

A.

In the Dimension Limits tab, checked Show Total


B.

In the Presentation tab. checked Subtotals at Top


C.

In the Presentation tab. checked Show Partial Sums


D.

In the Presentation tab checked Totals on Last Row


Expert Solution
Viewing page 2 out of 2 pages
Viewing questions 11-20 out of questions