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

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

Confidently Practice Online with Free QSBA2022 Exam Cram

Buying Options: