C_HCMOD_03 exam

You define a hierarchy in a calculation view. You want to expose the hierarchy to SQL. Which of the following conditions must be met? Note: There are 2 correct answers to this question.A . The hierarchy must be exposed by a calculation view of type CUBE with star join. B....

At which levels of a project structure can you execute a deploy operation? Note: There are 2 correct answers to this question.A . Individual source file B. Entire workspace C. Sub-folder of a database module D. Individual containerView AnswerAnswer: B,C

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 prevent passing columns in stacked calculation views B. To ensure specific columns are NOT exposed to the reporting tool C. To remove a...

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. Indexes C. Stored procedures D. Table partitionsView AnswerAnswer: A,B

Which components are part of SAP HANA Cloud? Note: There are 2 correct answers to this question.A . SAP Analytics Cloud B. Data lake C. SAP HANA database D. SAP Enterprise Architecture DesignerView AnswerAnswer: B,C

You set the Null Handling property for an attribute but do not set a default value. What is displayed when null values are found in a column of data type NVARCHAR?A . <empty string> B. "?" C. "0" D. "Null"View AnswerAnswer: A

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. You previewed the data with the technical user in SAP Business Application Studio. B....

What are the advantages of column store tables compared to row store tables? Note: There are 3 correct answers to this question.A . Higher data compression rates B. Improved write performance on frequent updates C. Additional indexes are used D. Parallel access is improved E. Higher performance for query operationsView...

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 a DROP statement in an SQL Console...

Why would you use the Transparent Filter property in a calculation view?A . To include columns that are NOT requested by a query B. To avoid columns being unnecessarily used in an aggregation C. To apply filters that are hidden from the end user D. To allow filter push-down in...