Qlik QSBA2021 問題集

質問 1：
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 the Dimensions menu, deselect Include null values
C. Ask the data architect to modify the data model
D. Under Box plot elements deselect Include outliers
正解：A

質問 2：
Refer to the exhibit.

A CEO wants to use a similar visualization on the company's dashboards
The visualization must meet several requirements
* Show three years of sales data
* Display sales trends by month
* Allow comparison of years using an area style display
Which set of actions should a business analyst take to meet these requirements?
A. * Add an area chart
* Add Month first then Year as the dimensions
* Add SumfSates) as the measure
* In the properties panel under Area select the dimension Year
B. * Add a ,line chart
* Add a master drill-down dimension with Year and Month
* Add Sum(Sates) as the measure
* In the properties panel under Presentation, select Area
C. * Add a fine chart
* Add Month first then Year as the dimensions
* Add Surry Sales > as the measure
* In the properties panel under Presentation select Area
D. * Add an area chart
* Add Year first then Month as the dimensions
* Add Sum(Sales) as the measure
* In the properties panel under Area select the dimensions
正解：D

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

質問 4：
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

質問 5：
An organization recently acquired a competitor A business analyst needs to merge me custom databases with 20 years of customer and order transactions. The data must be integrated into the existing app to show the past two years of data Performance degradation must be minimized What should the business analyst do to meet this requirement?
A. * Add the new Customers and Orders tables and associate the new tables to the existing data model
* Filter the data from the Orders table to bring only data created within the past two years
B. * Add the new Customers and Orders tables and concatenate the new tables to the existing data model
* Filter the data from the Orders table to bring only data created within the past two years
C. * Add the new Customers and Orders tables and associate the new tables to me existing data model
* Filter the data from the Customers and Orders table to bring only data created within the past two years
D. * Add the new Customers and Orders tables and concatenate the new tables to the existing data model
* Filter the data from the Customers and Orders table to bring only data created within the past two years
正解：A