Free Qlik Sense Business Analyst Certification Exam – February 2021 Release Exam QSBA2021 Exam Practice Test

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?

• Use the media library to upload the mages
• Add the images from the snapshot library
• Open the assets panel to drag and drop the images
• Drag and drop the images onto the sheet edit view

An organization recently acquired a competitor A business analyst needs to merge me custom databases with 20 years of customer and order transactions. The data must be integrated into the existing app to show the past two years of data Performance degradation must be minimizedWhat should the business analyst do to meet this requirement?

• * Add the new Customers and Orders tables and associate the new tables to me existing data model * Filter the data from the Customers and Orders table to bring only data created within the past two years
• * Add the new Customers and Orders tables and concatenate the new tables to the existing data model * Filter the data from the Orders table to bring only data created within the past two years
• * Add the new Customers and Orders tables and associate the new tables to the existing data model * Filter the data from the Orders table to bring only data created within the past two years
• * Add the new Customers and Orders tables and concatenate the new tables to the existing data model * Filter the data from the Customers and Orders table to bring only data created within the past two years

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 nameWhat should the business analyst do to load the Excel data?

• Open the Excel file, remove all columns that do not have the suffix '_c' and save t>e Me to be loaded
• Deselect the fields that do NOT have the '_c' suffix in the data manager table preview
• Utilize drier functionality in the data manager to select only columns with the suffix _C with a fitter condition
• Load all columns because the recommended associations will use only columns with the suffix '_c*

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?

• A Multi KPI set analysis
• A pivot table that filters by region
• A dashboard of KPIs and section access
• A dashboard with regional bookmarks

A sales manager needs to visualize the company's sales. The sales manager needs to understand how sates and profitability are related over time. The visualization will be used in a printed annual report.The business analyst has access to the following data:* Order Dates* Order ID* Total Safes by Order* Net profit margin%* Cost of Goods Sow (COGS)Which visualization should the business analyst use?

• Scatter Plot
• Combo Chart
• Distribution Plot
• Line Chart

CountryUSAUSU,S,ARefer 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?

• Use data profiling to group the country values
• Use data profiling and replace the country names
• Use data profiling 10 hide the inconsistent country names
• Use the filter and rename the country values

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 MonthAdditionally the learn wants to dear fillers while navigating between sheets and enable chat in the hub Which features should be used?

• Create default bookmark, maps sheet actions enable the insight Bot
• Create master measures alternate states GeoAnalytics enable Insights in app capabilities
• Create default bookmark GeoAnalytics alternate states enable the insight Bot
• Create master measures sheet actions maps enable Insights in app capacities

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 costMargin% can be calculated by dividing profit by revenue Profit is the difference between total cost and total satesWhich two sets of fields can the business analyst use to meet these requirements? (Select two.)

• Line Geometry Margin%
• Product Category Location
• Sales Total Cost
• Product Category Retail Store Location Factory Location
• Line Geometry

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 mapWhich two features are needed to meet these requirements? (Select two.)

• Standard map visualization
• Mashups
• Qlik Sense Mobile offline
• Qlik NPrinting
• Qlik web connectors

A business analyst s creating an app for the sales team. The app must meet several requirements* Compare 10 top -performing sales representatives and the amount of sales for each* Investigate margin percentage and total sales by each product category* View distribution of sales amountWhich visualizations should be used for this app?

• A treemap box plot, and histogram
• A bar chart, line chart, and scatter plot
• A treemap container and distribution plot
• A bar chart scatter plot and histogram