Qlik QV12BA Exam Practice Test Instant Access

Question 1

Refer to the exhibit.

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

AA data model with three tables and a synthetic key

BA data model with three tables with a circular reference

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

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

Answer : A

Question 2

A data model contains 1 billion records and a straight table renders all of the data at the most granular level. The business users do NOT need all of the detailed information. The business analyst needs to improve the rendering time of the straight table.

Which two approaches should the analyst use? (Select two )

AUpdate the straight table to a more summarized view

BReplace all table fields with only one field which concatenates the values of all previous table fields

CRemove all master dimensions and master measures, and replace with distinct expressions in each visualization

DSpecify a specific sort order in the output of the straight table using a field not found in the straight table columns

ESet up a calculation condition to only show the straight table if filtered down to a much smaller number of rows (e.g., 100k rows)

Answer : C, E

Question 3

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 4

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

ACheck Transfer State

BAdd the server name to the Document field

CUncheck Apply state on top of current

DRemove the '.qvw' extension from the Document field

EAdd Close This Document as the second action on this button

Answer : A, B

Question 5

A business analyst needs to analyze average sales by product number and country by year. Which measure(s) should the business analyst use?

AYear

BAverage Sales

CAverage Sales and Year

DProduct Number and Average Sales

Answer : D

Question 6

Refer to the exhibit.

The TOTAL in Table_1 equals 35 instead of 52

What will this indicate about a data model?

AThere is at least one synthetic key in the data model

BThe Expression Total is selected as Total Mode in Table_1

CThere is a many-to-many relationship between Field_3 and Field_5

DDimension Limits are used in Table 1 to restrict the displayed values

Answer : A

Question 7

Refer to the exhibit

A business analyst needs to present the actual sales of the current year in a KPI on a dashboard. The expression in the Text field is NOT working

Which two changes will correct the expression? (Select two )

ARemove the $ sign before Year

BRemove the $ sign between {and (

CAdd single quotes around the whole expression

DChange Representation from Text to Expression

EAdd a = sign at the beginning of the expression

Answer : A, B

Qlik QV12BA QlikView 12 Business Analyst Certification Exam Practice Test