Online Access Free QSBA2018 Practice Test

A data architect adds a field to an existing data model that contains new values for the ProductGroup. The business analyst needs to efficiently update the app and meet these requirements:
* Use the existing charts, which are built using a master item dimension called ProductGroup
* Existing charts must use the new values for ProductGroup
* Business users must be able to compare the new and old values
How should the business analyst meet these requirements?

• A.Use set analysis on the chart measures to see the difference in ProductGroup between the new field and the old field
• B.Replace the dimensions on all charts to use the new ProductGroup field added to the data model
• C.Change the ProductGroup dimension using the new field, and create a new dimension in the master items for the old field
• D.Create a calculated dimension on the charts to allow the users to compare the new value to the old value

Which two features/functions are enabled by the Qlik Associative Engine?

• A.Insight advisor and data profiling
• B.Smart search and mashups
• C.Smart search and data profiling
• D.Insight advisor and smart search

The sales department requests a new Qlik Sense app to show the amount of sales in each territory The app must:
* Allow analysis of aggregate views of big data stores
* Include objects that allow the user to jump to a specific sheet
* Provide a way to send a report through email
Which three products or features should the business analyst use to meet these requirements? (Select three.)

• A.Qlik NPrinting
• B.Qlik DataMarket
• C.Qlik Sense Enterprise for Elastic
• D.Bookmarks
• E.On Demand App Generation

A business analyst needs to create an app showing sales data. The app requirements are as follows
* Compare sales for the current year (CY Sales) versus last year (LY Sales)
* CY Sales must always be displayed in blue
* LY Sales must always be displayed in yellow
Which steps should the business analyst take to meet these requirements?

• A.1. Create CY Sales and LY Sales measures as master items and set the required color for each measure 2 Create one KPI from the two master item measures
• B.1. Create CY Sales and LY Sales measures as master items
  2 Write an IF expression to set the appropriate colors for the master items
• C.1 Create a KPI with two measures, CY Sales and LY Sales
  2 Write an IF expression to set the appropriate colors for each measure
• D.1 Create CY Sales and LY Sales measures as master items and set the required color for each measure using Value colors
  2 Create two gauges, one for each measure and set the color for each appropriately

A bus company wants to analyze customer travel patterns to add additional services or create new routes. The business analyst needs to consider the following data:
* 190 routes across the city
* Start and end location of each route
* Volume of customers travelling per hour
* Customer complaints when buses are full
Which visualization should a business analyst use to meet this requirement?

• A.Scatter plot
• B.Line layer map
• C.Area layer map
• D.Treemap