Free Salesforce Analytics-Con-301 Exam Dumps Questions & Answers

A consultant migrated a data source to improve performance. The consultant wants to identify which workbooks need to be updated to point to the new data source.
Which Tableau tool should the consultant use?

• A.  Prep Conductor
• B.  Tableau Advanced Management
• C.  Activity Log
• D.  Data Management

A client has a pipeline dashboard that takes a long time to load. The dashboard is connected to only one large data source that is an extract.
It contains two calculated fields:
. TOTAL([Opportunities])
SUM([Value])
It also contains two filters:
. A Relative Date filter on Created Date, a Date field containing values from 5 years ago until today
. A Multiple Values (Dropdown) filter on Account Name, a String field containing 1,000 distinct values A consultant creates a Performance Recording to troubleshoot the issue, and finds out that the longest-running event is "Executing Query." Which step should the consultant take to resolve this issue?

• A.  Replace the TOTAL([Opportunities]) calculation with a Grand Total.
• B.  Replace the Multiple Values (Dropdown) filter with a Multiple Values (Custom List) filter.
• C.  Replace SUM([Value]) with WINDOW_SUM([Value]).
• D.  Replace the Relative Date filter with a Multiple Values (Dropdown) filter on YEAR([Created Date]).

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

The Sales percentage is inadvertently recalculated each time the filter is applied to the Region.

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

• A.  {FIXED [Region]: SUM([Sales])}
• B.  {FIXED [Region]: SUM([Sales])} / {FIXED :SUM([Sales])}
• C.  {FIXED [Region]: SUM([Sales])} / SUM([Sales])
• D.  {FIXED [Region]: SUM([Sales])} / { [Sales] }

A consultant updates an IF-THEN calculation to use a newly created calculated field "Last Name" (parsed from "Full Name"). After the change, performance becomes noticeably worse.
Which two options should the consultant use to improve dashboard performance without altering functionality? Choose two.

• A.  Redesign the dashboard to replace Quick Filters with Action Filters.
• B.  Calculate "Last Name" in the IF THEN calculation.
• C.  Change the IF THEN calculation to a CASE statement.
• D.  Precalculate "Last Name" in the data source and use it.

A client is migrating their data warehouse. They visualize the data in workbooks hosted on Tableau Server with Tableau Data Management enabled and want to see how many workbooks will be impacted.
What should the consultant do to quickly identify how many workbooks will be impacted?

• A.  Open each workbook and identify the data source.
• B.  In Tableau Server, select the database from External Assets, then select the Lineage tab.
• C.  Leverage the Tableau Developer API to query the workbooks' metadata.
• D.  Complete the migration and let users report errors as they are noticed.