SAP Certified Application Associate - SAP HANA Cloud Modeling

QUESTION NO: 1
Your calculation view consumes one data source, which includes the following columns:
SALES_ORDER_ID, PRODUCT_ID, QUANTITY and PRICE.In the output, you want to see summarized data by PRODUCT_ID and a calculated column, PRODUCT_TOTAL, with the formula QUANTITY * PRICE.In which type of node do you define the calculation to display the correct result?

A. Projection B. Union C. Join D. Aggregation

Correct Answer: A

QUESTION NO: 2
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. Create and map an input parameter B. Assign a hierarchy node. C. Define constant values. D. Reference the output of a procedure. E. Map columns from lower nodes.

Correct Answer: A,C,E

QUESTION NO: 3
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. Table partitions B. Indexes C. Pre-calculated aggregates D. Stored procedures

Correct Answer: B,C

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

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

Correct Answer: C

QUESTION NO: 5
Why would you choose an HDI-shared service plan instead of a schema service plan?Note: There are 3 correct answers to this question.

A. You want to use SAP Business Application Studio. B. You want to use containers to isolate objects. C. You want to develop calculation views. D. You want to use synonyms to access external data. E. You want to create database objects using source files.

Correct Answer: A,B,E

QUESTION NO: 6
You have imported a new calculation view in a folder that contains an .hdinamespace file. This calculation view consumes one data source, which is a table. When trying to deploy the calculation view, the deployment fails with a namespace-related issue.What could be the reason?Note: There are 2 correct answers to this question.

A. The imported calculation view and its data source have different namespaces. B. The namespace used within the calculation view to reference the table is different from the actual namespace in the identifier of this table. C. An .hdinamespace file is defined in the SRC folder that specifies a different namespace property than the one in the identifier of the calculation view. D. The .hdinamespace specifies "sub-folder":"append", so calculation views can only be created in subfolders.

Correct Answer: A,B

QUESTION NO: 7
You implement a referential join between Table A and Table B, but when you query the calculation view, Table B is not pruned.

What could be the problem?Note: There are 2 correct answers to this question.

A. Join cardinality is set :1. B. The Keep flag is activated for the Customer column. C. The Country column is requested. D. Integrity constraint is set to RIGHT.

Correct Answer: A,D

QUESTION NO: 8
You have generated a calculation view properties file.What does it contain?

A. All settings defined in a calculation view B. Documentation to support the calculation view C. Descriptions of all objects defined in a calculation view D. Dependencies between calculation views

Correct Answer: C

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

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

Correct Answer: C,D

SAP Certified Application Associate - SAP HANA Cloud Modeling - C-HCMOD-03 Exam Questions