Certified Application Associate - SAP HANA 2.0 SPS06

Question 1

What do need in a multitenant database container (MDC) system to run queries across tenant databases? Note: There are 2 correct answers to this question.

A. The user in the source system must have sufficient privileges in the target database.

B. The cross-tenant database communication must be explicitly activated

C. The user in the source system must be associated with a user in the target database.

D. The bidirectional communication channel must be whitelisted.

Correct Answer: B,C

Question 2

Which SAP HANA security tasks can be performed in combination with a Lightweight Directory Access Protocol (LDAP) server? Note: There are 2 correct answers to this question.

A. User creation

B. Password policy configuration

C. Role assignment

D. User group assignment

Correct Answer: C,D

Question 3

Which role do you need in order to assign users to groups in the SAP HANA cockpit?

A. Cockpit Database Administrator Role

B. Cockpit Administrator Role

C. Cockpit user Role

D. Cockpit user Administrator Role

Correct Answer: A

Question 4

Which user credentials do you need to stop the SAP HANA database system using the SAP HANA cockpit? Note: There are 3 correct answers to this question.

A. <sid>adm

B. Cockpit user

C. sap<sid>

D. Root

E. Database User

Correct Answer: A,B,E

Question 5

Which actions can you perform using the SAP HANA platform lifecycle management web user interface? Note: There are 2 correct answers to this question.

A. Configure the system landscape directory registration.

B. Update the SAP HANA database system

C. Stop and start the SAP HANA database system

D. Manage the full system information dumps.

Correct Answer: A,B

Question 6

Which schema provides performance data and alert details to review in SAP HANA mini-checks?

A. SYS STATISTICS

B. SAP XS USAGE

C. SYS SQL ANALYZER

D. COCKPIT MONITOR

Correct Answer: A

Question 7

Which properties can you adjust in SAP HANA admission control? Note: There are 3 correct answers to this question.

A. Maximum number of parallel 10 requests

B. Maximum queue size for requests

C. Memory threshold for queuing new requests

D. Memory limits for new SQL statement requests

E. CPU threshold for rejecting new requests

Correct Answer: B,C,E

Question 8

Which characteristics describe an SAP HANA multitenant database container (MDC) system? Note: There are 3 correct answers to this question.

A. The name server provides index server functionality for the system database.

B. Each tenant database runs its own compile server and the preprocessor server.

C. The name server owns information about the location of tables and table partitions in databases.

D. A multitenant database container system is identified by a single system ID (SID).

E. Database isolation increases the isolation between tenant databases on operating system level

Correct Answer: A,D,E

Question 9

Which prerequisites of the primary system and the secondary system are mandatory before can activate SAP HANA system replication with secondary time travel?
Note: There are 2 correct answers to this question.

A. Both must have the same SAP HANA version.

B. The CPU architecture must be identical.

C. Both systems are located in the same data center

D. An explicit read-only connection between both systems must be available.

Correct Answer: B,D

SAP Certified Application Associate - SAP HANA 2.0 SPS06 - C-HANATEC-18 Exam Practice Test

Latest Update

Useful Links

Contact Us