Refer to the exhibit.

The data architect toads these fields from a data source A business analyst is creating an app for the human resources team Several visualizations are required
Line chart to show the number of new hires and terminations monthly
Treemap to show the number of employees by department and job level
Distribution plot of annual salaries or amount of benefits received by duration of employment or location
KPI to show average cost per employee
The cost per employee can be calculated by adding the employee salary to the amount of benefits received Which two additional fields does the business analyst need from the data architect lo meet these requirements? (Select two )

• A. Years employed
• B. Department
• C. Average cost of employee
• D. Number of h res and termination
• E. Benefits received

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?

• A. Deselect the fields that do NOT have the '_c' suffix in the data manager table preview
• B. Load all columns because the recommended associations will use only columns with the suffix '_c*
• C. Open the Excel file, remove all columns that do not have the suffix '_c' and save t>e Me to be loaded
• D. Utilize drier functionality in the data manager to select only columns with the suffix _C with a fitter condition

A sales manager needs to visualize the company's sales. The sales manager needs to understand how sates and profitability are related over time. The visualization will be used in a printed annual report.
The business analyst has access to the following data:
Order Dates
Order ID
Total Safes by Order
Net profit margin%
Cost of Goods Sow (COGS)
Which visualization should the business analyst use?

• A. Line Chart
• B. Distribution Plot
• C. Combo Chart
• D. Scatter Plot

A user makes a selection within a sheet and then navigates to another sheet to validate the details However when the user returns to the original sheet the selection is removed.
What is causing this behavior?

• A. The data has been reloaded and cleared the selection
• B. The original sheet is in a different alternate state
• C. A bookmark has been applied with default selections
• D. An action has been defined to dear selections

A customer wants to perform a regional sates analysis to learn how products setover time m different areas. The business analyst needs to design a sheet in the app tor business users to perform several tasks
Select two different groups of countries to study
Compare sales over time between these two groups using a bar chart
Change the group items by selecting different countries at any time
Select a time range in the bar chart and drill-down to daily transactional sales.
What steps should the business anaryst follow to meet these requirements?

• A. Create two Alternate States Sell and Set2
  Create two Finer Panels each associated with an Alternate Stale
  Create a Bar chart with drill-down dimension and two measures sum({Set1'S} Sates) and sum({,Set2'*S} Sales)
• B. Create two Alternate States Set1and Set2
  Create two Filter Panels each associated with an Alternate State
  Create a Bar chart with a drill-down dimension and two measures sum({Set1'$} Sales) and sum{fSet2"S} Sales)
• C. Create one Alternate State Set1
  Create two Filter Panels one associated lo this Set1 and one Default State1($)
  Create a Bar chart with the drill-down dimension and two measures sum({Set1-$) Sales) and sum('Set1-S) Sales)
• D. Create one Alternate State Set1
  Create two Filter Panels one associated to this Set1and one Default State(S)
  Create a Bar chart with the drill-down dimension and two measuressum({Set1'$} Sales)and sum({'Set1"S) Sales)