QlikView QSBA2022 시험

Question No : 1

A customer wants to perform a regional sates analysis to learn how products setover 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.
What steps should the business anaryst follow to meet these requirements?

• A.• Create one Alternate State Set1 • Create two Filter Panels one associated to this Set1and one Default State(S) • Create a Bar chart with the drill-down dimension and two measuressum({Set1’$} Sales)and sum({'Set1"S) Sales)
• B.•Create two Alternate States Set1and 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 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)
• 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)

답을 확인하기

정답:

Question No : 2

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.Open the assets panel to drag and drop the images
• D.Drag and drop the images onto the sheet edit view

답을 확인하기

정답:

Question No : 3

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.Under Box plot elements, select Whisker length and increase to two interquartile ranges
• B.Under Box plot elements deselect Include outliers
• C.Under the Dimensions menu, deselect Include null values
• D.Ask the data architect to modify the data model

답을 확인하기

정답:

Question No : 4

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.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
• C.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
• 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

답을 확인하기

정답:

Question No : 5

Use the reload function in the sheet Editor asset panel

답을 확인하기

정답: D

Question No : 6

To improve efficiencies a hospital mustanalyze how often a surgery is started late by operating room and surgeon.
The business analyst must consider several factors
• Dates of each surgery
• Number of minutes the start of the surgery is delayed
• Operating room
• Surgeon name
Which visualization should the business analyst use to meet these requirements?

• A.A combo chart that shows total minutes of delayed starts by operating room and surgeon
• B.A bar chart with total minutes of delayed starts and a drill-down from operating room to surgeon
• C.A scatter plot with delayed start minutes per day operating room and surgeon
• D.A line chart with total minutes of delayed starts and a drill-down from operating room to surgeon

답을 확인하기

정답:

Question No : 7

Refer to the exhibits



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

• A.The data type for CategorylD 332V does not match the others
• B.Null values are deluded in the source data
• C.Some categories do NOT exist in the Category table
• D.Hyphen character ('.') is included m the source data

답을 확인하기

정답:

Question No : 8

Refer to the exhibit.
Country
USA
US
U.S.A.
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?
A. Use data profiling to group the country values
B. Use data profiling and replace the country names
C. Use data profiling 10 hide the inconsistent country names
D. Use the filter and rename the country values

답을 확인하기

정답: C

Question No : 9

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

• A.Table
• B.Text and Image
• C.Gauge
• D.Combo chart

답을 확인하기

정답:

Question No : 10

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?

• A.Grid chart with diverging color by measure
• B.Line chart with area gradient color by measure
• C.Waterfall chart with custom positive value color
• D.Mekko chart with diverging color by dimension

답을 확인하기

정답:

Question No : 11

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.Use the Stones feature to create a story with embedded sheets for each department
• B.Edit the Show Condition expression field in the sheets tor each department
• C.Choose to add a bookmark for each department
• D.Create sheets with alternate states for each department

답을 확인하기

정답:

Question No : 12

Refer to the exhibits.



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.Disable Sorting Auto and uncheck all options.
• B.Disable Sorting Auto and uncheck Sort Numerically.
• C.Enable Sort by Expression ReloadTime().
• D.Enable Sort by State and select Descending.

답을 확인하기

정답:

Question No : 13

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)

• A.Associate the new tables with the old tables
• B.Synchronize the scripted tables and modify the tables
• C.Synchronize the new tables and modify the tables
• D.Add the new tables via the Add data icon
• E.Delete the existing tables and re-import the tables

답을 확인하기

정답:

Question No : 14

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

• A.Master items
• B.Variables
• C.Calculated fields
• D.Alternate states
• E.Set analysis

답을 확인하기

정답:

Question No : 15

A large auditing firm has a proprietary web portal that all of the' customers use to access their own data. 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 QlikSeriesapp is reloaded.
What should the business analyst recommend?

• A.Qlik Dynamic
  ews
• B.ODAG
• C.Embedded Stories
• D.QlikAPIs

답을 확인하기

정답: