C_HCMOD_02 무료 덤프문제 온라인 액세스

Why do you use the Hidden Columns checkbox in the semantics node of your calculation view?Note: There are 2 correct answers to this question.

• A.To avoid exposing sensitive columns when defining calculated columns
• B.To prevent passing columns in stacked calculation views
• C.To ensure specific columns are NOT exposed to the reporting tool
• D.To remove a column that is also used as a Label column

In a calculation view, what is the purpose of a variable?

• A.To pass values between procedures and calculation views
• B.To break up complex SQL into smaller steps
• C.To provide a dynamic value in a calculated column
• D.To filter an attribute at runtime based on a user input

You have generated a calculation view properties file.What does it contain?

• A.Dependencies between calculation views
• B.Documentation to support the calculation view
• C.All settings defined in a calculation view
• D.Descriptions of all objects defined in a calculation view

Which tool generates and executes the SQL for a specific node of your calculation view?

• A.Database explorer
• B.Explain plan
• C.Debug Query mode
• D.SQL analyzer

Referring to the diagram,

which privileges would a user require to view United States data when querying the CUBE calculation view?

• A.SELECT privileges and Analytic Privileges (Country = United States) on both views
• B.A SELECT privilege and an Analytic Privilege (Country = United States) on the DIMENSION calculation view
• C.A SELECT privilege on the CUBE calculation view and an Analytic Privilege (Country = United States) on the DIMENSION calculation view
• D.A SELECT privilege and an Analytic Privilege (Country = United States) on the CUBE calculation view