New Year Special 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: save70

Newly Released Qlik QSBA2021 Exam PDF

Page: 2 / 2
Total 50 questions

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

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: 2 / 2
Total 50 questions