Question

What returns data independent of the Data Granularity?

1) Aggregation
2) Group By
3) Rollup
4) Cube

Answer 1

The answer to the question is 3) Rollup. Rollup is a technique in data analysis that allows for data to be aggregated at different levels of granularity, maintaining the overall hierarchy.

Step-by-step explanation:

The answer to the question is 3) Rollup.

In data analysis, rollup is a technique that allows for data to be aggregated at different levels of granularity. It is a way of summarizing data across multiple dimensions while maintaining the overall hierarchy. This means that the data returned by a rollup query will be independent of the specific level of data granularity being used.

For example, if you have sales data for a company by month, by product category, and by region, you can use a rollup query to get the total sales for each month, for each product category, and for each region, and the total sales overall, regardless of the specific level of granularity used.