Pass with Analytics-Con-301 Practice Materials 100% for sure

An executive-level workbook leverages 37 of the 103 fields included in a data source. Performance for the workbook is noticeably slower than other workbooks on the same Tableau Server.
What should the consultant do to improve performance of this workbook while following best practice?

• A. Split some visualizations on the dashboard into many smaller visualizations on the same dashboard.
• B. Connect to the data source via a custom SQL query.
• C. Use filters, hide unused fields, and aggregate values.
• D. Restrict users from accessing the workbook to reduce server load.

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. 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.
• B. 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.
• C. Specify with user filters in each view individuals who can see profit, profit margin, or none of these.
• D. 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.

A consultant creates a histogram that presents the distribution of profits across a client's customers. The labels on the bars show percent shares. The consultant used a quick table calculation to create the labels.
Now, the client wants to limit the view to the bins that have at least a 15% share. The consultant creates a profit filter but it changes the percent labels.
Which approach should the consultant use to produce the desired result?

• A. Add the [Profit] filter to the context.
• B. Filter with a table calculation WINDOW_AVG(MIN([Profit]), first(), last())
• C. Filter with the table calculation used to create labels.
• D. Use a calculation with TOTAL() function instead of a quick table calculation.

A consultant wants to improve the performance of reports by moving calculations to the data layer and materializing them in the extract.
Which calculation should the consultant use?

• A. SUM([Profit])/SUM([Sales])
• B. ZN([Sales])*(1 - ZN([Discount]))
• C. CASE [Sector Parameter]
  WHEN 1 THEN "green"
  WHEN 2 THEN "yellow"
• D. POWER(ZN(SUM([Sales]))/
  LOOKUP(ZN(SUM([Sales])), FIRST()),ZN(1/(INDEX()-1)))- 1END

A client wants to use a bar chart to visualize the trend in profit per quarter for the last 5 years. They want each bar's color to be determined by whether the profit during that quarter was greater than the median profit for the past four quarters, including the current quarter.
For example, if a bar represents profit for 2020 Q4, they want to visually see whether the profit for 2020 Q4 is greater than the median profit for 2020 Q1-2020 Q4.
Which table calculation should produce the desired result?

• A. SUM([Profit]) > WINDOW_MEDIAN(SUM([Profit]), 3, 0)
• B. SUM([Profit]) > WINDOW_MEDIAN(SUM([Profit]), LAST()-3, LAST())
• C. SUM([Profit]) > WINDOW_MEDIAN(SUM([Profit]), FIRST(), FIRST() + 3)
• D. SUM([Profit]) > WINDOW_MEDIAN(SUM([Profit]), INDEX(), INDEX() + 3)