Qlik Sense Business Analyst Certification Exam - 2022 (QSBA2022) Free Practice Test

Question 1

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*

Correct Answer: B

Question 2

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?

A. Add tags into the data fields to improve how the Insight Advisor identifies the fields when using the natural language queries Use the Selection tool to remove any tads not needed for the search results

B. Create master dimensions and measures, including calendar measures to define fiscal periods Use tags to improve the insight Advisor search features and include vocabulary terms

C. Define me business logic and vocabulary to define values using the fields m me data set Create groups and set properties in fields Use Calendar groups to define custom periods

D. Update the data set using data manager or data load editor to include these terms as flags or values in the data set Also define the variable to determine which calculation should be used for each field

Correct Answer: D

Question 3

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?

A. Create a sheet that features colorful and layered visualizations and export as a PDF

B. Create a storytelling narration m a published app that contains embedded sheets

C. Embed a video player m the shared app with a recording to describe the charts

D. Set up Nprinting to connect to the app and design a slideshow-style report

Correct Answer: B

Question 4

Refer to the exhibit

A business analyst is modifying a box plot End users report unexpected blue dots in a box plot What should the business analyst do?

A. Ask the data architect to modify the data model

B. Under Box plot elements deselect Include outliers

C. Under the Dimensions menu, deselect Include null values

D. Under Box plot elements, select Whisker length and increase to two interquartile ranges

Correct Answer: D

Question 5

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. Use Section access to predefine tie default selections

C. Create a bookmark and select 'Set selections as app default"

D. Create a masnup and use the API to apply default selections

Correct Answer: C

Question 6

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. Distribution Plot Alternatives Measures Sales and Margin Alternatives dimensions Customer or Product category Bar Chart Dimension Stage. Measure Sates

B. Scatter Plot Measures X-axis Sates and Y-axis Margin Alternatives dimensions Customer or Product category Funnel Chart Segments Stage Width Sales

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

Correct Answer: B

Welcome to TestSimulate

Qlik Sense Business Analyst Certification Exam - 2022 (QSBA2022) Free Practice Test