QSBA2021 Questions PDF [2024] Use Valid New dump to Clear Exam [Q21-Q44]

Q21. A business analyst is developing an app that contains a data model with fields Country. City. Sales ProductName and ProductCategory. The global sales manager wants to add new visualizations to this app The business analyst must include the following
* Ability to dynamically change the number of countries and cities
* Display a maximum of 10 countries
* Display a maximum of 5 cities per country
Which steps should the business analyst take?

Q22. Refer to the exhibit.

The data architect toads these fields from a data source A business analyst is creating an app for the human resources team Several visualizations are required
* Line chart to show the number of new hires and terminations monthly
* Treemap to show the number of employees by department and job level
* Distribution plot of annual salaries or amount of benefits received by duration of employment or location
* KPI to show average cost per employee
The cost per employee can be calculated by adding the employee salary to the amount of benefits received Which two additional fields does the business analyst need from the data architect lo meet these requirements? (Select two )

Q23. Refer to the exhibit.

What is the selection slate of light gray values?

Q24. 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 data is 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)

Q25. A business analyst wants to send an email to app users when the region’s sales exceed $50,000. The notification must be delivered through a mobile app What should the business analyst configure?

Q26. A business analyst is creating a new app with sales dat
a. The visualizations must meet several requirements:
* A Bar chart mat shows sales by product group is used m multiple sheets
* A KPI object that visualizes that the total amount of sales is used once
* A Treemap mat shows margin by product group is used one time inside a Container What should be added to the master items library?

Q27. A company CEO requests an app that contains global sales information. The CEO needs to present this information to an audience of international investors during an upcoming meeting The presentation must meet several requirements
* Contain visualizations that present dearly to a large audience
* Answer audience questions dynamically
* Be made available as shared content
* Emphasize important sales revenue
Which Qlik Sense features must the business analyst prepare?

Q28. Refer to the exhibit.


A business analyst must add a list of interns to the current sates app. The app contains an existing employees table When the business analyst profiles the data the association vow displays possible associations as shown.
Which action should the business analyst take to meet the requirements?

Q29. An organization recently acquired a competitor A business analyst needs to merge me custom databases with 20 years of customer and order transactions. The data must be integrated into the existing app to show the past two years of data Performance degradation must be minimized What should the business analyst do to meet this requirement?

Q30. A business analyst ;s creating an app tor the team. A set of selections must be applied every time an app is opened.
What should the business analyst do to meet this requirement?

Q31. Refer to the exhibit.

These tables have the same structure. The Customers information is as shown in the Data Model Viewer In a sheet called “Customer Analysis” there is a filter pane with Customers.
A business analyst s developing an app for the Sales department and loads the data about Customers from two files.
The business analyst wants the values to appear as they were loaded How should this issue be resolved?

Q32. A large auditing firm has a proprietary web portal that all of the’ customers use to access their own dat a. The owner of the portal has asked if it is possible to embed some Ok visualizations within the portal when will present the data back to the Individual customers.
The data within the visualizations must be live and provide up-to-date data every time the customer logs in to the portal and updates when the Qlik Series app is reloaded.
What should the business analyst recommend?

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

Q34. Several departments use an app. The business analyst needs to modify access to the sheets so that each department can access their sheets only What should me business analyst do?

Q35. Refer to the exhibit.

A business analyst needs to display a bat chart only when less than 100 customers are selected What should the business analyst create to meet this requirement

Q36. Refer to the exhibit.

A business analyst needs to add a table and make sure it is associated appropriately. The table contains regional information about employee offices and must be able to titer the orders by employee office.
Which steps should the business analyst take?

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

Q38. A business analyst needs to develop a visualization that compares performances of every product the company sells and each product category. The CEO wants to highlight the worst- and best-performing products and categories in a meeting that beg/is in one hour Using a bar chart which two approaches should the business analyst use? (Select two.)

Q39. A company CFO has requested an app that contains visualizations applicable to analyzing the finance data Each regional finance team will analyze their data, and the app must contain a high-level sheet that navigates to relevant detail sheets.
Which features support a logical design structure?

Q40. A business analyst has access to all of a company’s data tor the past 10 years The source table consists of the following fields Transactions Transaction Time Transaction Date Transaction Year Cardholder Cardholder address Cardissuer and Amount Users request to create an app based on this source Users only review me data for the past 2 years Data must be updated daily Users do not view cardholder into What should the business analyst do to reprove the app performance?