Qlik Sense Business Analyst Certification Exam - February 2021 Release Exam Questions PDF download

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?

• count(BookinglD)
• [TolalCost]
• [Totalincomel
• sum(income|-sum[TotalCost]
• [TotalMargin]-sum(Cost)/sumTotal(lncome)*100
• count(dislinct BookinglD)
• [TolalCost]
• [Totalincomel
• ITotalincome|-[TotalCost]
• [TotalMargin]/{Totalllncome}*100
• count(dislinct BookinglD)
• [TolalCost]
• [Totalincome]
• [Totalincome|-[TotalCost]
• [TotalMargin]/[Totalllncome}*100
• count(distinct BookinglO)
• [TolalCost]
• [Totalincomel
• ITotalincome|-[TotalCost]
• [TotalMargin]/{Totalllncome}*100

Answer(s): C

Reveal Solution Next Question

QUESTION: 7

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?

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

Answer(s): C

Reveal Solution Next Question

QUESTION: 8

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.)

Standard map visualization
Mashups
Qlik Sense Mobile offline
Qlik NPrinting
Qlik web connectors

Answer(s): A,C

Reveal Solution Next Question

QUESTION: 9

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?

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

Answer(s): D

Reveal Solution Next Question