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

A client wants guidance for Creators to build efficient extracts from large data sources.
What are three Tableau best practices that the Creators should use? Choose three.

• A.  Use only live connections as they are always faster than extracts.
• B.  Hide all unused fields.
• C.  Keep only the data required for analysis by using extract filters.
• D.  Use aggregate data for visible dimensions, whenever possible.
• E.  Include all the data from the original data source in the extract.

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.  Use LOD calculations to ensure that claim costs are captured at the right granularity.
• B.  Replace the Custom SQL with a relationship between two Logical Tables: Members and Claims.
• C.  Use Table Calculations to ensure that claim costs are captured at the right granularity.
• D.  Replace the Custom SQL with a join between two Physical Tables: Members and Claims.

A client wants to provide sales users with the ability to perform the following tasks:
Access published visualizations and published data sources outside the company network.
Edit existing visualizations.
Create new visualizations based on published data sources.
. Minimize licensing costs.
Which site role should the client assign to the sales users?

• A.  Creator
• B.  Explorer (can publish)
• C.  Viewer
• D.  Site Administrator

A consultant is tasked with improving the performance of a large workbook that contains multiple dashboards, each of which leverages a separate data source. What is one way to improve performance?

• A.  Restrict the users who can access the workbook.
• B.  Split the workbook into multiple workbooks.
• C.  Convert any extracted data sources to live data sources.
• D.  Convert Data Source filters to Quick Filters.

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 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.
• B.  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.
• C.  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.
• D.  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.