Pass Qlik QSBA2021 Exam With Practice Test Questions Dumps Bundle
2022 Valid QSBA2021 test answers & Qlik Exam PDF
NEW QUESTION 18
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 Create two variables vCountry and vCity
2 Add a slider for vCountry and vCity
3 Apply the vanable to each virtualization - B. 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 - 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: A
NEW QUESTION 19
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. Waterfall chart with custom positive value color
- B. Mekko chart with diverging color by dimension
- C. Grid chart with diverging color by measure
- D. Line chart with area gradient color by measure
Answer: B
NEW QUESTION 20
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(distinct BookinglO)
* [TolalCost]
* [Totalincomel
* ITotalincome|-[TotalCost]
* [TotalMargin]/{Totalllncome}*100 - D. * count(BookinglD)
* [TolalCost]
* [Totalincomel
* sum(income|-sum[TotalCost]
* [TotalMargin]-sum(Cost)/sumTotal(lncome)*100
Answer: A
NEW QUESTION 21
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. Distribution Plot Alternatives Measures Sales and Margin Alternatives dimensions Customer or Product category Bar Chart Dimension Stage. Measure Sates
- B. Scatter Plot Measures X-axis Sates and Y-axis Margin Alternatives dimensions Customer or Product category Funnel Chart Segments Stage Width Sales
- C. Scatter Plot Measures X-axis Sates and Y-axis Margin Dimensions Customer or Product category Bar Chart Dimension Stage, Measure Sates
- D. Combo Chan Measures Sales and Margin Dimensions Customer or Product category Pie Chart Dimension Stage Measure Sales
Answer: B
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 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 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) - C. * 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) - D. * 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)
Answer: D
NEW QUESTION 23
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. Go to the OMC and select App Object
2. Right-click the correct visualization to get the URL
3. Share the URL with colleagues - C. 1. Right-click the visualization and select Share
2. Select </> Embed
3. Copy the URL and share with colleagues - D. 1. Right-click the visualization and select View data
2. Select Export data
3. Share the provided link with colleagues
Answer: B
NEW QUESTION 24
A marketing team is using an app to analyze the company events. The team registers attendees with information such as an ID name and region and discusses business opportunities with attendees Opportunities are evaluated m time and set to a different status.
The team wants to use insight Advisor to query events and opportunities to:
* Review specific areas and periods
* Use marketing terms not currently present in the app when classifying opportunities
* Define calendar periods and add calculations for specific data fields Some examples are as follows:
Which process should the business analyst follow?
- A. Define me business logic and vocabulary to define values using the fields m me data set Create groups and set properties in fields Use Calendar groups to define custom periods
- B. Update the data set using data manager or data load editor to include these terms as flags or values in the data set Also define the variable to determine which calculation should be used for each field
- C. Create master dimensions and measures, including calendar measures to define fiscal periods Use tags to improve the insight Advisor search features and include vocabulary terms
- D. Add tags into the data fields to improve how the Insight Advisor identifies the fields when using the natural language queries Use the Selection tool to remove any tads not needed for the search results
Answer: B
NEW QUESTION 25
Refer to the exhibit.
The data architect toads these fields from a data source A business analyst is creating an app for the human resources team Several visualizations are required
* Line chart to show the number of new hires and terminations monthly
* Treemap to show the number of employees by department and job level
* Distribution plot of annual salaries or amount of benefits received by duration of employment or location
* KPI to show average cost per employee
The cost per employee can be calculated by adding the employee salary to the amount of benefits received Which two additional fields does the business analyst need from the data architect lo meet these requirements? (Select two )
- A. Average cost of employee
- B. Years employed
- C. Department
- D. Benefits received
- E. Number of h res and termination
Answer: B,D
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 bar chart with total minutes of delayed starts and a drill-down from operating room to surgeon
- B. A scatter plot with delayed start minutes per day operating room and surgeon
- C. A line chart with total minutes of delayed starts and a drill-down from operating room to surgeon
- D. A combo chart that shows total minutes of delayed starts by operating room and surgeon
Answer: C
NEW QUESTION 27
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 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 - 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 field in data manager
2. Use a pant based on auto-calendar fields
3. Perform a daily reload via the data manager
Answer: C
NEW QUESTION 28
A business analyst using a shared folder mapped to S \419379942\ receives an Excel We with more than 100 columns Many of the columns are duplicates. The current set of columns mat should be used have the suffix '_c* appended to the column name What should the business analyst do to load the Excel data?
- A. Deselect the fields that do NOT have the '_c' suffix in the data manager table preview
- B. Load all columns because the recommended associations will use only columns with the suffix '_c*
- C. Utilize drier functionality in the data manager to select only columns with the suffix _C with a fitter condition
- D. Open the Excel file, remove all columns that do not have the suffix '_c' and save t>e Me to be loaded
Answer: C
NEW QUESTION 29
A company installs Qlik Sense on Windows without any additional visualization bungles A business analyst must create an app with three sheets
* Sheet 1 KPIs and sales trends for the past 12 months
* Sheet 2 Regional sales by representative
* Sheet 3 Sales by country displayed in a map
Users must be able to view all of the sheets and make selections for their analyses.
Which three objects should be added to the three sheets? (Select three)
- A. Filter pane KPls and a map
- B. Filter panes KPls and a combo chart
- C. Filter panes KPIs and a line chart
- D. Filter pane bar chart and KPIs
- E. Filter pane scatter plot and a map
Answer: A,B,C
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. Create a storytelling narration m a published app that contains embedded sheets
- B. Set up Nprinting to connect to the app and design a slideshow-style report
- C. Create a sheet that features colorful and layered visualizations and export as a PDF
- D. Embed a video player m the shared app with a recording to describe the charts
Answer: D
NEW QUESTION 31
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 default bookmark, maps sheet actions enable the insight Bot
- B. Create master measures alternate states GeoAnalytics enable Insights in app capabilities
- C. Create default bookmark GeoAnalytics alternate states enable the insight Bot
- D. Create master measures sheet actions maps enable Insights in app capacities
Answer: A
NEW QUESTION 32
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 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 - B. * 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 - 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 the existing data model
* Filter the data from the Orders table to bring only data created within the past two years
Answer: D
NEW QUESTION 33
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. Qlik APIs
- B. Qlik Dynamic \news
- C. Embedded Stories
- D. ODAG
Answer: C
NEW QUESTION 34
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 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 - B. * 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 - C. * 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 - D. * 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
Answer: B
NEW QUESTION 35
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. Alternative dimensions and diverging color scheme
- B. Stacked bar chart using ColorMix function
- C. Stack dimensions and color by dimension
- D. Stack dimensions and color by measure
- E. Alternative dimensions using fixed number limitations
Answer: A,B
NEW QUESTION 36
......
Qlik QSBA2021 Exam Syllabus Topics:
| Topic | Details |
|---|---|
| Topic 1 |
|
| Topic 2 |
|
| Topic 3 |
|
| Topic 4 |
|
| Topic 5 |
|
Top Qlik QSBA2021 Courses Online: https://dumpstorrent.actualpdf.com/QSBA2021-real-questions.html
