C-HANAIMP-17 무료 덤프문제 온라인 액세스

You want to control parallelization in a calculation view. Which action is mandatory when you define the parallelization block?

• A.Assign tables as the only data sources in the nodes that start the parallelization block.
• B.Define a projection node as the end of the parallelization block.
• C.Define a union node as the start of the parallelization block.
• D.Define a source column as partitioning value in the start node of the parallelization block.

Which of the following results are generated when you query this temporal hierarchy using a time-validity period interval of March to May?

• A.C
• B.A
• C.D
• D.B

Why might you use the Keep Flag property in an aggregation node?

• A.To ensure that the aggregation behavior defined in the aggregation node for a measure CANNOT be overridden by a query
• B.To include columns that are NOT requested by a query but are essential for the correct result
• C.To retain the correct aggregation behavior in stacked views.
• D.To cache the results of the aggregation node for drill-down

Why do we use Git when modeling calculation views?

• A.Enable collaboration between developers
• B.Provide access to external schemas
• C.Develop conceptual prototypes
• D.Control specifically object versioning

How can you optimize performance when writing SQL for use with calculation views?
Note: There are 2 correct answers to this question.

• A.Control the flow logic using IF-THEN-ELSE conditions
• B.Use calculation engine (CE) functions instead of plain SQL
• C.Use declarative language instead of cursors
• D.Increase parallelization by using variables to break up statements