70-466 · Question #33
You are developing a SQL Server Analysis Services (SSAS) tabular project. A model contains tables and columns that must not be visible to the user. The columns and tables must be preserved because the
The correct answer is D. Right-click the applicable tables and columns and select the Hide from Client Tools option.. In SSAS Tabular, 'Hide from Client Tools' makes an object invisible to reporting clients while preserving its full availability for DAX calculations and measures.
Question
Options
- ARight-click the applicable tables and columns and select the Hide option.
- BIn the Properties window for the applicable tables and columns, set the Enabled property to False.
- CIn the Properties window for the applicable tables and columns, set the Visible property to True.
- DRight-click the applicable tables and columns and select the Hide from Client Tools option.
How the community answered
(31 responses)- A3% (1)
- C3% (1)
- D94% (29)
Why each option
In SSAS Tabular, 'Hide from Client Tools' makes an object invisible to reporting clients while preserving its full availability for DAX calculations and measures.
A plain 'Hide' option is not the designated SSAS Tabular mechanism for hiding objects from client tools while preserving them for internal DAX calculations; 'Hide from Client Tools' is the specific correct option.
There is no 'Enabled' property on SSAS Tabular tables and columns; this property does not exist in the tabular model designer and would not achieve the required behavior.
Setting the Visible property to True makes the object visible to client tools, which is the opposite of the requirement to hide it.
The 'Hide from Client Tools' option marks a table or column as invisible in client applications such as Excel and Power BI while keeping it fully accessible to DAX expressions and calculated objects. This satisfies both requirements: hiding the object from end users and retaining it for use in calculations.
Concept tested: SSAS Tabular hiding objects from client tools
Source: https://learn.microsoft.com/en-us/analysis-services/tabular-models/hide-or-freeze-columns-ssas-tabular
Topics
Community Discussion
No community discussion yet for this question.