Free SAP Certified Application Associate – SAP HANA Cloud Modeling Exam C_HCMOD_02 Exam Practice Test

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 want to ensure that your calculation view does not give unexpected results for a query that is based on any combination of columns.What is the recommended approach for verifying the results?

• Set the HIDE property for columns NOT required.
• Write and execute a custom SQL query in the SQL Console.
• Select Data Preview for the calculation view.
• Select and deselect columns from the output mapping.

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

• Calculated columns
• Filters
• Joins
• Data sources of unions

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.

What are the consequences of NOT executing a delta merge?Note: There are 2 correct answers to this question.

• Read performance decreases.
• New records are not read.
• Memory is not optimized.
• Aggregates are not adjusted.

You have imported calculation views from SAP HANA on-premise to SAP HANA Cloud.Why should you switch calculated column expression language from column engine to SQL?

• To benefit from additional SQL optimizations
• Incorrect aggregations may be generated
• Column engine language is not supported.
• To define limits for query unfolding

You want to join two tables in a calculation view.Why do you use a non-equi join?

• Join columns have different data types.
• The number of joined columns is different in each table.
• Join columns need to be ignored when NOT requested by the query.
• The join condition is not represented by matching values.

In a calculation view, what is the purpose of a variable?

• To pass values between procedures and calculation views
• To provide a dynamic value in a calculated column
• To break up complex SQL into smaller steps
• To filter an attribute at runtime based on a user input

Which database features are typically NOT required by analytical applications that run on SAP HANA Cloud?Note: There are 2 correct answers to this question.

• Pre-calculated aggregates
• Indexes
• Stored procedures
• Table partitions

In SAP HANA Cloud, which tasks are handled by the cloud provider?Note: There are 3 correct answers to this question.Sizing, provisioning, and monitoring the database

• Tuning the database to run optimally on the underlying operating system, and hardware
• Managing users, roles, and permissions in the database
• Backing up the operating system and the database software
• Installing, configuring, and upgrading the operating system