SAP Certified Application Associate - SAP HANA Cloud Modeling

QUESTION NO: 1
In a database module, what is the purpose of the .hdiconfig file?

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

Correct Answer: A

QUESTION NO: 2
You create a table function to remove historic records, sum the current total weekly working hours for each employee, and update the personnel table with the results. The deployment of the table function fails. Which of the following could be a valid reason?

A. You did NOT define a valid table type. B. Your function refers to a scalar function. C. Your function includes a TRUNCATE statement. D. You did not define at least one input parameter.

Correct Answer: C

QUESTION NO: 3
When is the first column store compression executed?

A. When a delta merge is triggered B. When the table is created C. When a backup is started D. When partitions are regenerated

Correct Answer: A

QUESTION NO: 4
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. Deploy the folder that contained the deleted design-time file. B. Execute the refactor function for the calculation view. C. Deploy the project that contained the deleted design-time file. D. Execute a DROP statement in an SQL Console connected to the HDI container.

Correct Answer: A

QUESTION NO: 5
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 include ABAP syntax in the code C. To automate the generation of the code D. To implement conditional logic E. To exploit additional data types

Correct Answer: A,D,E

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

A. Memory is not optimized. B. New records are not read. C. Read performance decreases. D. Aggregates are not adjusted.

Correct Answer: B,C

QUESTION NO: 7
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 .hdinamespace file specifies a different namespace property than the one in the identifier of the calculation view. C. The namespace used within the calculation view to reference the table is different from the actual namespace in the identifier of this table. D. 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.

Correct Answer: A,C

QUESTION NO: 8
Why do you use the Hidden Columns checkbox in the semantics node of your calculation view? Note:
There are 2 correct answers to this question.

A. To remove a column that is also used as a Label column B. To ensure specific columns are NOT exposed to the reporting tool C. To prevent passing columns in stacked calculation views D. To avoid exposing sensitive columns when defining calculated columns

Correct Answer: A,B

QUESTION NO: 9
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.

A. To ensure that the join execution only uses the join columns requested in the query B. To ensure that the aggregation always happens after the join execution C. To force the calculation at the relevant level of granularity, even if this level is not the grouping level defined by the query D. To allow data analysis at different levels of granularity with the same calculation view

Correct Answer: A,D

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