C_HCMOD_05 試験問題を無料オンラインアクセス

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.Procedure
• B.Table function
• C.Anonymous block
• D.Scalar function

Why would you write your SQL code in a procedure instead of a function? Note: There are 3 correct answers to this question.

• A.To implement SQLScript syntax
• B.To generate multiple tabular output data sets
• C.To develop a dynamic analytic privilege
• D.To process input parameters
• E.To modify the content of a table

What can you identify using Performance Analysis mode?Note: There are 2 correct answers to this question.

• A.Information about join cardinality
• B.Joins that are defined on calculated columns
• C.Expected memory consumption
• D.Usage statistics of the calculation view

Why would you create SQL in calculation views?

• A.To fine-tune performance
• B.To provide an alternative to graphical modeling
• C.To implement custom logic
• D.To enable write capabilities

What is the SQL keyword used to process input parameters defined in a calculation view?

• A.WHERE
• B.HINT
• C.PLACEHOLDER
• D.SET