Vcehome > QlikView > QlikView Certification > QSBA2018 > QSBA2018 Online Practice Questions and Answers

QSBA2018 Online Practice Questions and Answers

Questions 4

A data architect adds a field to an existing data model that contains new values for the ProductGroup. The business analyst needs to efficiently update the app and meet these requirements: Use the existing charts, which are built using a master item dimension called ProductGroup Existing charts must use the new values for ProductGroup Business users must be able to compare the new and old values

How should the business analyst meet these requirements?

A. Change the ProductGroup dimension using the new field, and create a new dimension in the master items for the old field.

B. Create a calculated dimension on the charts to allow the users to compare the new value to the old value.

C. Replace the dimensions on all charts to use the new ProductGroup field added to the data model.

D. Use set analysis on the chart measures to see the difference in ProductGroup between the new field and the old field.

Browse 50 Q&As
Questions 5

A client wants to see a bar chart with a single measure and three dimensions: Region, Product Category, and Month.

The business analyst creates a bar chart with the measure, Sum(Revenue).

Which final step should the business analyst take to complete the chart?

A. Add Region, Product Category, and Month as three different dimensions

B. Create a single master dimension with Region, Product Category, and Month

C. Add Region as a dimension, add Product Category and Month as alternate dimensions

D. Create a cyclic group with Region, Product Category, and Month as dimensions

Browse 50 Q&As
Questions 6

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

Browse 50 Q&As
Questions 7

A business analyst wants to develop a Qlik Sense app with some key performance indicators on the dashboard. The analyst decides to use two KPI objects to represent key metrics for the organization.

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

A. Margin by region

B. Number of products by customer

C. Number of customers

D. Number of products sold

E. Number of customers by region

Browse 50 Q&As
Questions 8

A business analyst is NOT familiar with the data and is using insight advisor to create a number of visualizations.

Which steps should the business analyst take to add the visualizations to a sheet?

A. Click Generate insights to find visualizations, then click Add to sheet

B. Use the selection tool to find visualizations, then click Add to sheet

C. Use smart search to find visualizations, then click Add to sheet

D. Drag and drop fields on the workspace, then click Add to sheet

Browse 50 Q&As
Questions 9

A business analyst creates a scatter plot and wants to save it for reuse by colleagues. The business analyst must remain the owner of this scatter plot, and should be the only person allowed to make changes. These changes should be applied automatically to all instances of this visualization.

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

A. Copy the scatter plot on every sheet of the app

B. Add the finished scatter plot to the master items

C. Copy the scatter plot to the custom objects

D. Publish the app to the Everyone stream

E. Publish the finished scatter plot to the hub

Browse 50 Q&As
Questions 10

A business analyst must create a horizontal bar chart to identify the top Sales Reps, Customer Segment Description, and Customer City.

Users must be able to analyze the data for one field at a time The chart should show the unique number of customers for each dimension being analyzed The dimensions and measures created must be re-used on other charts

Which steps should the business analyst perform to configure the chart correctly?

A. Create all three dimensions as master items and add one as the chart dimension and the other two as alternative dimensions Create a master item measure using Count(Distinct[Customer Number]) and add it to the chart Change the chart presentation to Horizontal and sort it by the measure

B. Create a cyclic dimension as a master item using all three dimensions and add it to the chart Create a master item measure using Count(Total[Customer Number]) and add it to the chart Change the chart presentation to Horizontal and sort it by the measure

C. Create all three dimensions as master items and add one as the chart dimension and the other two as alternative dimensions Create a master item measure using Count(Total[Customer Number]) and add it to the chart Change the chart presentation to Horizontal and sort it by the measure

D. Create all three dimensions as master items and add to the bar chart Create a master item measure using Count(Distinct[Customer Number]) and add it to the chart Change the chart presentation to Horizontal and sort it by the first dimension

Browse 50 Q&As
Questions 11

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

Browse 50 Q&As
Questions 12

Refer to the exhibit.

The data architect informs the business analyst of an additional data source for Customer data. The values are stored in a different format.

Users do NOT need to display values in the current format for the NewCustomer.

The business analyst has split the `Customer' column into two new fields in the New Customer table.

Which steps should the business analyst take to finish integrating the new customer records into the existing visualizations?

A. 1. Click on the Customer table

2.

Select Concatenate tables in the `...' option menu

3.

Select the New Customer table

4.

Edit Mappings to align the `Customer Name' and `Status' columns from the two tables

5.

Remove the remaining third column from the `New Customer' row

B. 1. Click on the NewCustomer table

2.

Select Concatenate tables in the `...' option menu

3.

Select the Customer table

4.

Edit Mappings to align the `Customer Name' and `Status' columns from the two tables

5.

Rename the columns to `Customer Name' and `Status'

C. 1. Click on the Customer table

2.

Select Concatenate tables in the `...' option menu

3.

Select the New Customer table

4.

Edit Mappings to align the `Customer Name' and `Status' columns from the two tables

5.

Rename the columns to `Customer Name' and `Status'

D. 1. Click on the NewCustomer table

2.

Select Concatenate tables in the `...' option menu

3.

Select the Customer table

4.

Edit Mappings to align the `Customer Name' and `Status' columns from the two tables

5.

Remove the remaining third column from the `New Customer' row

Browse 50 Q&As
Questions 13

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

Browse 50 Q&As
Exam Code: QSBA2018
Exam Name: Qlik Sense Business Analyst Certification Exam
Last Update: May 08, 2024
Questions: 50 Q&As

PDF

$49.99

VCE

$59.99

PDF + VCE

$67.99