Câu 4: Salesforce Certified Tableau Consultant

A company has a Tableau dashboard that visualizes healthcare cost trends over time. The dashboard is connected to an extracted data source that uses Custom SQL to join two tables: a Claims table storing healthcare claims and a Members table storing member demographics. Each member can have many records in the Claims table, and each member can also have many records in the Members table. Stakeholders at the company discover that the dashboard shows inaccurate trending data. Members’ claim costs are multiplied by the number of records the members have in the Members table. A consultant must resolve this issue while optimizing dashboard performance and ease of maintenance. Which approach should the consultant use to solve this issue and meet the requirements?

1. A. Replace the Custom SQL with a relationship between two Logical Tables: Members and Claims. — đáp án hiện tại
2. B. Use Level of Detail (LOD) calculations to ensure that claim costs are captured at the right granularity.
3. C. Use Table Calculations to ensure that claim costs are captured at the right granularity.
4. D. Replace the Custom SQL with a join between two Physical Tables: Members and Claims.