SAP C_HAMOD_2404 - SAP Certified Associate - Data Engineer - SAP HANA

Page: 3 / 3
Total 80 questions

You have defined a pruning configuration table in a calculation view. What are you attempting to prune from the query execution?

Data sources of unions

Joins

Calculated columns

Filters

Using the table in the diagram, you need to create a cube calculation view. What is the simplest approach to create the output from the screenshot?

Create a filter expression that uses an OR operator.

Create 3 calculated columns.

Implement a union node and map each year as a separate column.

Create a restricted column for each year.

Why would you enable Debug Query mode in a calculation view?

To set breakpoints and step through the execution

To identify data sources that are not accessed by a query

To understand how tables are partitioned

To check which database engines are invoked

Your flowgraphs defines a template table as a data target. What triggers the generation of the template table?

Defining the flowgraph data target node

Building/deploying the flowgraph

Running the flowgraph

Saving the flowgraph