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

Question 1

What is generated when you deploy a CUBE calculation view design-time file?Note: There are 2 correct answers to this question.

A. An SQL execution plan B. A column view in a container C. Cached results to improve read performance D. Metadata to enable consumption by external tools

Discussion 0

Correct Answer: C,D Vote an answer

Question 2

In your calculation view, you want to consume a custom data source defined using SQLScript.In which type of object do you write your code?

A. Scalar function B. Procedure C. Table function D. Anonymous block

Discussion 0

Correct Answer: C Vote an answer

Question 3

In a calculation view, why would you choose the DEPRECATED setting?Note: There are 2 correct answers to this question.

A. To indicate that it should not be used as a data source to other calculation views B. To ensure it is not exposed to reporting tools for consumption C. To lock the calculation view from further modifications D. To warn developers that the calculation view is no longer supported

Discussion 0

Correct Answer: B,D Vote an answer

Question 4

You created a procedure to be consumed in an analytic privilege of the type DYNAMIC, but it isn't working as expected.What could be the reason?Note: There are 2 correct answers to this question.

A. No input parameter is specified B. The procedure is write-enabled C. The output parameter is defined as NVARCHAR D. You defined more than one output parameter

Discussion 0

Correct Answer: A,D Vote an answer

Question 5

Why would you create SQL in calculation views?

A. To implement custom logic B. To enable write capabilities C. To provide an alternative to graphical modeling D. To fine-tune performance

Discussion 0

Correct Answer: A Vote an answer

Question 6

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 7

Referring to the diagram,

which privileges would a user require to view United States data when querying the CUBE calculation view?

A. A SELECT privilege and an Analytic Privilege (Country = United States) on the CUBE calculation view B. SELECT privileges and Analytic Privileges (Country = United States) on both views C. A SELECT privilege and an Analytic Privilege (Country = United States) on the DIMENSION calculation view D. A SELECT privilege on the CUBE calculation view and an Analytic Privilege (Country = United States) on the DIMENSION calculation view

Discussion 0

Correct Answer: D Vote an answer

Question 8

What are some best practices when developing calculation views? Note: There are 2 correct answers to this question.

A. Avoid defining joins on calculated columns. B. Model star schemas using a sequence of join nodes. C. Include all data flow logic within one calculation view. D. Aggregate at the lowest possible node.

Discussion 0

Correct Answer: A,C Vote an answer

Question 9

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 .hdinamespace specifies "sub-folder":"append", so calculation views can only be created in subfolders. B. 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. C. The imported calculation view and its data source have different namespaces. D. The namespace used within the calculation view to reference the table is different from the actual namespace in the identifier of this table.

Discussion 0

Correct Answer: C,D Vote an answer

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