Free SAP Certified Application Associate – SAP HANA 2.0 SPS06 Exam C_HANAIMP_18 Exam Practice Test

In a calculation view, why would you implement an SQL expression?Note: There are 3 correct answers to this question.

• To convert currencies
• To generate hierarchies
• To define a filter
• To generate a calculated column
• To generate a restricted column

You combine two tables in a join node using multiple columns in each table.Why do you enable the dynamic join option?Note: There are 2 correct answers to this question.

• To ensure that the join execution only uses the join columns requested in the query
• To ensure that the aggregation always happens after the join execution
• To force the calculation at the relevant level of granularity, even if this level is not the grouping level defined by the query
• To allow data analysis at different levels of granularity with the same calculation view

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

• To ensure that the aggregation behavior defined in the aggregation node for a measure CANNOT be overridden by a query
• To retain the correct aggregation behavior in stacked views
• To include columns that are NOT requested by a query but are essential for the correct result
• To exclude columns that are NOT requested by a query to avoid incorrect results

You define a hierarchy in a calculation view. You want to expose the hierarchy to SQL Which of the following conditions must be met?Note: There are 2 correct answers to this question.

• The hierarchy must be defined in a calculation view of type SQL ACCESS ONLY.
• The hierarchy must be exposed by a calculation view of type CUBE with star join.
• The hierarchy must be a local hierarchy.
• The hierarchy must be a shared hierarchy.

Which tool generates and executes the SQL for a specific node of your calculation view?

• Debug Query mode
• Explain plan
• SQL analyzer
• Database explorer

Why do we use Git when modeling calculation views?Note: There are 2 correct answers to this question.

• To manage versions of source files
• To display dependencies in stacked scenarios
• To automate the build process
• To enable collaboration between developers

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.

• Use an inner join
• Limit the number of joined columns
• Specify the join cardinality
• Define join direction in a full outer join

Which type of join supports a temporal condition in a calculation view?

• Text join
• Left outer join
• Inner join
• Referential join

Which of the following are capabilities of SAP HANA smart data access?Note: There are 2 correct answers to this question.

• Replication of remote data
• Push-down of queries to remote data sources
• Exposure of real-time data from remote tables
• Cleansing and harmonization of data from disparate sources

Why would you set the 'Ignore multiple outputs for filters' property in a calculation view?

• To ensure semantic correctness
• To force filters to apply at the lowest node
• To hide columns that are not required
• To avoid duplicate rows in the output