Free SAP Certified Associate – Data Engineer – SAP HANA Exam C_HAMOD_2404 Exam Practice Test

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

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

Which calendar types can be selected when creating time-based DIMENSIONS?Note: There are 2 correct answers to this question.

• Fiscal
• Julian
• Gregorian
• Factory

You deleted the design-time file of a calculation view in your HDB module.What is the recommended way to ensure that the corresponding runtime object is also removed from the database?

• Deploy the folder that contained the deleted design-time file.
• Execute a DROP statement in an SQL Console connected to the HDI container.
• Deploy the project that contained the deleted design-time file.
• Execute the refactor function for the calculation view.

In a database module, what is the purpose of the .hdiconfig file?

• To specify an external schema in which calculation views will get their data
• To specify which HDI plug-ins are available
• To specify in which space the container should be deployed
• To specify the namespace rules applicable to the name of database objects

Why would you use the SQL analyzer? Note: There are 2 correct answers to this question.

• To warn of potential performance issues related to calculated columns
• To display the execution time of a calculation view
• To identify the root data sources of a function
• To preview data at the node level of a calculation view

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 allow data analysis at different levels of granularity with the same calculation view
• To force the calculation at the relevant level of granularity, even if this level is not the grouping level defined by the query

What options do you have to handle orphan nodes in your hierarchy?Note: There are 2 correct answers to this question.

• Define an expression to determine a parent.
• Generate additional root nodes.
• Assign them to a level below the root.
• Assign them to a node at the root level.

In a calculation view, your table function node executes a table function that requires input parameters. How can you fill the input parameters of the table function? Note: There are 3 correct answers to this question.

• Define constant values.
• Assign a hierarchy node.
• Reference the output of a procedure.
• Map columns from lower nodes.
• Create and map an input parameter

You have linked an underlying node to the star join node to define the data foundation. Which data source type can you then join to the data foundation?

• Tables
• CUBE calculation view
• DIMENSION calculation view
• Table functions

Why would you choose to implement a referential join?

• To develop a series of linked joins
• To define conditions for potential data source pruning
• To reuse the settings of an existing join
• To automate the setting of cardinality rules