最新的SAP Certified Application Associate認證 C-HANAIMP-16考試題庫

問題1

Which of the following data sources can you include in a graphical calculation view?
Note: There are 2 correct answers to this question.

A. SQL view

B. Scalar function

C. Table function

D. Procedure

正確答案: A,C

問題2

You are building a new calculation view B that uses calculation view A as a data source. In the Semantics node of calculation view A, you define a mask for the first 10 digits of a 15 digit Account Number. When you preview calculation view B, the Account Number is not masked.
Why do you see the Account Number unmasked?

A. The masking is based on the column of a row table.

B. The UNMASKED privilege for calculation view A has been granted.

C. You did not define masking in calculation view B.

D. The Account Number is based on the Integer datatype.

正確答案: B

問題3

In a calculation view, where can you insert SQL code?
Note: There are 3 correct answers to this question.

A. Calculated column expression

B. Currency conversion

C. Input parameter

D. Filter expression

E. Hierarchy

正確答案: A,C,D

問題4

In a calculation view, which object type do you assign to a projection node to consume a Predictive Analysis Library (PAL) function?

A. Scalar function

B. Input parameter

C. Table function

D. Synonym

正確答案: C

問題5

Which type of join supports a temporal condition in a calculation view?

A. Left outer join

B. Inner join

C. Referential join

D. Text join

正確答案: B

問題6

When you create a full text index, why do you specify FAST_PREPROCESS OFF?

A. To enable a full linguistic search

B. To prevent the creation of a fuzzy search index

C. To avoid the generation of the term document matrix

D. To generate text analysis results in multiple languages

正確答案: A

問題7

You want to create a star schema using a calculation view. The measures are based on columns from two transaction tables. Dimension calculation views provide the attributes.
What is the correct approach?

A. Combine the transaction tables using a join node in a calculation view of type cube.
Use the multi-join capability of the join node to connect the transactional tables with the dimension calculation views.

B. Combine the transaction tables using a join node in a calculation view of type cube with star join.
Use a star join node to join the dimensions to the fact table.

C. Combine the transaction tables using a star join node in a calculation view of type cube with star join.
Use a join node to join the dimensions to the fact table.

D. Combine the transaction tables using an aggregation node in a calculation view of type cube with star join.
Use a star join node to join the dimensions to the fact table.

正確答案: B

問題8

A calculation view includes a rank node that uses the source data and settings shown in the graphic. Your query requests all columns of the rank node. How many rows are in the output of your query?

A. 9

B. 6

C. 5

D. 2

正確答案: A

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

最新更新

站內鏈接

聯系我們