Salesforce Analytics-Con-301 : Salesforce Certified Tableau Consultant

A consultant builds a report where profit margin is calculated as SUM([Profit]) / SUM([Sales]). Three groups of users are organized on Tableau Server with the following levels of data access that they can be granted.
. Group 1: Viewers who cannot see any information on profitability
. Group 2: Viewers who can see profit and profit margin
. Group 3: Viewers who can see profit margin but not the value of profit Which approach should the consultant use to provide the required level of access?

• A. Specify in the row-level security (RLS) entitlement table individuals who can see profit, profit margin, or none of these. Then, use the table data to create user filters in the report.
• B. Use user filters to access data on profitability to all groups. Then, create a calculated field that allows visibility of profit value to Group 2 and use the calculation in the view in the report.
• C. Use user filters to allow only Groups 2 and 3 access to data on profitability. Then, create a calculated field that limits visibility of profit value to Group 2 and use the calculation in the view in the report.
• D. Specify with user filters in each view individuals who can see profit, profit margin, or none of these.

Sales managers use a daily extract from Snowflake to see the previous day's snapshot.
Sales managers should only see statistics for their direct reports.
The company has Tableau Data Management on Tableau Cloud.
A consultant must design a centralized, low-maintenance RLS strategy.
What should the consultant implement?

• A. Data policy
• B. Manual user filter
• C. Dynamic user filter
• D. Built-in RLS security in Snowflake

A client is considering migrating from Tableau Server to Tableau Cloud.
Which two elements are determining factors of whether the client should use Tableau Server or Tableau Cloud? Choose two.

• A. Whether or not the client plans to leverage single sign-on (SSO)
• B. Whether or not there are large numbers of concurrent extract refreshes
• C. Amount of data storage used on the client's existing server
• D. Whether or not the client needs the ability to connect to public, cloud-based data sources

A multi-national company wants to have a Tableau dashboard that will provide country-level information for both its forecast summaries and year-on-year metrics. The company wants to toggle between these two views while leaving main key performance indicators (KPIs) visible on the main dashboard.
Which method is the most efficient in achieving the company's requirements?

• A. Create a parameter that accepts values from a list that contains "Forecast View" and "Year-on-Year View."
  . Right-click the parameter and select Add to Sheet for both worksheets.
  . Navigate back to the dashboard and to the upper corner of the two worksheets.
  . Enable the Use as Filter option.
• B. Create a Boolean parameter with the two names of the views as aliases and a corresponding calculated field with the following calculation: True.
  . Add the forecast summary sheet to the dashboard and add the year-on-year metrics sheet to the same dashboard as a Floating dashboard object.
  . Add the calculated fields as a Detail under the Marks card of the floating view, create a "Change Parameter" action, and set the
  "Target Parameter" and "Source Fields" to the parameter and calculated field you created.
  . Check the box for "Control visibility using value" in the Layout tab of the floating view and select the parameter you created.
• C. Create a single worksheet with all the measures required for both the forecast summary and the year-on- year views.
  . Create a Boolean parameter and a corresponding calculated field with the following calculation: True.
  . Add a blank dashboard object and in the Layout tab, check the box for "Control visibility using value" and select the parameter you created.
• D. Create a dashboard with the sheets containing the main KPIs and the forecast summary worksheet.
  . Duplicate this dashboard and replace the forecast view worksheet with the year-on-year metrics worksheet.
  . Add navigation buttons to both dashboards.

A client has several long-term shipping contracts with different vendors that set rates based on shipping volume and speed. The client requests a dashboard that allows them to model shipping costs for the next week based on the selected shipping vendor. Speed for the end user is critical.
Which dashboard building strategy will deliver the desired result?

• A. Calculate the potential shipping cost for each order with each vendor, display the aggregate costs in a large table, and use quick filters to limit the options visible to the user.
• B. Use a calculated field that refers to a user-selected parameter to calculate shipping costs for each order and then display the aggregate values.
• C. Recommend that the client model for only profitability for the next 24 hours instead of a full week.
• D. Aggregate the orders then use a calculated field that refers to a user-selected parameter to calculate the shipping costs.