QlikView QSBA2024 - Qlik Sense Business Analyst Exam
Page: 3 / 10
Total 50 questions
Question #11 (Topic: Exam A)
A business analyst designs a visualization to analyze a count of products by fixed price ranges. The customer now wants the price ranges to be dynamically modified so they are configurable by the application users. The business analyst modified the dimension axis on the visualization.
Which step should the business analyst complete next?
Which step should the business analyst complete next?
A. Define a variable and use it in a variable input object on the sheet
B. Create a calculated field in Data manager, using the Class() function
C. Load an independent source file to contain the user-defined boundary values
D. Create the price range dimension using the Buckets feature in Data manager
Answer: A
Question #12 (Topic: Exam A)
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 dashboard
• Given 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?
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 dashboard
• Given 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?
A. Ask the ServiceNow team to create the field in the source dataset
B. Create an Excel sheet with all possible age values and the corresponding categories to add to the data model
C. Create a new field for the categories using the Bucket option in the Data manager
D. Write a master dimension with a nested IF statement to group ages together
Answer: A
Question #13 (Topic: Exam A)
A dashboard developer finishes creating a supply chain analysis app and is presenting it to leadership for review. The landing page shows four visualizations including:
• Bar chart showing available supply by product category
• Line chart showing total cost of deliveries to the warehouse by month-year
• Scatter plot showing cost of delivery and time-to-deliver by product
• A map that shows the volume of delivery from suppliers to warehouses using a line layer
Leadership asks the developer how they can see the total cost of delivery overall.
How can the analyst show this information to leadership?
• Bar chart showing available supply by product category
• Line chart showing total cost of deliveries to the warehouse by month-year
• Scatter plot showing cost of delivery and time-to-deliver by product
• A map that shows the volume of delivery from suppliers to warehouses using a line layer
Leadership asks the developer how they can see the total cost of delivery overall.
How can the analyst show this information to leadership?
A. Use the line chart to add up each month-year to get to the number required
B. Create a KPI object that shows the total cost of delivery
C. Adjust the line layer on the map to reflect cost of delivery
D. Select all products in the scatter plot to see the total delivery cost
Answer: B
Question #14 (Topic: Exam A)
A business analyst needs to create two side-by-side charts for a sales department with the following data:
• Number of orders
• Name of the customer
• Percentage of margin
• Total sales
The charts use a common dimension, but each chart has different measures. The analyst needs to create a color association between the two charts on the dimension values.
Which action should the business analyst take?
• Number of orders
• Name of the customer
• Percentage of margin
• Total sales
The charts use a common dimension, but each chart has different measures. The analyst needs to create a color association between the two charts on the dimension values.
Which action should the business analyst take?
A. Use nested IF statements to set the colors by expression for each dimension value
B. Define the color values in the master measures and use the color library
C. Select 'By Dimension' and 'Persistent colors' in the Colors property panel
D. Use the FieldIndex function to set the colors by expression for each dimension value
Answer: C
Question #15 (Topic: Exam A)
A business analyst has access to all of a company's data for the past 10 years. The source table consists of the following fields: TransactionID, TransactionTime, TransactionDate, TransactionYear, Cardholder, Cardholder address, Cardissuer, and Amount.
Users request to create an app based on this source with the following requirements:
• Users only review the data for the past 2 years
• Data must be updated daily
• Users should not view cardholder info
Which steps should the business analyst complete to improve the app performance?
Users request to create an app based on this source with the following requirements:
• Users only review the data for the past 2 years
• Data must be updated daily
• Users should not view cardholder info
Which steps should the business analyst complete to improve the app performance?
A. • Delete Cardholder and time fields in Data manager
• Use a bookmark based on auto-calendar fields
• Use the reload function in the sheet Editor asset panel B. • Delete Cardholder and time fields in Data manager
• Use set analysis to show data based on transaction year
• Use an API to perform a daily reload task C. • Deselect Cardholder and time fields in Data manager
• Use a filter pane based on auto-calendar fields
• Perform a daily reload via the Data manager D. • Deselect Cardholder and time fields in Data manager
• Apply a filter to extract data based on transaction year
• Request a daily reload task from the system admin
• Use a bookmark based on auto-calendar fields
• Use the reload function in the sheet Editor asset panel B. • Delete Cardholder and time fields in Data manager
• Use set analysis to show data based on transaction year
• Use an API to perform a daily reload task C. • Deselect Cardholder and time fields in Data manager
• Use a filter pane based on auto-calendar fields
• Perform a daily reload via the Data manager D. • Deselect Cardholder and time fields in Data manager
• Apply a filter to extract data based on transaction year
• Request a daily reload task from the system admin
Answer: D
