nerdexam
Microsoft

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.

Build a tabular data model

Question

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 they are used in calculations. You need to hide the tables and columns. What should you do?

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)
  • A
    3% (1)
  • C
    3% (1)
  • D
    94% (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.

ARight-click the applicable tables and columns and select the Hide option.

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.

BIn the Properties window for the applicable tables and columns, set the Enabled property to False.

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.

CIn the Properties window for the applicable tables and columns, set the Visible property to True.

Setting the Visible property to True makes the object visible to client tools, which is the opposite of the requirement to hide it.

DRight-click the applicable tables and columns and select the Hide from Client Tools option.Correct

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

#column visibility#Hide from Client Tools#table hiding#tabular model

Community Discussion

No community discussion yet for this question.

Full 70-466 Practice