[Mar 26, 2024] Valid QSBA2021 Test Answers & Qlik QSBA2021 Exam PDF
Realistic QSBA2021 Exam Dumps with Accurate & Updated Questions
Qlik QSBA2021 certification exam consists of 50 multiple-choice questions and has a duration of 2 hours. QSBA2021 exam is available in English and can be taken online or at a Pearson VUE test center. The passing score for the exam is 70%. Upon passing the exam, candidates will receive a digital badge and a certificate that verifies their Qlik Sense Business Analyst certification. Qlik Sense Business Analyst Certification Exam - February 2021 Release certification is valid for 2 years, after which the candidate will need to recertify to maintain their certification status. Overall, the Qlik QSBA2021 certification exam is a valuable credential that demonstrates the candidate's expertise in using Qlik Sense for data analysis and business intelligence.
NEW QUESTION # 10
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]
* [Totalincomel
* ITotalincome|-[TotalCost]
* [TotalMargin]/{Totalllncome}*100 - B. * count(BookinglD)
* [TolalCost]
* [Totalincomel
* sum(income|-sum[TotalCost]
* [TotalMargin]-sum(Cost)/sumTotal(lncome)*100 - C. * count(dislinct BookinglD)
* [TolalCost]
* [Totalincome]
* [Totalincome|-[TotalCost]
* [TotalMargin]/[Totalllncome}*100 - D. * count(distinct BookinglO)
* [TolalCost]
* [Totalincomel
* ITotalincome|-[TotalCost]
* [TotalMargin]/{Totalllncome}*100
Answer: C
NEW QUESTION # 11
A business analyst wants to send an email to app users when the region's sales exceed $50,000. The notification must be delivered through a mobile app What should the business analyst configure?
- A. A destination using Qlik NPrinting
- B. An email trigger on a data reload
- C. An action on the sheet containing the KPI
- D. A condition using Qlik Alerting
Answer: B
NEW QUESTION # 12
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. Enable Sort by State and select Descending.
- B. Disable Sorting Auto and uncheck all options.
- C. Disable Sorting Auto and uncheck Sort Numerically.
- D. Enable Sort by Expression ReloadTime().
Answer: D
NEW QUESTION # 13
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. Create a bucket that groups the 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. Apply a filter" to load three months of data
Answer: C
NEW QUESTION # 14
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. 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 - B. 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 - C. 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 - D. 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
Answer: D
NEW QUESTION # 15
Refer to the exhibit.
The business analyst needs to see now me same data wil appear m other chart types Which steps should the business analyst take to meet these requirements?
- A. 1. Create a new chart
2. Enable Chart suggestions
3. Select a recommended chart - B. 1. Duplicate the chart
2. Drag and drop a new chart object over the old chart
3. Select Replace - C. 1. Duplicate the chart
2. Enable Chart suggestions
3. Select a recommended chart - D. 1. Create a new chart
2. Enable Insights
3. Select a recommended chart
Answer: A
NEW QUESTION # 16
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 the Effects library to rescale the visualization
- B. Select Edit on the visualization and enter the new height
- C. Select Edit in the Snapshot library and rescale the visualization
- D. Select Unlock the snapshot and rescale the visualization
Answer: C
NEW QUESTION # 17
Refer to the exhibit.
After the latest data reload a business analyst notices the value tor CategoryID 'B321' seems different What is causing this discrepancy?
- A. Null values are deluded in the source data
- B. Some categories do NOT exist in the Category table
- C. Hyphen character ('.') is included m the source data
- D. The data type for CategorylD 332V does not match the others
Answer: D
NEW QUESTION # 18
An organization recently acquired a competitor A business analyst needs to merge me custom databases with 20 years of customer and order transactions. The data must be integrated into the existing app to show the past two years of data Performance degradation must be minimized What should the business analyst do to meet this requirement?
- A. * Add the new Customers and Orders tables and associate the new tables to the existing data model
* Filter the data from the Orders table to bring only data created within the past two years - B. * Add the new Customers and Orders tables and concatenate the new tables to the existing data model
* Filter the data from the Orders table to bring only data created within the past two years - C. * Add the new Customers and Orders tables and concatenate the new tables to the existing data model
* Filter the data from the Customers and Orders table to bring only data created within the past two years - D. * Add the new Customers and Orders tables and associate the new tables to me existing data model
* Filter the data from the Customers and Orders table to bring only data created within the past two years
Answer: A
NEW QUESTION # 19
A sales manager needs to visualize the company's sales. The sales manager needs to understand how sates and profitability are related over time. The visualization will be used in a printed annual report.
The business analyst has access to the following data:
* Order Dates
* Order ID
* Total Safes by Order
* Net profit margin%
* Cost of Goods Sow (COGS)
Which visualization should the business analyst use?
- A. Combo Chart
- B. Distribution Plot
- C. Line Chart
- D. Scatter Plot
Answer: B
NEW QUESTION # 20
A business analyst is developing an app that contains a data model with fields Country. City. Sales ProductName and ProductCategory. The global sales manager wants to add new visualizations to this app The business analyst must include the following
* Ability to dynamically change the number of countries and cities
* Display a maximum of 10 countries
* Display a maximum of 5 cities per country
Which steps should the business analyst take?
- A. 1 Add an input field for vCountry and vCity
2 Set the dimension limitation to the required maximum values 5 and 10
3 Apply the variable to each visualization - B. 1 Create two variables vCountry and vCity
2 Add a slider for vCountry and vCity
3 Apply the vanable to each virtualization - C. 1 Create two variables vCountry and vCrty
2 Add a slider for vCountry and vCity
3 Apply the variable to each virtualization
4 Set a sheet action that limits the data displayed - D. 1 Add an input field for vCountry and vCity
2 Sat the dimension limitation to the required maximum values 5 and 10
3 Apply the variable to each visualization
4 Add a bookmark Country and City
Answer: B
NEW QUESTION # 21
A business analyst s developing an app 10 track the influence of the company's mascot cat on instagram The marketing department has several requirements for this solution.
* Information must be updated every hour to the company's information monitor
* Data from Instagram must be fetched over a REST connection and combined with Google Analytics data
* There must be a way to visualize changes of followers *i a map
Which two features are needed to meet these requirements? (Select two.)
- A. Qlik web connectors
- B. Standard map visualization
- C. Qlik Sense Mobile offline
- D. Mashups
- E. Qlik NPrinting
Answer: B,C
NEW QUESTION # 22
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 bar chart and in the Add-ons, set the calculation condition to Count(Customer ID) < 100
- B. A show/hide container using a master item bar chart and set the show condition to Count(CustomerlD) < 100
- C. A bar chart and in the Add-ons set the calculation condition 10 Count(DlSTINCT CustomerlD) < 100
- D. A show, hide container using a bar chart and set the show condition to Count(Distinct CustomerlD) <100
Answer: D
NEW QUESTION # 23
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 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) - B. * 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) - C. * 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) - D. * 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)
Answer: B
NEW QUESTION # 24
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. Edit the Show Condition expression field in the sheets tor each department
- B. Create sheets with alternate states for each department
- C. Use the Stones feature to create a story with embedded sheets for each department
- D. Choose to add a bookmark for each department
Answer: D
NEW QUESTION # 25
A business analyst wants to create a dashboard for the Finance team to use The app must include four sheets one looking at the full dataset and three others focused on the regions APAC EMEA and AMERICAS each.
The team needs visualizations for
* Sales by Product in the past 6" months
* Cost of Sales on a map by Country
* Sales Cost and Margin by Month
Additionally the learn wants to dear fillers while navigating between sheets and enable chat in the hub Which features should be used?
- A. Create master measures sheet actions maps enable Insights in app capacities
- B. Create default bookmark, maps sheet actions enable the insight Bot
- C. Create master measures alternate states GeoAnalytics enable Insights in app capabilities
- D. Create default bookmark GeoAnalytics alternate states enable the insight Bot
Answer: B
NEW QUESTION # 26
To improve efficiencies a hospital must analyze how often a surgery is started late by operating room and surgeon The business analyst must consider several factors
* Dates of each surgery
* Number of minutes the start of the surgery is delayed
* Operating room
* Surgeon name
Which visualization should the business analyst use to meet these requirements?
- A. A line chart with total minutes of delayed starts and a drill-down from operating room to surgeon
- B. A bar chart with total minutes of delayed starts and a drill-down from operating room to surgeon
- C. A combo chart that shows total minutes of delayed starts by operating room and surgeon
- D. A scatter plot with delayed start minutes per day operating room and surgeon
Answer: A
NEW QUESTION # 27
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?
- A. Force an association between the InternEmp and the Orders tables
- B. Create a concatenated key to associate the Employees and internEmp tables
- C. Concatenate the InternEmp table to the Employees tables within data manager
- D. Create an association between the EmpID and EmployeelD fields
Answer: C
NEW QUESTION # 28
A business analyst needs to share a link to a specific visualization with colleagues Which steps should the business analyst use?
- A. 1. Right-click the visualization and select Share
2. Select </> Embed
3. Copy the URL 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. Go to the Dev Hub and select Single Configurator
2. Select Add data
3. Copy the URL from the browser and share with colleagues
Answer: C
NEW QUESTION # 29
......
Achieving the QSBA2021 certification demonstrates that an individual has a deep understanding of Qlik Sense and can use it effectively to analyze data and create insights. It is a valuable credential for business analysts who want to advance their careers and demonstrate their expertise in data analytics. With the demand for data analytics professionals increasing rapidly, obtaining the QSBA2021 certification can help individuals stand out in the job market and open up new career opportunities.
QSBA2021 Exam Dumps - PDF Questions and Testing Engine: https://itexams.lead2passed.com/Qlik/QSBA2021-practice-exam-dumps.html
