Nov 06, 2022 Newest QSBA2021 Exam Dumps – Achieve Success in Actual QSBA2021 Exam [Q28-Q47] : Actual Test Materials : http://blog.actualtests4sure.com

Q28. 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.)

Master items

Variables

Calculated fields

Alternate states

Set analysis

Q29. 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?

Set up Nprinting to connect to the app and design a slideshow-style report

Create a storytelling narration m a published app that contains embedded sheets

Embed a video player m the shared app with a recording to describe the charts

Create a sheet that features colorful and layered visualizations and export as a PDF

Q30. 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?

* 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

* 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

* 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

* 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

Q31. 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?

Create a concatenated key to associate the Employees and internEmp tables

Force an association between the InternEmp and the Orders tables

Create an association between the EmpID and EmployeelD fields

Concatenate the InternEmp table to the Employees tables within data manager

Q32. 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?

Create a bucket that groups the three months of data

Use a WHERE clause to limit the data to three months

Apply a filter” to load three months of data

Create a calculated field for the three months of data

Q33. 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?

Grid chart with diverging color by measure

Line chart with area gradient color by measure

Waterfall chart with custom positive value color

Mekko chart with diverging color by dimension

Q34. 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.)

Standard map visualization

Mashups

Qlik Sense Mobile offline

Qlik NPrinting

Qlik web connectors

Q35. 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?

Disable Sorting Auto and uncheck all options.

Disable Sorting Auto and uncheck Sort Numerically.

Enable Sort by Expression ReloadTime().

Enable Sort by State and select Descending.

Q36. 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 show, hide container using a bar chart and set the show condition to Count(Distinct CustomerlD) <100

A bar chart and in the Add-ons set the calculation condition 10 Count(DlSTINCT CustomerlD) < 100

A bar chart and in the Add-ons, set the calculation condition to Count(Customer ID) < 100

A show/hide container using a master item bar chart and set the show condition to Count(CustomerlD) < 100

Q37. 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?

* KPIs
* Table PivotTable
* Bar Chart Pie Chart Line Chart

* Bar Chart Pie Chart Line Chart
* KPIs
* Table Pivol Table

* KPIS
* Ba’ Chart Pie Chart Line Chart
* Table Pivot. Table

* Bar Chart Pie Chart Line Chart
* Table Pivot Table
* KPIs

Q38. 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?

Scatter Plot

Combo Chart

Distribution Plot

Line Chart

Q39. 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?

Use the Stones feature to create a story with embedded sheets for each department

Edit the Show Condition expression field in the sheets tor each department

Choose to add a bookmark for each department

Create sheets with alternate states for each department

Q40. 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)

Mashup

Qlik Compose

Qlik NPrinting

Custom objects

Qlik GeoAnalytics

Q41. 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?

Remove the master items tag

Unlock the object

Unlink the object

Disable chart suggestions

Q42. 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?

* 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)

* 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)

* 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)

* 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)

Q43. 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 treemap box plot, and histogram

A bar chart, line chart, and scatter plot

A treemap container and distribution plot

A bar chart scatter plot and histogram

Q44. A business analyst is creating an app for the sales department
Users of the app most be able to create sheets and analyze data The sales department has several additional requirements
* Reuse the global sales visualization
* Create new visualizations
* The app has over 100 visualizations
Users will NOT have access to the full data model
What should be added to the master items to meet the requirement?

* All fields as dimensions and measures
* All visualizations

* All fields as dimensions and measures
* Selected visualizations

* Seated fields as dimensions and measures
* Selected visualizations

* Selected fields as dimensions and measures
* All visualizations

Q45. A business analyst is creating a new app with sales dat
a. The visualizations must meet several requirements:
* A Bar chart mat shows sales by product group is used m multiple sheets
* A KPI object that visualizes that the total amount of sales is used once
* A Treemap mat shows margin by product group is used one time inside a Container What should be added to the master items library?

KPI

Treemap

Bar chart

Container

Q46. 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?

* 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

* 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

* 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

* 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

Q47. A user makes a selection within a sheet and then navigates to another sheet to validate the details However when the user returns to the original sheet the selection is removed What is causing this behavior?

The original sheet is in a different alternate state

A bookmark has been applied with default selections

The data has been reloaded and cleared the selection

An action has been defined to dear selections

Nov 06, 2022 Newest QSBA2021 Exam Dumps – Achieve Success in Actual QSBA2021 Exam [Q28-Q47]

Qlik QSBA2021 Exam Syllabus Topics: