You have the following dataset.

You want to create a new calculated dimension field named Category that meets the following conditions:
. When Subject is Computer Science or Science, Category must be Sciences.
. When Subject is English or Social Studies, Category must be Humanities.
Which two logical functions achieve the goal? Choose two.

• A.IF [Subject]- 'Science' THEN 'Sciences'
  ELSEIF [Subject]='English' THEN 'Humanities'
  ELSEIF [Subject]-'Social Studies' THEN 'Humanities'
  ELSEIF [Subject]= 'Computer Science' THEN 'Sciences'
  END
• B.IIF(( CONTAINS ([Subject], 'Science') = TRUE) , 'Humanities', 'Sciences')
• C.IF ENDSWITH ( [Subject], 'Computer Science') THEN 'Sciences' ELSE 'Humanities' END
• D.CASE [Subject]
  WHEN 'Computer Science' THEN 'Sciences'
  WHEN 'Science' THEN 'Sciences'
  WHEN 'English' THEN 'Humanities'
  WHEN 'Social Studies' THEN 'Humanities'
  End

Comment: *

Name: *

Email: *

Verification: *

You create the following worksheet
The Pick Measure parameter contains the following list of values
Users can select a value from Pick Measure to change the visualization to show either the Sales measure or the Profit measure.
Which formula is used in the Selected Measure calculated field lo switch between measures?

• A.Case [Pick Measure]
  WHEN 1 then ([Sales])
  WHEN 2 then ([Profit])
  END
• B.Case AVG([Pick Measure])
  WHEN [Sales] then 1
  WHEN [Profit] then 2
  END
• C.Case [Pick Measure:
  WHEN [Sales] then 1
  WHEN [Profit] then 2 END
• D.Case STFMEPick Measure])
  WHEN "Sales" then ([Sales])
  WHEN "Profit" then ([Profit]) e::i

Comment: *

Name: *

Email: *

Verification: *

You have the Mowing dashboard.

Which two elements are floating? Choose two.

• A.The state filter
• B.The color legend
• C.The map
• D.The Rate of Obesity chart
• E.The little

Comment: *

Name: *

Email: *

Verification: *

You have the following dashboard.

When a user selects a only on the map the data on the bar chart must show only the data for the selected city. The data in the bar chart must change only when the user selects a different city How should you configure the dashboard action? (Use the dropdowns in the Answers Area to select the correct options.)

Correct Answer:

Comment: *

Name: *

Email: *

Verification: *

How should a Data Analyst sort data by Sales across multiple dimensions in Tableau?

• A.Right-click on each dimension, choose Sort, then select data source order in the options.
• B.Right-click on the rightmost dimension, choose Sort, then select nested in the options.
• C.Use the Sets feature to combine dimensions and then sort one of the fields.
• D.Use the Group feature to combine dimensions and then sort the grouped field.

Comment: *

Name: *

Email: *

Verification: *