Free Access Qlik.QSBA2021.v2022-05-06.q18 Practice Test (Page 4)

Question 11

Refer to the exhibit.

A CEO wants to use a similar visualization on the company's dashboards
The visualization must meet several requirements
* Show three years of sales data
* Display sales trends by month
* Allow comparison of years using an area style display
Which set of actions should a business analyst take to meet these requirements?

A.* Add a ,line chart
* Add a master drill-down dimension with Year and Month
* Add Sum(Sates) as the measure
* In the properties panel under Presentation, select Area

B.* Add an area chart
* Add Year first then Month as the dimensions
* Add Sum(Sales) as the measure
* In the properties panel under Area select the dimensions

C.* Add an area chart
* Add Month first then Year as the dimensions
* Add SumfSates) as the measure
* In the properties panel under Area select the dimension Year

D.* Add a fine chart
* Add Month first then Year as the dimensions
* Add Surry Sales > as the measure
* In the properties panel under Presentation select Area

Question 12

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?

A.Edit the Show Condition expression field in the sheets tor each department

B.Choose to add a bookmark for each department

C.Use the Stones feature to create a story with embedded sheets for each department

D.Create sheets with alternate states for each department

Question 13

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?

A.* Add the new Customers and Orders tables and concatenate the new tables to the existing data model
* Filter the data from the Customers and Orders table to bring only data created within the past two years

B.* Add the new Customers and Orders tables and associate the new tables to the existing data model
* Filter the data from the Orders table to bring only data created within the past two years

C.* Add the new Customers and Orders tables and concatenate the new tables to the existing data model
* Filter the data from the Orders table to bring only data created within the past two years

D.* Add the new Customers and Orders tables and associate the new tables to me existing data model
* Filter the data from the Customers and Orders table to bring only data created within the past two years

Question 14

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?

A.A Multi KPI set analysis

B.A dashboard with regional bookmarks

C.A pivot table that filters by region

D.A dashboard of KPIs and section access

Question 15

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)

A.Use JOIN statements to reduce the number of tables m the data model

B.Create versions of the app using a WHERE clause m the data manager to restrict the data

C.Replace set analysis with calculated fields in the data manager

D.Make sure a I master items contain variables that define the expressions

E.Request the data architect to create flags in the data model to optimize set analysis expressions

Other Version: 555Qlik.QSBA2021.v2023-07-19.q18; 779Qlik.QSBA2021.v2022-07-05.q18

Latest Upload: 117Oracle.1Z0-1057-23.v2025-09-10.q47; 150Google.Professional-Cloud-Network-Engineer.v2025-09-09.q179; 131SAP.C-S4EWM-2023.v2025-09-08.q83; 162TheSecOpsGroup.CNSP.v2025-09-08.q20; 220CFAInstitute.ESG-Investing.v2025-09-08.q173; 155PECB.ISO-IEC-27001-Lead-Implementer.v2025-09-06.q132; 145Salesforce.Data-Architect.v2025-09-05.q216; 139Adobe.AD0-E605.v2025-09-05.q50; 183Nutanix.NCP-MCI-6.10.v2025-09-05.q55; 114Oracle.1z0-591.v2025-09-05.q104

Question 11

Question 12

Question 13

Question 14

Question 15

Download PDF File