Weekend Special Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code = simple70

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

Pass the Qlik Sense Business Analyst QSBA2021 Questions and answers with ExamsMirror

Practice at least 50% of the questions to maximize your chances of passing.

Exam QSBA2021 Premium Access

View all detail and faqs for the QSBA2021 exam

Go to Exam

512 Students Passed

95% Average Score

91% Same Questions

Viewing page 1 out of 2 pages

Viewing questions 1-10 out of questions

Questions # 1:

Country

USA

U.S.A.

Refer to the exhibit.

A business analyst needs to load several data files and notices that some of the values for the United States of America are formatted inconsistently.

What should the business analyst do?

Options:

Use data profiling to group the country values

Use data profiling and replace the country names

Use data profiling 10 hide the inconsistent country names

Use the filter and rename the country values

Answer

Questions # 2:

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

Which process should the business analyst follow?

Options:

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

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

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

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

Answer

Questions # 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:

Create a bucket that groups the three months of data

Use a WHERE clause to limit the data to three months

Apply a filter" to load three months of data

Create a calculated field for the three months of data

Answer

Questions # 4:

A business analyst inherits an app full of sheets The business analyst needs to redesign the app using the DAR principle How should the business analyst orderthe visualizations?

Options:

• KPIs

• Table PivotTable

• Bar Chart Pie Chart Line Chart

• KPIs

• Table Pivol Table

• KPIS

• Ba' Chart Pie Chart Line Chart

• Table Pivot. Table

• Bar Chart Pie Chart Line Chart

• Table Pivot Table

• KPIs

Answer

Questions # 5:

Question # 5

Refer to the exhibit.

A business analyst must add a list of interns to the current sates app. The app contains an existing employees table When the business analyst profiles the data the association vow displays possible associations as shown.

Which action should the business analyst take to meet the requirements?

Options:

Create a concatenated key to associate the Employees and internEmp tables

Force an association between the InternEmp and the Orders tables

Create an association between the EmpID and EmployeelD fields

Concatenate the InternEmp table to the Employees tables within data manager

Answer

Questions # 6:

A business analyst is creating an app that requires several visualizations

• A scatter plot mat shows the margin percentage and total sales by product category

• A map with a the layer that visualizes lines between retail stores and lactones

• A KPI that shows total cost

Margin% can be calculated by dividing profit by revenue Profit is the difference between total cost and total sates

Which two sets of fields can the business analyst use to meet these requirements? (Select two.)

Options:

Line Geometry

Margin%

Product Category

Location

Sales

Total Cost

Product Category

Retail Store Location

Factory Location

Line Geometry

Answer

C, E

Questions # 7:

To improve efficiencies a hospital mustanalyze how often a surgery is started late by operating room and surgeon The business analyst must consider several factors

• Dates of each surgery

• Number of minutes the start of the surgery is delayed

• Operating room

• Surgeon name

Which visualization should the business analyst use to meet these requirements?

Options:

A combo chart that shows total minutes of delayed starts by operating room and surgeon

A bar chart with total minutes of delayed starts and a drill-down from operating room to surgeon

A scatter plot with delayed start minutes per day operating room and surgeon

A line chart with total minutes of delayed starts and a drill-down from operating room to surgeon

Answer

Questions # 8:

A business analyst is developing an app that contains a data model with fields Country. City. Sales ProductName and ProductCategory.The global sales manager wants to add new visualizations to this app

The business analyst must include the following

• Ability to dynamically change the number of countries and cities

• Display a maximum of 10 countries

• Display a maximum of 5 cities per country

Which steps should the business analyst take?

Options:

1 Create two variables vCountry and vCity

2 Add a slider for vCountry and vCity

3 Apply the vanable to each virtualization

1 Add an input field for vCountry and vCity

2 Sat the dimension limitation to the required maximum values 5 and 10

3 Apply the variable to each visualization

4 Add a bookmark Country and City

1Add an input field for vCountry and vCity

2 Set the dimension limitation to the required maximum values 5 and 10

3 Apply the variable to each visualization

1 Create two variables vCountry and vCrty

2 Add a slider for vCountry and vCity

3 Apply the variable to each virtualization

4 Set a sheet action that limits the data displayed

Answer

Questions # 9:

Refer to the exhibit.

Question # 9

What is the selection slate of light gray values?

Options:

Possible

Excluded

Selected

Alternative

Answer

Questions # 10:

A company CEO requests a dashboard that easily displays provides understating and tracks company performance. There are several ma n dashboard requirements:

• Viewable by a mobile device

• Display multiple key measures

• Provide ability to easily navigate to other sheets

Which feature meets these requirements?