Salesforce Certified Tableau Consultant : Analytics-Con-301

A client has a large data set that contains more than 10 million rows.
A consultant wants to calculate a profitability threshold as efficiently as possible. The calculation must classify the profits by using the following specifications:
. Classify profit margins above 50% as Highly Profitable.
. Classify profit margins between 0% and 50% as Profitable.
. Classify profit margins below 0% as Unprofitable.
Which calculation meets these requirements?

• A. IF [ProfitMargin]>0.50 Then 'Highly Profitable'
  ELSEIF [ProfitMargin]>=0 Then 'Profitable'
  ELSE 'Unprofitable'
  END
• B. IF [ProfitMargin]>0.50 Then 'Highly Profitable'
  ELSEIF [ProfitMargin]>=0 Then 'Profitable'
  ELSEIF [ProfitMargin] <0 Then 'Unprofitable'END
• C. IF [ProfitMargin]>=0.50 Then 'Highly Profitable'
  ELSEIF [ProfitMargin]>=0 Then 'Profitable'
  ELSE 'Unprofitable'
  END
• D. IF([ProfitMargin]>=0.50,'Highly Profitable', 'Profitable')ELSE 'Unprofitable'END

A company has a sales team that is segmented by territory. The team's manager wants to make sure each sales representative can see only data relevant to that representative's territory in the team Sales Dashboard.
The team is large and has high turnover, and the manager wants the mechanism for restricting data access to be as automated as possible. However, the team does not have a Tableau Data Management license.
What should the consultant recommend to meet the company's requirements?

• A. Create a user filter in the Sales Dashboard workbook and map each sales representative to the territories they are responsible for. Publish this dashboard to the Sales Dashboard project and ensure all users have permissions to view the dashboard.
• B. Create separate workbooks for each territory. Publish each dashboard to the same Sales Dashboard project, and set permissions so each sales representative can see only the dashboards for their territories.
• C. Create a data source by joining the sales data table to an entitlements data table. Add a data source filter to restrict access and publish the data source. Connect the Sales Dashboard to this published data source.
• D. Create one group for each territory and assign sales representatives to the appropriate groups. Map each group to a territory in the Sales Dashboard. Publish this dashboard to the Sales Dashboard project and ensure all users have permissions to view the dashboard.

A client wants to view stores serviced by delivery drivers on a map. The have the information provided in the table below:

What does the client need to do to plot exact street addresses on the map?

• A. Custom geocode the street addresses.
• B. Establish a hierarchy of State > City > Street Address 1 > Street Address 2.
• C. Change the data type of Street Address 1 and Street Address 2 to the Geographic role.
• D. Add a Map layer to the visualization.

A shipping clerk wants to use a Sankey diagram to analyze the flow of goods between different categories, shipping modes, and locations to spot bottlenecks and optimize the most critical paths. The company uses Tableau Cloud.
How should the shipping clerk create a chart that depicts the above information?

• A. Search and download a suitable Connector from Tableau Exchange.
• B. Use Show Me to start a view based on the fields selected.
• C. Search and download a suitable sandboxed Accelerator from Tableau Exchange.
• D. Search and download a suitable sandboxed Viz Extension from Tableau Exchange.

A university has data on its undergraduate students and their majors by grade level (Freshman, Sophomore, Junior, Senior). The university is interested in visualizing the path students take as they change majors across grade levels.
Which visualization type should the consultant recommend?

• A. Tree Chart
• B. Chord Chart
• C. Radar Chart
• D. Sankey Diagram