C-HCMOD-02 試験問題を無料オンラインアクセス

Why would you use the Transparent Filter property in a calculation view?

• A.To avoid columns being unnecessarily used in an aggregation
• B.To apply filters that are hidden from the end user
• C.To include columns that are NOT requested by a query
• D.To allow filter push-down in stacked calculation views

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

You want to join two tables in a calculation view.Why do you use a non-equi join?

• A.The number of joined columns is different in each table.
• B.Join columns need to be ignored when NOT requested by the query.
• C.The join condition is not represented by matching values.
• D.Join columns have different data types.

What are possible consequences of unfolding?Note: There are 2 correct answers to this question.

• A.Count-distinct results are incorrect
• B.SQL compilation time increases
• C.Results are read from static cache
• D.Query processing time improves

Which of the following are standard options provided to define analytic privileges?Note: There are 3 correct answers to this question.

• A.Dynamic
• B.Hierarchy function
• C.Attributes
• D.Graph
• E.SQL expression