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

The board asked the team to review current sales by age group on a bar chart. These groups were created in Data Manager and named AgeGroup, as follows:
• Children: up to 16 years;
• YoungAdult: between 17 and 30 years old;
• Adult: 31+
The analyst then defines the colors of the bars with an expression:
If( AgeGroup = 'Children', Red(), If( AgeGroup = 'YoungAdult', Blue(), Green() ))
What's left to complete the jobs and apply the result to the visualization?

Options :

A : In object properties, in data, create a calculated dimension using the informed expression

B : Create a master item for the dimension. In object properties, in color, select Color by Dimension and use the master item created

C : In the object properties, in appearance, select Colors and then select the Color by Expression type. Be sure to keep selected the option "the expression is a color code"

D : Create a metric as a master item with this expression. In the view select Color by Metric and point to the master item created

Answer: C

Question 3

A business analyst is testing an existing application that returns some unexpected results. Using the selection tool the business analyst observes the following:

When you select the Category field and the contents of Doc remain white. Selects the Year field and all Doc records become gray. Select some content in Doc and the Contents of Week are all gray, but the contents of Category are white. Selects a content from the ProductID field and the associated field ShipperID and Date remain white, but the Year field is grayed out.

What is causing these results?

2021-10-22-14-38-54-67b97a9a592cc6b65756f4592e7d1508

Options :

A : The model logic is incorrect and does not reflect a star schema

B : The master calendar table should be associated with the sales details table (Dim_Sales_Add)

C : The Doc field should be a key field in the master calendar table

D : Date fields have different properties and/or date types

Answer: D

Question 4

A cinema company is analyzing the age group of customers who watch movies at least once a month and where they live. The following requirements should be considered:

• Age of customers

• Customer address

• Frequency of visits

What objects should the business analyst use to meet the requirements?

Options :

A : A distribution chart and a pie chart

B : A map and scatter plot

C : A map and histogram

D : A distribution chart and a treemap

Answer: C

Question 5

A business analyst needs to add some images to a slide in a story in their personal workspace in Qlik Sense Enterprise.
What should the business analyst do to meet this requirement?

Smartly Prepare Exam with Free Online QSBA2022 Practice Test

Buying Options: