Download Qlik QSBA2021 Mock Test Study Material
QSBA2021 Questions Prepare with Learning Information
NEW QUESTION # 18
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?
- A. Apply a filter" to load three months of data
- B. Create a bucket that groups the three months of data
- C. Create a calculated field for the three months of data
- D. Use a WHERE clause to limit the data to three months
Answer: D
NEW QUESTION # 19
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?
- A. Use the media library to upload the mages
- B. Add the images from the snapshot library
- C. Drag and drop the images onto the sheet edit view
- D. Open the assets panel to drag and drop the images
Answer: A
NEW QUESTION # 20
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?
- A. ODAG
- B. Embedded Stories
- C. Qlik APIs
- D. Qlik Dynamic \news
Answer: B
NEW QUESTION # 21
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?
- A. Hyphen character ('.') is included m the source data
- B. The data type for CategorylD 332V does not match the others
- C. Some categories do NOT exist in the Category table
- D. Null values are deluded in the source data
Answer: B
NEW QUESTION # 22
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?
- A. Edit the Show Condition expression field in the sheets tor each department
- B. Choose to add a bookmark for each department
- C. Create sheets with alternate states for each department
- D. Use the Stones feature to create a story with embedded sheets for each department
Answer: B
NEW QUESTION # 23
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?
- A. An email trigger on a data reload
- B. A destination using Qlik NPrinting
- C. A condition using Qlik Alerting
- D. An action on the sheet containing the KPI
Answer: A
NEW QUESTION # 24
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?
- A. Force an association between the InternEmp and the Orders tables
- B. Create a concatenated key to associate the Employees and internEmp tables
- C. Create an association between the EmpID and EmployeelD fields
- D. Concatenate the InternEmp table to the Employees tables within data manager
Answer: D
NEW QUESTION # 25
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?
- A. Enable Sort by Expression ReloadTime().
- B. Disable Sorting Auto and uncheck all options.
- C. Disable Sorting Auto and uncheck Sort Numerically.
- D. Enable Sort by State and select Descending.
Answer: A
NEW QUESTION # 26
Refer to the exhibit.
What is the selection slate of light gray values?
- A. Alternative
- B. Excluded
- C. Possible
- D. Selected
Answer: B
NEW QUESTION # 27
A business analyst ;s creating an app tor the team. A set of selections must be applied every time an app is opened.
What should the business analyst do to meet this requirement?
- A. Use a sheet action and apply a bookmark named 'Default'
- B. Create a masnup and use the API to apply default selections
- C. Use Section access to predefine tie default selections
- D. Create a bookmark and select 'Set selections as app default"
Answer: A
NEW QUESTION # 28
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.)
- A. Stack dimensions and color by measure
- B. Alternative dimensions and diverging color scheme
- C. Stacked bar chart using ColorMix function
- D. Alternative dimensions using fixed number limitations
- E. Stack dimensions and color by dimension
Answer: B,C
NEW QUESTION # 29
The sales manager is investigating the relationship between Sales and Margin to determine if this relationship is linear when choosing the dimension Customer or Product Category The sales manager wants to have the potential percentage Sales tor each Stage (initial to Won) of the sales process What are the two correct visualizations?
- A. Scatter Plot Measures X-axis Sates and Y-axis Margin Alternatives dimensions Customer or Product category Funnel Chart Segments Stage Width Sales
- B. Distribution Plot Alternatives Measures Sales and Margin Alternatives dimensions Customer or Product category Bar Chart Dimension Stage. Measure Sates
- C. Combo Chan Measures Sales and Margin Dimensions Customer or Product category Pie Chart Dimension Stage Measure Sales
- D. Scatter Plot Measures X-axis Sates and Y-axis Margin Dimensions Customer or Product category Bar Chart Dimension Stage, Measure Sates
Answer: A
NEW QUESTION # 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.)
- A. Calculated fields
- B. Alternate states
- C. Master items
- D. Variables
- E. Set analysis
Answer: A,C,D
NEW QUESTION # 31
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?
- A. Gauge
- B. Table
- C. Combo chart
- D. Text and Image
Answer: B
NEW QUESTION # 32
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?
- A. * Create one Alternate State Set1
* Create two Filter Panels one associated lo this Set1 and one Default State1($)
* Create a Bar chart with the drill-down dimension and two measures sum({Set1-$) Sales) and sum('Set1-S) Sales) - B. * Create two Alternate States Set1 and Set2
* Create two Filter Panels each associated with an Alternate State
* Create a Bar chart with a drill-down dimension and two measures sum({Set1'$} Sales) and sum{fSet2"S} Sales) - C. * Create one Alternate State Set1
* Create two Filter Panels one associated to this Set1 and one Default State(S)
* Create a Bar chart with the drill-down dimension and two measures sum({Set1'$} Sales)and sum({'Set1"S) Sales) - D. * Create two Alternate States Sell and Set2
* Create two Finer Panels each associated with an Alternate Stale
* Create a Bar chart with drill-down dimension and two measures sum({Set1'S} Sates) and sum({,Set2'*S} Sales)
Answer: D
NEW QUESTION # 33
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?
- A. Open the Excel file, remove all columns that do not have the suffix '_c' and save t>e Me to be loaded
- B. Deselect the fields that do NOT have the '_c' suffix in the data manager table preview
- C. Utilize drier functionality in the data manager to select only columns with the suffix _C with a fitter condition
- D. Load all columns because the recommended associations will use only columns with the suffix '_c*
Answer: C
NEW QUESTION # 34
A business analyst creates an app for a large retailer The app is based on me past ^2 months of transactional data in CSV formal After successfully demonstrating the app the retailer provides a tile that contains another seven years of data After the new data is loaded the previously responsive app takes 10 times longer to respond to users' selections The app has many complex expressions Which two actions should the business analyst take to resolve the issues? (Select two)
- A. Make sure a I master items contain variables that define the expressions
- B. Request the data architect to create flags in the data model to optimize set analysis expressions
- C. Replace set analysis with calculated fields in the data manager
- D. Use JOIN statements to reduce the number of tables m the data model
- E. Create versions of the app using a WHERE clause m the data manager to restrict the data
Answer: A,B
NEW QUESTION # 35
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)
- A. Filter pane bar chart and KPIs
- B. Filter panes KPIs and a line chart
- C. Filter pane scatter plot and a map
- D. Filter pane KPls and a map
- E. Filter panes KPls and a combo chart
Answer: B,D,E
NEW QUESTION # 36
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?
- A. 1 Add an input field for vCountry and vCity
2 Sat the dimension limitation to the required maximum values 5 and 10
3 Apply the variable to each visualization
4 Add a bookmark Country and City - B. 1 Create two variables vCountry and vCity
2 Add a slider for vCountry and vCity
3 Apply the vanable to each virtualization - C. 1 Create two variables vCountry and vCrty
2 Add a slider for vCountry and vCity
3 Apply the variable to each virtualization
4 Set a sheet action that limits the data displayed - D. 1 Add an input field for vCountry and vCity
2 Set the dimension limitation to the required maximum values 5 and 10
3 Apply the variable to each visualization
Answer: B
NEW QUESTION # 37
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
- A. A show, hide container using a bar chart and set the show condition to Count(Distinct CustomerlD) <100
- B. A bar chart and in the Add-ons, set the calculation condition to Count(Customer ID) < 100
- C. A show/hide container using a master item bar chart and set the show condition to Count(CustomerlD) < 100
- D. A bar chart and in the Add-ons set the calculation condition 10 Count(DlSTINCT CustomerlD) < 100
Answer: A
NEW QUESTION # 38
......
Most Reliable Qlik QSBA2021 Training Materials: https://examcollection.vcetorrent.com/QSBA2021-valid-vce-torrent.html