1357 お客様のコメント
質問 1：
Using the table in the diagram, you need to create a CUBE calculation view.
What is the simplest approach to create the output shown in the screenshot?
A. Create a restricted column for each country.
B. Create a filter expression that uses an OR operator.
C. Implement a union node and map each country as a separate column.
D. Create 3 calculated columns.
正解：A
質問 2：
Which type of join supports a temporal condition in a calculation view?
A. Inner join
B. Referential join
C. Text join
D. Left outer join
正解：A
質問 3：
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. You defined more than one output parameter
B. The output parameter is defined as NVARCHAR
C. The procedure is write-enabled
D. No input parameter is specified
正解：A,D
質問 4：
You want to map an input parameter of calculation view A to an input parameter of calculation view B using the parameter mapping feature in the calculation view editor.
However, the input parameters of calculation view B are not proposed as source parameters. What might be the reason for this?
A. You selected the wrong parameter mapping TYPE.
B. Your source calculation view is of type DIMENSION.
C. The names of the input parameters do not match.
D. You already mapped the input parameters in another calculation view.
正解：D
質問 5：
What are some of the typical tasks performed by the SAP HANA Cloud modeler role? Note: There are 2 correct answers to this question.
A. Create graph workspaces
B. Configure data tiering
C. Develop SAP Fiori apps
D. Develop calculation views
正解：A,D
質問 6：
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 project that contained the deleted design-time file.
B. Execute a DROP statement in an SQL Console connected to the HDI container.
C. Deploy the folder that contained the deleted design-time file.
D. Execute the refactor function for the calculation view.
正解：A
質問 7：
What are possible consequences of unfolding?Note: There are 2 correct answers to this question.
A. Count-distinct results are incorrect
B. Results are read from static cache
C. Query processing time improves
D. SQL compilation time increases
正解：A,D
質問 8：
Which tool generates and executes the SQL for a specific node of your calculation view?
A. Debug Query mode
B. Explain plan
C. Database explorer
D. SQL analyzer
正解：A
質問 9：
What options do you have to handle orphan nodes in your hierarchy?Note: There are 2 correct answers to this question.
A. Assign them to a node at the root level.
B. Define an expression to determine a parent.
C. Assign them to a level below the root.
D. Generate additional root nodes.
正解：C,D
Using the table in the diagram, you need to create a CUBE calculation view.
What is the simplest approach to create the output shown in the screenshot?
A. Create a restricted column for each country.
B. Create a filter expression that uses an OR operator.
C. Implement a union node and map each country as a separate column.
D. Create 3 calculated columns.
正解：A
質問 2：
Which type of join supports a temporal condition in a calculation view?
A. Inner join
B. Referential join
C. Text join
D. Left outer join
正解：A
質問 3：
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. You defined more than one output parameter
B. The output parameter is defined as NVARCHAR
C. The procedure is write-enabled
D. No input parameter is specified
正解：A,D
質問 4：
You want to map an input parameter of calculation view A to an input parameter of calculation view B using the parameter mapping feature in the calculation view editor.
However, the input parameters of calculation view B are not proposed as source parameters. What might be the reason for this?
A. You selected the wrong parameter mapping TYPE.
B. Your source calculation view is of type DIMENSION.
C. The names of the input parameters do not match.
D. You already mapped the input parameters in another calculation view.
正解：D
質問 5：
What are some of the typical tasks performed by the SAP HANA Cloud modeler role? Note: There are 2 correct answers to this question.
A. Create graph workspaces
B. Configure data tiering
C. Develop SAP Fiori apps
D. Develop calculation views
正解：A,D
質問 6：
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 project that contained the deleted design-time file.
B. Execute a DROP statement in an SQL Console connected to the HDI container.
C. Deploy the folder that contained the deleted design-time file.
D. Execute the refactor function for the calculation view.
正解：A
質問 7：
What are possible consequences of unfolding?Note: There are 2 correct answers to this question.
A. Count-distinct results are incorrect
B. Results are read from static cache
C. Query processing time improves
D. SQL compilation time increases
正解：A,D
質問 8：
Which tool generates and executes the SQL for a specific node of your calculation view?
A. Debug Query mode
B. Explain plan
C. Database explorer
D. SQL analyzer
正解：A
質問 9：
What options do you have to handle orphan nodes in your hierarchy?Note: There are 2 correct answers to this question.
A. Assign them to a node at the root level.
B. Define an expression to determine a parent.
C. Assign them to a level below the root.
D. Generate additional root nodes.
正解：C,D
吉田** -
最新試験に対応してますし、教科書と過去問題も、このC_HCMOD_03問題集一つに集約していて素晴らしいですね。ありがとうございます。