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

Why should you define calculated column expressions using plain SQL and avoid using column engine language?

• A.To prevent queries from unfolding
• B.To allow imperative statements
• C.To benefit from additional SQL optimizations
• D.To access the full set of SQL functions

Which of the following are usually not required In the data model of SAP S/4HANA?Note: There are 2 correct answers to this question.

• A.Indexes
• B.Views
• C.Partitions
• D.Stored aggregates

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

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

What are some best practices when developing calculation views?Note: There are 2 correct answers to this question.

• A.Avoid defining joins on calculated columns.
• B.Include all data flow logic within one calculation view.
• C.Aggregate at the lowest possible node.
• D.Model star schemas using a sequence of join nodes.

How can you define a variable that presents its value help hierarchically?Note: There are 2 correct answers to this question.

• A.Create a parent-child hierarchy and assign it to the variable.Ensure the variable's reference column is the child attribute of the hierarchy.
• B.Create a level hierarchy and assign it to the variable.Ensure the variable's reference column is the leaf level of the hierarchy.
• C.Create a level hierarchy and assign it to the variable.Ensure the variable's reference column is the top level of the hierarchy.
• D.Create a parent-child hierarchy and assign it to the variable.Ensure the variable's reference column is the parent attribute of the hierarchy.