[2026] SAP Certified Application Associate - SAP HANA 2.0 (SPS02)

문제1

What information can you find in the Visualize Plan tool?
There are 2 correct answers to this question.
Response:

A. The time taken for each step

B. The SQL Plan Cache

C. The number of records returned in each step

D. The execution engines used

정답: A,C

문제2

You have logs from a website. How do you show the total number of website visitors that used a mobile phone?
There are 2 correct answers to this question.
Response:

A. Create an action

B. Create a rank column

C. Create a restricted column

D. Create a filter expression

정답: C,D

문제3

To start and stop Data Provisioning tasks, which are the following privileges should users have to start or stop tasks?
There are 2 correct answers to this question
Response:

A. Start task: sap.hana.io.dp.monitor::StartTask

B. Stop task: sap.hana.im.dp.monitor::StopTask

C. Stop task: sap.hana.io.dp.monitor::StopTask

D. Start task: sap.hana.im.dp.monitor::StartTask

정답: B,D

문제4

You are working with a currency measure. What is decimal shift used for?
Please choose the correct answer.
Response:

A. For currencies with more than two decimal places

B. Avoid rounding errors during the conversion

C. Increase the accuracy of the currency conversion

D. To undo the decimal adjustment for ABAP

정답: A

문제5

A company sends out a lot of quotes. Some customers accept the quotes, and they're invoiced. The company asks you to find a list of the customers that did NOT accept the quotes.
How do you find the customers that received quotes but did NOT receive invoices?
Please choose the correct answer.
Response:

A. Use a right outer join. Filter to show only customers on the left table.

B. Use a left outer join. Filter to show only the NULL values on the right table.

C. Use a left outer join. Filter to show only customers on the right table.

D. Use a right outer join. Filter to show only the NULL values on the right table.

정답: B

문제6

In a graphical calculation view of type cube, two tables are joined on multiple columns in a join node. Most queries using the view have no problems, but one query always gets a query runtime error.
What is the cause of this error?
Please choose the correct answer.
Response:

A. The language column is NOT specified in the join.

B. The two tables are joined with a dynamic join.

C. The two tables do NOT have referential integrity.

D. An incorrect column was selected when the join was formed.

정답: B

문제7

What can you use to limit users to see only 2016 data?
There are 2 correct answers to this question.
Response:

A. A view with a restricted column

B. A view with a filter

C. An object privilege

D. A SQL analytic privilege

정답: B,D

문제8

Which of following are features associated with SAP HANA Live?
There are 2 correct answers to this question.

A. Hundreds of predeveloped views

B. Precalculated aggregates stored in cubes

C. Web-based tools

D. A new data warehouse

정답: A,C

문제9

You have successfully built an SAP HANA database (HDB) module. It contains a dimension calculation view that is only consumed by one cube calculation view.
- In the dimension calculation view, you change the name of a column that is referenced by the cube calculation view.
- You then accidentally delete the design-time object of the cube calculation view.
During the build, which of the following scenarios are possible?
There are 2 correct answers to this question.
Response:

A. When you build only the dimension calculation view, the build fails.

B. When you build only the dimension calculation view, the build is successful.

C. When you build the HDB module, the build fails.

D. When you build the HDB module, the build is successful.

정답: A,D

SAP Certified Application Associate - SAP HANA 2.0 (SPS02) - C_HANAIMP_14무료 덤프문제 풀어보기

우리와 연락하기

유용한 링크

최신 업데이트