Question 1

A company has acquired a new ERP system that has already passed through the approvals and must be inserted in the existing main application. Legacy system data is already available in the data model. Both customer account tables have similar column structure, but still have different names. Registration codes have already been planned in your systems so that conflicts do not occur.

What actions should the business analyst take to gather the data from both systems?

2021-10-22-13-59-46-61bddcd792c4453667218f49eccf6e80

Options :

A : 1. Select the data from the new system
2. Move over legacy system data
3. Rename the pool
4. Click Apply

B : 1. Select legacy system data
2. Concatenate tables
3. Select the data from the new system
4. Map the tables
5. Click apply

C : 1. Select the data from the new system
2. Move over the legacy table
3. Define associations
4. Click Apply

D : 1. Select legacy system data
2. Concatenate tables
3. Select the data from the new system
4. Click on the sample data
5. Click Apply

Answer: B

Question 2

A business analyst s creating an app for the sales team. The app must meet several requirements

* Compare 10 top -performing sales representatives and the amount of sales for each

* Investigate margin percentage and total sales by each product category

* View distribution of sales amount

Which visualizations should be used for this app?

Options :

A : A treemap box plot, and histogram

B : A bar chart, line chart, and scatter plot

C : A treemap container and distribution plot

D : A bar chart scatter plot and histogram

Answer: A

Question 3

A business analyst needs to analyze sales using an existing Sales Orders application:

• The sales order details table were added from a QVD file using Data Manager;

• The in-app and QVD sales order table does not have the pre-calculated "Sales" field

• Sales can be calculated by multiplying between "Qty" and "UnPrice"

How should the business analyst add the "Sales" field to the sales order table?

2021-10-22-14-30-44-24d6ee1c04d0d9442c628f3ab0500d6a

Options :

A : In the Data Viewer, add a calculated field named "Sales" with the expression: UnPrice * Qty

B : In Data Manager, add a calculated field named "Sales" with the expression: Sum(UnPrice * Qty)

C : In Data Manager, add a calculated field named "Sales" with the expression: UnPrice * Qty

D : In qvd file sales orders, add an additional field with the name "Sales" with the expression: UnPrice * Qty

Answer: C

Question 4

A company installs Qlik Sense on Windows without any additional visualization bungles A business analyst must create an app with three sheets

* Sheet 1 KPIs and sales trends for the past 12 months

* Sheet 2 Regional sales by representative

* Sheet 3 Sales by country displayed in a map

Users must be able to view all of the sheets and make selections for their analyses.

Which three objects should be added to the three sheets? (Select three)

Options :

A : Filter pane scatter plot and a map

B : Filter pane bar chart and KPIs

C : Filter panes KPls and a combo chart

D : Filter pane KPls and a map

E : Filter panes KPIs and a line chart

Answer: A,C,D

Question 5

Refer to the exhibit.

Other-Image-29a7ed21f-a02a-46a8-9302-23d912f81da6

What is the selection slate of light gray values?

Options :

A : Possible

B : Excluded

C : Selected

D : Alternative

Answer: B

Free QSBA2022 Mock Exam – Practice Online Confidently

Buying Options: