QlikView QSBA2021 Online Practice Questions and Exam Preparation

QlikView QSBA2021 Online Questions & Answers

• Question 11:

  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. A show, hide container using a bar chart and set the show condition to Count(Distinct CustomerlD)
  B. A bar chart and in the Add-ons set the calculation condition 10 Count(DlSTINCT CustomerlD) < 100
  C. A bar chart and in the Add-ons, set the calculation condition to Count(Customer ID) <
  D. A show/hide container using a master item bar chart and set the show condition to Count(CustomerlD) < 100
  A. A show, hide container using a bar chart and set the show condition to Count(Distinct CustomerlD)

  ---

  Explanation/Reference:

• Question 12:

  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. Create a bucket that groups the three months of data
  B. Use a WHERE clause to limit the data to three months
  C. Apply a filter" to load three months of data
  D. Create a calculated field for the three months of data
  B. Use a WHERE clause to limit the data to three months

• Question 13:

  A business analyst is creating an app for the sales department

  Users of the app most be able to create sheets and analyze data The salesdepartment has several additionalrequirements:

  Reuse the global sales visualization Create new visualizations The app has over 100 visualizations

  Users will NOT have access to the full data model

  What should be added to the master items to meet the requirement?

  A. All fields as dimensions and measures All visualizations
  B. All fields as dimensions and measures Selected visualizations
  C. Seated fields as dimensions and measures Selected visualizations
  D. Selected fields as dimensions and measures All visualizations
  A. All fields as dimensions and measures All visualizations

  ---

  Explanation/Reference:

• Question 14:

  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. An email trigger on a data reload
  B. An action on the sheet containing the KPI
  C. A destination using Qlik NPrinting
  D. A condition using Qlik Alerting
  A. An email trigger on a data reload

  ---

  Explanation/Reference:

• Question 15:

  A business analyst s creating an app for the sales team. The app must meet several requirements:

  1.

  Compare 10 top -performing sales representatives and the amount of sales for each

  2.

  Investigate margin percentage and total sales by each product category

  3.

  View distribution of sales amount

  Which visualizations should be used for this app?

  A. A treemap box plot, and histogram
  B. A bar chart, line chart, and scatter plot
  C. A treemap container and distribution plot
  D. A bar chart scatter plot and histogram
  A. A treemap box plot, and histogram

  ---

  Explanation/Reference:

• Question 16:

  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

  1.

  Sales by Product in the past "; months

  2.

  Cost of Sales on a map by Country

  3.

  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?

  A. Create default bookmark, maps sheet actions enable the insight Bot
  B. Create master measures alternate states GeoAnalytics enable Insights in app capabilities
  C. Create default bookmark GeoAnalytics alternate states enable the insight Bot
  D. Create master measures sheet actions maps enable Insights in app capacities
  A. Create default bookmark, maps sheet actions enable the insight Bot

  ---

  Explanation/Reference:

• Question 17:

  A business analyst is creating an app that requires several visualizations

  1.

  A scatter plot mat shows the margin percentage and total sales by product category

  2.

  A map with a the layer that visualizes lines between retail stores and lactones

  3.

  A KPI that shows total cost

  4.

  Margin% can be calculated by dividing profit by revenue Profit is the difference between total cost and total sates

  Which two sets of fields can the business analyst use to meet these requirements? (Select two.)

  A. Line Geometry Margin%
  B. Product Category Location
  C. Sales Total Cost
  D. Product Category Retail Store Location Factory Location
  E. Line Geometry
  C. Sales Total Cost
  E. Line Geometry

  ---

  Explanation/Reference:

• Question 18:

  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?

  A. The original sheet is in a different alternate state
  B. A bookmark has been applied with default selections
  C. The data has been reloaded and cleared the selection
  D. An action has been defined to dear selections
  D. An action has been defined to dear selections

• Question 19:

  A business analyst is designing a business intelligence solution to track production.There are several requirements in the complicated factory environment:

  1.

  Printed work summary documents produced daily

  2.

  Information monitors that show custom website with visualizations from QIA Sense

  3.

  Ability to calculate the shortest routes between two sets of coordinates

  Which three options are needed to meet these requirements? (Select three)

  A. Mashup
  B. Qlik Compose
  C. Qlik NPrinting
  D. Custom objects
  E. Qlik GeoAnalytics
  A. Mashup
  C. Qlik NPrinting
  E. Qlik GeoAnalytics

  ---

  Explanation/Reference:

• Question 20:

  A large auditing firm has a proprietary web portal that all of the' customers use to access their own data. 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 QlikSeriesapp is reloaded.

  What should the business analyst recommend?

  A. Qlik Dynamic \news
  B. ODAG
  C. Embedded Stories
  D. QlikAPIs
  C. Embedded Stories