Online Access Free QSBA2024 Exam Questions

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 scatter plot using K-Means to color the products and add a median sales volume reference line
• B.Create a pivot table and color the sales volume cell using K-Means function and median sales volume as an additional column
• 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

A business analyst receives an image of a dashboard from the HR Director and is asked to recreate the image in Qlik Sense. The image shows charts for:
* Company employee structure
* Average employee salary by region
* Geographical representation of office capacity
* Company retention over time
Which charts will meet these analysis requirements?

• A.Map chart, org chart, line chart, bar chart
• B.Line chart, sankey chart, map chart, bar chart
• C.Line chart, network chart, bar chart, map chart
• D.Map chart, grid chart, line chart, KPI chart

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

A business analyst using a shared folder mapped to S:\488957004\ receives an Excel file with more than 100 columns. Many of the columns are duplicates. Any current columns that should be used have the suffix '_c' appended to the column name.
Which action should the business analyst take to load the Excel data?

• A.Load all columns because the recommended associations will use only columns with the suffix '_c'
• B.Open the Excel file, remove all columns that do not have the suffix '_c', and save the file to be loaded
• C.Deselect the fields that do not have the '_c' suffix in the Data manager table preview
• D.Utilize filter functionality in the Data manager to select only columns with the suffix '_c' with a filter condition

A business analyst is building an app to analyze virus outbreaks. They create a bar chart using a dimension of Continent, and a measure of Sum (Knowning sections). They require a secondary bar on the chart, so they create a second measure using Count (MajorCities).
The bar chart adjusts, but no bars are visible for this second measure. Which action should the business analyst take to resolve this issue?

• A.Convert the bar chart to a combo chart and reconfigure the second measure to be a bar
• B.Change the Y-axis Range scale from Auto to Custom and select a suitable Max value
• C.Recreate the second measure as an alternative measure
• D.Enable Value labels within the Presentation section of the Appearance properties