C_HCMOD_05 by SAP Valid Free Exam Practice Test

Question 1

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 an intersect node. B. Use an aggregation node. C. Use a minus node D. Use a union node.

Correct Answer: A

Question 2

In SAP HANA Cloud, which tasks are handled by the cloud provider?Note: There are 3 correct answers to this question.Sizing, provisioning, and monitoring the database

A. Tuning the database to run optimally on the underlying operating system, and hardware B. Managing users, roles, and permissions in the database C. Backing up the operating system and the database software D. Installing, configuring, and upgrading the operating system

Correct Answer: A,C,D

Question 3

Why would you partition a table in an SAP HANA Cloud database? Note: There are 2 correct answers to this question.

A. To improve response time when multiple users access the same table B. To improve data replication performance on large row tables C. To improve query performance when accessing large column tables D. To overcome the 2 billion record limit

Correct Answer: D

Question 4

You are deploying a new calculation view, A, that uses calculation view B, as shown in the diagram.

When you preview calculation view A, the account number is not masked.What could be the reason?

A. The UNMASKED privilege has NOT been granted at the schema level. B. You previewed the data with the technical user in SAP Business Application Studio. C. The type of the Account_Number column is VARCHAR. D. You did not define masking in calculation view A.

Correct Answer: A

Question 5

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. You did not define any columns in the cache setting. B. The query requests only a subset of the cached results. C. The cache data retention period has expired. D. You did not define a filter in the cache setting.

Correct Answer: A

Question 6

Which of the following approaches might improve the performance of joins in a CUBE calculation view?
Note: There are 2 correct answers to this question.

A. Define join direction in a full outer join B. Use an inner join C. Specify the join cardinality D. Limit the number of joined columns

Correct Answer: C,D

Question 7

You have linked an underlying node to the star join node to define the data foundation. Which data source type can you then join to the data foundation?

A. Tables B. Table functions C. DIMENSION calculation view D. CUBE calculation view

Correct Answer: C

Question 8

You combine two customer master data tables with a union node in a calculation view. Both master data tables include the same customer name.How do you ensure that each customer name appears only once in the results?

A. Define a restricted column in a union node. B. In the union node, map both source customer name columns to one target column. C. Add an intersect node above the union node. D. Include an aggregation node above the union node.

Correct Answer: D

Question 9

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 not dropped. B. The deployment is successful but the data preview returns an error message. C. The deployment fails and the table is dropped. D. The deployment is successful and the data preview returns expected data.

Correct Answer: A

SAP Certified Application Associate - SAP HANA Cloud Modeling - C_HCMOD_05 Exam Practice Test