Analytics-Con-301 무료 덤프문제 온라인 액세스

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 Relative Date filter with a Multiple Values (Dropdown) filter on YEAR([Created Date]).
• B.Replace SUM([Value]) with WINDOW_SUM([Value]).
• C.Replace the Multiple Values (Dropdown) filter with a Multiple Values (Custom List) filter.
• D.Replace the TOTAL([Opportunities]) calculation with a Grand Total.

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 join between two Physical 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 relationship between two Logical Tables: Members and Claims.

A client wants to use a bar chart to visualize the trend in profit per quarter for the last 5 years. They want each bar's color to be determined by whether the profit during that quarter was greater than the median profit for the past four quarters, including the current quarter.
For example, if a bar represents profit for 2020 Q4, they want to visually see whether the profit for 2020 Q4 is greater than the median profit for 2020 Q1-2020 Q4.
Which table calculation should produce the desired result?

• A.SUM([Profit]) > WINDOW_MEDIAN(SUM([Profit]), FIRST(), FIRST() + 3)
• B.SUM([Profit]) > WINDOW_MEDIAN(SUM([Profit]), 3, 0)
• C.SUM([Profit]) > WINDOW_MEDIAN(SUM([Profit]), INDEX(), INDEX() + 3)
• D.SUM([Profit]) > WINDOW_MEDIAN(SUM([Profit]), LAST()-3, LAST())

A client wants to see data for only the most recent day in the dataset that is updated intermittently. The solution should offer the best caching performance.
Which approach should the consultant use to produce the desired results?

• A.Fixed Level of Detail (LOD) date calculation
• B.TODAY function
• C.Relative date filters
• D.Quick filter

A client's fiscal calendar runs from February 1 through January 31.
How should the consultant configure Tableau to use the client's fiscal calendar when building date charts?

• A.Edit the data source and set the Fiscal Year in the data preview window.
• B.Edit the data source Date Properties, then update the Default Properties of the Date Fields.
• C.Create Calculated Fields using the FISCALQUARTER() and FISCALYEAR() functions.
• D.Right click on the Date axis in charts and select Use Fiscal Calendar.