Exam4Training

QlikView QSBA2021 Qlik Sense Business Analyst Certification Exam – February 2021 Release Online Training

Question #1

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?

  • A . Select the Effects library to rescale the visualization
  • B . Select Edit in the Snapshot library and rescale the visualization
  • C . Select Unlock the snapshot and rescale the visualization
  • D . Select Edit on the visualization and enter the new height

Reveal Solution Hide Solution

Correct Answer: B
Question #2

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

Reveal Solution Hide Solution

Correct Answer: A
Question #3

A business analyst is creating an app that requires several visualizations

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

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

• A KPI that shows total cost

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

Reveal Solution Hide Solution

Correct Answer: C,E
Question #4

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)

  • A . Request the data architect to create flagsin the data model to optimize set analysis expressions
  • B . Use JOIN statements to reduce the number of tables m the data model
  • C . Make sure a I master items contain variables that define the expressions
  • D . Replace set analysis with calculated fields in the data manager
  • E . Create versions of the app using a WHERE clause m the data manager to restrict the data

Reveal Solution Hide Solution

Correct Answer: A,C
Question #4

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)

  • A . Request the data architect to create flagsin the data model to optimize set analysis expressions
  • B . Use JOIN statements to reduce the number of tables m the data model
  • C . Make sure a I master items contain variables that define the expressions
  • D . Replace set analysis with calculated fields in the data manager
  • E . Create versions of the app using a WHERE clause m the data manager to restrict the data

Reveal Solution Hide Solution

Correct Answer: A,C
Question #4

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)

  • A . Request the data architect to create flagsin the data model to optimize set analysis expressions
  • B . Use JOIN statements to reduce the number of tables m the data model
  • C . Make sure a I master items contain variables that define the expressions
  • D . Replace set analysis with calculated fields in the data manager
  • E . Create versions of the app using a WHERE clause m the data manager to restrict the data

Reveal Solution Hide Solution

Correct Answer: A,C
Question #4

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)

  • A . Request the data architect to create flagsin the data model to optimize set analysis expressions
  • B . Use JOIN statements to reduce the number of tables m the data model
  • C . Make sure a I master items contain variables that define the expressions
  • D . Replace set analysis with calculated fields in the data manager
  • E . Create versions of the app using a WHERE clause m the data manager to restrict the data

Reveal Solution Hide Solution

Correct Answer: A,C
Question #4

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)

  • A . Request the data architect to create flagsin the data model to optimize set analysis expressions
  • B . Use JOIN statements to reduce the number of tables m the data model
  • C . Make sure a I master items contain variables that define the expressions
  • D . Replace set analysis with calculated fields in the data manager
  • E . Create versions of the app using a WHERE clause m the data manager to restrict the data

Reveal Solution Hide Solution

Correct Answer: A,C
Question #4

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)

  • A . Request the data architect to create flagsin the data model to optimize set analysis expressions
  • B . Use JOIN statements to reduce the number of tables m the data model
  • C . Make sure a I master items contain variables that define the expressions
  • D . Replace set analysis with calculated fields in the data manager
  • E . Create versions of the app using a WHERE clause m the data manager to restrict the data

Reveal Solution Hide Solution

Correct Answer: A,C
Question #4

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)

  • A . Request the data architect to create flagsin the data model to optimize set analysis expressions
  • B . Use JOIN statements to reduce the number of tables m the data model
  • C . Make sure a I master items contain variables that define the expressions
  • D . Replace set analysis with calculated fields in the data manager
  • E . Create versions of the app using a WHERE clause m the data manager to restrict the data

Reveal Solution Hide Solution

Correct Answer: A,C

Question #4

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)

  • A . Request the data architect to create flagsin the data model to optimize set analysis expressions
  • B . Use JOIN statements to reduce the number of tables m the data model
  • C . Make sure a I master items contain variables that define the expressions
  • D . Replace set analysis with calculated fields in the data manager
  • E . Create versions of the app using a WHERE clause m the data manager to restrict the data

Reveal Solution Hide Solution

Correct Answer: A,C
Question #4

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)

  • A . Request the data architect to create flagsin the data model to optimize set analysis expressions
  • B . Use JOIN statements to reduce the number of tables m the data model
  • C . Make sure a I master items contain variables that define the expressions
  • D . Replace set analysis with calculated fields in the data manager
  • E . Create versions of the app using a WHERE clause m the data manager to restrict the data

Reveal Solution Hide Solution

Correct Answer: A,C
Question #13

Share the provided link with colleagues

Reveal Solution Hide Solution

Correct Answer: A
Question #14

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
    ews
  • B . ODAG
  • C . Embedded Stories
  • D . QlikAPIs

Reveal Solution Hide Solution

Correct Answer: C
Question #15

A business analyst is creating an app for technicians. The app must meet several requirements

• Visualization labels must change according to the selected tame period

• A button to toggle between Month and Year to Date (YTD)

• Two fields combine to create one dimension that is used m several visualizations.

What three options are needed to meet the requirements? (Select three.)

  • A . Master items
  • B . Variables
  • C . Calculated fields
  • D . Alternate states
  • E . Set analysis

Reveal Solution Hide Solution

Correct Answer: A,B,C
Question #16

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

Reveal Solution Hide Solution

Correct Answer: B,C,D
Question #17

Refer to the exhibits.

These tables have the same structure. The Customers information is as shown in the Data Model Viewer In a sheet called "Customer Analysis" there is a filter pane with Customers.

A business analyst s developing an app for the Sales department and loads the data about Customers from two files.

The business analyst wants the values to appear as they were loaded How should this issue be resolved?

  • A . Disable Sorting Auto and uncheck all options.
  • B . Disable Sorting Auto and uncheck Sort Numerically.
  • C . Enable Sort by Expression ReloadTime().
  • D . Enable Sort by State and select Descending.

Reveal Solution Hide Solution

Correct Answer: C
Question #18

Several departments use an app. The business analyst needs to modify access to the sheets so that each department can access their sheets only.

What should me business analyst do?

  • A . Use the Stones feature to create a story with embedded sheets for each department
  • B . Edit the Show Condition expression field in the sheets tor each department
  • C . Choose to add a bookmark for each department
  • D . Create sheets with alternate states for each department

Reveal Solution Hide Solution

Correct Answer: C
Question #19

After a campaign a marketing group has data that snows distinct increases of product sales over a 12-month period. The group needs to highlight the products that show the highest revenue.

What should be developed to meet this requirement?

  • A . Grid chart with diverging color by measure
  • B . Line chart with area gradient color by measure
  • C . Waterfall chart with custom positive value color
  • D . Mekko chart with diverging color by dimension

Reveal Solution Hide Solution

Correct Answer: D
Question #20

A Help Desk department sets a first-time fix target of 65% for ail customer calls. The department has a measure that captures the actual first-time fix percentage. A business analyst needs to choose the visualization that most effectively shows the performance against the target using a color gradient.

What visualization should the business analyst use?

  • A . Table
  • B . Text and Image
  • C . Gauge
  • D . Combo chart

Reveal Solution Hide Solution

Correct Answer: A

Question #21

Refer to the exhibit.

Country

USA

US

U.S.A.

A business analyst needs to load several data files and notices that some of the values for the United States of America are formatted inconsistently.

What should the business analyst do?

  • A . Use data profiling to group the country values
  • B . Use data profiling and replace the country names
  • C . Use data profiling 10 hide the inconsistent country names
  • D . Use the filter and rename the country values

Reveal Solution Hide Solution

Correct Answer: C
Question #22

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

Reveal Solution Hide Solution

Correct Answer: A
Question #23

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

• Dates of each surgery

• Number of minutes the start of the surgery is delayed

• Operating room

• 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

Reveal Solution Hide Solution

Correct Answer: D
Exit mobile version