C-HANATEC-13 Exam Training Practice Tests (SAP Certified Technology Associate

Question 1

You can change the SSFS master keys using the command line tool RSECSSFX, where it is available?
Please choose the correct answer.
Response:

A. /sap/usr/<SID>/HDB<instance>/exe B. /sap/usr/HDB<instance>/<SID>/exe C. /usr/sap/<SID>/HDB<instance>/exe D. /usr/sap/HDB<instance>/<SID>/exe

Correct Answer: C

Question 2

The SAP HANA memory pool CANNOT satisfy the memory requests for new queries. Where does the SAP HANA database request additional memory?
Please choose the correct answer.
Response:

A. Virtual memory B. Resident memory C. Physical memory D. Standby memory

Correct Answer: A

Question 3

What software innovations did SAP deliver with SAP HANA?
There are 2 correct answers to this question.
Response:

A. Partitioning. B. Row and Delta store. C. Insert only on Column store. D. Compression and Decompression.

Correct Answer: A,B

Question 4

What are some of the characteristics of the design-time role?
There are 3 correct answers to this question.
Response:

A. The role is granted through the execution of stored procedures. B. The role is granted and revoked directly by the database user. C. The role is created by technical user _SYS_REPO. D. The role is revoked if the grantee user is deleted. E. The role can be transported between systems.

Correct Answer: A,C,E

Question 5

Which authorization assignments are possible when you set up an authorization concept in the SAP HANA database?
There are 2 correct answers to this question.
Response:

A. A user can be granted to a role. B. A role can be granted to a role. C. A privilege can be granted to a user. D. A role can be granted to a catalog object.

Correct Answer: B,C

Question 6

Which of the following tools can be used for User Administration?
There are 3 correct answers to this question.
Response:

A. hdbsql B. Resident hdblcm C. SAP NetWeaver Identity Management D. SAP HANA Cockpit

Correct Answer: A,C,D

Question 7

How is a savepoint triggered in SAP HANA?
Please choose the correct answer.
Response:

A. By performing a soft shutdown B. By executing a delta merge C. By committing a transaction D. By starting a log backup

Correct Answer: A

Question 8

Which tasks must you perform to convert a single database to a multitenant database system?
There are 2 correct answers to this question.
Response:

A. Create an operating system user for the converted tenant database. B. Set the password for the system database user. C. Trigger the conversion in the SAP HANA cockpit 2.0. D. Generate the system database before the conversion.

Correct Answer: B,C

Question 9

What is the the recommended disk space for /hana/shared/<SID> for single-node SAP HANA systems Please choose the correct answer.
Response:

A. Size [installation(single-node)] = MIN (2 x RAM; 2 TB) B. Size [installation(single-node)] = MAX (2 x RAM; 1 TB) C. Size [installation(single-node)] = MIN (2 x RAM; 1 TB) D. Size [installation(single-node)] = MIN (1 x RAM; 1 TB)

Correct Answer: D

Question 10

What is scale-out?
There are 2 correct answers to this question.
Response:

A. Use of remote servers to store archived data that is rarely used. B. Use of commodity servers that are used in high volume steaming applications. C. Use of multiple servers to spread processing and improve performance. D. Use of standby servers in the event of hardware failure.

Correct Answer: C,D

Question 11

To maintain good read performance in a constantly changing database, which two components are used?
There are 2 correct answers to this question.
Response:

A. Memory store B. Main storage C. Delta storage D. Column store

Correct Answer: B,C

Question 12

The Add System Archive Link is a new feature that allows users to connect to multiple SAP HANA systems.
From which method one user can manage the list of all systems in a centrally-accessible archive (with read only link to other user)?
Please choose the correct answer.
Response:

A. File -> Export -> SAP HANA -> Landscape B. File -> archive -> SAP HANA -> Landscape C. File -> Export -> Landscape -> SAP HANA D. File -> archive -> SAP HANA -> Export

Correct Answer: A

SAP Certified Technology Associate - SAP HANA 2.0 - C-HANATEC-13 Exam Practice Test