QlikView QSBA2021 Online Practice Questions and Exam Preparation

QlikView QSBA2021 Online Questions & Answers

• Question 41:

  A company CEO requests an app that contains global sales information. The CEO needs to present this information to an audience of international investors during an upcoming meeting.

  The presentation must meet several requirements

  1.

  Contain visualizations that present dearly to a large audience

  2.

  Answer audience questions dynamically

  3.

  Be made available as shared content

  4.

  Emphasize important sales revenue

  Which Qlik Sense features must the business analyst prepare?

  A. Set up Nprinting to connect to the app and design a slideshow-style report
  B. Create a storytelling narration m a published app that contains embedded sheets
  C. Embed a video player m the shared app with a recording to describe the charts
  D. Create a sheet that features colorful and layered visualizations and export as a PDF
  C. Embed a video player m the shared app with a recording to describe the charts

  ---

  Explanation/Reference:

• Question 42:

  Refer to the exhibit

  

  A business analyst is modifying a box plot End users report unexpected blue dots in a box plot. What should the business analyst do?

  A. Under Box plot elements, select Whisker length and increase to two interquartile ranges
  B. Under Box plot elements deselect Include outliers
  C. Under the Dimensions menu, deselect Include null values
  D. Ask the data architect to modify the data model
  A. Under Box plot elements, select Whisker length and increase to two interquartile ranges

  ---

  Explanation/Reference:

• Question 43:

  Refer to the exhibit.

  

  A business analyst must add a list of interns to the current sates app. The app contains an existing employees table When the business analyst profiles the data the association vow displays possible associations as shown. Which action should the business analyst take to meet the requirements?

  A. Create a concatenated key to associate the Employees and internEmp tables
  B. Force an association between the InternEmp and the Orders tables
  C. Create an association between the EmpID and EmployeelD fields
  D. Concatenate the InternEmp table to the Employees tables within data manager
  D. Concatenate the InternEmp table to the Employees tables within data manager

  ---

  Explanation/Reference:

• Question 44:

  A business analyst must add data from several tables to an existing app This app was built by a previous business analyst who used the data load editor to load some simple tables.

  The changes must be implemented in the data manager

  Which three actions should the business analyst take to matt these requirements?(Select three )

  A. Associate the new tables with the old tables
  B. Synchronize the scripted tables and modify the tables
  C. Synchronize the new tables and modify the tables
  D. Add the new tables via the Add data icon
  E. Delete the existing tables and re-import the tables
  B. Synchronize the scripted tables and modify the tables
  C. Synchronize the new tables and modify the tables
  D. Add the new tables via the Add data icon

• Question 45:

  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:

  1.

  Number of bookings that users make

  2.

  Cost associated with booking (including electricity and indirect costs)

  3.

  Income obtained and profit originated m each booking

  4.

  Sales margin: percentage of margin over income

  5.

  Detail by tennis clubs

  Which optimal expressions should the business analyst use?

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

  ---

  Explanation/Reference:

• Question 46:

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

  ---

  Explanation/Reference:

• Question 47:

  Refer to the exhibits

  

  After the latest data reload a business analyst notices the value tor CategoryID 'B321' seems different

  What is causing this discrepancy?

  A. The data type for CategorylD 332V does not match the others
  B. Null values are deluded in the source data
  C. Some categories do NOT exist in the Category table
  D. Hyphen character ('.') is included m the source data
  A. The data type for CategorylD 332V does not match the others

  ---

  Explanation/Reference:

• Question 48:

  To improve efficiencies a hospital mustanalyze how often a surgery is started late by operating room and surgeon The business analyst must consider several factors.

  1.

  Dates of each surgery

  2.

  Number of minutes the start of the surgery is delayed

  3.

  Operating room

  4.

  Surgeon name

  Which visualization should the business analyst use to meet these requirements?

  A. A combo chart that shows total minutes of delayed starts by operating room and surgeon
  B. A bar chart with total minutes of delayed starts and a drill-down from operating room to surgeon
  C. A scatter plot with delayed start minutes per day operating room and surgeon
  D. A line chart with total minutes of delayed starts and a drill-down from operating room to surgeon
  D. A line chart with total minutes of delayed starts and a drill-down from operating room to surgeon

  ---

  Explanation/Reference:

• Question 49:

  A company CEO requests a dashboard that easily displays provides understating and tracks company performance. There are several ma n dashboard requirements:

  1.

  Viewable by a mobile device

  2.

  Display multiple key measures

  3.

  Provide ability to easily navigate to other sheets

  Which feature meets these requirements?

  A. Multi KPI object with master visualizations
  B. Multiple text and images visualizations
  C. Multiple visualizations m a container
  D. Multi master item visualizations
  D. Multi master item visualizations

  ---

  Explanation/Reference:

• Question 50:

  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. Use a sheet action and apply a bookmark named 'Default'
  B. Create a masnup and use the API to apply default selections
  C. Create a bookmark and select 'Set selections as app default"
  D. Use Section access to predefine tie default selections
  A. Use a sheet action and apply a bookmark named 'Default'