C-HCMOD-02 by SAP Actual Free Exam Q&As

Question 1

What is a restricted measure?

A. A measure that can only be displayed by those with necessary privileges. B. A measure that can be consumed by a CUBE and not a DIMENSION. C. A measure that cannot be referenced by a calculated column. D. A measure that is filtered by one or more attribute values.

Discussion 0

Correct Answer: D Vote an answer

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. Additional indexes are used B. Improved write performance on frequent updates C. Parallel access is improved D. Higher data compression rates E. Higher performance for query operations

Discussion 0

Correct Answer: C,D,E Vote an answer

Question 3

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. Define an expression to determine a parent. C. Assign them to a node at the root level. D. Assign them to a level below the root.

Discussion 0

Correct Answer: A,D Vote an answer

Question 4

Which components are part of SAP HANA Cloud?Note: There are 2 correct answers to this question.

A. Data lake B. SAP Analytics Cloud C. SAP HANA database D. SAP Enterprise Architecture Designer

Discussion 0

Correct Answer: A,C Vote an answer

Question 5

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. .mtar B. .yaml C. .namespace D. .hdiconfig

Discussion 0

Correct Answer: B Vote an answer

Question 6

Two calculation views, A and B, are defined as shown in the diagram. Three analytic privileges have been granted to you.

When you preview calculation view A, what data do you see?

A. US for P1 and P2, and GE for P1 and P2 B. US for P1 and P2, and GE for P2 C. US for P1 D. US for P1 and GE for P1

Discussion 0

Correct Answer: D Vote an answer

Question 7

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. Table partitions D. Indexes

Discussion 0

Correct Answer: A,D Vote an answer

Question 8

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

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

Discussion 0

Correct Answer: B Vote an answer

Question 9

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

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

Discussion 0

Correct Answer: A,B,C Vote an answer

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