Qlik Sense Certification- Business Analyst: Questions
And Accurate Answers
Which of the following statements is true about master items? Right Ans -
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?
Right Ans - A histogram and map
Which three actions can a business analyst complete in the Qlick Sense
Enterprise hub? Right Ans - 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? Right Ans - 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? Right
Ans - A bar chart using master items drill-down
A bookmark for the departments
, Qlik GeoAnalytics allows you to... Right Ans - 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?
Right Ans - 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? Right Ans - 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? Right Ans - 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? Right Ans - 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?
Right Ans - In the data manager edit the table, select Country! then select
Order from the data profiling card
And Accurate Answers
Which of the following statements is true about master items? Right Ans -
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?
Right Ans - A histogram and map
Which three actions can a business analyst complete in the Qlick Sense
Enterprise hub? Right Ans - 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? Right Ans - 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? Right
Ans - A bar chart using master items drill-down
A bookmark for the departments
, Qlik GeoAnalytics allows you to... Right Ans - 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?
Right Ans - 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? Right Ans - 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? Right Ans - 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? Right Ans - 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?
Right Ans - In the data manager edit the table, select Country! then select
Order from the data profiling card
