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

What do you use in the definition of a dynamic SQL analytic privilege?

• A table function that returns a list of allowed values.
• A scalar function that returns a list of the allowed values for each attribute.
• A procedure that returns the data access condition as an SQL expression.
• An organization hierarchy that provides role-based access to data.

Which solutions form the SAP Business Technology Platform? Note: There are 2 correct answers to this question.

• Analytics
• Intelligent Suite
• Experience Management
• Application Development & Integration

You create a user-provided service to access tables in external schemas.In which file type do you assign the user-provided service to your database module?

• .hdiconfig
• .mtar
• .yaml
• .namespace

You created a procedure to be consumed in an analytic privilege of the type DYNAMIC, but it isn't working as expected.What could be the reason?Note: There are 2 correct answers to this question.

• No input parameter is specified
• You defined more than one output parameter
• The output parameter is defined as NVARCHAR
• The procedure is write-enabled

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

What are the limitations of using a full outer join in a star join node?Note: There are 2 correct answers to this question.

• It must appear in the last DIMENSION in the star join node.
• It is restricted to one DIMENSION in a star join node.
• It CANNOT be mixed in the same star join node with other join types.
• Only one column can be included in the join condition.

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 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

What are the advantages of column store tables compared to row store tables? Note: There are 3 correct answers to this question.

• Higher data compression rates
• Improved write performance on frequent updates
• Additional indexes are used
• Parallel access is improved
• Higher performance for query operations

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

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