Free Qlik Sense Business Analyst Certification Exam – 2024 Exam QSBA2024 Exam Practice Test

A business analyst needs to rapidly prototype an application design for a prospective customer. The only dataset provided by the customer contains 30 fields, but has over one billion rows. It will take too long to keep loading in its entirety while the analyst develops the data model.Which action should the business analyst complete in the Data manager?

• Split the dataset and create a normalized star schema of associated tables
• Deselect text columns with unique data values to reduce the memory footprint
• Use the Filter data option to reduce the number of rows
• Truncate text fields longer than 256 characters to create preview fields

The VP of Finance is requesting a presentable solution that allows them to share finance information in monthly meetings with C-suite executives. Given the monthly meeting agendas, the solution must be customizable.Which Qlik Sense feature should be implemented to meet this requirement?

• Storytelling
• Insight Advisor Chat
• Action Buttons
• Bookmarks

A business analyst is creating a new app with sales data. The visualizations must meet several requirements:A Bar chart that shows sales by product group is used in multiple sheetsA KPI object that visualizes that the total amount of sales is used onceA Treemap that shows margin by product group is used one time inside a Container Which visualization should be added to the master items library?

• Container
• KPI
• Bar chart
• Treemap

A business analyst is creating an app using a dataset from ServiceNow. The dataset shows information about support cases, including how many days it has been since the case was opened (age).The app requirements are:The dashboard must display support cases in categories based on the age (New, Aging, and Beyond Service Level Agreement)The categories will be used multiple times in the dashboardGiven the volume of support cases, it is expected that the dataset will grow to be very large Which solution is the most efficient way for the business analyst to create this app?

• Ask the ServiceNow team to create the field in the source dataset
• Create an Excel sheet with all possible age values and the corresponding categories to add to thedata model
• Create a new field for the categories using the Bucket option in the Data manager
• Write a master dimension with a nested IF statement to group ages together

A banking organization needs a dashboard that shows the following:A KPI indicator for current year (CY) versus last year (LY) revenueA scatter plot that shows the cost versus revenue of product categoriesA treemap that shows average customer satisfaction rating based on regionsA table that shows CY cost by record number, financial instrument, and bankIn addition to the customer satisfaction rating, which fields should be used to create the required measures?

• CY Revenue, LY Revenue, CY Cost
• CY Revenue, LY Revenue, Cost
• Revenue and Cost
• Revenue and CY Cost

Two customers in an organization want to use an app that contains a finance data set. With different analysis objectives, each customer will only use a subset of that data. Which procedure should the business analyst follow?

• Apply Section Access to manage the data for each customer
• Create multiple visualizations using set analysis
• Duplicate and rename the apps for each customer
• Unpivot, then re-associate the data tables for each customer

A company has sales data where every Customer ID can be assigned to one or more Sales Account ID. Sales Accounts are assigned to one of eight Groups. The business analyst is creating an app with the following requirements:Each Group should have a separate sheetThe Sales Account can only see its own customersThe Sales Account can navigate only to the sheet for the Group assignedThe business analyst has created a Section Access table, in which each Sales Account ID is assigned their CustomerlDs. Which action should the business analyst take next?

• Use the Sales Account ID as a filter on the show/hide condition on the relevant sheet
• Use the Group as a filter on the show/hide condition on the relevant sheet
• Use the Group field within the Section Access table, then apply it to the show/hide condition of the sheets
• Use the OSUser() function within the show/hide condition of the sheets to set the required
• visibility

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 clearly to a large audienceAnswer audience questions dynamicallyBe made available as shared contentEmphasize important sales revenueWhich Qlik Sense features should the business analyst prepare?

• Embed a video player in the shared app with a recording to describe the charts
• Create a sheet that features colorful and layered visualizations and export as a PDF
• Set up NPrinting to connect to the app and design a si ides how-style report
• Create a storytelling narration in a published app that contains embedded sheets

A marketing team needs to display sales for a limited number of products by providing a bar chart that the user can control. The visualization has several requirements:Starts with the top five productsAllows the user to change the number of products displayedAllows the user to scroll through all products on a mini chartThe business analyst creates a bar chat and a variable. Which steps should the business analyst complete next?

• Add the slider object and use the variable to set its value
• Set the number of bars to custom and use the variable to set its value B.
• Use the variable to fix the limitation
• Add an input box to enable the user to enter the required value C.
• Use the variable to fix the limitation
• Add a slider object and use the variable to set its value D.
• Add the slider object and use the variable to set its value
• Use the properties to set the number of bars to custom

A customer needs to demonstrate the value of sales for each month of the year with a rolling 3- month summary. Which visualization should the business analyst recommend to meet the customer's needs?

• Scatter plot
• Mekko chart
• Combo chart
• Pie chart