SAP Certified Application Associate - SAP HANA 2.0 (SPS01)

QUESTION NO: 1
In which SAP HANA solution do you eliminate stored data, like year-to-date figures?
Please choose the correct answer.
Response:

A. SAP BW on SAP HANA B. SAP CRM on SAP HANA C. SAP S/4HANA D. SAP HANA Enterprise Cloud

Correct Answer: C

QUESTION NO: 2
What node is used to link dimension views to a data foundation (fact tables)?
Please choose the correct answer.
Response:

A. Projection node B. Star join node C. Union node D. Join node

Correct Answer: B

QUESTION NO: 3
Which of the following data provisioning tools can provide a delta load of a table from the source system?
Please choose the correct answer.
Response:

A. Flat files B. SDS C. SDA D. DXC

Correct Answer: D

QUESTION NO: 4
Where do you create a variable?
Please choose the correct answer.
Response:

A. In the scenario area of an aggregate node B. In the semantics node C. In the output area of a join node D. In the context menu of a package

Correct Answer: B

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

A. A new data warehouse B. Web-based tools C. Hundreds of predeveloped views D. Precalculated aggregates stored in cubes

Correct Answer: B,C

QUESTION NO: 6
When do you always have both an active and an inactive version of an infor- mation model available in the SAP HANA development system?
Please choose the correct answer.
Response:

A. When validation of a model fails B. When you edit an existing model C. When you create a new model D. When you selected Revert to Active on an inactive version

Correct Answer: B

QUESTION NO: 7
What are the rules for defining a stepparent in a hierarchy?
There are 2 correct answers to this question.
Response:

A. A stepparent only applies to parent-child hierarchies. B. The stepparent node ID must be entered according to the node style you selected for the hierarchy. C. The stepparent node must already exist in the hierarchy at any level. D. The stepparent node must already exist in the hierarchy at the root level.

Correct Answer: B,D

QUESTION NO: 8
What SAP HANA information object does AFM create?
Please choose the correct answer.
Response:

A. Attribute view B. Procedure C. Calculation view D. Table function

Correct Answer: B

QUESTION NO: 9
Which of the following are results of deploying SAP HANA as a distributed (scale-out) solution?
There are 3 correct answers to this question.
Response:

A. Disaster recovery B. Partitioning C. Failover D. Backups E. High availability

Correct Answer: B,C,E

QUESTION NO: 10
You are writing a mobile application for the World Series. You have details about all the baseball players and the baseball scores for all the previous matches.
How do you use the data of the player information and the scores?
Please choose the correct answer.
Response:

A. The player information is used as transactional data, and the scores are used as master data. B. Both the player information and the scores are used as transactional data. C. The player information is used as master data, and the scores are used as transactional data. D. Both the player information and the scores are used as master data.

Correct Answer: C

QUESTION NO: 11
Which are features of a calculated column?
There are 2 correct answers to this question.
Response:

A. It is created in the output area B. It is a column in the result set C. Its calculations are persisted D. It is created in the semantics node

Correct Answer: A,B

SAP Certified Application Associate - SAP HANA 2.0 (SPS01) - C-HANAIMP-13 Exam Questions