Question 1

A business analyst has access to all of a company's data tor the past 10 years The source table consists of the following fields Transactions Transaction Time Transaction Date Transaction Year Cardholder Cardholder address Cardissuer and Amount Users request to create an app based on this source

Users only review me data for the past 2 years Data must be updated daily Users do not view cardholder into

What should the business analyst do to reprove the app performance?

Options :

A :

1. Deselect Cardholder and time field in data manager

2. Use a pant based on auto-calendar fields

3. Perform a daily reload via the data manager

B :

1. Delete Cardholder and time fields in data manager

2. Use set analysis to show data based on transaction year

3. Use an API to perform a daily reload task

C :

1. Deselect Cardholder and time fields in data manager

2. Apply a filter to extract data based on transaction year

3. Request a daily reload task from the System Admin

D :

1. Delete Cardholder and time fields in data manager

2. Use a bookmark based on auto-calendar fields

3. Use the reload function in the sheet Editor asset panel

Answer: C

Question 2

A multinational company wants to demonstrate the amounts in dollars and local currency. How would you solve this scenario?

Options :

A : Create an application and use Dual() function in all currency fields to match USD to local currency

B : Add additional expressions one for local currency and one with USD

C : Create two applications, one for each currency and use document chaining

D : Create an application and add a table with currency conversion where USD is the base currency

Answer: D

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

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

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

Confidently Practice Online with Free QSBA2022 Exam Cram

Buying Options: