Question 1

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

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

Question 4

A business analyst needs to share a link to a specific visualization with colleagues

Which steps should the business analyst use?

Options :

A :

1. Go to the OMC and select App Object

2. Right-click the correct visualization to get the URL

3. Share the URL with colleagues

B :

1. Go to the Dev Hub and select Single Configurator

2. Select Add data

3. Copy the URL from the browser and share with colleagues

C :

1. Right-click the visualization and select Share

2. Select </> Embed

3. Copy the URL and share with colleagues

D :

1. Right-click the visualization and select View data

2. Select Export data

3. Share the provided link with colleagues

Answer: A

Question 5

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