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

A company uses an extract built from Custom SQL joining Claims and Members.
Members have multiple records in both tables # causing data duplication, which results in inflated claim cost trends.
Which approach meets performance and maintenance goals?

A business analyst needs to create a view in Tableau Desktop that reports data from both Excel and MSSQL Server.
Which two features should the business analyst use to create the view? Choose two.

A client creates a report and publishes it to Tableau Server where each department has its own user group set on the server. The client wants to limit visibility of the report to the sales and marketing groups in the most efficient manner.
Which approach should the consultant recommend?

A client has a sales dataset that contains fields named Customer ID, Region, Item, and Sales Amount. Each row represents a single sale. There may be multiple sales for each Customer ID.
The client wants to visualize the average total customer sales by region.
Which Level of Detail (LOD) expression should a consultant recommend?

A client calculates the percent of total sales for a particular region compared to all regions.

Which calculation will fix the automatic recalculation on the % of total field?

A client wants to produce a visualization to show quarterly profit growth and aggregated sales totals across a number of product categories from the data provided below.

Which set of charts should the consultant use to meet the client's requirements?

A new Tableau user created a simple dashboard on Tableau Server using supply chain data. Now, the user wants to know if they created the dashboard in accordance with specific performance best practices.
Which approach should the consultant recommend for the client to make this determination?

A client is searching for ways to curate and document data in order to obtain data lineage. The client has a data source connected to a data lake.
Which tool should the consultant recommend to meet the client's requirements?

A worksheet uses a LOOKUP function to display Sales by Month, Year of Order Date, and sales from the last
12 months. A consultant wants to use a Relative Date Filter to filter for data from the last 12 months.
However, when the consultant does this, the prior year's data is removed from the sheet.
Which two actions should the consultant take to retain the prior year's data after applying the filter? Choose two.