Which external tool can you use to identify which columns contribute most to model size by providing size information for each table and column?

Which external tool can you use to identify which columns contribute most to model size by providing size information for each table and column?

• A. DAX Studio
• B. Power BI Desktop
• C. SQL Server Data Tools
• D. Azure Data Studio

Answer: (A)

Inspecting how storage is consumed inside a tabular model at the granularity of each table and column. DAX Studio is the right external tool because it can connect to a live Power BI Desktop (or SSAS Tabular) model and run DMVs that expose storage usage details. By querying these system views, you can get a list of tables and their columns along with the bytes they occupy, then identify which columns contribute the most to the model size. You’d connect to the Power BI model, run a DMV query such as a storage-usage query, and sort the results to spot the top contributors. This direct visibility into per-column storage isn’t readily available in the other tools listed—the built-in Power BI Desktop features don’t provide a straightforward per-column size breakdown, and SQL Server Data Tools or Azure Data Studio aren’t focused on diagnosing Power BI model storage at the column level.

Inspecting how storage is consumed inside a tabular model at the granularity of each table and column. DAX Studio is the right external tool because it can connect to a live Power BI Desktop (or SSAS Tabular) model and run DMVs that expose storage usage details. By querying these system views, you can get a list of tables and their columns along with the bytes they occupy, then identify which columns contribute the most to the model size. You’d connect to the Power BI model, run a DMV query such as a storage-usage query, and sort the results to spot the top contributors. This direct visibility into per-column storage isn’t readily available in the other tools listed—the built-in Power BI Desktop features don’t provide a straightforward per-column size breakdown, and SQL Server Data Tools or Azure Data Studio aren’t focused on diagnosing Power BI model storage at the column level.