How To Pass QSBA2021 Qlik Sense Business Analyst Certification Exam?

test2022-06-07T07:25:34+00:00

Looking for the tips to Pass QSBA2021 Qlik Sense Business Analyst Certification Exam? The Qlik Sense Business Analyst Certification Exam measures your ability to identify requirements, design applications, prepare and load data, and develop applications. Latest QSBA2021 exam dumps are available online for your learning. The QSBA2021 exam dumps are accessible to direct you in the perfect manner. We ensure that if you use the most accurate QSBA2021 dumps from FreeTestShare, you will pass the exam on the first try! Just choose the latest QSBA2021 exam dumps questions as your preparation materials.

This free QSBA2021 practice test can now be used to assess your preparation.

Page 1 of 2

1. To improve efficiencies a hospital mustanalyze 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 combo chart that shows total minutes of delayed starts by operating room and surgeon

A bar chart with total minutes of delayed starts and a drill-down from operating room to surgeon

A scatter plot with delayed start minutes per day operating room and surgeon

A line chart with total minutes of delayed starts and a drill-down from operating room to surgeon

2. 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.

What three options are needed to meet the requirements? (Select three.)

Master items

Variables

Calculated fields

Alternate states

Set analysis

3. Select a recommended chart

4. A Help Desk department sets a first-time fix target of 65% for ail customer calls. The department has a measure that captures the actual first-time fix percentage. A business analyst needs to choose the visualization that most effectively shows the performance against the target using a color gradient.

What visualization should the business analyst use?

Table

Text and Image

Gauge

Combo chart

5. A company CEO requests a dashboard that easily displays provides understating and tracks company performance.

There are several ma n dashboard requirements:

• Viewable by a mobile device

• Display multiple key measures

• Provide ability to easily navigate to other sheets.

What feature meets these requirements?

Multi KPI object with master visualizations

Multiple text and images visualizations

Multiple visualizations m a container

Multi master item visualizations

6. 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

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

8. 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

9. 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*

10. Refer to the exhibit.

Country

USA

US

U.S.A.

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

Page 2 of 2

11. Refer to the exhibit

A business analyst is modifying a box plot End users report unexpected blue dots in a box plot

What should the business analyst do?

Under Box plot elements, select Whisker length and increase to two interquartile ranges

Under Box plot elements deselect Include outliers

Under the Dimensions menu, deselect Include null values

Ask the data architect to modify the data model

12. 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

13. Refer to the exhibit.

What is the selection slate of light gray values?

Possible

Excluded

Selected

Alternative

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

• count(BookinglD) • [TolalCost] • [Totalincomel • sum(income|-sum[TotalCost] • [TotalMargin]-sum(Cost)/sumTotal(lncome)*100

• count(dislinct BookinglD) • [TolalCost] • [Totalincomel • ITotalincome|-[TotalCost] • [TotalMargin]/{Totalllncome}*100

• count(dislinct BookinglD) • [TolalCost] • [Totalincome] • [Totalincome|-[TotalCost] • [TotalMargin]/[Totalllncome}*100

• count(distinct BookinglO) • [TolalCost] • [Totalincomel • ITotalincome|-[TotalCost] • [TotalMargin]/{Totalllncome}*100

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

Number of h res and termination

Benefits received

Average cost of employee

Years employed

Department

16. Use the reload function in the sheet Editor asset panel