C_HCMOD_02

In your calculation view, you want to consume a custom data source defined using SQLScript.In which type of object do you write your code?A . Scalar functionB . Table functionC . Anonymous blockD . ProcedureView AnswerAnswer: B

What options do you have to handle orphan nodes in your hierarchy? Note: There are 2 correct answers to this question.A . Define an expression to determine a parent.B . Generate additional root nodes.C . Assign them to a level below the root.D . Assign them to a node at...

Why would you enable Debug Query mode in a calculation view?A . To identify data sources that are not accessed by a queryB . To check which database engines are invokedC . To set breakpoints and step through the executionD . To understand how tables are partitionedView AnswerAnswer: A

Which of the following approaches might improve the performance of joins in a CUBE calculation view? Note: There are 2 correct answers to this question.A . Specify the join cardinalityB . Limit the number of joined columnsC . Use an inner joinD . Define join direction in a full outer...

What is generated when you deploy a CUBE calculation view design-time file? Note: There are 2 correct answers to this question.A . Cached results to improve read performanceB . Metadata to enable consumption by external toolsC . An SQL execution planD . A column view in a containerView AnswerAnswer: A,B