QSBA2021 Premium Files Updated Jan-2024 Practice Valid Exam Dumps Question [Q18-Q38] : Latest Exam Prep : http://certify.vceprep.com

NO.18 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

NO.19 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

NO.20 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

NO.21 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

NO.22 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

NO.23 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

NO.24 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

NO.25 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?

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

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

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

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

NO.26 How does the Qlik Associative Engine analyze data from one or more data sources?

Creates a set of pre aggregated queries for Qlik Sense to run

Associates data into cubes to enable multidimensional analysis

Inner joins multiple data sources together to remove unrequired information

Combines multiple data sources without pre-aggregation

NO.27 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

NO.28 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)

Request the data architect to create flags in the data model to optimize set analysis expressions

Use JOIN statements to reduce the number of tables m the data model

Make sure a I master items contain variables that define the expressions

Replace set analysis with calculated fields in the data manager

Create versions of the app using a WHERE clause m the data manager to restrict the data

NO.29 Refer to the exhibit.

What is the selection slate of light gray values?

Possible

Excluded

Selected

Alternative

NO.30 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?

Open the Excel file, remove all columns that do not have the suffix ‘_c’ and save t>e Me to be loaded

Deselect the fields that do NOT have the ‘_c’ suffix in the data manager table preview

Utilize drier functionality in the data manager to select only columns with the suffix _C with a fitter condition

Load all columns because the recommended associations will use only columns with the suffix ‘_c*

NO.31 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?

Use data profiling to group the country values

Use data profiling and replace the country names

Use data profiling 10 hide the inconsistent country names

Use the filter and rename the country values

NO.32 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

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

Qlik Dynamic news

ODAG

Embedded Stories

Qlik APIs

NO.34 A business analyst needs to share a link to a specific visualization with colleagues Which steps should the business analyst use?

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

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

1. Right-click the visualization and select Share
2. Select </> Embed
3. Copy the URL and share with colleagues

1. Right-click the visualization and select View data
2. Select Export data
3. Share the provided link with colleagues

NO.35 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?

Use the media library to upload the mages

Add the images from the snapshot library

Open the assets panel to drag and drop the images

Drag and drop the images onto the sheet edit view

NO.36 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

NO.37 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.)

Alternative dimensions using fixed number limitations

Stacked bar chart using ColorMix function

Stack dimensions and color by measure

Alternative dimensions and diverging color scheme

Stack dimensions and color by dimension