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

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

Question 5

A business analyst s creating an app for the sales team. The app must meet several requirements

* Compare 10 top -performing sales representatives and the amount of sales for each

* Investigate margin percentage and total sales by each product category

* View distribution of sales amount

Which visualizations should be used for this app?

Options :

A : A treemap box plot, and histogram

B : A bar chart, line chart, and scatter plot

C : A treemap container and distribution plot

D : A bar chart scatter plot and histogram

Answer: A