NO.27 A company CEO requests a dashboard that easily displays provides understating and tracks company performance. There are several ma n dashboard requirements:
* Viewable by a mobile device
* Display multiple key measures
* Provide ability to easily navigate to other sheets
Which feature meets these requirements?

NO.28 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.29 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?

NO.30 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 Which three options are needed to meet the requirements? (Select three.)

NO.31 Refer to the exhibit.

A CEO wants to use a similar visualization on the company’s dashboards
The visualization must meet several requirements
* Show three years of sales data
* Display sales trends by month
* Allow comparison of years using an area style display
Which set of actions should a business analyst take to meet these requirements?

NO.32 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.33 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.34 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.35 Country
USA
US
U,S,A
Refer to the exhibit.
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?

NO.36 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.37 A business analyst needs to develop a visualization that compares performances of every product the company sells and each product category. The CEO wants to highlight the worst- and best-performing products and categories in a meeting that beg/is in one hour Using a bar chart which two approaches should the business analyst use? (Select two.)

NO.38 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.39 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?

NO.40 A marketing team is using an app to analyze the company events. The team registers attendees with information such as an ID name and region and discusses business opportunities with attendees Opportunities are evaluated m time and set to a different status.
The team wants to use insight Advisor to query events and opportunities to:
* Review specific areas and periods
* Use marketing terms not currently present in the app when classifying opportunities
* Define calendar periods and add calculations for specific data fields Some examples are as follows:

Which process should the business analyst follow?

NO.41 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.
* Information must be updated every hour to the company’s information monitor
* Data from Instagram must be fetched over a REST connection and combined with Google Analytics data
* There must be a way to visualize changes of followers *i a map
Which two features are needed to meet these requirements? (Select two.)

NO.42 A business analyst wants to send an email to app users when the region’s sales exceed $50,000. The notification must be delivered through a mobile app What should the business analyst configure?

NO.43 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.44 A business analyst wants to create a dashboard for the Finance team to use The app must include four sheets one looking at the full dataset and three others focused on the regions APAC EMEA and AMERICAS each.
The team needs visualizations for
* Sales by Product in the past 6″ months
* Cost of Sales on a map by Country
* Sales Cost and Margin by Month
Additionally the learn wants to dear fillers while navigating between sheets and enable chat in the hub Which features should be used?

NO.45 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.)

NO.46 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 )