[2023年11月]更新のC_HCMOD_05試験資料SAP学習ガイド [Q16-Q38]

[2023年11月]更新のC_HCMOD_05試験資料SAP学習ガイド

有効な問題最新版を試そうC_HCMOD_05テスト解釈C_HCMOD_05有効な試験ガイド

質問 # 16
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. Use an inner join
B. Define join direction in a full outer join
C. Specify the join cardinality
D. Limit the number of joined columns

正解：C、D

質問 # 17
What are the key steps to implement currency conversion in a calculation view?

A. Enable the measure for conversion/Choose client, source, and target currencies/Choose conversion date and rate type/Assign the conversion rule to your calculation view
B. Assign semantic type Enable the measure for conversion/Choose client, source, and target currencies/Choose conversion date and rate type
C. Enable the measure for conversion Choose client, source, and target currencies Choose conversion date and rate type Deploy the conversion rule
D. Assign semantic type/Choose client, source, and target currencies/Choose conversion date and rate type/Define an expression in a calculated column

正解：B

質問 # 18
Which of the following are standard options provided to define analytic privileges?Note: There are 3 correct answers to this question.

A. Dynamic
B. Graph
C. SQL expression
D. Attributes
E. Hierarchy function

正解：A、C、D

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

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

正解：A、B

質問 # 20
Why would you choose an HDI-shared service plan instead of a schema service plan?Note: There are 3 correct answers to this question.

A. You want to use synonyms to access external data.
B. You want to develop calculation views.
C. You want to use SAP Business Application Studio.
D. You want to create database objects using source files.
E. You want to use containers to isolate objects.

正解：C、D、E

質問 # 21
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. Indexes
B. Stored procedures
C. Pre-calculated aggregates
D. Table partitions

正解：B、C

質問 # 22
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 a local hierarchy.
B. The hierarchy must be a parent-child hierarchy.
C. The hierarchy must be exposed by a calculation view of type CUBE with star join.
D. The hierarchy must be a shared hierarchy.

正解：C、D

質問 # 23
What are some of the restrictions that apply when defining parallelization blocks in calculation views? Note:
There are 2 correct answers to this question.

A. The block must start with a node that defines a table as a data source.
B. Only one block can be defined across a stack of calculation views.
C. The block must only have one start node.
D. Multiple blocks can only be defined within a single calculation view.

正解：A、B

質問 # 24
Why would you use parameter mapping in a calculation view?Note: There are 2 correct answers to this question.

A. To assign variables to one or more attributes
B. To pass variable values to external value help views
C. To push down filters to the lowest level calculation views
D. To convert the data types of input parameters

正解：B、C

質問 # 25
In a calculation view, your table function node executes a table function that requires input parameters. How can you fill the input parameters of the table function? Note: There are 3 correct answers to this question.

A. Assign a hierarchy node.
B. Create and map an input parameter
C. Define constant values.
D. Reference the output of a procedure.
E. Map columns from lower nodes.

正解：B、C、E

質問 # 26
You have generated a calculation view properties file.What does it contain?

A. Descriptions of all objects defined in a calculation view
B. Documentation to support the calculation view
C. Dependencies between calculation views
D. All settings defined in a calculation view

正解：A

質問 # 27
Which solutions form the SAP Business Technology Platform? Note: There are 2 correct answers to this question.

A. Analytics
B. Experience Management
C. Intelligent Suite
D. Application Development & Integration

正解：A、D

質問 # 28
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 filter expression that uses an OR operator.
B. Implement a union node and map each country as a separate column.
C. Create 3 calculated columns.
D. Create a restricted column for each country.

正解：B

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

正解：B

質問 # 30
Why would you use the SQL analyzer? Note: There are 2 correct answers to this question.

A. To warn of potential performance issues related to calculated columns
B. To identify the root data sources of a function
C. To preview data at the node level of a calculation view
D. To display the execution time of a calculation view

正解：C、D

質問 # 31
Which tool generates and executes the SQL for a specific node of your calculation view?

A. SQL analyzer
B. Database explorer
C. Explain plan
D. Debug Query mode

正解：D

質問 # 32
What can you do with shared hierarchies? Note:There are 2 correct answers to this question.

A. Enable SQL SELECT statements to access hierarchies
B. Provide reusable hierarchies for drilldown in a CUBE without star join
C. Access hierarchies created in external schemas
D. Provide reusable hierarchies for drilldown in a CUBE with star join

正解：A、B

質問 # 33
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

正解：D

質問 # 34
You create a table function to remove historic records, sum the current total weekly working hours for each employee, and update the personnel table with the results. The deployment of the table function fails.Which of the following could be a valid reason?

A. You did not define at least one input parameter.
B. Your function includes a TRUNCATE statement.
C. Your function refers to a scalar function.
D. You did NOT define a valid table type.

正解：B

質問 # 35
In a database module, what is the purpose of the .hdiconfig file?

A. To specify the namespace rules applicable to the name of database objects
B. To specify an external schema in which calculation views will get their data
C. To specify in which space the container should be deployed
D. To specify which HDI plug-ins are available

正解：D

質問 # 36
Why would you choose to implement a referential join?

A. To develop a series of linked joins
B. To reuse the settings of an existing join
C. To automate the setting of cardinality rules
D. To define conditions for potential data source pruning

正解：C

質問 # 37
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?