Online Access Free Analytics-Con-301 Exam Questions

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 Table 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 LOD 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 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.{FIXED [Region]:sum([Sales])}/SUM([Sales]}
• B.{FIXED [Region]:sum([Sales])}/{FIXED :SUM([Sales])
• C.{FIXED [Region]:sum([Sales])}
• D.{FIXED [Region]:[Sales]}/{FIXED: SUM([Sales])}

In what way does View Acceleration improve performance?

• A.By improving the performance of views that contain long-running queries with transient functions
• B.By enhancing the rendering speed of visuals, such as drawing shapes and maps
• C.By precompiling and fetching workbook data in a background process
• D.By optimizing the performance of views built only on extract-based data sources

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.Gantt and bar charts
• B.Waterfall chart and tree map
• C.Scatter plot and pie chart
• D.Line and bubble charts

A client has a published dashboard. They change the dashboard and then republish it. Now, users report that their web browser bookmarks to the dashboard are broken.
What are two possible causes for this issue? Choose two.

• A.New credentials were embedded into the data source.
• B.The dashboard was published with a new name.
• C.Tableau Server was upgraded.
• D.The dashboard was published to a different project.