Question 1

A developer has created an application with native objects in a way that is well organized by sheets so that users can gain their insights independently. Users have notebooks, mobile phones and tablets. When the application was created, the developer did not imagine that the application would be accessed by mobile devices, but the good news is that the application adapts very well to any format and screen size.

What's the name of this feature?

Options :

A : Associative selection model

B : Responsive design

C : User-friendly analytics

Answer: B

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

A business analyst is creating an app that requires several visualizations

* A scatter plot mat shows the margin percentage and total sales by product category

* A map with a the layer that visualizes lines between retail stores and lactones

* A KPI that shows total cost

Margin?n be calculated by dividing profit by revenue Profit is the difference between total cost and total sates

Which two sets of fields can the business analyst use to meet these requirements? (Select two.)

Options :

A :

Line Geometry

Margin%

B :

Product Category

Location

C :

Sales

Total Cost

D :

Product Category

Retail Store Location

Factory Location

E : Line Geometry

Answer: A,C

Question 5

A business analyst using a shared folder mapped to S \419379942\ receives an Excel We with more than 100 columns Many of the columns are duplicates. The current set of columns mat should be used have the suffix '_c* appended to the column name

What should the business analyst do to load the Excel data?

Options :

A : Open the Excel file, remove all columns that do not have the suffix '_c' and save t>e Me to be loaded

B : Deselect the fields that do NOT have the '_c' suffix in the data manager table preview

C : Utilize drier functionality in the data manager to select only columns with the suffix _C with a fitter condition

D : Load all columns because the recommended associations will use only columns with the suffix '_c*

Answer: C