nerdexam
Microsoft

70-466 · Question #13

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 cannot be removed because the

The correct answer is C. Before adding the forecast calculations to the model, right-click the applicable tables and columns and select the Hide from Client Tools option.. This question tests how to hide tables and columns in an SSAS tabular model while keeping them usable in calculations. The 'Hide from Client Tools' option is the correct mechanism.

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 cannot be removed because they are used in calculations. The calculations are used to calculate the budget and forecast for the current quarter. You need to hide the tables and columns. What should you do?

Options

  • AAfter adding the budget calculations to the model, in the Properties window for the applicable tables and columns, set the Enabled property to False.
  • BBefore adding the forecast calculations to the model, right-click the applicable tables and columns and select the Hide option.
  • CBefore adding the forecast calculations to the model, right-click the applicable tables and columns and select the Hide from Client Tools option.
  • DAfter adding the budget calculations to the model, in the Properties window for the applicable tables and columns, set the Visible property to True.

How the community answered

(43 responses)
  • A
    5% (2)
  • B
    2% (1)
  • C
    91% (39)
  • D
    2% (1)

Why each option

This question tests how to hide tables and columns in an SSAS tabular model while keeping them usable in calculations. The 'Hide from Client Tools' option is the correct mechanism.

AAfter adding the budget calculations to the model, in the Properties window for the applicable tables and columns, set the Enabled property to False.

There is no 'Enabled' property on tables or columns in SSAS tabular models that controls client-side visibility; this property does not exist for this purpose.

BBefore adding the forecast calculations to the model, right-click the applicable tables and columns and select the Hide option.

The plain 'Hide' option in SSDT removes the object from the model designer view entirely and does not specifically target client tool visibility while preserving calculation references.

CBefore adding the forecast calculations to the model, right-click the applicable tables and columns and select the Hide from Client Tools option.Correct

The 'Hide from Client Tools' option marks tables and columns as invisible in client applications like Power View and Excel, while still allowing them to be referenced by DAX measures and calculated columns. Applying this setting before adding the forecast calculations ensures the hidden items remain available for computation but are not exposed to end users browsing the model.

DAfter adding the budget calculations to the model, in the Properties window for the applicable tables and columns, set the Visible property to True.

Setting the Visible property to True makes the table or column visible to client tools, which is the opposite of the requirement.

Concept tested: Hiding SSAS tabular model objects from client tools

Source: https://learn.microsoft.com/en-us/analysis-services/tabular-models/hide-or-freeze-columns-ssas-tabular

Topics

#Hide from Client Tools#column visibility#tabular model#calculated columns

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full 70-466 Practice