Qlik QSBA2022 問題集 : Qlik Sense Business Analyst Certification Exam - 2022

A business analyst has access to all ofa company's data tor the past 10 years. The source table consists of the following fields Transactions Transaction Time Transaction Date Transaction Year Cardholder Cardholder address Cardissuer and Amount Users request to create an app based on this source Users only review me data for the past 2 years Data must be updated daily Users do not view cardholder into What should the business analyst do to reprove the app performance?

• A. 1. Delete Cardholder and time fields in data manager
  2. Use a bookmark based on auto-calendar fields
  3. Use the reload function in the sheet Editor asset panel
• B. 1. Delete Cardholder and time fields in data manager
  2. Use set analysis to show data based on transaction year
  3. Use an API to perform a daily reload task
• C. 1. Deselect Cardholder and time fields in data manager
  2. Apply a filter to extract data based on transaction year
  3. Request a daily reload task from the System Admin
• D. 1. Deselect Cardholder and time fieldin data manager
  2. Use apant based on auto-calendar fields
  3. Perform a daily reload via the data manager

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?

• A. count(dislinct BookinglD)
  [TolalCost]
  [Totalincome]
  [Totalincome|-[TotalCost]
  [TotalMargin]/[Totalllncome}*100
• B. count(distinct BookinglO)
  [TolalCost]
  [Totalincomel
  ITotalincome|-[TotalCost]
  [TotalMargin]/{Totalllncome}*100
• C. count(BookinglD)
  [TolalCost]
  [Totalincomel
  sum(income|-sum[TotalCost]
  [TotalMargin]-sum(Cost)/sumTotal(lncome)*100
• D. count(dislinct BookinglD)
  [TolalCost]
  [Totalincomel
  ITotalincome|-[TotalCost]
  [TotalMargin]/{Totalllncome}*100

A company CFO has requested an app that contains visualizations applicable to analyzing the finance data Each regional finance team will analyze their data, and the app must contain a high-level sheet that navigates to relevant detail sheets.
Which features support a logical design structure?

• A. A pivot table that filters by region
• B. A Multi KPI set analysis
• C. A dashboard with regional bookmarks
• D. A dashboard of KPIs and section access

A business analyst; s creating an app tor the team. A set of selections must be applied every time an app is opened.
What should the business analyst do to meet this requirement?

• A. Create a masnup and use the API to apply default selections
• B. Create a bookmark and select 'Set selections as app default"
• C. Use Section access to predefine tie default selections
• D. Use a sheet action and apply a bookmark named 'Default'

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 Employees bubble
  2. Move the Employees bubble on top of the Offices 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 Offices bubble
  2. Move the Offices bubble on top of the Employees bubble
  3. Select the associated field