QSBA2018 Online Practice Questions and Answers

A business analysis must create new master items for quarterly calendar measures with company-specific 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? (Choose three.)

A. Right-click the Date field in the assets panel and Select Create calendar measures

B. Right-click the Sales field in the assets panel and Select Create calendar measures

C. Select Date, Sales, Sum, and Quarterly

D. Sales to master items, rename master items

E. Select Date, Sales, Sum, and Yearly

A business analyst is building a dashboard to track customer loyalty. The app has several requirements: A table that shows the total number of purchases by customer A scatter plot that shows the correlation between the number of purchases and total spent by customer A bar chart that shows the top five customers by sales

Which two measures should the business analyst use to meet these requirements? (Choose two.)

A. Customer Ranking

B. Number of Purchases

C. Purchase Amount

D. Number of Products

E. Correlation

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

Refer to the exhibit.

A business analyst must analyze sales using an existing sales order app. The Orders table in the app was added from a QVD file using the data manager The Orders table in the app and the QVD do NOT contain a SalesAmount field SalesAmount can be calculated by multiplying the Quantity and UnitPrice

How should the business analyst add a SalesAmount field into the Orders table?

A. In the data manager, create a new calculated field, SalesAmount, and set the expression value to Sum (UnitPrice * Quantity)

B. In the data mode viewer, add a calculated field named SalesAmount with the expression UnitPrice * Quantity

C. In the data manager, add a calculated field named SalesAmount with the expression UnitPrice * Quantity

D. In the Orders QVD file, add an additional field named SalesAmount with the expression UnitPrice * Quantity

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

A business analyst must create an interactive table to analyze sales performance for the selected year and the previous year.

Which are the correct expressions to meet this requirement?

A. B. C.

D.

Refer to the exhibit.

A business analyst must provide a visualization to show the trends of the number of orders generated per

employee. The Customer must be searchable.

EmployeeID, EmployeeName, OrderID, and CustomerID will be included in the load.

Which additional fields must be loaded to meet this requirement?

A. OrderDate, Customer, ProductID

B. Customer, ProductID

C. OrderDate, Customer

D. OrderDate, UnitPrice

A business analyst needs to add some images to a slide in a story in their personal workspace in Qlik Sense Enterprise.

What should the business analyst do to meet this requirement?

A. Use the image import wizard within the hub and add to the story slide

B. Copy and paste the images onto the story slide

C. Upload the images to the media library and add to the story slide

D. Drag and drop the images onto the story slide

Which two features/functions are enabled by the Qlik Associative Engine?

A. Smart search and mashups

B. Insight advisor and smart search

C. Insight advisor and data profiling

D. Smart search and data profiling