Question 380
An analyst is troubleshooting this business scenario: A report currently uses a high-cardinality second-by-second timestamp when only daily totals are required. The attempt does not achieve the expected result. Which specific failure best explains the gap?
Explanation
Correct Answer
This defect explains why the required behavior failed. Granularity reduction trades detail for lower cardinality and should follow requirements. The corrective action is: Reduce unnecessary timestamp granularity in a modeled aggregate or add an appropriate date-level summary.
Incorrect Answers
A year-to-date function includes months outside the requested trailing 30 days. The stated evidence instead indicates: Discarding transaction lines before confirming the requested drillthrough removes needed detail.
Reusing one calendar field for both independent slicers cannot express two different role filters reliably. The stated evidence instead indicates: Discarding transaction lines before confirming the requested drillthrough removes needed detail.
Replacing the logic with a static calculated column changes slicer responsiveness. The stated evidence instead indicates: Discarding transaction lines before confirming the requested drillthrough removes needed detail.