Updated Apr-2023 Official licence for QSBA2021 Certified by QSBA2021 Dumps PDF [Q20-Q37]

Updated Apr-2023 Official licence for QSBA2021 Certified by QSBA2021 Dumps PDF

Grab latest Amazon QSBA2021 Dumps as PDF Updated on 2023

The Qlik QSBA2021 certification exam is a comprehensive exam that covers a wide range of topics related to Qlik Sense Business Analyst. The exam consists of 50 multiple-choice questions and has a time limit of 2 hours. The exam is administered by Pearson VUE, which is a global leader in computer-based testing. The passing score for the exam is 70%, and certification is valid for 2 years.

NEW QUESTION # 20
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 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
B. 1. Click the Offices bubble
2. Click Synchronize scripted tables
3. Move the Offices bubble on top of the Employees bubble
C. 1. Select the Offices bubble
2. Move the Offices bubble on top of the Employees bubble
3. Select the associated field
D. 1. Select the Employees bubble
2. Move the Employees bubble on top of the Offices bubble
3. Select the associated field

Answer: C

NEW QUESTION # 21
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. Create versions of the app using a WHERE clause m the data manager to restrict the data
B. Request the data architect to create flags in the data model to optimize set analysis expressions
C. Use JOIN statements to reduce the number of tables m the data model
D. Make sure a I master items contain variables that define the expressions
E. Replace set analysis with calculated fields in the data manager

Answer: B,D

NEW QUESTION # 22
Country
USA
US
U,S,A
Refer to the exhibit.
A business analyst needs to load several data files and notices that some of the values for the United States of America are formatted inconsistently.
What should the business analyst do?

A. Use the filter and rename the country values
B. Use data profiling 10 hide the inconsistent country names
C. Use data profiling and replace the country names
D. Use data profiling to group the country values

Answer: B

NEW QUESTION # 23
Several departments use an app. The business analyst needs to modify access to the sheets so that each department can access their sheets only What should me business analyst do?

A. Choose to add a bookmark for each department
B. Use the Stones feature to create a story with embedded sheets for each department
C. Edit the Show Condition expression field in the sheets tor each department
D. Create sheets with alternate states for each department

Answer: A

NEW QUESTION # 24
A business analyst needs to share a link to a specific visualization with colleagues Which steps should the business analyst use?

A. 1. Go to the Dev Hub and select Single Configurator
2. Select Add data
3. Copy the URL from the browser and share with colleagues
B. 1. Right-click the visualization and select View data
2. Select Export data
3. Share the provided link with colleagues
C. 1. Go to the OMC and select App Object
2. Right-click the correct visualization to get the URL
3. Share the URL with colleagues
D. 1. Right-click the visualization and select Share
2. Select </> Embed
3. Copy the URL and share with colleagues

Answer: C

NEW QUESTION # 25
Refer to the exhibit.

These tables have the same structure. The Customers information is as shown in the Data Model Viewer In a sheet called "Customer Analysis" there is a filter pane with Customers.
A business analyst s developing an app for the Sales department and loads the data about Customers from two files.
The business analyst wants the values to appear as they were loaded How should this issue be resolved?

A. Disable Sorting Auto and uncheck all options.
B. Enable Sort by State and select Descending.
C. Enable Sort by Expression ReloadTime().
D. Disable Sorting Auto and uncheck Sort Numerically.

Answer: C

NEW QUESTION # 26
A business analyst ;s creating an app tor the team. A set of selections must be applied every time an app is opened.
What should the business analyst do to meet this requirement?

A. Use Section access to predefine tie default selections
B. Use a sheet action and apply a bookmark named 'Default'
C. Create a bookmark and select 'Set selections as app default"
D. Create a masnup and use the API to apply default selections

Answer: B

NEW QUESTION # 27
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. Line chart with area gradient color by measure
B. Mekko chart with diverging color by dimension
C. Grid chart with diverging color by measure
D. Waterfall chart with custom positive value color

Answer: B

NEW QUESTION # 28
Refer to the exhibit.

A CEO wants to use a similar visualization on the company's dashboards
The visualization must meet several requirements
* Show three years of sales data
* Display sales trends by month
* Allow comparison of years using an area style display
Which set of actions should a business analyst take to meet these requirements?

A. * Add a ,line chart
* Add a master drill-down dimension with Year and Month
* Add Sum(Sates) as the measure
* In the properties panel under Presentation, select Area
B. * Add an area chart
* Add Month first then Year as the dimensions
* Add SumfSates) as the measure
* In the properties panel under Area select the dimension Year
C. * Add an area chart
* Add Year first then Month as the dimensions
* Add Sum(Sales) as the measure
* In the properties panel under Area select the dimensions
D. * Add a fine chart
* Add Month first then Year as the dimensions
* Add Surry Sales > as the measure
* In the properties panel under Presentation select Area

Answer: C

NEW QUESTION # 29
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 # 30
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(distinct BookinglO)
* [TolalCost]
* [Totalincomel
* ITotalincome|-[TotalCost]
* [TotalMargin]/{Totalllncome}*100
B. * count(dislinct BookinglD)
* [TolalCost]
* [Totalincome]
* [Totalincome|-[TotalCost]
* [TotalMargin]/[Totalllncome}*100
C. * count(dislinct BookinglD)
* [TolalCost]
* [Totalincomel
* ITotalincome|-[TotalCost]
* [TotalMargin]/{Totalllncome}*100
D. * count(BookinglD)
* [TolalCost]
* [Totalincomel
* sum(income|-sum[TotalCost]
* [TotalMargin]-sum(Cost)/sumTotal(lncome)*100

Answer: B

NEW QUESTION # 31
A business analyst inherits an app full of sheets The business analyst needs to redesign the app using the DAR principle How should the business analyst order the visualizations?

A. * KPIs
* Table PivotTable
* Bar Chart Pie Chart Line Chart
B. * Bar Chart Pie Chart Line Chart
* Table Pivot Table
* KPIs
C. * KPIS
* Ba' Chart Pie Chart Line Chart
* Table Pivot. Table
D. * Bar Chart Pie Chart Line Chart
* KPIs
* Table Pivol Table

Answer: B

NEW QUESTION # 32
Refer to the exhibit.

What is the selection slate of light gray values?

A. Possible
B. Selected
C. Alternative
D. Excluded

Answer: D

NEW QUESTION # 33
A finance manager uses an Excel file to record travel expenses The file has historical data and is used m multiple Qlik Sense apps The finance manager needs to deploy only the past three months of data to the regional sales managers Which solution should be used to meet the requirements using the data manager?

A. Apply a filter" to load three months of data
B. Create a calculated field for the three months of data
C. Use a WHERE clause to limit the data to three months
D. Create a bucket that groups the three months of data

Answer: C

NEW QUESTION # 34
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 dimension
B. Alternative dimensions using fixed number limitations
C. Alternative dimensions and diverging color scheme
D. Stacked bar chart using ColorMix function
E. Stack dimensions and color by measure

Answer: C,D

NEW QUESTION # 35
A business analyst is designing a business intelligence solution to track production. There are several requirements in the complicated factory environment
* Printed work summary documents produced daily
* Information monitors that show custom website with visualizations from QIA Sense
* Ability to calculate the shortest routes between two sets of coordinates Which three options are needed to meet these requirements? (Select three)

A. Qlik Compose
B. Mashup
C. Custom objects
D. Qlik GeoAnalytics
E. Qlik NPrinting

Answer: B,D,E

NEW QUESTION # 36
Refer to the exhibit.

A business analyst must add a list of interns to the current sates app. The app contains an existing employees table When the business analyst profiles the data the association vow displays possible associations as shown.
Which action should the business analyst take to meet the requirements?