Skip to main content

QSBA2021 Real Exam Questions

Qlik Sense Business Analyst Certification - February 2021 Release

50 questions available · Page 1 of 5

Updated Exam DumpsVerified AnswersPass Guarantee

Get Complete Exam Dumps
Question 1 Single choice

An organization recently acquired a competitor A business analyst needs to merge me custom databases with 20 years of customer and order transactions.

The data must be integrated into the existing app to show the past two years of data Performance degradation must be minimized What should the business analyst do to meet this requirement?

  1. A

    Add the new Customers and Orders tables and associate the new tables to me existing data model Filter the data from the Customers and Orders table to bring only data created within the past two years

  2. B

    Add the new Customers and Orders tables and concatenate the new tables to the existing data model Filter the data from the Orders table to bring only data created within the past two years

  3. C

    Add the new Customers and Orders tables and associate the new tables to the existing data model Filter the data from the Orders table to bring only data created within the past two years

  4. D

    Add the new Customers and Orders tables and concatenate the new tables to the existing data model Filter the data from the Customers and Orders table to bring only data created within the past two years

Show answer and explanation

Correct answer: C

Question 2 Single choice

A business analyst is creating a story One visualization must be scaled only vertically.

Which steps are needed to apply this in the storytelling view?

  1. A

    Select the Effects library to rescale the visualization

  2. B

    Select Edit in the Snapshot library and rescale the visualization

  3. C

    Select Unlock the snapshot and rescale the visualization

  4. D

    Select Edit on the visualization and enter the new height

Show answer and explanation

Correct answer: B

Question 3 Single choice

A business analyst inherits an app full of sheets The business analyst needs to redesign the app using the
DAR principle

How should the business analyst orderthe visualizations?

  1. A

    KPIs
    Table PivotTable
    Bar Chart Pie Chart Line Chart

  2. B

    Bar Chart Pie Chart Line Chart
    KPIs
    Table Pivol Table

  3. C

    KPIS
    Ba' Chart Pie Chart Line Chart
    Table Pivot. Table

  4. D

    Bar Chart Pie Chart Line Chart
    Table Pivot Table
    KPIs

Show answer and explanation

Correct answer: D

Question 4 Multiple choice

A business analyst creates an app for a large retailer.
The app is based on me past ^2 months of transactional data in CSV formal

After successfully demonstrating the app the retailer provides a tile that contains another seven years of data

After the new datais loaded the previously responsive app takes 10 times longer to respond to users' selections

The app has many complex expressions.

Which two actions should the business analyst take to resolve the issues?(Select two)

  1. A

    Request the data architect to create flagsin the data model to optimize set analysis expressions

  2. B

    Use JOIN statements to reduce the number of tables m the data model

  3. C

    Make sure a I master items contain variables that define the expressions

  4. D

    Replace set analysis with calculated fields in the data manager

  5. E

    Create versions of the app using a WHERE clause m the data manager to restrict the data

Show answer and explanation

Correct answers: A, C

Question 5 Single choice

How does the Qlik Associative Engine analyze data from one or more data sources?

  1. A

    Creates a set of pre aggregated queries for Qlik Sense to run

  2. B

    Associates data into cubes to enable multidimensional analysis

  3. C

    Inner joins multiple data sources together to remove unrequired information

  4. D

    Combines multiple data sources without pre-aggregation

Show answer and explanation

Correct answer: A

Question 6 Multiple choice

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.

1. Information must be updated every hour to the company's information monitor
2. Data from Instagram must be fetched over a REST connection and combined with Google Analytics data
3. 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. A

    Standard map visualization

  2. B

    Mashups

  3. C

    Qlik Sense Mobile offline

  4. D

    Qlik NPrinting

  5. E

    Qlik web connectors

Show answer and explanation

Correct answers: A, C

Question 7 Multiple choice

Refer to the exhibit.

The data architect toads these fields from a data source A business analyst is creating an app for the human resources team Several visualizations are required

1. Line chart to show the number of new hires and terminations monthly
2. Treemap to show the number of employees by department and job level
3. Distribution plot of annual salaries or amount of benefits received by duration of employment or location
4. KPI to show average cost per employee

The cost per employee can be calculated by adding the employee salary to the amount of benefits received

Which two additional fields does the business analyst need from the data architect lo meet these requirements? (Select two )

  1. A

    Number of h res and termination

  2. B

    Benefits received

  3. C

    Average cost of employee

  4. D

    Years employed

  5. E

    Department

Show answer and explanation

Correct answers: B, D

Question 8 Single choice

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?

  1. A

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

  2. B

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

  3. C

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

  4. D

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

Show answer and explanation

Correct answer: C

Question 9 Single choice

A business analyst needs to uniquely identify tour sheets in the app overview Custom images have been created for each sheet

What should the business analyst do next?

  1. A

    Use the media library to upload the mages

  2. B

    Add the images from the snapshot library

  3. C

    Open the assets panel to drag and drop the images

  4. D

    Drag and drop the images onto the sheet edit view

Show answer and explanation

Correct answer: A

Question 10 Single choice

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?

  1. A

    Create a concatenated key to associate the Employees and internEmp tables

  2. B

    Force an association between the InternEmp and the Orders tables

  3. C

    Create an association between the EmpID and EmployeelD fields

  4. D

    Concatenate the InternEmp table to the Employees tables within data manager

Show answer and explanation

Correct answer: D