Online Access Free QSBA2022 Practice Test

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.Number of h res and termination
• B.Benefits received
• C.Years employed
• D.Average cost of employee
• E.Department

Refer of the exhibit.

A business analyst needs to add a table and make sure it is associated appropriately. The table contains regional information about employee offices and must be able to titer the orders by employee office.
Which steps should the business analyst take?

• A.1. Click the Offices bubble
  2. Click Synchronize scripted tables
  3. Move the Offices bubble on top of the Employees bubble
• B.1. Select the Offices bubble
  2. Move the Offices bubble on top of the Employees bubble
  3. Select the associated field
• C.1. Select the Offices bubble and click the more options menu
  2. Select concatenate or join option then select concatenate option from the drop-down menu
  3. Select the Employees bubble
• D.1. Select the Employees bubble
  2. Move the Employees bubble on top of the Offices bubble
  3. Select the associated field

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

• A.1. Right-click the visualization and select View data
  2. Select Export data
  3. Share the provided link with colleagues
• B.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
• C.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
• D.1. Right-click the visualization and select Share
  2. Select </> Embed
  3. Copy the URL and share with colleagues

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?

• A.Use a WHERE clause to limit the data to three months
• B.Apply a filter" to load three months of data
• C.Create a calculated field for the three months of data
• D.Create a bucket that groups the three months of data

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.Line chart with area gradient color by measure
• B.Grid chart with diverging color by measure
• C.Waterfall chart with custom positive value color
• D.Mekko chart with diverging color by dimension