Qlik QSBA2022 問題集

質問 1：
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. Create a calculated field for the three months of data
B. Use a WHERE clause to limit the data to three months
C. Create a bucket that groups the three months of data
D. Apply a filter" to load three months of data
正解：D

質問 2：
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. Waterfall chart with custom positive value color
B. Mekko chart with diverging color by dimension
C. Line chart with area gradient color by measure
D. Grid chart with diverging color by measure
正解：B

質問 3：
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 scatter plot with delayed start minutes per day operating room and surgeon
B. A line chart with total minutes of delayed starts and a drill-down from operating room to surgeon
C. A combo chart that shows total minutes of delayed starts by operating room and surgeon
D. A bar chart with total minutes of delayed starts and a drill-down from operating room to surgeon
正解：D

質問 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. 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
B. 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
C. 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
D. 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
正解：B

質問 5：
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. Combo Chan Measures Sales and Margin Dimensions Customer or Product category Pie Chart Dimension Stage Measure Sales
B. Scatter Plot Measures X-axis Sates and Y-axis Margin Dimensions Customer or Product category Bar Chart Dimension Stage, Measure Sates
C. Scatter Plot Measures X-axis Sates and Y-axis Margin Alternatives dimensions Customer or Product category Funnel Chart Segments Stage Width Sales
D. Distribution Plot Alternatives Measures Sales and Margin Alternatives dimensions Customer or Product category Bar Chart Dimension Stage. Measure Sates
正解：C