Qlik QSBA2024 問題集

質問 1：
A business analyst from the APAC region is creating a single KPI object for that region.
The analyst must meet the following requirements:
* The KPI should show a total of sales
* The business wants to compare current year (CY) vs last year (LY) sales
* The KPI should not change if the user makes selections
Which measure(s) will allow the KPI object to fulfill this requirement?
A.

B.

C.

D.

正解：A
解説: (Topexam メンバーにのみ表示されます)

質問 2：
A customer needs to distribute sales data to a variety of teams. The internal analyst team requires a global view of dat a. The sales team requires mobile device access.
Which solution will meet the needs of both teams?
A. Two apps: one designed for mobile and one for internal use
B. One app with various objects
C. A mashup with various objects
D. One app with a specific extension for mobile users
正解：A
解説: (Topexam メンバーにのみ表示されます)

質問 3：
A business analyst is creating a data model from several Excel files that contain several hundred thousand rows of dat a. The requirements include:
* Users need to drill down to various details within the available data set.
* Several final measures will be repeatedly used. These final measures require combining several fields in a single table.
* User experience and load time is a high priority.
Which action should the business analyst take to meet these requirements?
A. Combine the various source fields in a calculated item in the Data manager
B. Combine the source fields and create additional fields in Excel
C. Develop a master item using the required source fields
D. Aggregate the data to the source period
正解：C
解説: (Topexam メンバーにのみ表示されます)

質問 4：
Refer to the exhibit.

The users of a Qlik Sense app report slow performance. The app contains approximately 10 million rows of dat a. The business analyst notices the following KPI master measure definition:
Left{ Trim( TransactionName), 1 ) * Right ( TransactionName, 5) Which steps should the business analyst complete to improve app performance?
A. * In the Data manager, use the Split function to split the field values with the underscore character as the separator.
* In the Data manager, use the Add calculated field function to multiply the 1st and the 3rd column of the split field.
* Reload the data.
B. Change the master measure definition as follows:
subfield( TransactionName, '',!)* subfieldl TransactionName, ' ', 3)
C. In the Data manager, use the Replace function to remove the middle part of the field TransactionName
D. Ask the developer of the underlying database to change the structure of the field TransactionName.
正解：A
解説: (Topexam メンバーにのみ表示されます)

質問 5：
A business analyst has access to all of a company's data for the past 10 years. The source table consists of the following fields: TransactionID, TransactionTime, Transaction Date, Transaction Year, Cardholder, Cardholder address, Cardissuer, and Amount.
Users request to create an app based on this source with the following requirements:
* Users only review the data for the past 2 years
* Data must be updated daily
* Users should not view cardholder info
Which steps should the business analyst complete to improve the app performance?
A. * Deselect Cardholder and time fields in Data manager
* Use a filter pane based on auto-calendar fields
* Perform a daily reload via the Data manager
B. * Deselect Cardholder and time fields in Data manager
* Apply a filter to extract data based on transaction year
* Request a daily reload task from the system admin
C. * Delete Cardholder and time fields in Data manager
* Use set analysis to show data based on transaction year
* Use an API to perform a daily reload task
D. * Delete Cardholder and time fields in Data manager
* Use a bookmark based on auto-calendar fields
* Use the reload function in the sheet Editor asset panel
正解：B
解説: (Topexam メンバーにのみ表示されます)