QSBA2018 Online Practice Questions and Answers

A large organization with more than 100 departments wants to raise money for a donation in the next 30 days. This year, leadership decides to increase employee participation through a competition. Team members of departments that raise $10,000 or more receive two additional holidays.

Leadership needs the following capabilities: Ability to view the total donation amount Ability to identify departments that raise $10,000 or more

Which two visualizations should the business analyst use without set analysis to meet these requirements? (Choose two.)

A. Pie chart

B. Box plot

C. Bar chart

D. KPI

E. Treemap

A bus company wants to analyze customer travel patterns to add additional services or create new routes.

The business analyst needs to consider the following data: 190 routes across the city Start and end location of each route Volume of customers travelling per hour Customer complaints when buses are full

Which visualization should a business analyst use to meet this requirement?

A. Area layer map

B. Treemap

C. Line layer map

D. Scatter plot

A business analyst must adjust and create new visualizations on a published app in Qlik Sense Enterprise. The changes need to be made very quickly.

Which two actions can the business analyst perform in the app on the hub? (Choose two.)

A. Duplicate sheets to edit visualizations

B. Create new sheets and visualizations

C. Add data to the app

D. Create and edit master items

E. Create variables in the app

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 business analyst needs to create an app showing sales data. The app requirements are as follows:

Compare sales for the current year (CY Sales) versus last year (LY Sales)

CY Sales must always be displayed in blue

LY Sales must always be displayed in yellow

Which steps should the business analyst take to meet these requirements?

A. 1. Create a KPI with two measures, CY Sales and LY Sales

2. Write an IF expression to set the appropriate colors for each measure

B. 1. Create CY Sales and LY Sales measures as master items

2. Write an IF expression to set the appropriate colors for the master items

C. 1. Create CY Sales and LY Sales measures as master items and set the required color for each measure

2. Create one KPI from the two master item measures

D. 1. Create CY Sales and LY Sales measures as master items and set the required color for each measure using Value colors

2. Create two gauges, one for each measure and set the color for each appropriately

A business analyst is creating a dashboard to analyze supply chains. The app must contain several elements: A bar chart that shows a number of products and product groups handled by shipper A map that shows the number of shipments sent from factory locations A bar chart that shows average delivery costs by shipper

Which dimensions should the business analyst use for this app?

A. Product, Shipper, FactoryLocation

B. Shipper, FactoryLocation

C. Shipper, Product

D. Product, ProductGroup, Shipper

A business analyst uses the data manager to load customer data from a QVD file. The data manager automatically profiles the data, and recognizes City and Country values as Geo data.

The app must meet the following requirements: Country field should be in Geo data format City should NOT be allowed as a mapping option for the users There must be an association between the Country and City fields

Which actions should the business analyst take to meet these requirements?

A. 1. In the Associations view, select the City field

2. Delete $geoname-tag from field properties

B. 1. In the Associations view, select the City field

2. Change the format from `Geo data' to `No data profiling'

C. 1. In the Associations view, select the City field

2. Delete the City field

D. 1. In the Associations view, select the City field

2. Change the format from `Geo data' to `General'

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 OrderID records are white Select a Year and all OrderID records are gray Select an OrderID 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. OrderID should be the key field in the MasterCalendar

B. The logical model is NOT a star schema

C. The OrderDate fields are different data types

D. MasterCalendar should be associated to the OrderDetails table

A company has customers in 16 countries. The majority of the customers are in Germany.

A business analyst creates a filter pane for Country, and wants "Germany" listed first. The rest of the

countries should be listed in alphabetical order.

Which method should the business analyst use to meet this requirement?

A. Edit the sheet, select Chart, Properties panel, Custom sorting, then select Germany

B. Edit the sheet, select Chart, Properties panel, Custom sorting, then click Descending Frequency

C. In the data manager, edit the table, select Country, then select Order from the data profiling card

D. In the data manager, edit the table, select Country, then select Order from the column header

Refer to the exhibits.

A business analyst must improve the first chart shown to make it look like the second chart.

Which two actions should the business analyst take to meet this requirements? (Choose two.)

A. Replace the three measures with one measure that calculated Total Sales

B. Change the stacked chart property in the properties panel

C. Add Year as an additional dimension

D. Change the continuous chart property in the properties panel

E. Change the Area property in the chart properties

Refer to the exhibits.

After the latest data reload, a business analyst notices the value for CategoryID `B321 appears to be

different from the other values.

What is causing this difference?

A. Null values are included in the source data

B. Pre-aggregated data is being used

C. Hyphen characters (`-') are included in the source data

D. Some categories do NOT exist in the Category table

A hospital has a large number of users who create their own visualizations in Qlik Sense Enterprise. The hospital has several requirements: Users must be able to create their own visualizations Users can duplicate and modify existing sheets New visualizations can be shared among the work groups in a governed and controlled way User created objects and sheets can be included in the base sheets

Which three privileges will meet these requirements? (Choose three.)

A. Users can publish sheets to the Community section

B. The app owner can promote community sheets to base sheets

C. Users can promote community sheets to base sheets

D. Users can replace base sheets with community sheets

E. Users can copy and modify base sheets

The sales department requests a new Qlik Sense app to show the amount of sales in each territory. The app must:

Allow analysis of aggregate views of big data stores Include objects that allow the user to jump to a specific sheet Provide a way to send a report through email

Which three products or features should the business analyst use to meet these requirements? (Choose three.)

A. On Demand App Generation

B. Bookmarks

C. Qlick Sense Enterprise for Elastic

D. Qlick NPrinting

E. Qlick DataMarket

A business analyst is using a box plot to show distribution. The data scientist provides the formulas to configure a custom box plot.

Which action(s) should the business analyst take to meet these requirements?

A. Under Box plot elements, disable Use presets and enter the given formulas as calculated dimensions

B. Under Box plot elements, disable Use presets and enter the given formulas in the expressions field

C. Select Add measure, and enter the given formulas as expressions

D. Create variables and enter the given formulas as expressions

Refer to the exhibit.

A business analyst must update an app by adding a new table called `Invoices'. This table must be associated to the existing mode via reference code values.

`Full Invoice No' includes the `CostCenter Code', the `Department Code', and a `Reference Code'.

The CostCenter Code is NOT relevant for further analysis, so the analyst must split this new field into two new columns.

Which set of actions should the business analyst take to meet these requirements?

A. 1. Select the split marker

2.

Click This instance

3.

Uncheck the first column

4.

Rename the fields

5.

Click Create fields

B. 1. Select the split marker

2.

Click All Instances

3.

Uncheck the last two columns

4.

Rename the fields

5.

Click Reset

C. 1. Select the split marker

2.

Click This Instance

3.

Uncheck the last two columns

4.

Rename the fields

5.

Click Reset

D. 1. Select the split marker

2.

Click All Instances

3.

Uncheck the first column

4.

Rename the fields

5.

Click Create fields