Qlik QSBA2024 問題集

質問 1：
A customer needs to demonstrate the value of sales for each month of the year with a rolling 3-month summary. Which visualization should the business analyst recommend to meet the customer's needs?
A. Combo chart
B. Scatter plot
C. Mekko chart
D. Pie chart
正解：A
解説: (Topexam メンバーにのみ表示されます)

質問 2：
A business analyst needs to create two side-by-side charts for a sales department with the following data:
* Number of orders
* Name of the customer
* Percentage of margin
* Total sales
The charts use a common dimension, but each chart has different measures. The analyst needs to create a color association between the two charts on the dimension values.
Which action should the business analyst take?
A. Select 'By Dimension' and 'Persistent colors' in the Colors property panel
B. Use nested IF statements to set the colors by expression for each dimension value
C. Use the Fieldlndex function to set the colors by expression for each dimension value
D. Define the color values in the master measures and use the color library
正解：A
解説: (Topexam メンバーにのみ表示されます)

質問 3：
Exhibit.

Refer to the exhibit.
An app is being developed at a university to monitor student exam attempts- Three core tables are loaded into the app for Students, Exams, and Attempts. Students can attempt the same exam multiple times.
Before building any visualizations, the business analyst needs to know:
* How many students are in the system
* What percentage of students have not yet attempted an exam
Which metadata should the analyst focus on to answer these questions?
A. Subset ratio and Present distinct values for the ExamID field in the Attempts table
B. Total distinct values and Subset ratio for the StudentID field in the Attempts table
C. Non-null values and Subset ratio for the StudentID field in the Students table
D. Present distinct values and Density% for the ExamID field in the Exams table
正解：B
解説: (Topexam メンバーにのみ表示されます)

質問 4：
Refer to the exhibit.


Refer to the exhibits.
A business analyst must add a list of temporary employees (interns) to the current sales app. The app contains an existing employees table. When the business analyst profiles the data, the association view displays possible associations as shown.
Which action should the business analyst take in Data manager 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. Concatenate the InternEmp table to the Employees tables within Data manager
D. Create an association between the EmpID and EmployeelD fields
正解：D
解説: (Topexam メンバーにのみ表示されます)

質問 5：
The business analyst creates one table by concatenating and joining several source tables. This has resulted in a table of several thousand rows that may have several columns containing between 30% and 70% null values. The business analyst needs to understand the level of null values in each field of this table to determine if this is an issue.
Which capability should the business analyst use?
A. Inspect each field in the Data model viewer and use the Subset ratio to determine the level of null values
B. Enable the Preview Panel in the Data model viewer and inspect the data table visually to determine the level of null values
C. Select each field in the Data model viewer and use the Density value to determine the level of nulls
D. Look at the tags fields for any indication that $null is associated to this field
正解：C
解説: (Topexam メンバーにのみ表示されます)