Qlik Sense Business Analyst Certification Exam - 2022 Sample Questions:

1. 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(dislinct BookinglD)
[TolalCost]
[Totalincomel
ITotalincome|-[TotalCost]
[TotalMargin]/{Totalllncome}*100
B) count(BookinglD)
[TolalCost]
[Totalincomel
sum(income|-sum[TotalCost]
[TotalMargin]-sum(Cost)/sumTotal(lncome)*100
C) count(distinct BookinglO)
[TolalCost]
[Totalincomel
ITotalincome|-[TotalCost]
[TotalMargin]/{Totalllncome}*100
D) count(dislinct BookinglD)
[TolalCost]
[Totalincome]
[Totalincome|-[TotalCost]
[TotalMargin]/[Totalllncome}*100

2. A business analyst creates an app for a large retailer. The app is based on me past ^2 months of transactional data in CSV formal After successfully demonstrating the app the retailer provides a tile that contains another seven years of data After the new datais loaded the previously responsive app takes 10 times longer to respond to users' selections. The app has many complex expressions Which two actions should the business analyst take to resolve the issues? (Select two)

A) Request the data architect to create flagsin the data model to optimize set analysis expressions
B) Create versions of the app using a WHERE clause m the data manager to restrict the data
C) Make sure a I master items contain variables that define the expressions
D) Replace set analysis with calculated fields in the data manager
E) Use JOIN statements to reduce the number of tables m the data model

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

A) Mashups
B) Qlik NPrinting
C) Standard map visualization
D) Qlik web connectors
E) Qlik Sense Mobile offline

4. 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?

A) Combo Chart
B) Line Chart
C) Distribution Plot
D) Scatter Plot

5. A user makes a selection within a sheet and then navigates to another sheet to validate the details However when the user returns to the original sheet the selection is removed.
What is causing this behavior?

A) An action has been defined to dear selections
B) The data has been reloaded and cleared the selection
C) A bookmark has been applied with default selections
D) The original sheet is in a different alternate state

Solutions: