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

問題1

What is the disk storage layer used for?
Note: There are 2 correct answers to this question.

A. To unload the least-used data when the memory is full

B. To enable data to be recovered if hardware fails

C. To improve the parallel processing of queries

D. To store the data primarily used for transactional processing

正確答案: A,B

問題2

Which of the following results are generated when you query this temporal hierarchy using a time-validity period interval of March to May?

A. B

B. A

C. D

D. C

正確答案: C

問題3

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

問題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. Your source calculation view is of the type SQL Access Only.

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

C. You selected the wrong parameter mapping TYPE.

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

正確答案: B

問題5

In SAP Web IDE for SAP HANA, what can a flowgraph generate in a predictive analysis scenario?
Note: There are 2 correct answers to this question.

A. Container

B. Task

C. Function

D. Procedure

正確答案: B,D

問題6

How can you optimize performance when writing SQL for use with calculation views?
Note: There are 2 correct answers to this question.

A. Control the flow logic using IF-THEN-ELSE conditions

B. Use declarative language instead of cursors

C. Use calculation engine (CE) functions instead of plain SQL

D. Increase parallelization by using variables to break up statements

正確答案: B,D

問題7

What are the components of a graph workspace?
Note: There are 2 correct answers to this question.

A. Dimension

B. Association

C. Edge

D. Vertex

正確答案: C,D

問題8

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

問題9

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. Your function refers to a scalar function.

B. You did NOT define a valid table type.

C. Your function includes a TRUNCATE statement

D. You did not define at least one input parameter.

正確答案: C

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

最新更新

站內鏈接

聯系我們