Qlik Sense Business Analyst Certification Exam - February 2021 Release QSBA2021 Question # 15 Topic 2 Discussion

Qlik Sense Business Analyst Certification Exam - February 2021 Release QSBA2021 Question # 15 Topic 2 Discussion

QSBA2021 Exam Topic 2 Question 15 Discussion:
Question #: 15
Topic #: 2

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?


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


Get Premium QSBA2021 Questions

Contribute your Thoughts:


Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.