Qlik Sense Business Analyst Certification Exam - June 2018 Release 認定 QSBA2018 試験問題:

1. A marketing team needs to analyze current sales by age groups in a bar chart. The following age groups are created in the data manager and the field is named AgeGroup:
* Children 16 years old and younger
* YoungAdult: 17 to 30 years old
* Adult: 31 years old and older
The business analyst will use an expression to set the colors for the bars:
If ( [AgeGroup] = 'Children', Red() , If ([AgeGroup] = ' Your.gAdult', Blue () , Green())) Which steps must be completed to apply the correct colors in the visualization'?

A) Select Data in the properties panel and create a calculated dimension using the expression in the expression editor.
B) Create a master item measure using the expression. In the visualization, select Color by measure and use the newly created master item.
C) Create a master item dimension using the expression. In the visualization, select Color by dimension and use the newly created master item.
D) Under Appearance in the properties panel, select Color then select Color by expression and make sure that The expression is a color code is checked

2. Refer to the exhibit.

A business analyst must analyze sales using an existing sales order app.
* The Orders table in the app was added from a QVD file using the data manager
* The Orders table in the app and the QVD do NOT contain a SalesAmount field
* SalesAmount can be calculated by multiplying the Quantity and UnitPrice How should the business analyst add a SalesAmount field into the Orders table?
A)

B)

C)

D)

A) Option A
B) Option C
C) Option D
D) Option B

3. A business analyst must create a horizontal bar chart to identify the top Sales Reps. Customer Segment Description, and Customer City
* Users must be able t(^analyze the data for one field at a time
* The chart should show the unique number of customers for each dimension being analyzed
* The dimensions and measures created must be re-used on other charts
Which steps should the business analyst perform to configure the chart correctly?

A) * Create all three dimensions as master items and add one as the chart dimension and the other two as alternative dimensions
* Create a master item measure using Count(Distinct [Customer Number]) and add it to the chart
* Change the chart presentation to Horizontal and sort it by the measure
B) * Create all three dimensions as master items and add one as the chart dimension and the other two as alternative dimensions
* Create a master item measure using Count(Total (Customer Number)) and add it to the chart
* Change the chart presentation to Horizontal and sort it by the measure
C) * Create all three dimensions as master items and add to the bar chart
* Create a master item measure using Count{Distinct [Customer Number]) and add it to the chart
* Change the chart presentation to Horizontal and sort it by the first dimension
D) * Create a cyclic dimension as a master item using all three dimensions and add it to the chart
* Create a master item measure using Count{Distinct [Customer Number]) and add it to the chart
* Change the chart presentation to Horizontal and sort it by the measure

4. A business analyst creates a scatter plot and wants to save it for reuse by colleagues. The business analyst must remain the owner of this scatter plot and should be the only person allowed to make changes. These changes should be applied automatically to all instances of this visualization Which two actions should the business analyst take to meet these requirements? (Select two.)

A) Copy the scatter plot to the custom objects
B) Publish the app to the Everyone stream
C) Copy the scatter plot on every sheet of the app
D) Publish the finished scatter plot to the hub
E) Add the finished scatter plot to the master items

5. A printing company has several requirements for a new Qlik Sense app
* Report of daily work orders
* Total number of print jobs
* Print jobs based on region
* Total number of print jobs by month
The app will be used by executives, sales managers, sales representatives, and press workers. Which sheets should a business analyst build to meet these requirements?

A) * Sheet 1 Dashboard with a KPI visualization of total print jobs, and a bar chart with print jobs by region
* Sheet 2: Visualizations that show the count of print jobs by month, customer sales representative, and region
* Sheet 3: Details page that shows the daily print jobs in a table
B) * Sheet 1: Dashboard with a KPI visualization of total print jobs, and a bar chart with print jobs by region
* Sheet 2 Details page that shows the daily print jobs in a table
* Sheet 3: Report page that shows the daily print jobs
C) * Sheet 1: Details page that shows the daily print jobs in a table
* Sheet 2 Dashboard with a KPI visualization of total print jobs, and a bar chart with print jobs by region
* Sheet 3: Visualizations that show the count of print jobs by month and press worker
D) * Sheet 1: Details page that shows the daily print jobs in a table
* Sheet 2: Dashboard with a KPI visualization of total print jobs by month, customer sales representative, and region
* Sheet 3 Report page that shows the daily print jobs

質問と回答：