Valid TCC-C01 Dumps shared by ExamDiscuss.com for Helping Passing TCC-C01 Exam! ExamDiscuss.com now offer the newest TCC-C01 exam dumps, the ExamDiscuss.com TCC-C01 exam questions have been updated and answers have been corrected get the newest ExamDiscuss.com TCC-C01 dumps with Test Engine here:
A consultant wants to improve the performance of reports by moving calculations to the data layer and materializing them in the extract. Which calculation should the consultant use?
Correct Answer: C
To improve performance by moving calculations to the data layer and materializing them in the extract, the consultant should choose calculations that benefit from pre-computation and significantly reduce the load during query time: * Aggregation-Level Calculation: The formula SUM([Profit])/SUM([Sales]) calculates a ratio at an aggregate level, which is ideal for pre-computation. Materializing this calculation in the extract means that the complex division operation is done once and stored, rather than being recalculated every time the report is accessed. * Performance Improvement: By pre-computing this aggregate ratio, Tableau can utilize the pre-calculated fields directly in visualizations, which speeds up report loading and interaction times as the heavy lifting of data processing is done during the data preparation stage. References: * Materialization in Extracts: This concept involves pre-calculating and storing complex aggregations or calculations within the Tableau data extract itself, improving performance by reducing the computational load during visualization rendering.