Certified Application Associate - SAP HANA Cloud Modeling

Question 1

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?

A. .hdiconfig

B. .mtar

C. .yaml

D. .namespace

Correct Answer: C

Question 2

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

A. Parallel access is improved

B. Improved write performance on frequent updates

C. Higher data compression rates

D. Additional indexes are used

E. Higher performance for query operations

Correct Answer: A,C,E

Question 3

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

B. 1 year

C. 2 weeks

D. 3 months

Correct Answer: D

Question 4

You have configured static cache for your calculation view and run a query against it, but the cache results are not being used.What might be the reason for this?

A. The query requests only a subset of the cached results.

B. You did not define a filter in the cache setting.

C. You did not define any columns in the cache setting.

D. The cache data retention period has expired.

Correct Answer: C

Question 5

Why would you create SQL in calculation views?

A. To enable write capabilities

B. To provide an alternative to graphical modeling

C. To implement custom logic

D. To fine-tune performance

Correct Answer: C

Question 6

Which type of join supports a temporal condition in a calculation view?

A. Inner join

B. Referential join

C. Left outer join

D. Text join

Correct Answer: A

Question 7

Which of the following are standard options provided to define analytic privileges?Note: There are 3 correct answers to this question.

A. SQL expression

B. Graph

C. Attributes

D. Hierarchy function

E. Dynamic

Correct Answer: A,C,E

Question 8

You created a table and inserted data in it using SQL statements inside the SAP HANA Deployment Infrastructure (HDI) container of your project. You add this table as a data source to a calculation view and try to deploy it.What do you observe in the SAP HANA database container?

A. The deployment fails and the table is dropped.

B. The deployment fails and the table is not dropped.

C. The deployment is successful but the data preview returns an error message.

D. The deployment is successful and the data preview returns expected data.

Correct Answer: B

Question 9

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

A. The number of joined columns is different in each table.

B. The join condition is not represented by matching values.

C. Join columns need to be ignored when NOT requested by the query.

D. Join columns have different data types.

Correct Answer: B

SAP Certified Application Associate - SAP HANA Cloud Modeling - C-HCMOD-02 Exam Practice Test

Latest Update

Useful Links

Contact Us