Qlik Sense Business Analyst Exam : Questions & Answers
Which of the following statements is true about master items? - ANSWER:Master items reusable assets
that can be used throughout the app.
A marketing company must analyze the age of customers who view movies at a theater at least once a
month, and where those customers are located. The business analyst must consider several
requirements:
- Age of customers- Addresses of customers- Frequency of theater visits
Which objects should a business analyst use to visualize these requirements? - ANSWER:A histogram and
map
Which three actions can a business analyst complete in the Qlick Sense Enterprise hub? -
ANSWER:Publish an app into a stream
Publish a sheet into the Community section
Load data from multiple sources
A business analyst must create an interactive table to analyze sales performance for the selected year
and the previous year. Which are the correct expressions to meet this requirement? - ANSWER:Option A
Selected Year:
Sum ({$<Year={$=Only(Year))}>}Sales)
Previous Year:
Sum({$<Year={$(=Only(Year) -1)}>}Sales)
A hospital billing department is concerned with the performance of the cardiology and orthopedic
departments. The billing department wants to add a visualization to an existing app to analyze billing for
these two departments.
The business analyst must consider the hierarchy of:
- The department- The physicians in each department- The procedure performed by the physicians
What should the business analyst create to meet the requirements? - ANSWER:A bar chart using master
items drill-down
A bookmark for the departments
Qlik GeoAnalytics allows you to... - ANSWER:Create map visualizations and apply location-based analytics
and functions.
, A retailer with 300 locations worldwide needs to analyze its workforce to prepare for its next board
meeting. The two most important items to the board members are total compensation and number of
employees by city.
Which visualization should a business analyst use to meet this requirement? - ANSWER:Scatter plot
After the latest data reload, a business analyst notices the value for CategoryID 'B321 appears to be
different from the other values. What is causing this difference? - ANSWER:Pre-aggregated data is being
used
A business analyst must create new master items for quarterly calendar measures with company-specific
naming conventions based on:
- The Date field and the Sum of Sales- The new master items will calculate QTD Sales, Current QTD Sales,
Last QTD Sales, Current Quarter Sales, Last Year Current Quarter Sales, and Last Quarter Sales
Which three steps should the business analyst take to meet these requirements? - ANSWER:Save to
master items, rename master items
Right-click the Sales field in the assets panel and select Create calendar measures
Select Date, Sales, Sum, and Quarterly
A business analyst needs to present a one-slide story and be able to make selections in a visualization.
How should the business analyst meet this requirement? - ANSWER:Create a story and add a sheet from
the sheet library that contains the visualization
A company has customers in 16 countries. The majority of the customers are in Germany A business
analyst creates a fitter pane for Country and wants "Germany" listed first. The rest of the countries
should be listed in alphabetical order.
Which method should the business analyst use to meet this requirement? - ANSWER:In the data
manager edit the table, select Country! then select Order from the data profiling card
Which two features/functions are enabled by the Qlik Associative Engine? - ANSWER:Smart search and
data profiling
A manufacturer has several requirements for its new sales dashboard:
- Deliver analytics to mobile devices- Share data with retail partners via a custom portal- Prevent
sensitive data from being shared with competitors- Provide governed reusable assets
Which capabilities should a business analyst use to meet these requirements? - ANSWER:Mashups
Master items
Responsive design
Configurable security rules
Which of the following statements is true about master items? - ANSWER:Master items reusable assets
that can be used throughout the app.
A marketing company must analyze the age of customers who view movies at a theater at least once a
month, and where those customers are located. The business analyst must consider several
requirements:
- Age of customers- Addresses of customers- Frequency of theater visits
Which objects should a business analyst use to visualize these requirements? - ANSWER:A histogram and
map
Which three actions can a business analyst complete in the Qlick Sense Enterprise hub? -
ANSWER:Publish an app into a stream
Publish a sheet into the Community section
Load data from multiple sources
A business analyst must create an interactive table to analyze sales performance for the selected year
and the previous year. Which are the correct expressions to meet this requirement? - ANSWER:Option A
Selected Year:
Sum ({$<Year={$=Only(Year))}>}Sales)
Previous Year:
Sum({$<Year={$(=Only(Year) -1)}>}Sales)
A hospital billing department is concerned with the performance of the cardiology and orthopedic
departments. The billing department wants to add a visualization to an existing app to analyze billing for
these two departments.
The business analyst must consider the hierarchy of:
- The department- The physicians in each department- The procedure performed by the physicians
What should the business analyst create to meet the requirements? - ANSWER:A bar chart using master
items drill-down
A bookmark for the departments
Qlik GeoAnalytics allows you to... - ANSWER:Create map visualizations and apply location-based analytics
and functions.
, A retailer with 300 locations worldwide needs to analyze its workforce to prepare for its next board
meeting. The two most important items to the board members are total compensation and number of
employees by city.
Which visualization should a business analyst use to meet this requirement? - ANSWER:Scatter plot
After the latest data reload, a business analyst notices the value for CategoryID 'B321 appears to be
different from the other values. What is causing this difference? - ANSWER:Pre-aggregated data is being
used
A business analyst must create new master items for quarterly calendar measures with company-specific
naming conventions based on:
- The Date field and the Sum of Sales- The new master items will calculate QTD Sales, Current QTD Sales,
Last QTD Sales, Current Quarter Sales, Last Year Current Quarter Sales, and Last Quarter Sales
Which three steps should the business analyst take to meet these requirements? - ANSWER:Save to
master items, rename master items
Right-click the Sales field in the assets panel and select Create calendar measures
Select Date, Sales, Sum, and Quarterly
A business analyst needs to present a one-slide story and be able to make selections in a visualization.
How should the business analyst meet this requirement? - ANSWER:Create a story and add a sheet from
the sheet library that contains the visualization
A company has customers in 16 countries. The majority of the customers are in Germany A business
analyst creates a fitter pane for Country and wants "Germany" listed first. The rest of the countries
should be listed in alphabetical order.
Which method should the business analyst use to meet this requirement? - ANSWER:In the data
manager edit the table, select Country! then select Order from the data profiling card
Which two features/functions are enabled by the Qlik Associative Engine? - ANSWER:Smart search and
data profiling
A manufacturer has several requirements for its new sales dashboard:
- Deliver analytics to mobile devices- Share data with retail partners via a custom portal- Prevent
sensitive data from being shared with competitors- Provide governed reusable assets
Which capabilities should a business analyst use to meet these requirements? - ANSWER:Mashups
Master items
Responsive design
Configurable security rules
