最新的SAP C-HANAIMP-17免費考試真題

問題1

You want to expose a hierarchy that is defined in a calculation view for access to SQL which of the following conditions must be met?
Note: There are 2 correct answers .

A. The hierarchy must be exposed by a calculation view of type CUBE with star join.

B. The hierarchy must be a shared hierarchy.

C. The hierarchy must be a local hierarchy.

D. The hierarchy must be defined in a calculation view of type SQL ACCESSONLY.

正確答案: A,B

問題2

How can you define a variable that presents its value help hierarchically?
Note: There are2 correct answers to this question.

A. Create a level hierarchy and assign it to the variable.
Ensure the variable's reference column is the top level of the hierarchy.

B. Create a parent-child hierarchy and assign it to the variable.
Ensure the variable's reference column is the child attribute of the hierarchy.

C. Create a level hierarchy and assign it to the variable.
Ensure the variable's reference column is the leaf level of the hierarchy.

D. Create a parent-child hierarchy and assign it to the variable.
Ensure the variable's reference column is the parent attribute of the hierarchy.

正確答案: C

問題3

You have imported a new calculation view in a folder that contains a .hdinamespace file. This calculation view consumes one data source which is a table. When trying to build the calculation view, there is a namespace-related issue and the build fails.
What could be the reason? Note: There are 2 correct answers.

A. The .hdinamespace file specifies a different name space property than the one in the identifier of the calculation view.

B. The name space used within the calculation view to reference the table is different from the actual namespace in the identifier of this table.

C. The hdinamespace specifies "sub-folder": "append'', so calculation views can only be created in sub-folders.

D. The imported calculation view and its data source have different namespaces.

正確答案: B,D

問題4

You want to map an input parameter of the calculation view A to the input parameter of calculation view B using the parameter mapping feature in the calculation view editor. However, the input parameter of the calculation view B is not proposed to you as a source parameter.
What might be the reason for this?

A. You already mapped the input parameters in another calculation view.

B. You selected the wrong parameter mapping TYPE.

C. Your source calculation view is of the type SQL Access Only.

D. The names of the input parameters do not match.

正確答案: A

問題5

In your calculation view, you need to define a custom data source using SQLScript. In which object do you write your SQL Script?

A. Virtual Table

B. CDS view

C. Procedure

D. Table function

正確答案: D

問題6

Why might you use the Keep Flag property in an aggregation node?

A. To include columns that are NOT requested by a query but are essential for the correct result

B. To retain the correct aggregation behavior in stacked views.

C. To ensure that the aggregation behavior defined in the aggregation node for a measure CANNOT be overridden by a query

D. To cache the results of the aggregation node for drill-down

正確答案: A

問題7

What do you use in the definition of a dynamic SQL analytic privilege?

A. A scalar function that returns a list of the allowed values for each attribute.

B. A table function that returns a list of allowed values.

C. An organization hierarchy that provides role-based access to data.

D. A procedure that returns the data access condition as an SQL expression.

正確答案: D

問題8

You created a table function to remove previous records, sum the current total weekly working hours for each employee, and updated the personnel table. The build 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. You did NOT define a valid table type.

D. Your function refers to a scalar function.

正確答案: B

問題9

Which of the following are usually no longer required in the architecture of SAPS/4HANA? Note: There are 2 correct answers to this question.

A. ABAP CDS

B. Synonyms

C. Aggregates

D. Indexes

正確答案: B,C

最新的SAP Certified Application Associate - SAP HANA 2.0 (SPS05) - C-HANAIMP-17免費考試真題

聯系我們

站內鏈接

最新更新