QSBA2021 Practice Test Questions Updated 52 Questions
Qlik QSBA2021 Dumps - Secret To Pass in First Attempt
Qlik QSBA2021 is a certification exam that focuses on the skills and knowledge required for business analysts to work with Qlik Sense, one of the most powerful and widely used business intelligence (BI) tools in the market. The exam is based on the February 2021 release of the software, which introduces several new features and enhancements to the platform. Passing this exam is a great way for business analysts to demonstrate their proficiency in using Qlik Sense to drive data-driven decision-making in their organization.
NEW QUESTION # 15
Refer to the exhibit.
A business analyst needs to display a bat chart only when less than 100 customers are selected What should the business analyst create to meet this requirement
- A. A show, hide container using a bar chart and set the show condition to Count(Distinct CustomerlD) <100
- B. A bar chart and in the Add-ons set the calculation condition 10 Count(DlSTINCT CustomerlD) < 100
- C. A bar chart and in the Add-ons, set the calculation condition to Count(Customer ID) < 100
- D. A show/hide container using a master item bar chart and set the show condition to Count(CustomerlD) < 100
Answer: A
NEW QUESTION # 16
Refer to the exhibit.
A business analyst needs to add a table and make sure it is associated appropriately. The table contains regional information about employee offices and must be able to titer the orders by employee office.
Which steps should the business analyst take?
- A. 1. Select the Offices bubble
2. Move the Offices bubble on top of the Employees bubble
3. Select the associated field - B. 1. Select the Offices bubble and click the more options menu
2. Select concatenate or join option then select concatenate option from the drop-down menu
3. Select the Employees bubble - C. 1. Click the Offices bubble
2. Click Synchronize scripted tables
3. Move the Offices bubble on top of the Employees bubble - D. 1. Select the Employees bubble
2. Move the Employees bubble on top of the Offices bubble
3. Select the associated field
Answer: A
NEW QUESTION # 17
A business analyst creates an app for a large retailer The app is based on me past ^2 months of transactional data in CSV formal After successfully demonstrating the app the retailer provides a tile that contains another seven years of data After the new data is loaded the previously responsive app takes 10 times longer to respond to users' selections The app has many complex expressions Which two actions should the business analyst take to resolve the issues? (Select two)
- A. Use JOIN statements to reduce the number of tables m the data model
- B. Create versions of the app using a WHERE clause m the data manager to restrict the data
- C. Request the data architect to create flags in the data model to optimize set analysis expressions
- D. Replace set analysis with calculated fields in the data manager
- E. Make sure a I master items contain variables that define the expressions
Answer: C,E
NEW QUESTION # 18
How does the Qlik Associative Engine analyze data from one or more data sources?
- A. Combines multiple data sources without pre-aggregation
- B. Associates data into cubes to enable multidimensional analysis
- C. Inner joins multiple data sources together to remove unrequired information
- D. Creates a set of pre aggregated queries for Qlik Sense to run
Answer: D
NEW QUESTION # 19
A business analyst s creating an app for the sales team. The app must meet several requirements
* Compare 10 top -performing sales representatives and the amount of sales for each
* Investigate margin percentage and total sales by each product category
* View distribution of sales amount
Which visualizations should be used for this app?
- A. A bar chart, line chart, and scatter plot
- B. A treemap box plot, and histogram
- C. A treemap container and distribution plot
- D. A bar chart scatter plot and histogram
Answer: B
NEW QUESTION # 20
A business analyst is creating a story One visualization must be scaled only vertically. Which steps are needed to apply this in the storytelling view?
- A. Select Edit on the visualization and enter the new height
- B. Select the Effects library to rescale the visualization
- C. Select Unlock the snapshot and rescale the visualization
- D. Select Edit in the Snapshot library and rescale the visualization
Answer: D
NEW QUESTION # 21
A business analyst needs to uniquely identify tour sheets in the app overview Custom images have been created for each sheet What should the business analyst do next?
- A. Add the images from the snapshot library
- B. Drag and drop the images onto the sheet edit view
- C. Use the media library to upload the mages
- D. Open the assets panel to drag and drop the images
Answer: C
NEW QUESTION # 22
A customer wants to perform a regional sates analysis to learn how products set over time m different areas The business analyst needs to design a sheet in the app tor business users to perform several tasks
* Select two different groups of countries to study
* Compare sales over time between these two groups using a bar chart
* Change the group items by selecting different countries at any time
* Select a time range in the bar chart and drill-down to daily transactional sales Which steps should the business anaryst follow to meet these requirements?
- A. * Create one Alternate State Set1
* Create two Filter Panels one associated to this Set1 and one Default State(S)
* Create a Bar chart with the drill-down dimension and two measures sum({Set1'$} Sales)and sum({'Set1"S) Sales) - B. * Create one Alternate State Set1
* Create two Filter Panels one associated lo this Set1 and one Default State1($)
* Create a Bar chart with the drill-down dimension and two measures sum({Set1-$) Sales) and sum('Set1-S) Sales) - C. * Create two Alternate States Sell and Set2
* Create two Finer Panels each associated with an Alternate Stale
* Create a Bar chart with drill-down dimension and two measures sum({Set1'S} Sates) and sum({,Set2'*S} Sales) - D. * Create two Alternate States Set1 and Set2
* Create two Filter Panels each associated with an Alternate State
* Create a Bar chart with a drill-down dimension and two measures sum({Set1'$} Sales) and sum{fSet2"S} Sales)
Answer: C
NEW QUESTION # 23
A company that manages several tennis clubs uses an app mat includes three master measures TotalCost, Totallncome. and TotalMargin A business analyst needs to create a new table that utilizes master items and meets the following requirements:
* Number of bookings that users make
* Cost associated with booking (including electricity and indirect costs)
* Income obtained and profit originated m each booking
* Sales margin: percentage of margin over income
* Detail by tennis clubs
Which optimal expressions should the business analyst use?
- A. * count(dislinct BookinglD)
* [TolalCost]
* [Totalincome]
* [Totalincome|-[TotalCost]
* [TotalMargin]/[Totalllncome}*100 - B. * count(dislinct BookinglD)
* [TolalCost]
* [Totalincomel
* ITotalincome|-[TotalCost]
* [TotalMargin]/{Totalllncome}*100 - C. * count(BookinglD)
* [TolalCost]
* [Totalincomel
* sum(income|-sum[TotalCost]
* [TotalMargin]-sum(Cost)/sumTotal(lncome)*100 - D. * count(distinct BookinglO)
* [TolalCost]
* [Totalincomel
* ITotalincome|-[TotalCost]
* [TotalMargin]/{Totalllncome}*100
Answer: A
NEW QUESTION # 24
A business analyst needs to develop a visualization that compares performances of every product the company sells and each product category. The CEO wants to highlight the worst- and best-performing products and categories in a meeting that beg/is in one hour Using a bar chart which two approaches should the business analyst use? (Select two.)
- A. Stack dimensions and color by measure
- B. Alternative dimensions using fixed number limitations
- C. Stack dimensions and color by dimension
- D. Alternative dimensions and diverging color scheme
- E. Stacked bar chart using ColorMix function
Answer: D,E
NEW QUESTION # 25
Refer to the exhibit.
A business analyst is modifying a box plot End users report unexpected blue dots in a box plot What should the business analyst do?
- A. Under the Dimensions menu, deselect Include null values
- B. Under Box plot elements, select Whisker length and increase to two interquartile ranges
- C. Under Box plot elements deselect Include outliers
- D. Ask the data architect to modify the data model
Answer: B
NEW QUESTION # 26
A business analyst needs to create a master item from an object m an app After right-clicking the object the analyst notices the Add to master Items option is NOT available. What should the business analyst do to fix this issue?
- A. Disable chart suggestions
- B. Unlock the object
- C. Unlink the object
- D. Remove the master items tag
Answer: D
NEW QUESTION # 27
Refer to the exhibit.
What is the selection slate of light gray values?
- A. Alternative
- B. Selected
- C. Possible
- D. Excluded
Answer: D
NEW QUESTION # 28
A business analyst has access to all of a company's data tor the past 10 years The source table consists of the following fields Transactions Transaction Time Transaction Date Transaction Year Cardholder Cardholder address Cardissuer and Amount Users request to create an app based on this source Users only review me data for the past 2 years Data must be updated daily Users do not view cardholder into What should the business analyst do to reprove the app performance?
- A. 1. Deselect Cardholder and time field in data manager
2. Use a pant based on auto-calendar fields
3. Perform a daily reload via the data manager - B. 1. Delete Cardholder and time fields in data manager
2. Use set analysis to show data based on transaction year
3. Use an API to perform a daily reload task - C. 1. Delete Cardholder and time fields in data manager
2. Use a bookmark based on auto-calendar fields
3. Use the reload function in the sheet Editor asset panel - D. 1. Deselect Cardholder and time fields in data manager
2. Apply a filter to extract data based on transaction year
3. Request a daily reload task from the System Admin
Answer: C
NEW QUESTION # 29
A business analyst is creating an app for technicians. The app must meet several requirements
* Visualization labels must change according to the selected tame period
* A button to toggle between Month and Year to Date (YTD)
* Two fields combine to create one dimension that is used m several visualizations Which three options are needed to meet the requirements? (Select three.)
- A. Set analysis
- B. Alternate states
- C. Master items
- D. Variables
- E. Calculated fields
Answer: C,D,E
NEW QUESTION # 30
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 dearly to a large audience
* Answer audience questions dynamically
* Be made available as shared content
* Emphasize important sales revenue
Which Qlik Sense features must the business analyst prepare?
- A. Embed a video player m the shared app with a recording to describe the charts
- B. Create a sheet that features colorful and layered visualizations and export as a PDF
- C. Set up Nprinting to connect to the app and design a slideshow-style report
- D. Create a storytelling narration m a published app that contains embedded sheets
Answer: A
NEW QUESTION # 31
After a campaign a marketing group has data that snows distinct increases of product sales over a 12-month period. The group needs to highlight the products that show the highest revenue.
What should be developed to meet this requirement?
- A. Grid chart with diverging color by measure
- B. Line chart with area gradient color by measure
- C. Mekko chart with diverging color by dimension
- D. Waterfall chart with custom positive value color
Answer: C
NEW QUESTION # 32
A large auditing firm has a proprietary web portal that all of the' customers use to access their own dat a. The owner of the portal has asked if it is possible to embed some Ok visualizations within the portal when will present the data back to the Individual customers.
The data within the visualizations must be live and provide up-to-date data every time the customer logs in to the portal and updates when the Qlik Series app is reloaded.
What should the business analyst recommend?
- A. ODAG
- B. Qlik APIs
- C. Embedded Stories
- D. Qlik Dynamic \news
Answer: C
NEW QUESTION # 33
The sales manager is investigating the relationship between Sales and Margin to determine if this relationship is linear when choosing the dimension Customer or Product Category The sales manager wants to have the potential percentage Sales tor each Stage (initial to Won) of the sales process What are the two correct visualizations?
- A. Scatter Plot Measures X-axis Sates and Y-axis Margin Dimensions Customer or Product category Bar Chart Dimension Stage, Measure Sates
- B. Combo Chan Measures Sales and Margin Dimensions Customer or Product category Pie Chart Dimension Stage Measure Sales
- C. Distribution Plot Alternatives Measures Sales and Margin Alternatives dimensions Customer or Product category Bar Chart Dimension Stage. Measure Sates
- D. Scatter Plot Measures X-axis Sates and Y-axis Margin Alternatives dimensions Customer or Product category Funnel Chart Segments Stage Width Sales
Answer: D
NEW QUESTION # 34
A business analyst must add data from several tables to an existing app This app was built by a previous business analyst who used the data load editor to load some simple tables.
The changes must be implemented in the data manager
Which three actions should the business analyst take to matt these requirements? (Select three )
- A. Synchronize the new tables and modify the tables
- B. Synchronize the scripted tables and modify the tables
- C. Add the new tables via the Add data icon
- D. Associate the new tables with the old tables
- E. Delete the existing tables and re-import the tables
Answer: A,B,C
NEW QUESTION # 35
......
Qlik QSBA2021 Exam Dumps [2023] Practice Valid Exam Dumps Question: https://troytec.itpassleader.com/Qlik/QSBA2021-dumps-pass-exam.html