Free QSBA2021 Exam Braindumps (page: 2)

Page 2 of 13

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?

  1. Create a bucket that groups the three months of data
  2. Use a WHERE clause to limit the data to three months
  3. Apply a filter" to load three months of data
  4. Create a calculated field for the three months of data

Answer(s): B



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?


  1. • count(BookinglD)
    • [TolalCost]
    • [Totalincomel
    • sum(income|-sum[TotalCost]
    • [TotalMargin]-sum(Cost)/sumTotal(lncome)*100

  2. • count(dislinct BookinglD)
    • [TolalCost]
    • [Totalincomel
    • ITotalincome|-[TotalCost]
    • [TotalMargin]/{Totalllncome}*100

  3. • count(dislinct BookinglD)
    • [TolalCost]
    • [Totalincome]
    • [Totalincome|-[TotalCost]
    • [TotalMargin]/[Totalllncome}*100

  4. • count(distinct BookinglO)
    • [TolalCost]
    • [Totalincomel
    • ITotalincome|-[TotalCost]
    • [TotalMargin]/{Totalllncome}*100

Answer(s): C



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?

  1. Open the Excel file, remove all columns that do not have the suffix '_c' and save t>e Me to be loaded
  2. Deselect the fields that do NOT have the '_c' suffix in the data manager table preview
  3. Utilize drier functionality in the data manager to select only columns with the suffix _C with a fitter condition
  4. Load all columns because the recommended associations will use only columns with the suffix '_c*

Answer(s): C



A business analyst s developing an app 10 track the influence of the company's mascot cat on instagram. The marketing department has several requirements for this solution:
•Information must be updated every hour to the company's information monitor
•Data from Instagram must be fetched over a REST connection and combined with Google Analytics data
•There must be a way to visualize changes of followers *i a map

Which two features are needed to meet these requirements? (Select two.)

  1. Standard map visualization
  2. Mashups
  3. Qlik Sense Mobile offline
  4. Qlik NPrinting
  5. Qlik web connectors

Answer(s): A,C



Page 2 of 13



Post your Comments and Discuss QlikView QSBA2021 exam with other Community members:

Nmathew commented on October 27, 2024
Similar questions for qdba 2024
UNITED KINGDOM
upvote