NO.18 A business analyst is designing a business intelligence solution to track production. There are several requirements in the complicated factory environment
* Printed work summary documents produced daily
* Information monitors that show custom website with visualizations from QIA Sense
* Ability to calculate the shortest routes between two sets of coordinates Which three options are needed to meet these requirements? (Select three)

NO.19 A large auditing firm has a proprietary web portal that all of the’ customers use to access their own dat a. 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 Qlik Series app is reloaded.
What should the business analyst recommend?

NO.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 Which visualization should the business analyst use?

NO.21 Refer to the exhibit.

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?

NO.22 Refer to 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?

NO.23 A customer wants to perform a regional sates analysis to learn how products set over time m different areas The business analyst needs to design a sheet in the app tor business users to perform several tasks
* Select two different groups of countries to study
* Compare sales over time between these two groups using a bar chart
* Change the group items by selecting different countries at any time
* Select a time range in the bar chart and drill-down to daily transactional sales Which steps should the business anaryst follow to meet these requirements?

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

NO.25 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?

NO.26 Refer to the exhibit.

What is the selection slate of light gray values?

NO.27 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 sales department has several additional requirements
* 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?

NO.28 Refer to the exhibit.

After the latest data reload a business analyst notices the value tor CategoryID ‘B321’ seems different What is causing this discrepancy?

NO.29 A finance manager uses an Excel file to record travel expenses The file has historical data and is used m multiple Qlik Sense apps The finance manager needs to deploy only the past three months of data to the regional sales managers Which solution should be used to meet the requirements using the data manager?

NO.30 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?

NO.31 A business analyst is creating a new app with sales dat
a. The visualizations must meet several requirements:
* A Bar chart mat shows sales by product group is used m multiple sheets
* A KPI object that visualizes that the total amount of sales is used once
* A Treemap mat shows margin by product group is used one time inside a Container What should be added to the master items library?

NO.32 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
* Contain visualizations that present dearly to a large audience
* Answer audience questions dynamically
* Be made available as shared content
* Emphasize important sales revenue
Which Qlik Sense features must the business analyst prepare?

NO.33 A business analyst is developing an app that contains a data model with fields Country. City. Sales ProductName and ProductCategory. The global sales manager wants to add new visualizations to this app The business analyst must include the following
* Ability to dynamically change the number of countries and cities
* Display a maximum of 10 countries
* Display a maximum of 5 cities per country
Which steps should the business analyst take?

NO.34 Refer to the exhibit.

A business analyst needs to display a bat chart only when less than 100 customers are selected What should the business analyst create to meet this requirement

NO.35 A business analyst using a shared folder mapped to S 419379942 receives an Excel We with more than 100 columns Many of the columns are duplicates. The current set of columns mat should be used have the suffix ‘_c* appended to the column name What should the business analyst do to load the Excel data?

NO.36 A company installs Qlik Sense on Windows without any additional visualization bungles A business analyst must create an app with three sheets
* Sheet 1 KPIs and sales trends for the past 12 months
* Sheet 2 Regional sales by representative
* Sheet 3 Sales by country displayed in a map
Users must be able to view all of the sheets and make selections for their analyses.
Which three objects should be added to the three sheets? (Select three)

NO.37 A company CFO has requested an app that contains visualizations applicable to analyzing the finance data Each regional finance team will analyze their data, and the app must contain a high-level sheet that navigates to relevant detail sheets.
Which features support a logical design structure?