QSBA2021 Sample Questions Answers

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)

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

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?

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

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

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

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