Labour Day Special Limited Time Flat 70% Discount offer - Ends in 0d 00h 00m 00s - Coupon code: 70spcl

Activedumpsnet Logo
  1. Home
  2. Qlik
  3. Qlik Sense Business Analyst
  4. QSBA2021 - Qlik Sense Business Analyst Certification Exam - February 2021 Release

Qlik QSBA2021 Qlik Sense Business Analyst Certification Exam - February 2021 Release Exam Practice Test

Page: 1 / 5
Total 50 questions
Get QSBA2021 Full Access Download QSBA2021 PDF

Qlik Sense Business Analyst Certification Exam - February 2021 Release Questions and Answers

Question 1

A business analyst wants to send an email to app users when the region's sales exceed $50,000. The notification must be delivered through a mobile app What should the business analyst configure?

Options:

A.

An email trigger on a data reload

B.

An action on the sheet containing the KPI

C.

A destination using Qlik NPrinting

D.

A condition using Qlik Alerting

Question 2

Question # 2

Refer to the exhibit

A business analyst is modifying a box plot End users report unexpected blue dots in a box plot

What should the business analyst do?

Options:

A.

Under Box plot elements, select Whisker length and increase to two interquartile ranges

B.

Under Box plot elements deselect Include outliers

C.

Under the Dimensions menu, deselect Include null values

D.

Ask the data architect to modify the data model

Question 3

A finance manager uses an Excel file to record travel expenses The file has historical data and is used m multiple Qlik Sense apps The finance manager needs to deploy only the past three months of data to the regional sales managers

Which solution should be used to meet the requirements using the data manager?

Options:

A.

Create a bucket that groups the three months of data

B.

Use a WHERE clause to limit the data to three months

C.

Apply a filter" to load three months of data

D.

Create a calculated field for the three months of data

Question 4

An organization recently acquired a competitor A business analyst needs to merge me custom databases with 20 years of customer and order transactions. The data must be integrated into the existing app to show the past two years of data Performance degradation must be minimized

What should the business analyst do to meet this requirement?

Options:

A.

• Add the new Customers and Orders tables and associate the new tables to me existing data model

• Filter the data from the Customers and Orders table to bring only data created within the past two years

B.

• Add the new Customers and Orders tables and concatenate the new tables to the existing data model

• Filter the data from the Orders table to bring only data created within the past two years

C.

• Add the new Customers and Orders tables and associate the new tables to the existing data model

• Filter the data from the Orders table to bring only data created within the past two years

D.

• Add the new Customers and Orders tables and concatenate the new tables to the existing data model

• Filter the data from the Customers and Orders table to bring only data created within the past two years

Question 5

A business analyst wants to create a dashboard for the Finance team to use The app must include four sheets one looking at the full dataset and three others focused on the regions APAC EMEA and AMERICAS each.

The team needs visualizations for

• Sales by Product in the past 6" months

• Cost of Sales on a map by Country

• Sales Cost and Margin by Month

Additionally the learn wants to dear fillers while navigating between sheets and enable chat in the hub Which features should be used?

Options:

A.

Create default bookmark, maps sheet actions enable the insight Bot

B.

Create master measures alternate states GeoAnalytics enable Insights in app capabilities

C.

Create default bookmark GeoAnalytics alternate states enable the insight Bot

D.

Create master measures sheet actions maps enable Insights in app capacities

Question 6

A company that manages several tennis clubs uses an app mat includes three master measures TotalCost, Totallncome. and TotalMargin A business analyst needs to create a new table that utilizes master items and meets the following requirements:

• Number of bookings that users make

• Cost associated with booking (including electricity and indirect costs)

• Income obtained and profit originated m each booking

• Sales margin: percentage of margin over income

• Detail by tennis clubs

Which optimal expressions should the business analyst use?

Options:

A.

• count(BookinglD)

• [TolalCost]

• [Totalincomel

• sum(income|-sum[TotalCost]

• [TotalMargin]-sum(Cost)/sumTotal(lncome)*100

B.

• count(dislinct BookinglD)

• [TolalCost]

• [Totalincomel

• ITotalincome|-[TotalCost]

• [TotalMargin]/{Totalllncome}*100

C.

• count(dislinct BookinglD)

• [TolalCost]

• [Totalincome]

• [Totalincome|-[TotalCost]

• [TotalMargin]/[Totalllncome}*100

D.

• count(distinct BookinglO)

• [TolalCost]

• [Totalincomel

• ITotalincome|-[TotalCost]

• [TotalMargin]/{Totalllncome}*100

Question 7

A marketing team is using an app to analyze the company events. The team registers attendees with information such as an ID name and region and discusses business opportunities with attendees Opportunities are evaluated m time and set to a different status.

The team wants to use insight Advisor to query events and opportunities to:

• Review specific areas and periods

• Use marketing terms not currently present in the app when classifying opportunities

• Define calendar periods and add calculations for specific data fields

Some examples are as follows:

Question # 7

Which process should the business analyst follow?

Options:

A.

Add tags into the data fields to improve how the Insight Advisor identifies the fields when using the natural language queries Use the Selection tool to remove any tads not needed for the search results

B.

Define me business logic and vocabulary to define values using the fields m me data set Create groups and set properties in fields Use Calendar groups to define custom periods

C.

Create master dimensions and measures, including calendar measures to define fiscal periods Use tags to improve the insight Advisor search features and include vocabulary terms

D.

Update the data set using data manager or data load editor to include these terms as flags or values in the data set Also define the variable to determine which calculation should be used for each field

Load More QSBA2021 Questions 
Page: 1 / 5
Total 50 questions
Get QSBA2021 Full Access Download QSBA2021 PDF