Qlik Sense Business Analyst Certification Exam - June 2018 Release (QSBA2018) Free Practice Test

Question 1

A retailer with 300 locations worldwide needs to analyze its workforce to prepare for its next board meeting The two most important items to the board members are total compensation and number of employees by city.
Which visualization should a business analyst use to meet this requirement?

A. Scatter plot

B. Bar chart

C. Pivot table

D. Map

Correct Answer: A

Question 2

A business analyst must create new master items for quarterly calendar measures with company-specific naming conventions based on
* The Date field and the Sum of Sales
* The new master items will calculate QTD Sales. Current QTD Sales, Last QTD Sales, Current Quarter Sales, Last Year Current Quarter Sales, and Last Quarter Sales Which three steps should the business analyst take to meet these requirements? (Select three.)

A. Right-click the Sales field in the assets panel and select Create calendar measures

B. Right-click the Date field in the assets panel and select Create calendar measures

C. Select Date. Sales. Sum. and Yearly

D. Select Date, Sales, Sum, and Quarterly Save to master items, rename master items

Correct Answer: A,B,C

Question 3

A business analyst must display current year sales versus previous year sales by region, sub-region, and city The result will be a pivot table, with rows for the region, sub-region, and city, and columns for Current Year Sales and Previous Year Sales Which calculated expressions should the business analyst create to meet these requirements?
A)

B)

C)

D)

A. Option D

B. Option C

C. Option A

D. Option B

Correct Answer: A

Question 4

A marketing team needs to analyze current sales by age groups in a bar chart. The following age groups are created in the data manager and the field is named AgeGroup:
* Children 16 years old and younger
* YoungAdult: 17 to 30 years old
* Adult: 31 years old and older
The business analyst will use an expression to set the colors for the bars:
If ( [AgeGroup] = 'Children', Red() , If ([AgeGroup] = ' Your.gAdult', Blue () , Green())) Which steps must be completed to apply the correct colors in the visualization'?

A. Create a master item measure using the expression. In the visualization, select Color by measure and use the newly created master item.

B. Select Data in the properties panel and create a calculated dimension using the expression in the expression editor.

C. Create a master item dimension using the expression. In the visualization, select Color by dimension and use the newly created master item.

D. Under Appearance in the properties panel, select Color then select Color by expression and make sure that The expression is a color code is checked

Correct Answer: C

Question 5

Refer to the exhibit.
A business analyst is testing an existing app that returns unexpected results.
Using the selection tool, the business analyst observes the following behavior
* Select a CompanyName and the associated OrderlD records are white
* Select a Year and all OrderlD records are gray
* Select an OrderlD and the Quarter values are all gray, but the CompanyNames are white
* Select a ProductID and the associated ShipperName and OrderDates are white, but the Year is gray What is causing these results?

A. The OrderDate fields are different data types

B. MasterCalendar should be associated to the OrderDetails table

C. The logical model is NOT a star schema

D. OrderlD should be the key field in the MasterCalendar

Correct Answer: D

Welcome to TestSimulate

Qlik Sense Business Analyst Certification Exam - June 2018 Release (QSBA2018) Free Practice Test