QlikView QSBA2021 Exam (page: 2)
QlikView Qlik Sense Business Analyst Certification Exam - February 2021 Release
Updated on: 12-Feb-2026

Viewing Page 2 of 11

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?


  1. • count(BookinglD)
    • [TolalCost]
    • [Totalincomel
    • sum(income|-sum[TotalCost]
    • [TotalMargin]-sum(Cost)/sumTotal(lncome)*100

  2. • count(dislinct BookinglD)
    • [TolalCost]
    • [Totalincomel
    • ITotalincome|-[TotalCost]
    • [TotalMargin]/{Totalllncome}*100

  3. • count(dislinct BookinglD)
    • [TolalCost]
    • [Totalincome]
    • [Totalincome|-[TotalCost]
    • [TotalMargin]/[Totalllncome}*100

  4. • count(distinct BookinglO)
    • [TolalCost]
    • [Totalincomel
    • ITotalincome|-[TotalCost]
    • [TotalMargin]/{Totalllncome}*100

Answer(s): C



A business analyst using a shared folder mapped to S \419379942\ receives an Excel We with more than 100 columns many of the columns are duplicates. The current set of columns mat should be used have the suffix '_c* appended to the column name
What should the business analyst do to load the Excel data?

  1. Open the Excel file, remove all columns that do not have the suffix '_c' and save t>e Me to be loaded
  2. Deselect the fields that do NOT have the '_c' suffix in the data manager table preview
  3. Utilize drier functionality in the data manager to select only columns with the suffix _C with a fitter condition
  4. Load all columns because the recommended associations will use only columns with the suffix '_c*

Answer(s): C



A business analyst s developing an app 10 track the influence of the company's mascot cat on instagram. The marketing department has several requirements for this solution:
•Information must be updated every hour to the company's information monitor
•Data from Instagram must be fetched over a REST connection and combined with Google Analytics data
•There must be a way to visualize changes of followers *i a map

Which two features are needed to meet these requirements? (Select two.)

  1. Standard map visualization
  2. Mashups
  3. Qlik Sense Mobile offline
  4. Qlik NPrinting
  5. Qlik web connectors

Answer(s): A,C



To improve efficiencies a hospital must analyze 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?

  1. A combo chart that shows total minutes of delayed starts by operating room and surgeon
  2. A bar chart with total minutes of delayed starts and a drill-down from operating room to surgeon
  3. A scatter plot with delayed start minutes per day operating room and surgeon
  4. A line chart with total minutes of delayed starts and a drill-down from operating room to surgeon

Answer(s): D



Refer to the exhibit.

What is the selection slate of light gray values?

  1. Possible
  2. Excluded
  3. Selected
  4. Alternative

Answer(s): B



Viewing Page 2 of 11



Share your comments for QlikView QSBA2021 exam with other users:

Stephen 10/3/2023 6:24:00 PM

yes, iam looking this
AUSTRALIA


Stephen 8/4/2023 9:08:00 PM

please upload cima e2 managing performance dumps
Anonymous


hp 6/16/2023 12:44:00 AM

wonderful questions
Anonymous


Priyo 11/14/2023 2:23:00 AM

i used this site since 2000, still great to support my career
INDONESIA


Jude 8/29/2023 1:56:00 PM

why is the answer to "which of the following is required by scrum?" all of the following stated below since most of them are not mandatory? sprint retrospective. members must be stand up at the daily scrum. sprint burndown chart. release planning.
UNITED STATES


Marc blue 9/15/2023 4:11:00 AM

great job. hope this helps out.
UNITED STATES


Anne 9/13/2023 2:33:00 AM

upload please. many thanks!
Anonymous


pepe el toro 9/12/2023 7:55:00 PM

this is so interesting
Anonymous


Antony 11/28/2023 12:13:00 AM

great material thanks
AUSTRALIA


Thembelani 5/30/2023 2:22:00 AM

anyone who wrote this exam recently
Anonymous


P 9/16/2023 1:27:00 AM

ok they re good
Anonymous


Jorn 7/13/2023 5:05:00 AM

relevant questions
UNITED KINGDOM


AM 6/20/2023 7:54:00 PM

please post
UNITED STATES


Nagendra Pedipina 7/13/2023 2:22:00 AM

q:42 there has to be a image in the question to choose what does it mean from the options
INDIA


BrainDumpee 11/18/2023 1:36:00 PM

looking for cphq dumps, where can i find these for free? please and thank you.
UNITED STATES


sheik 10/14/2023 11:37:00 AM

@aarun , thanks for the information. it would be great help if you share your email
Anonymous


Random user 12/11/2023 1:34:00 AM

1z0-1078-23 need this dumps
Anonymous


labuschanka 11/16/2023 6:06:00 PM

i gave the microsoft azure az-500 tests and prepared from this site as it has latest mock tests available which helped me evaluate my performance and score 919/1000
Anonymous


Marianne 10/22/2023 11:57:00 PM

i cannot see the button to go to the questions
Anonymous


sushant 6/28/2023 4:52:00 AM

good questions
EUROPEAN UNION


A\MAM 6/27/2023 5:17:00 PM

q-6 ans-b correct. https://docs.paloaltonetworks.com/pan-os/9-1/pan-os-cli-quick-start/use-the-cli/commit-configuration-changes
UNITED STATES


unanimous 12/15/2023 6:38:00 AM

very nice very nice
Anonymous


akminocha 9/28/2023 10:36:00 AM

please help us with 1z0-1107-2 dumps
INDIA


Jefi 9/4/2023 8:15:00 AM

please upload the practice questions
Anonymous


Thembelani 5/30/2023 2:45:00 AM

need this dumps
Anonymous


Abduraimov 4/19/2023 12:43:00 AM

preparing for this exam is overwhelming. you cannot pass without the help of these exam dumps.
UNITED KINGDOM


Puneeth 10/5/2023 2:06:00 AM

new to this site but i feel it is good
EUROPEAN UNION


Ashok Kumar 1/2/2024 6:53:00 AM

the correct answer to q8 is b. explanation since the mule app has a dependency, it is necessary to include project modules and dependencies to make sure the app will run successfully on the runtime on any other machine. source code of the component that the mule app is dependent of does not need to be included in the exported jar file, because the source code is not being used while executing an app. compiled code is being used instead.
Anonymous


Merry 7/30/2023 6:57:00 AM

good questions
Anonymous


VoiceofMidnight 12/17/2023 4:07:00 PM

Delayed the exam until December 29th.
UNITED STATES


Umar Ali 8/29/2023 2:59:00 PM

A and D are True
Anonymous


vel 8/28/2023 9:17:09 AM

good one with explanation
Anonymous


Gurdeep 1/18/2024 4:00:15 PM

This is one of the most useful study guides I have ever used.
CANADA