Free QlikView QSBA2024 Exam Questions

Question 1

A business analyst is creating a data model from several Excel files that contain several hundred thousand rows of data. The requirements include: • Users need to drill down to various details within the available data set.• Several final measures will be repeatedly used. These final measures require combining several fields in asingle table.• User experience and load time is a high priority.Which action should the business analyst take to meet these requirements?

A : Aggregate the data to the source period

B : Develop a master item using the required source fields

C : Combine the various source fields in a calculated item in the Data manager

D : Combine the source fields and create additional fields in Excel

Answer: B

Question 2

A business analyst designs a visualization to analyze a count of products by fixed price ranges. The customernow wants the price ranges to be dynamically modified so they are configurable by the application users. Thebusiness analyst modified the dimension axis on the visualization.Which step should the business analyst complete next?

A : Define a variable and use it in a variable input object on the sheet

B : Create a calculated field in Data manager, using the Class() function

C : Load an independent source file to contain the user-defined boundary values

D : Create the price range dimension using the Buckets feature in Data manager

Answer: A

Question 3

A business analyst is working with retail data for consumer products. The customer is interested in thefollowing:• Ability to look for outliers on sales volume and margin %• Ability to understand the clustering of products visually• Ability to see products that are above the median sales volumeWhich action should the business analyst take to implement these requirements?

A : Create a pivot table and color the sales volume cell using K-Means function and median sales volume as an additional column

B : Create a treemap visualization showing sales volume and margin% by product with the median sales volume in the title

C : Create a combo chart with K-Means colors for the bar and a line measure representing median sales volume

D : Create a scatter plot using K-Means to color the products and add a median sales volume reference line

Answer: D

Question 4

A business analyst designs a visualization to analyze a count of products by fixed price ranges. The customernow wants the price ranges to be dynamically modified so they are configurable by the application users. Thebusiness analyst modified the dimension axis on the visualization.Which step should the business analyst complete next?

A : Define a variable and use it in a variable input object on the sheet

B : Create a calculated field in Data manager, using the Class() function

C : Load an independent source file to contain the user-defined boundary values

D : Create the price range dimension using the Buckets feature in Data manager

Answer: A

Question 5

A business analyst designs a visualization to analyze a count of products by fixed price ranges. The customernow wants the price ranges to be dynamically modified so they are configurable by the application users. Thebusiness analyst modified the dimension axis on the visualization.Which step should the business analyst complete next?

A : Define a variable and use it in a variable input object on the sheet

B : Create a calculated field in Data manager, using the Class() function

C : Load an independent source file to contain the user-defined boundary values

D : Create the price range dimension using the Buckets feature in Data manager

Answer: A