Salesforce Analytics-Con-301 Actual Free Exam Questions & Community Discussion

A client has a dashboard that renders in less than 10 seconds. The client receives a request to add a new calculated field that will return TRUE if a Project contains any one of the values "Project 1" or "Project 2" and FALSE otherwise. After adding the function found below, the dashboard's render time increases to 14 seconds from 10 seconds.
[Project] = 'Project 1' OR [Project] = 'Project 2'
Which function should the consultant use to reduce the render time?

A client wants to see the average number of orders per customer per month, broken down by region. The client has created the following calculated field:
Orders per Customer: {FIXED [Customer ID]: COUNTD([Order ID])}
The client then creates a line chart that plots AVG(Orders per Customer) over MONTH(Order Date) by Region. The numbers shown by this chart are far higher than the customer expects.
The client asks a consultant to rewrite the calculation so the result meets their expectation.
Which calculation should the consultant use?

A Tableau Cloud client has requested a custom dashboard to help track which data sources are used most frequently in dashboards across their site.
Which two actions should the client use to access the necessary metadata? Choose two.

A client wants to report Saturday and Sunday regardless of the workbook's data source's locale settings.
Which calculation should the consultant recommend?

A consultant used Tableau Data Catalog to determine which workbooks will be affected by a field change.
Catalog shows:
* Published Data Source # 7 connected workbooks
* Field search (Lineage tab) # 6 impacted workbooks
The client asks: Why 7 connected, but only 6 impacted?

For a new report, a consultant needs to build a data model with three different tables, including two that contain hierarchies of locations and products. The third table contains detailed warehousing data from all locations across six countries. The consultant uses Tableau Cloud and the size of the third table excludes using an extract.
What is the most performant approach to model the data for a live connection?

A client builds a dashboard that presents current and long-term stock measures. Currently, the data is at a daily level. The data presents as a bar chart that presents monthly results over current and previous years. Some measures must present as monthly averages.
What should the consultant recommend to limit the data source for optimal performance?

A client requests a published Tableau data source that is connected to SQL Server. The client needs to leverage the multiple tables option to create an extract. The extract will include partial data from the SQL Server data source.
Which action will reduce the amount of data in the extract?

During a Tableau Cloud implementation, a Tableau consultant has been tasked with implementing row-level security (RLS). They have already invested in implementing RLS within their own database for their legacy reporting solution. The client wants to know if they will be able to leverage their existing RLS after the Tableau Cloud implementation.
Which two requirements should the Tableau consultant share with the client? Choose two.