Download QLIK SENSE BUSINESS ANALYST (QSBA) CERTIFICATION ACTUAL EXAM WITH CORRECT ACTUAL QUESTIONS and more Exams Business Administration in PDF only on Docsity!
QLIK SENSE BUSINESS ANALYST (QSBA)
CERTIFICATION ACTUAL EXAM WITH CORRECT
ACTUAL QUESTIONS AND CORRECTLY WELL
DEFINED ANSWERS LATEST 2025 ALREADY
GRADED A+
A company is starting to use a new customer account system. The business analyst must include this data in an existing app. Data from the legacy customer account system is already available in the app. Both tables have similar data, but the columns have different names.
Which actions should the business analyst take to merge data from both systems?
- ANSWERS-1. Select Legacy Accounts
- Click Concatenate tables
- Select New Customer Accounts
- Map the tables
- Click Apply
A business analyst is creating a dashboard to analyze supply chains. The app must contain several elements:
- A bar chart that shows a number of products and product groups handled by shipper- A map that shows the number of shipments sent from factory locations- A bar chart that shows average delivery costs by shipper
Which dimensions should the business analyst use for this app? - ANSWERS- Shipper, FactoryLocation
What does the color light gray indicate in the selections tool? - ANSWERS-The field value is an alternative selection
A business analyst must provide a visualization to show the trends of the number of orders generated per employee. The Customer must be searchable. EmployeeID, EmployeeName, OrderID, and CustomerID will be included in the load.
Which additional fields must be loaded to meet this requirement? - ANSWERS- OrderDate, Customer
A range of colors between red (using code RGB(229,20,0)) and green (using code RGB(164,196,23)) needs to be used as a gradient in a scatter plot that displays sales and cost by store. The gradient needs to produce visualization shown in the exhibit.
What is the most efficient method a business analyst should use to meet this requirement? - ANSWERS-Modify the visualization to set a color for the data points with an expression based on a Colormix 1 function
Qlik GeoAnalytics allows you to... - ANSWERS-Create map visualizations and apply location-based analytics and functions.
A retailer with 300 locations worldwide needs to analyze its workforce to prepare for its next board meeting. The two most important items to the board members are total compensation and number of employees by city.
Which visualization should a business analyst use to meet this requirement? - ANSWERS-Scatter plot
After the latest data reload, a business analyst notices the value for CategoryID 'B321 appears to be different from the other values. What is causing this difference? - ANSWERS-Pre-aggregated data is being used
A business analyst must create new master items for quarterly calendar measures with company-specific naming conventions based on:
- The Date field and the Sum of Sales- The new master items will calculate QTD Sales, Current QTD Sales, Last QTD Sales, Current Quarter Sales, Last Year Current Quarter Sales, and Last Quarter Sales
Which three steps should the business analyst take to meet these requirements? - ANSWERS-Save to master items, rename master items
Right-click the Sales field in the assets panel and select Create calendar measures
Select Date, Sales, Sum, and Quarterly
A business analyst needs to present a one-slide story and be able to make selections in a visualization. How should the business analyst meet this requirement? - ANSWERS-Create a story and add a sheet from the sheet library that contains the visualization
Which of the following statements is true about master items? - ANSWERS- Master items reusable assets that can be used throughout the app.
A marketing company must analyze the age of customers who view movies at a theater at least once a month, and where those customers are located. The business analyst must consider several requirements:
- Age of customers- Addresses of customers- Frequency of theater visits
Which objects should a business analyst use to visualize these requirements? - ANSWERS-A histogram and map
Which three actions can a business analyst complete in the Qlick Sense Enterprise hub? - ANSWERS-Publish an app into a stream
Publish a sheet into the Community section
Load data from multiple sources
A company has customers in 16 countries. The majority of the customers are in Germany A business analyst creates a fitter pane for Country and wants "Germany" listed first. The rest of the countries should be listed in alphabetical order.
A business analyst must arrange the sheets within an app to logically guide user interactions. Which order should the business analyst use to meet this requirement? - ANSWERS-High-level dashboard, interactive analysis, reports
A business analyst must create a set of managed reports that:
- Can be distributed via email- Has a central resource so users can view historical reports- Will have a format so that the users can add content- Will refresh and distribute reports on a schedule- Enables users to manage their own report subscriptions
Which Qlik capability should the business analyst use to meet these requirements? - ANSWERS-Qlik NPrinting
Visualization design is about encoding data, that is, mapping data onto graphical elements. What is the most efficient of these encodings? - ANSWERS-Length
To analyze current office space utilization, a business analyst must create an office floor plan to show employee density and movements. What are the requirements to create the office floor plan? - ANSWERS-A KML file with the floor plan shapes, the office movements, and employee location
A business analyst creates a bar chart and notices the weekdays are NOT in a US default format. The analyst does NOT have permissions to enter the data load editor and edit the data. The analyst only has a few minutes before the meeting to show the insights to a manager. The business analyst wants to quickly customize the chart to show the weekdays in US format.
Which action should the business analyst take to fix the chart? - ANSWERS- Change the dimension to a calculated dimension using the REPLACE() function.
Which of the following statements is correct? - ANSWERS-The grouping, by which you want to show results in a chart is known as the dimension.
A business analyst is using a box plot to show distribution. The data scientist provides the formulas to configure a custom box plot. Which action(s) should the business analyst take to meet these requirements? - ANSWERS-Under Box plot elements, disable Use presets and enter the given formulas in the expressions field
A business analyst needs to add a reference line to a bar chart. Which action should the business analyst take to meet this requirement? - ANSWERS-Create a reference line using Max(Aggr(Sum(Sales),CompanyName))
A sales department has a pie chart that displays the total amount of sales by city. Users have requested several changes to the pie chart:
- Display the labels in 'Red'- Increase the font size of the title- Change the color of the values to 'Blue'
Which technique should a business analyst use to meet these requirements? - ANSWERS-Create a custom theme
A business analyst needs to make a complex pie chart easier to understand. The pie chart shows the total number of customers by customer type. There are 12 customer types. Some customers do NOT have a type assigned.
The business analyst needs to:
Bookmarks
A business analyst is building an app for a customer:
The customer wants to be able to:
- Show row-level transaction details- Access an overview of the most important numbers- Analyze data
How should the business analyst order the sheets to meet these requirements? - ANSWERS-1. Report: sheet for the row-level details
- Dashboard: sheet for the overview
- Analysis: sheet for the analysis
Which of the following statements is correct? - ANSWERS-In a data story, you can create two types of slides. Blank and Embedded sheet.
A wholesaler needs to show sales and products in a PowerPoint presentation.
The dimensions and measures are:
- Product Name- Sum of Sales- Number of Orders
Which two chart types could the business analyst use to meet these requirements? - ANSWERS-Combo Chart
Scatter Plot
A CEO of an automotive manufacturing company wants a single dashboard sheet to track the company's sales.
The app must meet several requirements:
- All charts must be on one sheet
- Show summary charts of key performance data
- Ability to scroll up and down the sheet
Which set of actions should the business analyst use to meet these requirement?
- ANSWERS-Use KPI objects Activate Extend sheet
A business analyst must update an app by adding a new table called 'Invoices'. This table must be associated to the existing model via reference code values. There is NO column available with reference codes in the Invoices table.
This information can only be retrieved by splitting a field called 'Full Invoice No' from the Invoices table 'Full Invoice No' includes the 'CostCenter Code', the 'Department Code', and a 'Reference Code' The CostCenter Code is NOT relevant for further analysis, so the analyst must split this new field into two new columns.
Which set of actions should the business analyst take to meet these requirements? - ANSWERS-Select the split marker Click All instances
Uncheck the first column
Rename the fields
Click Create fields
A business analyst uses the data manager to load customer data from a QVD file. The data manager automatically profiles the data, and recognizes City and Country values as Geo data.
Which of the following statements is correct? - ANSWERS-When you use Qlik Sense on a very small screen (480 pixels wide or smaller), you can make selections and navigate between apps, sheets, visualizations, and stories, but you cannot create new content or take snapshots.
A business analyst develops apps for users to independently visualize their data to gain insights. The users have desktop computers, tablets, and mobile devices. When creating the apps, the business analyst does NOT need to know the specific device on which it will be consumed. - ANSWERS-Responsive design
A business analyst needs to add some images to a slide in a story in their personal workspace in Qlik Sense Enterprise. What should the business analyst do to meet this requirement? - ANSWERS-Upload the images to the media library and add to the story slide
A business analyst needs to create an app showing sales data. The app requirements are as follows:
- Compare sales for the current year (CY Sales) versus last year (LY Sales)- CY Sales must always be displayed in blue- LY Sales must always be displayed in yellow
Which steps should the business analyst take to meet these requirements? - ANSWERS-1. Create CY Sales and LY Sales measures as master items and set the required color for each measure2. Create one KPI from the two master item measures
A business analyst creates a scatter plot and wants to save it for reuse by colleagues. The business analyst must remain the owner of this scatter plot, and should be the only person allowed to make changes. These changes should be applied automatically to all instances of this visualization.
Which two actions should the business analyst take to meet these requirements?
- ANSWERS-Publish the app to the Everyone stream
Add the finished scatter plot to the master items
A large organization with more than 100 departments wants to raise money for a donation in the next 30 days. This year, leadership decides to increase employee participation through a competition. Team members of departments that raise $10,000 or more receive two additional holidays.
Leadership needs the following capabilities:- Ability to view the total donation amount- Ability to identify departments that raise $10,000 or more
Which two visualizations should the business analyst use without set analysis to meet these requirements? - ANSWERS-KPI
Bar Chart
A business analyst is testing an existing app that returns unexpected results. Using the selection tool, the business analyst observes the following behavior. Select a CompanyName and the associated OrderID records are white Select a Year and all OrderID records are gray Select an OrderID and the Quarter values are all gray, but the CompanyNames are white Select a ProductID and the associated ShipperName and OrderDates are white, but the Year is gray
What is causing these results? - ANSWERS-The logical model is NOT a star schema
You want to show results in multiple currencies. Select the easiest approach to maintain. - ANSWERS-Load currency exchange rates table using Qlik DataMarket
- Add a line chart with Manager as the dimension and Sales as the measure
A business analyst must combine the following bar charts on one sheet in a story:
- A bar chart that updates with live data- A bar chart that shows static data from a previous period
How should the business analyst meet this requirement? - ANSWERS-Embed a sheet with the bar chart for live data, then add a snapshot of the bar chart for the static data
A printing company has several requirements for a new Qlick Sense app:
- Report of daily work orders- Total number of print jobs- Print jobs based on region- Total number of print jobs by month
The app will be used by executives, sales managers, sales representatives, and press workers. Which sheets should a business analyst build to meet these requirements? - ANSWERS-Sheet 1: Details page that shows the daily print jobs in a tableSheet
2: Dashboard with a KPI visualization of total print jobs by month, customer, sales representative, and regionSheet
3: Report page that shows the daily print jobs
A business analyst is building a dashboard to track customer loyalty. The app has several requirements:
A table that shows the total number of purchases by customer
A scatter plot that shows the correlation between the number of purchases and total spent by customer
A bar chart that shows the top five customers by sales
Which two measures should the business analyst use to meet these requirements? - ANSWERS-Number of Purchases
Purchase Amount
A business analyst is NOT familiar with the data and is using insight advisor to create a number of visualizations. Which steps should the business analyst take to add the visualizations to a sheet? - ANSWERS-Click Generate insights to find visualizations, then click Add to sheet
A business analyst must analyze sales using an existing sales order app.- The Orders table in the app was added from a QVD file using the data manager- The Orders table in the app and the QVD do NOT contain a SalesAmount field- SalesAmount can be calculated by multiplying the Quantity and UnitPrice
How should the business analyst add a SalesAmount field into the Orders table? - ANSWERS-In the data manager, add a calculated field named SalesAmount with the expression UnitPrice *Quantity
A manufacturer uses a dashboard for analysis Users created many bookmarks to simplify their workflow. An administrator also created some bookmarks in the app based on user feedback The organization needs to republish the app and maintain both the users' and administrator's bookmarks.
Which steps should the business analyst take to meet this requirement? - ANSWERS-Duplicate the app in Work
Which two actions can the users perform? - ANSWERS-Create charts using dimensions and measures from master items
Export stories created in the app to a PDF of PowerPoint format
Refer to the exhibits.
A business analyst must improve the first chart shown to make it look like the second chart. Which two actions should the business analyst take to meet this requirements? - ANSWERS-Add Year as an additional dimension
Replace the three measures with one measure that calculated Total Sales
