お手軽QSBA2024問題集PDFのベスト問題集を使おう！高得点目指すならここ
Qlik Sense Business Analyst QSBA2024試験と認定テストエンジン
Qlik QSBA2024 認定試験の出題範囲：
| トピック | 出題範囲 |
|---|---|
| トピック 1 |
|
| トピック 2 |
|
| トピック 3 |
|
| トピック 4 |
|
質問 # 27
A business analyst designs a visualization to analyze a count of products by fixed price ranges. The customer now wants the price ranges to be dynamically modified so they are configurable by the application users. The business analyst modified the dimension axis on the visualization.
Which step should the business analyst complete next?
- A. Create a calculated field in Data manager, using the Class() function
- B. Load an independent source file to contain the user-defined boundary values
- C. Create the price range dimension using the Buckets feature in Data manager
- D. Define a variable and use it in a variable input object on the sheet
正解：D
解説：
To make the price ranges dynamically adjustable by the application users, a variable input object is the best approach. The business analyst can define a variable that stores the range value, which users can modify directly through a variable input control. This method allows users to change the price ranges interactively, giving them control over the ranges used in the analysis.
Key Concepts:
Variable Input Object: This object allows users to interact with and modify the values of predefined variables directly within a Qlik Sense sheet, which can then be used to adjust calculations dynamically, such as defining custom ranges.
Configurable by Users: This approach gives end-users the flexibility to modify the visualization based on their specific needs without requiring backend changes or reloading the app.
Why the Other Options Are Less Suitable:
B . Create a calculated field in Data manager, using the Class() function: The Class() function is useful for creating static price ranges, but it does not allow for user interaction or dynamic updates to the ranges.
C . Load an independent source file to contain the user-defined boundary values: While this could provide configurable ranges, it's unnecessarily complex and would require more management, and it's not as user-friendly as using a variable.
D . Create the price range dimension using the Buckets feature in Data manager: Similar to the Class() function, this would create static groupings, which wouldn't be dynamically adjustable by the user.
References for Qlik Sense Business Analyst:
Dynamic Controls with Variables: Qlik Sense provides the ability to create variable input objects that allow users to control how visualizations behave dynamically. This feature is highlighted in Qlik Sense's Business Analyst best practices when making interactive applications.
By using a variable and a variable input object, the business analyst enables user interactivity and customization, making A the correct choice.
質問 # 28
A business analyst created a visualization that has a color indicator when an order is below a certain fixed profit threshold. This visualization now needs to change so that the threshold can be defined by the user. The user base is approximately 1000 heavy Excel users. These thresholds will be defined by each user somewhat frequently, although the data changes only once per day.
Which action should the business analyst take to update this visualization?
- A. Introduce a variable for the threshold that is controlled by a variable slider
- B. Allow users to define their threshold in a shared spreadsheet and increase the app reload frequency to every hour
- C. Add a threshold field and provide a filter pane for that field for users to select
- D. Create threshold values in the data manager using the Bucket function
正解：A
解説：
The best approach to allow users to frequently adjust the profit threshold in the visualization is to use a variable controlled by a variable slider. This method allows each user to adjust the threshold value independently without requiring any changes to the data model or the visualization itself. Given that the user base consists of heavy Excel users, using a slider provides a familiar and intuitive way to interact with the threshold.
Key Concepts:
Variables and Sliders: Variables can be used to store threshold values, and sliders provide an easy way for users to adjust those variables interactively.
User Interaction: A variable slider is a user-friendly option for adjusting thresholds frequently, especially for users who are accustomed to working with data interactively.
Why the Other Options Are Less Suitable:
A . Threshold field with a filter pane: This option is less flexible and doesn't allow the same dynamic interaction as a variable and slider.
B . Shared spreadsheet and frequent app reloads: This approach is inefficient and would increase the load on the system unnecessarily. It is also less user-friendly for frequent threshold adjustments.
D . Bucket function: The Bucket function is not appropriate for this case, as it creates static groupings, which would not allow the user to adjust the threshold dynamically.
References for Qlik Sense Business Analyst:
Interactive Thresholds with Variables: Qlik Sense's variables and slider objects provide the best mechanism for dynamically controlling thresholds in a visualization.
Thus, introducing a variable for the threshold and controlling it with a variable slider is the best solution, making C the correct answer.
質問 # 29
A clothing manufacturer has operations throughout Europe and needs to manage access to the data.
There is data for the following countries under the field SACOUNTRY -> France, Spain, United Kingdom and Germany. The application has been designed with Section Access to manage the data displayed.
What is the expected outcome of this Section Access table?
- A. USER1 does not see data for France and Spain. USER2 does not see data for the United Kingdom. ADMIN sees data for all countries.
- B. USER1 sees data for France and Spain, USER2 sees data for the UK. ADMIN sees data for France, Spain and United Kingdom
- C. USER1 sees data for France and Spain, USER2 sees data for the UK. ADMIN sees data for France, Spain, Germany and United Kingdom
- D. USER1 does not see data for France and Spain, USER2 does not see data for United Kingdom. ADMIN can not open the application
正解：C
解説：
In this Section Access script, the roles and access to data for different users are defined based on the SACOUNTRY field. Here's how the data access will work:
ADMIN: The ADMIN user has access to all data because the * in the SACOUNTRY field allows full access to all countries in the dataset.
USER1: This user has access to Spain and France because the SACOUNTRY field specifies these countries for USER1.
USER2: This user has access to United Kingdom because the SACOUNTRY field specifies only the UK for USER2.
Key Concepts:
Section Access: This feature in Qlik Sense controls which data users can see based on their login credentials. The access rights are controlled through fields like ACCESS, USERID, and SACOUNTRY in this case.
Why the Other Options Are Less Suitable:
B and C: These suggest that users won't see data they have access to, which contradicts the defined Section Access script.
D: This incorrectly assumes that ADMIN cannot see Germany, which is not defined in the script.
References for Qlik Sense Business Analyst:
Section Access Best Practices: In Qlik Sense, Section Access tables define the data that users can see, and the use of * for the ADMIN role ensures access to all data.
Thus, A is the correct answer because it matches the expected data access behavior based on the script, making it the verified answer.
質問 # 30
An app needs to load a few hundred rows of data from a .csv text file. The file is the result of a concatenated data dump by multiple divisions across several countries. These divisions use different internal systems and processes, which causes country names to appear differently. For example, the United States of America appears in several places as 'USA', 'U.S.A.', or 'US'.
For the country dimension to work properly in the app, the naming of countries must be standardized in the data model.
Which action should the business analyst complete to address this issue?
- A. Cleanse the source text file prior to loading
- B. Load a lookup table to convert values
- C. Create a calculated master dimension expression
- D. Use the Replace option in Data manager
正解：B
解説：
In Qlik Sense, when dealing with inconsistent naming conventions across different systems or divisions (like the variation in country names), the best practice is to standardize the data during the loading process. Using a lookup table is the most efficient approach to achieve this. This involves loading a separate table that contains all variations of a country name along with the standardized version. During the load process, Qlik Sense can then map the varying names to a common value.
Key Concepts:
Lookup Table: A lookup table contains key-value pairs where different versions of a data element (like country names) are mapped to a single standard value. In this case, the lookup table could have entries like USA, U.S.A., US all mapped to United States of America.
Data Standardization: This is crucial in ensuring consistent analysis across datasets. By converting variations of country names into a single consistent value, the business analyst ensures that all data visualizations and analysis will treat "USA", "US", etc., as the same entity.
Why the Other Options Are Less Suitable:
A . Create a calculated master dimension expression: While this could theoretically work by creating a calculated expression to handle variations, it's not scalable or maintainable, especially as new variations in country names could appear in future data loads.
C . Cleanse the source text file prior to loading: This option would require modifying the raw data files manually, which is time-consuming and not sustainable if data is frequently updated or if the number of variations is extensive.
D . Use the Replace option in Data manager: The Replace option in the Data Manager could work on a small scale, but it requires manual intervention each time, which is not efficient or sustainable when new data is loaded. Also, it's more useful for one-off corrections than for handling systemic issues across multiple data loads.
References for Qlik Sense Business Analyst:
Data Modeling Best Practices: Lookup tables are a common approach to resolve issues of inconsistent data across multiple sources. They ensure that data is consistently represented in visualizations and reduce the need for manual intervention.
Data Cleansing During Loading: Qlik Sense allows for transformation and data cleansing during the data load process. A lookup table is part of this capability and ensures that the data loaded into the app is clean and consistent.
Using a lookup table is the most scalable and maintainable approach to standardizing country names in this scenario, which is why option B is the verified solution.
質問 # 31
A business analyst is working with retail data for consumer products. The customer is interested in the following:
* Ability to look for outliers on sales volume and margin %
* Ability to understand the clustering of products visually
* Ability to see products that are above the median sales volume
Which action should the business analyst take to implement these requirements?
- A. Create a combo chart with K-Means colors for the bar and a line measure representing median sales volume
- B. Create a treemap visualization showing sales volume and margin% by product with the median sales volume in the title
- C. Create a scatter plot using K-Means to color the products and add a median sales volume reference line
- D. Create a pivot table and color the sales volume cell using K-Means function and median sales volume as an additional column
正解：C
解説：
A scatter plot is the best choice for visualizing outliers, clustering, and products that are above the median sales volume. Scatter plots are excellent for showing relationships between two variables (like sales volume and margin %) while providing the ability to highlight outliers. By using K-Means clustering to color the products, the business analyst can visually group similar products. Additionally, adding a median sales volume reference line makes it easy to identify which products are above or below the median.
Key Concepts:
Scatter Plot: This visualization is ideal for detecting outliers and understanding the distribution and clustering of data points.
K-Means Clustering: This technique groups similar data points (products) based on their values, which helps to identify patterns visually.
Median Reference Line: Adding a reference line for median sales volume ensures that the analyst can easily see which products are performing above or below the median.
Why the Other Options Are Less Suitable:
A . Pivot table: While a pivot table could show aggregated data, it is not as effective for visualizing outliers or clustering as a scatter plot.
B . Treemap: A treemap can show hierarchical relationships but is not as effective for identifying clusters or outliers.
C . Combo chart: A combo chart is not as well-suited for visualizing clustering and outliers as a scatter plot.
References for Qlik Sense Business Analyst:
Outliers and Clustering Visualization: Qlik Sense recommends scatter plots for visualizing relationships between two measures and for detecting outliers and clustering in the data.
Thus, creating a scatter plot with K-Means clustering and a median sales volume reference line is the best approach, making D the verified answer.
質問 # 32
A business analyst is creating a new app with sales dat
a. The visualizations must meet several requirements:
A Bar chart that shows sales by product group is used in multiple sheets
* A KPI object that visualizes that the total amount of sales is used once
* A Treemap that shows margin by product group is used one time inside a Container Which visualization should be added to the master items library?
- A. Container
- B. KPI
- C. Treemap
- D. Bar chart
正解：D
解説：
The Bar chart is used multiple times across various sheets, which makes it a good candidate to be added to the Master Items library. Master items are reusable components that can be added to multiple visualizations across different sheets without needing to recreate them. Since the bar chart will be reused multiple times, adding it to the Master Items ensures consistency and reusability.
Key Concepts:
Master Items: These are predefined dimensions, measures, or visualizations that can be reused across multiple sheets in an app, ensuring consistency and reducing development time.
Why the Other Options Are Less Suitable:
A . Container: The container is only used once in this scenario, so it doesn't need to be a master item.
B . KPI: The KPI is only used once, so it does not require master item status.
D . Treemap: The treemap is only used once in a container, so it doesn't need to be a master item.
References for Qlik Sense Business Analyst:
Master Items for Reusability: Qlik Sense recommends adding frequently used charts or dimensions to the master items for easy reuse and consistency.
Thus, the bar chart is the best choice for adding to the master items, making C the correct answer.
質問 # 33
A business analyst is developing an app that requires a complex visualization. The visualization is very similar in style and configuration to another visualization in a different app, but the data models are completely different.
Which action should the business analyst take to most efficiently create the new visualization?
- A. Copy and paste the visualization between the apps, and update the data properties in the new app.
- B. Open both apps at the same time. Drag the base visualization between apps, then update the data properties.
- C. Add the base visualization to the master items and use it as a template for the new visualization.
- D. Note the properties of the base visualization and create the new visualization from scratch.
正解：A
解説：
When working with Qlik Sense apps, a business analyst often encounters situations where visualizations may be highly similar between different apps, even if the underlying data models differ. In such cases, efficiency is crucial, and Qlik Sense provides several methods to reuse visualizations across apps. Let's break down the options:
A . Add the base visualization to the master items and use it as a template for the new visualization.
This option suggests adding the base visualization to the master items. While master items are useful for reusing dimensions, measures, and visualizations within the same app, they do not easily transfer across apps. In this case, since the visualization is required in a different app, this approach would not be the most efficient or feasible.
B . Note the properties of the base visualization and create the new visualization from scratch.
This option involves manually noting the properties and then replicating them in the new app. While this would work, it is labor-intensive and increases the likelihood of human error, especially in complex visualizations. It is not an efficient solution for business analysts looking to save time.
C . Copy and paste the visualization between the apps, and update the data properties in the new app.
This is the most efficient solution. Qlik Sense allows for the copying and pasting of visualizations between different apps, and you can then adjust the properties to fit the new data model. This option enables the business analyst to leverage existing visual work without having to recreate it from scratch. Updating the data properties, such as dimensions and measures, ensures that the visualization functions correctly with the new data model.
D . Open both apps at the same time. Drag the base visualization between apps, then update the data properties.
While this seems like a practical option, Qlik Sense does not allow users to drag and drop visualizations directly between different apps. As a result, this method is not possible.
Key Qlik Sense Business Analyst References:
Copying and pasting visualizations is a common practice in Qlik Sense when working between different apps. The ability to quickly replicate and adapt visualizations across apps helps streamline the development process.
Adjusting data properties such as dimensions and measures ensures that visualizations adapt to different data models without the need for full recreation.
Efficiency and error reduction are critical in app development, and copy-paste functionalities are specifically designed to reduce manual work in such scenarios.
In conclusion, the correct and most efficient action for the business analyst to take is C, copy and paste the visualization, and then update the relevant data properties.
質問 # 34
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 for each Stage (Initial to Won) of the sales process.
Which visualizations will meet these requirements?
- A. Combo chart: Measures Sales and Margin, Dimensions Customer or Product category Pie chart: Dimension Stage, Measure Sales
- B. Scatter plot: Measures X-axis Sales and Y-axis Margin, Alternative dimensions Customer or Product category Funnel chart: Segments Stage, Width Sales
- C. Distribution plot: Alternative measures Sales and Margin, Alternatives dimensions Customer or Product category Bar chart: Dimension Stage, Measure Sales
- D. Scatter plot: Measures X-axis Sales and Y-axis Margin, Dimensions Customer or Product category Bar chart: Dimension Stage, Measure Sales
正解：B
解説：
For analyzing the relationship between Sales and Margin, a scatter plot is ideal, as it allows you to visualize the relationship between two measures (Sales and Margin) across various dimensions such as Customer or Product Category. The funnel chart is perfect for visualizing stages in a sales process, as it shows how sales progress from the initial stage to the final (Won) stage, with the width of each segment representing the total sales for each stage.
Key Concepts:
Scatter Plot: This type of chart is specifically designed to visualize the correlation or relationship between two measures, making it ideal for analyzing Sales versus Margin across different dimensions.
Funnel Chart: This chart is particularly suited for visualizing the sales stages, as it visually demonstrates the proportion of sales moving through each stage of the sales funnel.
Why the Other Options Are Less Suitable:
A . Scatter plot and Bar chart: While a scatter plot is correct for analyzing Sales and Margin, a bar chart won't adequately represent the different stages of the sales process as effectively as a funnel chart.
C . Combo chart and Pie chart: A combo chart could potentially work, but it would not show the relationship between Sales and Margin as clearly as a scatter plot. A pie chart is also less effective for representing stages in a sales funnel.
D . Distribution plot and Bar chart: A distribution plot does not effectively show the relationship between two measures, and a bar chart isn't the best choice for visualizing the stages of a sales process.
References for Qlik Sense Business Analyst:
Scatter Plot for Relationships: This chart type is highly recommended when exploring relationships between two continuous variables, such as Sales and Margin.
Funnel Charts: These are ideal for visualizing how data moves through various stages of a process, such as sales stages, from initial engagement to final sale.
Therefore, the combination of a scatter plot and a funnel chart provides the best solution, making B the correct answer.
質問 # 35
Refer to the exhibit.
A movie analyst is using an app to gain insights into films created in the early 20th century. The analyst reviews the filter for Length Range, notices a hyphen "-", and selects it.
What can the analyst determine from the resulting filter panes?
- A. Movies at the start of the 20th century often varied in length.
- B. All movies from the 1920s or 1930s contain no data for Length Range.
- C. The source data for six movies is missing a Length Range.
- D. Six movies in the source data contain illegal characters for the Length Range field.
正解：C
解説：
In the provided exhibit, the movie analyst filters by the Length Range field and notices a hyphen ("-"), which typically indicates missing data in Qlik Sense. When the analyst selects this hyphen, it filters out the rows where no data exists for the Length Range field.
Let's review the options:
A . Six movies in the source data contain illegal characters for the Length Range field.
This statement is incorrect. The hyphen ("-") is not an indicator of illegal characters. In Qlik Sense, it usually represents null values or missing data, not improperly formatted data.
B . Movies at the start of the 20th century often varied in length.
This answer is not relevant to the specific observation of the hyphen in the Length Range field. The hyphen does not provide insights into the variation of movie lengths; it indicates missing data.
C . All movies from the 1920s or 1930s contain no data for Length Range.
While the screenshot shows some movies from different decades, we cannot definitively conclude that all movies from a particular era are missing the Length Range data. The hyphen indicates that some movies across various years are missing data, but this does not apply to all movies from the 1920s or 1930s.
D . The source data for six movies is missing a Length Range.
This is the correct interpretation. The hyphen in the Length Range column indicates that these six movies lack data for this field. Selecting the hyphen allows the analyst to identify movies with missing values in the Length Range field.
Key Qlik Sense Business Analyst References:
Hyphen ("-") in Qlik Sense typically represents null or missing values in a field.
Filter panes in Qlik Sense allow users to quickly see where data may be incomplete or missing, and selecting these null values provides immediate insight into which records are affected.
Thus, the correct determination is that the source data for six movies is missing a Length Range.
質問 # 36
A marketing team needs to display sales for a limited number of products by providing a bar chart that the user can control. The visualization has several requirements:
* Starts with the top five products
* Allows the user to change the number of products displayed
* Allows the user to scroll through all products on a mini chart
The business analyst creates a bar chat and a variable. Which steps should the business analyst complete next?
- A. * Use the variable to fix the limitation
* Add a slider object and use the variable to set its value - B. * Add the slider object and use the variable to set its value
* Use the properties to set the number of bars to custom - C. * Use the variable to fix the limitation
* Add an input box to enable the user to enter the required value - D. * Add the slider object and use the variable to set its value
* Set the number of bars to custom and use the variable to set its value
正解：D
解説：
To meet the requirement of controlling the number of products displayed in the bar chart, the business analyst should use a slider object tied to a variable. The variable will store the number of products the user wants to display. In the Appearance section of the bar chart's properties, the analyst can set the number of bars to a custom value using the variable, ensuring that the user can dynamically change the number of displayed products.
Key Concepts:
Slider Object: This provides a user-friendly way for users to adjust the number of products displayed in the bar chart.
Custom Bar Limitation: By setting the number of bars displayed to a custom value controlled by the variable, the business analyst ensures that the user can dynamically adjust how many products are shown.
Why the Other Options Are Less Suitable:
B . Use the variable to fix the limitation and add an input box: While this could work, sliders provide a better, more intuitive user experience than input boxes for adjusting values dynamically.
C . Use the variable to fix the limitation and add a slider: This is almost correct, but it misses the step of setting the number of bars to a custom value using the variable.
D . Add the slider object and set its value, but without custom bar settings: While adding a slider is correct, not setting the number of bars to custom using the variable means the user wouldn't be able to dynamically control the number of displayed products.
References for Qlik Sense Business Analyst:
Dynamic Control with Variables and Sliders: Qlik Sense best practices recommend using sliders and variables to give users control over visualizations, particularly when it comes to dynamically limiting data displayed.
Thus, adding the slider object and setting the number of bars to a custom value controlled by the variable is the best solution, making A the verified answer.
質問 # 37
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.
正解：C
解説：
For the KPI object that meets the requirements of comparing Current Year (CY) sales against Last Year (LY) sales, while ensuring the KPI remains static regardless of selections, we need to leverage Set Analysis with the 1 identifier. This ensures the KPI ignores any selections made by the user.
Option A uses the correct structure of Set Analysis that compares CY sales to LY sales within the APAC region, and the 1 set identifier ensures the KPI does not change based on selections. The logic is structured as follows:
Sum({1 <region={"apac"}, year={$(=max(year))}>} Sales) computes the sales for the APAC region for the current year (CY).
Sum({1 <region={"apac"}, year={$(=max(year)-1)}>} Sales) computes the sales for the APAC region for the previous year (LY).
This expression will ensure that the comparison of sales between CY and LY is made, without being affected by user selections.
Key Concepts:
Set Analysis with 1: The 1 set identifier ensures that selections made by users do not affect the result, making the KPI static.
Comparison of CY vs. LY: The use of $(=max(year)) and $(=max(year)-1) ensures that the current and previous years are dynamically compared.
Why the Other Options Are Less Suitable:
B, C, and D: While these options use a similar structure, they do not correctly handle the measure structure or have syntactical issues. Only Option A properly utilizes the 1 set identifier and dynamic year comparison for the APAC region.
References for Qlik Sense Business Analyst:
Set Analysis for Static KPIs: Using the 1 set identifier in Qlik Sense ensures that a KPI remains static and unaffected by user selections, which is essential for business requirements like this.
Thus, A is the correct choice because it correctly computes the required static KPI for the APAC region, making it the verified answer.
質問 # 38
Two customers in an organization want to use an app that contains a finance data set. With different analysis objectives, each customer will only use a subset of that data. Which procedure should the business analyst follow?
- A. Apply Section Access to manage the data for each customer
- B. Duplicate and rename the apps for each customer
- C. Unpivot, then re-associate the data tables for each customer
- D. Create multiple visualizations using set analysis
正解：D
解説：
In Qlik Sense, Set Analysis is one of the most powerful tools available to a Business Analyst for managing different subsets of data within the same app. Since both customers are working with the same finance dataset but have different objectives, creating multiple visualizations using set analysis allows the analyst to tailor the data views for each customer without duplicating the app or creating complex data models.
Key Concepts:
Set Analysis: This feature enables the creation of expressions that define subsets of data, allowing you to filter data within specific visualizations. This is ideal when multiple users need different insights from the same underlying dataset.
Flexibility: Using set analysis, you can specify conditions within individual visualizations so that each user can focus on their own segment of the data without impacting others.
Efficiency: This method avoids redundancy by ensuring you only need one app and one data model, instead of duplicating and maintaining multiple apps or applying complex logic such as Section Access.
Why the Other Options Are Less Suitable:
A . Apply Section Access: While Section Access is useful for managing security and limiting what users can see in the entire dataset, it is primarily designed to restrict data access based on user roles. In this case, both users need access to the same dataset but will conduct different analyses. Section Access would be an overly restrictive and complex solution for this scenario.
C . Duplicate and rename the apps: This is inefficient because it leads to redundancy and makes maintenance harder (e.g., any changes to the dataset or visualizations would need to be applied to both apps). It also increases the risk of inconsistencies across versions of the app.
D . Unpivot and re-associate the data tables: This option is not relevant to the problem, as unpivoting is more appropriate for transforming datasets rather than tailoring views for different users within the same app. It does not address the need for customer-specific analysis objectives.
References for Qlik Sense Business Analyst:
Set Analysis: In the Qlik Sense Business Analyst's toolkit, Set Analysis is covered as a method to manage diverse data subsets within single apps, providing the flexibility needed in multi-user environments without duplicating content.
Efficient Application Design: Best practices suggest maintaining a single app where possible to ensure consistency and ease of maintenance, which aligns with the approach of using Set Analysis.
By using Set Analysis, you provide both customers with tailored data views that are easily managed and updated within a single app. This is why option B is the most effective and verified solution.
質問 # 39
A business analyst needs to create a visualization that compares two measures over time using a continuous scale that includes a range. The measures will be Profit and Revenue.
Which visualization should the business analyst use?
- A. Bullet chart
- B. Bar chart
- C. Scatter plot
- D. Line chart
正解：D
質問 # 40
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. Select each field in the Data model viewer and use the Density value to determine the level of nulls
- B. Inspect each field in the Data model viewer and use the Subset ratio to determine the level of null values
- C. Look at the tags fields for any indication that $null is associated to this field
- D. Enable the Preview Panel in the Data model viewer and inspect the data table visually to determine the level of null values
正解：A
解説：
The Density value in the Data Model Viewer provides a measure of how "dense" or "sparse" a field is in terms of data completeness. A higher density value means fewer nulls, while a lower value indicates more nulls. By checking the density value for each field, the business analyst can determine the percentage of non-null values, which is critical for understanding data quality and completeness.
Key Concepts:
Density Value: This is a measure in Qlik Sense that indicates the proportion of non-null values in a field. A field with a high density is mostly populated, while a lower density indicates a high proportion of null values.
Data Model Viewer: This tool allows analysts to inspect the structure and quality of data fields, including metrics such as density.
Why the Other Options Are Less Suitable:
B . Preview Panel: While the Preview Panel shows sample data, it does not provide a comprehensive measure of null values and is more suited for a quick glance rather than detailed analysis.
C . Tags fields with $null: This would show if the field contains any nulls, but it wouldn't quantify the level of nulls.
D . Subset Ratio: The subset ratio compares values across related tables, not null values within individual fields.
References for Qlik Sense Business Analyst:
Data Quality in Qlik Sense: Using the Density value is the best way to assess the proportion of null values in a field, making it ideal for the business analyst to understand the completeness of the data.
Thus, A is the correct answer because the density value provides the required insight into the level of nulls in each field.
質問 # 41
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. Present distinct values and Density% for the ExamID field in the Exams table
- B. Subset ratio and Present distinct values for the ExamID field in the Attempts table
- C. Total distinct values and Subset ratio for the StudentID field in the Attempts table
- D. Non-null values and Subset ratio for the StudentID field in the Students table
正解：C
解説：
To answer the two questions:
How many students are in the system?
What percentage of students have not yet attempted an exam?
The analyst needs to focus on the StudentID field, specifically in relation to the Attempts table. This is because the Attempts table captures all exam attempts made by students, and we can deduce which students have and have not made an attempt by examining the presence of StudentID values in this table.
Key Concepts:
Total Distinct Values: This provides the total number of unique students who have attempted exams. It helps identify how many students have made at least one attempt.
Subset Ratio: This compares the values of StudentID between the Students table and the Attempts table. The subset ratio shows how many students in the Students table are represented in the Attempts table. This ratio helps determine the percentage of students who have not yet attempted any exams.
Why the Other Options Are Less Suitable:
B . Non-null values and Subset ratio for the StudentID field in the Students table: The non-null values in the Students table are not relevant to the question about exam attempts. The focus should be on whether the StudentID is present in the Attempts table.
C . Subset ratio and Present distinct values for the ExamID field in the Attempts table: This focuses on exams, not students. The question specifically relates to how many students have attempted exams.
D . Present distinct values and Density% for the ExamID field in the Exams table: This focuses on the number of exams and their density, which does not help in determining how many students have attempted or not attempted an exam.
References for Qlik Sense Business Analyst:
Subset Ratio and Distinct Counts: Qlik Sense's data model viewer provides valuable metadata like the distinct count of a field and its subset ratio when compared to related fields in other tables. This is particularly useful for understanding relationships and gaps in the data, such as identifying students who have not yet made an exam attempt.
By focusing on the Total distinct values and Subset ratio for the StudentID field in the Attempts table, the business analyst can easily determine the total number of students and the percentage who have not yet attempted an exam, making A the verified answer.
質問 # 42
A company director who spends very little time in applications needs to be informed when a threshold is breached. Which feature should the business analyst use?
- A. Storytelling
- B. Bookmark
- C. Weekly PDF report
- D. Alerting
正解：D
解説：
To inform a company director when a threshold is breached, Alerting is the most appropriate feature. Qlik Sense allows users to set up automated alerts based on specific conditions or thresholds. These alerts can be configured to notify users when certain criteria are met, making it ideal for keeping the director informed without requiring them to constantly check the application.
Key Concepts:
Alerting: This feature allows users to set conditions (such as when a sales or performance threshold is breached) and automatically send notifications to the relevant individuals.
Automated Notifications: Alerting ensures that the director is notified promptly and automatically when a critical threshold is reached.
Why the Other Options Are Less Suitable:
A . Weekly PDF report: A weekly report would not provide real-time notifications, which are necessary when thresholds are breached.
B . Storytelling: Storytelling is used for presentations, not for monitoring thresholds.
D . Bookmark: A bookmark only saves a particular selection or view, and cannot send notifications when a condition is met.
References for Qlik Sense Business Analyst:
Alerting in Qlik Sense: Qlik Sense's alerting functionality is designed to notify users when specific conditions are triggered, making it ideal for scenarios where timely notifications are critical.
Thus, using Alerting is the best solution to notify the director when a threshold is breached, making C the verified answer.
質問 # 43
A business analyst using a shared folder mapped to S:\488957004\ receives an Excel file with more than 100 columns. Many of the columns are duplicates. Any current columns that should be used have the suffix '_c' appended to the column name.
Which action should the business analyst take to load the Excel data?
- A. Utilize filter functionality in the Data manager to select only columns with the suffix '_c' with a filter condition
- B. Open the Excel file, remove all columns that do not have the suffix '_c', and save the file to be loaded
- C. Deselect the fields that do not have the '_c' suffix in the Data manager table preview
- D. Load all columns because the recommended associations will use only columns with the suffix '_c'
正解：C
解説：
When loading data from an Excel file with more than 100 columns, where only columns with the suffix _c are relevant, the most efficient approach is to use the Data Manager. The Data Manager provides a preview of the table being loaded, allowing the business analyst to deselect columns that do not have the _c suffix. This is a quick and straightforward method that avoids manual editing of the Excel file and allows the analyst to focus on the necessary columns.
Key Concepts:
Data Manager Preview: The Data Manager allows you to inspect and modify which columns will be loaded into the data model. The preview panel makes it easy to deselect columns that are not needed.
Efficient Data Loading: By using the Data Manager, the business analyst can avoid loading unnecessary columns, ensuring a cleaner and more manageable data model.
Why the Other Options Are Less Suitable:
A . Load all columns: This would load unnecessary columns, leading to a bloated data model with duplicates and irrelevant data.
B . Utilize filter functionality: While filtering could work, deselecting fields directly in the preview is more efficient and straightforward.
C . Edit the Excel file: Manually editing the Excel file is unnecessary and could lead to errors, especially when Qlik Sense provides tools to handle this within the platform.
References for Qlik Sense Business Analyst:
Data Manager for Field Selection: Qlik Sense recommends using the Data Manager to inspect and selectively load data fields, which is particularly useful when dealing with large datasets.
Thus, D is the best solution because it allows for selective loading of relevant columns, making it the correct answer.
質問 # 44
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. Develop a master item using the required source fields
- B. Combine the various source fields in a calculated item in the Data manager
- C. Aggregate the data to the source period
- D. Combine the source fields and create additional fields in Excel
正解：A
解説：
In Qlik Sense, creating Master Items allows business analysts to define fields, dimensions, and measures that are used consistently across the app. This is particularly important for measures that will be used repeatedly. By defining these as master items, you ensure that all calculations are consistent and optimized for user experience and performance. This approach also supports drill-down capabilities while ensuring a responsive user experience.
Key Concepts:
Master Items: Master Items are reusable definitions for dimensions, measures, and visualizations. When you create a measure as a Master Item, it becomes available for use across different visualizations, ensuring consistency and reducing duplication of effort.
User Experience and Load Time: Using Master Items optimizes performance, as Qlik Sense caches the results of these items, reducing the need for recalculating complex measures each time they are used.
Why the Other Options Are Less Suitable:
A . Aggregate the data to the source period: While aggregation could reduce the data volume, it would limit the ability to drill down to the detailed levels required by the users.
C . Combine the various source fields in a calculated item in the Data manager: While you could create calculated fields, this method would be less efficient than defining measures in the Master Items library. Calculations done outside Master Items would need to be manually repeated in each visualization, leading to inconsistencies.
D . Combine the source fields and create additional fields in Excel: This would not optimize user experience or load time, as it relies on modifying source data outside of Qlik Sense and could lead to unnecessary data duplication and inefficiencies.
References for Qlik Sense Business Analyst:
Master Items Best Practices: Qlik Sense promotes the use of Master Items for consistent measure definition and reuse, as they improve performance and ensure consistency across multiple visualizations.
By creating a Master Item, the business analyst ensures a streamlined and efficient user experience, making B the best and verified option for this scenario.
質問 # 45
A business analyst needs to create a visualization that compares two measures over time using a continuous scale that includes a range. The measures will be Profit and Revenue.
Which visualization should the business analyst use?
- A. Bullet chart
- B. Bar chart
- C. Scatter plot
- D. Line chart
正解：D
解説：
A line chart is the most appropriate visualization for comparing two continuous measures (Profit and Revenue) over time. Line charts are designed to show trends and patterns over a continuous scale (such as time), making it ideal for this scenario where we need to observe how both Profit and Revenue vary across a period.
Key Concepts:
Continuous Scale: Line charts are specifically suited for continuous data like time, making them the preferred choice when tracking changes over time for multiple measures.
Dual Measure Comparison: A line chart allows you to plot two measures on the same axis, making it easy to compare their trends over the same period.
Why the Other Options Are Less Suitable:
B . Bullet chart: A bullet chart is used to compare a single measure against a target, not for tracking two measures over time.
C . Bar chart: Bar charts are better suited for comparing categorical data, not continuous measures over time.
D . Scatter plot: Scatter plots are used to compare relationships between two measures but are not suited for continuous time-based comparisons.
References for Qlik Sense Business Analyst:
Line Charts for Time Series Data: Line charts are the recommended visualization for comparing multiple measures over time in Qlik Sense, especially when working with continuous data like Profit and Revenue.
Thus, the line chart is the best choice for this scenario, making A the correct answer.
質問 # 46
A business analyst is creating an app that contains a bar chart showing the top-selling product categories. The users must be able to control the number of product categories shown.
Which action should the business analyst take?
- A. Create a variable and variable input object and use variable in the sales expression
- B. Use firstsortedvalue() function to extract the required product categories
- C. Create a variable and variable input object and use variable in dimension limit field
- D. Use a rankQ function in the sales expression
正解：C
解説：
When users need control over how many product categories are shown in a bar chart, the most effective solution is to use a variable input object. This allows users to dynamically adjust the number of categories displayed.
A: Create a variable and variable input object and use the variable in the dimension limit field.
This is the correct solution. By creating a variable and using the Variable Input object, the user can dynamically control the number of product categories shown in the bar chart by adjusting the dimension limit. This method provides flexibility and an intuitive interface for the user.
B: Use firstsortedvalue() function to extract the required product categories.
The firstsortedvalue() function is typically used to extract the first occurrence of a value based on sorting criteria, but it's not the best approach for controlling the number of displayed categories dynamically.
C: Create a variable and variable input object and use the variable in the sales expression.
While variables can be used in expressions, this approach is less efficient than using the dimension limit field, which is specifically designed for controlling the number of displayed values.
D: Use a rankQ function in the sales expression.
The rankQ function ranks data, but it's not the most efficient or intuitive method for dynamically controlling the number of product categories displayed in a bar chart. It would require more complex expressions compared to the straightforward use of a variable in the dimension limit field.
Key Qlik Sense Business Analyst References:
The Variable Input object allows users to interact with and adjust variables within the app. This is ideal for giving users control over visual elements like the number of categories displayed in a chart.
The Dimension Limit field is specifically designed to control how many items (like product categories) are shown in a chart based on a ranking or expression.
Thus, the best approach to allow users to control the number of product categories displayed is to create a variable and variable input object, and use the variable in the dimension limit field.
質問 # 47
A dashboard developer finishes creating a supply chain analysis app and is presenting it to leadership for review. The landing page shows four visualizations including:
* Bar chart showing available supply by product category
* Line chart showing total cost of deliveries to the warehouse by month-year
* Scatter plot showing cost of delivery and time-to-deliver by product
* A map that shows the volume of delivery from suppliers to warehouses using a line layer Leadership asks the developer how they can see the total cost of delivery overall. How can the analyst show this information to leadership?
- A. Select all products in the scatter plot to see the total delivery cost
- B. Adjust the line layer on the map to reflect cost of delivery
- C. Use the line chart to add up each month-year to get to the number required
- D. Create a KPI object that shows the total cost of delivery
正解：D
解説：
In Qlik Sense, when leadership requests a high-level summary such as the total cost of delivery overall, the most efficient way to present this information is by using a KPI object. The KPI object is specifically designed to display a single, important metric in a simple and clear format.
A . Use the line chart to add up each month-year to get to the number required.
This option is not efficient because it requires manual effort to add up the values from the line chart for each period. Additionally, this method is prone to human error and would be time-consuming during a presentation.
B . Create a KPI object that shows the total cost of delivery.
The most appropriate action here is to use a KPI object to display the overall total cost of delivery. A KPI in Qlik Sense is specifically designed to display single, aggregate measures in a clean and concise way, making it the perfect choice for presenting high-level summaries to leadership.
C . Adjust the line layer on the map to reflect the cost of delivery.
While it is possible to adjust the map, the map is primarily used for spatial analysis. Modifying it to reflect the overall cost of delivery would not be as intuitive or effective as using a KPI object. Additionally, it could lead to unnecessary clutter and confusion for the audience.
D . Select all products in the scatter plot to see the total delivery cost.
Selecting all products in the scatter plot would not give the desired result because the scatter plot is designed to show relationships between variables (cost of delivery and time-to-deliver). It's not ideal for displaying aggregate values like total cost.
Key Qlik Sense Business Analyst References:
KPI objects are ideal for presenting single, key metrics such as the total cost of delivery. They provide a straightforward, visually clear representation of high-level performance indicators.
Best practices in dashboard development emphasize the importance of creating specific visualizations that address both granular and high-level data needs. KPI objects fulfill the need for high-level summaries, particularly in leadership presentations.
Thus, the best way to show the total cost of delivery to leadership is to create a KPI object.
質問 # 48
......
無料提供中のQSBA2024試験問題集で（2025年最新のPDF問題集）信頼度の高いQSBA2024テストエンジン：https://jp.fast2test.com/QSBA2024-premium-file.html