Online Access Free QSBA2024 Practice Test

A business analyst is working with retail data for consumer products. The customer is interested in the following:
* Ability to look for outliers on sales volume and margin %
* Ability to understand the clustering of products visually
* Ability to see products that are above the median sales volume
Which action should the business analyst take to implement these requirements?

• A.Create a pivot table and color the sales volume cell using K-Means function and median sales volume as an additional column
• B.Create a scatter plot using K-Means to color the products and add a median sales volume reference line
• C.Create a combo chart with K-Means colors for the bar and a line measure representing median sales volume
• D.Create a treemap visualization showing sales volume and margin% by product with the median sales volume in the title

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?

• A.Action Buttons
• B.Storytelling
• C.Insight Advisor Chat
• D.Bookmarks

A business analyst is creating a data model from several Excel files that contain several hundred thousand rows of dat a. The requirements include:
* Users need to drill down to various details within the available data set.
* Several final measures will be repeatedly used. These final measures require combining several fields in a single table.
* User experience and load time is a high priority.
Which action should the business analyst take to meet these requirements?

• A.Develop a master item using the required source fields
• B.Combine the source fields and create additional fields in Excel
• C.Combine the various source fields in a calculated item in the Data manager
• D.Aggregate the data to the source period

A company has recently implemented Qlik Sense. A user is looking to use natural language questions to help create content. Which feature can achieve this goal?

• A.Story and Bookmarks
• B.Associative Engine
• C.Insights Advisor Chat
• D.Advanced Authoring

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 sheet
* The Sales Account can only see its own customers
* The Sales Account can navigate only to the sheet for the Group assigned The 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?

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