QlikView QSBA2021 Exam (page: 2)
QlikView Qlik Sense Business Analyst Certification Exam - February 2021 Release
Updated on: 25-Dec-2025

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:

CHINIMILLI SATISH 8/29/2023 6:22:00 AM

looking for 1z0-116
Anonymous


Pedro Afonso 1/15/2024 8:01:00 AM

in question 22, shouldnt be in the data (option a) layer?
Anonymous


Pushkar 11/7/2022 12:12:00 AM

the questions are incredibly close to real exam. you people are amazing.
INDIA


Ankit S 11/13/2023 3:58:00 AM

q15. answer is b. simple
UNITED STATES


S. R 12/8/2023 9:41:00 AM

great practice
FRANCE


Mungara 3/14/2023 12:10:00 AM

thanks to this exam dumps, i felt confident and passed my exam with ease.
UNITED STATES


Anonymous 7/25/2023 2:55:00 AM

need 1z0-1105-22 exam
Anonymous


Nigora 5/31/2022 10:05:00 PM

this is a beautiful tool. passed after a week of studying.
UNITED STATES


Av dey 8/16/2023 2:35:00 PM

can you please upload the dumps for 1z0-1096-23 for oracle
INDIA


Mayur Shermale 11/23/2023 12:22:00 AM

its intresting, i would like to learn more abouth this
JAPAN


JM 12/19/2023 2:23:00 PM

q252: dns poisoning is the correct answer, not locator redirection. beaconing is detected from a host. this indicates that the system has been infected with malware, which could be the source of local dns poisoning. location redirection works by either embedding the redirection in the original websites code or having a user click on a url that has an embedded redirect. since users at a different office are not getting redirected, it isnt an embedded redirection on the original website and since the user is manually typing in the url and not clicking a link, it isnt a modified link.
UNITED STATES


Freddie 12/12/2023 12:37:00 PM

helpful dump questions
SOUTH AFRICA


Da Costa 8/25/2023 7:30:00 AM

question 423 eigrp uses metric
Anonymous


Bsmaind 8/20/2023 9:22:00 AM

hello nice dumps
Anonymous


beau 1/12/2024 4:53:00 PM

good resource for learning
UNITED STATES


Sandeep 12/29/2023 4:07:00 AM

very useful
Anonymous


kevin 9/29/2023 8:04:00 AM

physical tempering techniques
Anonymous


Blessious Phiri 8/15/2023 4:08:00 PM

its giving best technical knowledge
Anonymous


Testbear 6/13/2023 11:15:00 AM

please upload
ITALY


shime 10/24/2023 4:23:00 AM

great question with explanation thanks!!
ETHIOPIA


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

does this exam have lab sections?
Anonymous


Shin 9/8/2023 5:31:00 AM

please upload
PHILIPPINES


priti kagwade 7/22/2023 5:17:00 AM

please upload the braindump for .net
UNITED STATES


Robe 9/27/2023 8:15:00 PM

i need this exam 1z0-1107-2. please.
Anonymous


Chiranthaka 9/20/2023 11:22:00 AM

very useful!
Anonymous


Not Miguel 11/26/2023 9:43:00 PM

for this question - "which three type of basic patient or member information is displayed on the patient info component? (choose three.)", list of conditions is not displayed (it is displayed in patient card, not patient info). so should be thumbnail of chatter photo
Anonymous


Andrus 12/17/2023 12:09:00 PM

q52 should be d. vm storage controller bandwidth represents the amount of data (in terms of bandwidth) that a vms storage controller is using to read and write data to the storage fabric.
Anonymous


Raj 5/25/2023 8:43:00 AM

nice questions
UNITED STATES


max 12/22/2023 3:45:00 PM

very useful
Anonymous


Muhammad Rawish Siddiqui 12/8/2023 6:12:00 PM

question # 208: failure logs is not an example of operational metadata.
SAUDI ARABIA


Sachin Bedi 1/5/2024 4:47:00 AM

good questions
Anonymous


Kenneth 12/8/2023 7:34:00 AM

thank you for the test materials!
KOREA REPUBLIC OF


Harjinder Singh 8/9/2023 4:16:00 AM

its very helpful
HONG KONG


SD 7/13/2023 12:56:00 AM

good questions
UNITED STATES