Labour Day Special - Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: top65certs

Qlik QSBA2021 Dumps

Page: 1 / 2
Total 50 questions

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

Question 1

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:

A.

Line Geometry

Margin%

B.

Product Category

Location

C.

Sales

Total Cost

D.

Product Category

Retail Store Location

Factory Location

E.

Line Geometry

Question 2

Refer to the exhibits

After the latest data reload a business analyst notices the value tor CategoryID 'B321' seems different What is causing this discrepancy?

Options:

A.

The data type for CategorylD 332V does not match the others

B.

Null values are deluded in the source data

C.

Some categories do NOT exist in the Category table

D.

Hyphen character ('.') is included m the source data

Question 3

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 4

Country

USA

US

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:

A.

Use data profiling to group the country values

B.

Use data profiling and replace the country names

C.

Use data profiling 10 hide the inconsistent country names

D.

Use the filter and rename the country values

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:

A.

Create a concatenated key to associate the Employees and internEmp tables

B.

Force an association between the InternEmp and the Orders tables

C.

Create an association between the EmpID and EmployeelD fields

D.

Concatenate the InternEmp table to the Employees tables within data manager

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 sales manager needs to visualize the company's sales. The sales manager needs to understand how sates and profitability are related over time. The visualization will be used in a printed annual report.

The business analyst has access to the following data:

• Order Dates

• Order ID

• Total Safes by Order

• Net profit margin%

• Cost of Goods Sow (COGS)

Which visualization should the business analyst use?

Options:

A.

Scatter Plot

B.

Combo Chart

C.

Distribution Plot

D.

Line Chart

Page: 1 / 2
Total 50 questions