Question 1

A marketing team is using an app to analyze the company events. The team registers attendees with information such as an ID name and region and discusses business opportunities with attendees Opportunities are evaluated m time and set to a different status.

The team wants to use insight Advisor to query events and opportunities to:

* Review specific areas and periods

* Use marketing terms not currently present in the app when classifying opportunities

* Define calendar periods and add calculations for specific data fields

Some examples are as follows:

Other-Image-72ab1f2a4-aa74-4e74-80c2-4fa267633198

Which process should the business analyst follow?

Options :

A : Add tags into the data fields to improve how the Insight Advisor identifies the fields when using the natural language queries Use the Selection tool to remove any tads not needed for the search results

B :

Define me business logic and vocabulary to define values using the fields m me data set Create groups and set properties in fields Use Calendar groups to define custom periods

C : Create master dimensions and measures, including calendar measures to define fiscal periods Use tags to improve the insight Advisor search features and include vocabulary terms

D : Update the data set using data manager or data load editor to include these terms as flags or values in the data set Also define the variable to determine which calculation should be used for each field

Answer: D

Question 2

A business analyst must display current year sales versus previous year sales by region, sub-region and city.
The result will be a pivot table, with rows for the region, sub-region, and city, and columns for Current Year Sales and Previous Year Sales.
Which calculated expressions should the business analyst create to meet these requirements?

Options :

A : 1. Sum({$< OrderYear = {$(=Year(Today()))} >} Sales)
2. Sum({$< OrderYear = {$(=Year(Today())-1)} >} Sales)

B : 1. Sum({$< OrderYear = {CurrentYear} >} Sales)
2. Sum({$< OrderYear = {CurrentYear-1} >} Sales)

C :

1. Sum({$< OrderYear = {Year(Today())} >} Sales)

2. Sum({$< OrderYear = {Year(Today())-1} >} Sales)

D :

1. Sum({$< OrderYear = {$(=Year(Today(0)))} >} Sales)

2. Sum({$< OrderYear = {$(=Year(Today(0))-1)} >} Sales)

Answer: A

Question 3

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 4

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 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?

Confidently Practice Online with Free QSBA2022 Exam Cram

Buying Options: