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

Refer to the exhibit.

A business analyst creates a bar chart and notices the weekdays are NOT in a US default format. The

analyst does NOT have permissions to enter the data load editor and edit the data. The analyst only has a

few minutes before the meeting to show the insights to a manager.

The business analyst wants to quickly customize the chart to show the weekdays in US format.

Which action should the business analyst take to fix the chart?

A. Change the dimension label using the DATE() function to specify the right data format.

B. Change the dimension to a calculated dimension to specify the right data format.

C. Change the dimension label to a calculated dimension using an IF() function.

D. Change the dimension to a calculated dimension using the REPLACE() function.

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

A company is starting to use a new customer account system. The business analyst must include this data in an existing app.

Data from the legacy customer account system is already available in the app.

Both tables have similar data, but the columns have different names.

Which actions should the business analyst take to merge data from both systems?

A. 1. Select Legacy Accounts

2.

Click Concatenate tables

3.

Select New Customer Accounts

4.

Map the tables

5.

Click Apply

B. 1. Select New Customer Accounts

2.

Drag it over Invoices

3.

Define the association

4.

Click Apply

C. 1. Select Legacy Accounts

2.

Click Concatenate tables

3.

Select New Customer Accounts

4.

Click Sample data

5.

Click Apply

D. 1. Select New Customer Accounts

2.

Drag it over Legacy Accounts

3.

Rename the association

4.

Click Apply

A business analyst needs to make a complex pie chart easier to understand. The pie chart shows the total number of customers by customer type. There are 12 customer types. Some customers do NOT have a type assigned.

The business analyst needs to: Show all customers including those without a customer type See the total number of customers in each customer type

Which two visualizations could the business analyst use to meet these requirements? (Choose two.)

A. Donut

B. Treemap

C. KPI

D. Scatter plot

E. Bar chart

A CEO of an automotive manufacturing company wants a single dashboard sheet to track the company's sales.

The app must meet several requirements: All charts must be on one sheet Show summary charts of key performance data Ability to scroll up and down the sheet

Which set of actions should the business analyst use to meet these requirement?

A. Use KPI objects Use Insight Advisor

B. Adjust grid spacing Use Insight Advisor

C. Use KPI objects Activate Chart assistance

D. Activate grid spacing Activate Extend sheet

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

A Qlik Sense Enterprise data architect creates and publishes an app to a stream and gives access to users. The users do NOT have access to Qlick Management Console All dimensions and measures used in the app are created in the master items library

Which two actions can the users perform? (Choose two.)

A. Create charts using dimensions and measures from master items

B. Export stories created in the app to a PDF of PowerPoint format

C. Export the data model to a QVD format and load it into another app

D. Create a calculated measure for a chart and add it to master items

E. Export the app from the hub and open it in Qlick Sense Desktop