SAP Certified Application Associate - SAP HANA Cloud Modeling - C_HCMOD

Question 1

Why would an SQL developer work with SQLScript?Note: There are 3 correct answers to this question.

A. To pass parameters from calculation views B. To implement conditional logic C. To exploit additional data types D. To include ABAP syntax in the code E. To automate the generation of the code

Discussion 0

Correct Answer: A,B,C Vote an answer

Question 2

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

A. Generate additional root nodes. B. Assign them to a level below the root. C. Define an expression to determine a parent. D. Assign them to a node at the root level.

Discussion 0

Correct Answer: A,B Vote an answer

Question 3

A calculation view consumes the data sources shown in the graphic.

You want to identify which companies sold products in January AND February. What is the optimal way to do this?

A. Use a minus node B. Use an intersect node. C. Use a union node. D. Use an aggregation node.

Discussion 0

Correct Answer: B Vote an answer

Question 4

Referring to the diagram,

which privileges would a user require to view United States data when querying the CUBE calculation view?

A. SELECT privileges and Analytic Privileges (Country = United States) on both views B. A SELECT privilege and an Analytic Privilege (Country = United States) on the CUBE calculation view C. A SELECT privilege on the CUBE calculation view and an Analytic Privilege (Country = United States) on the DIMENSION calculation view D. A SELECT privilege and an Analytic Privilege (Country = United States) on the DIMENSION calculation view

Discussion 0

Correct Answer: C Vote an answer

Question 5

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.

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

Discussion 0

Correct Answer: B,D,E Vote an answer

Question 6

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?

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

Discussion 0

Correct Answer: B Vote an answer

Question 7

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?

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

Discussion 0

Correct Answer: C Vote an answer

Question 8

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.

A. Pre-calculated aggregates B. Stored procedures C. Indexes D. Table partitions

Discussion 0

Correct Answer: A,B Vote an answer

Question 9

A new version of SAP HANA Cloud, SAP HANA database is available from today.If you do not perform the upgrade manually, how much time do you have before your database will be automatically upgraded to the next version?

A. 3 months B. 7 months C. 2 weeks D. 1 year

Discussion 0

Correct Answer: B Vote an answer

SAP Certified Application Associate - SAP HANA Cloud Modeling - C_HCMOD_05 FREE EXAM DUMPS QUESTIONS & ANSWERS