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

Question 1

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 2

In SAP HANA Architecture which of the following component can easily enhance the functionality of Multiple-Container System Please choose the correct answer.
Response:

A. OS & Hardware B. System Database C. Tenant Database D. Storage

Correct Answer: C

Question 3

Which components of SAP HANA Indexserver allow clients to connect and communicate with the SAP HANA database?
Please choose the correct answer.
Response:

A. Storage Engine and Disk Storage B. Relational Engines C. Request Processing and Execution Control D. External Interfaces

Correct Answer: D

Question 4

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 5

A developer at your customer starts a badly designed query. How do you stop this query?
Please choose the correct answer.
Response:

A. Use the Expensive Statements Trace app to stop the statement. B. Use the Sessions app to end the session. C. Use the Threads app to cancel the thread. D. Use the Monitor Statements app to interrupt the statement.

Correct Answer: D

Question 6

What are the advantages of the DMO procedure?
There are 3 correct answers to this question.
Response:

A. DMO combines several steps into one procedure. B. DMO is an inplace procedure by default, keeping the application server host. C. DMO allows an easy reset during the procedure. D. DMO allows a lower target release on SAP HANA database.

Correct Answer: A,B,C

Question 7

Which of the following traces is active after the SAP HANA installation is completed?
Please choose the correct answer.
Response:

A. SQL B. Database C. Plan D. Performance

Correct Answer: B

Question 8

When creating a system connection in SAP HANA Studio, which of these is essential information?
There are 3 correct answers to this question.
Response:

A. Host B. A valid user and password C. Instance D. URL

Correct Answer: A,B,C

Question 9

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 10

What do you have to ensure during the downtime phases of SUM?
There are 3 correct answers to this question.
Response:

A. End users can not log on to the SAP system B. Batch jobs from daily business can not start C. Interfaces from other SAP systems can not log on to the SAP system D. The source database must be stopped

Correct Answer: A,B,C

Question 11

SAP HANA, in the context of user management, allows you to do which of the following?
There are 3 correct answers to this question.
Response:

A. Create and delete users B. Assign a user to a user group C. Create a restricted user D. Lock and unlock users

Correct Answer: A,C,D

Question 12

You register a new resource in SAP HANA cockpit 2.0. What prerequisite does the resource require?
Please choose the correct answer.
Response:

A. A multitenant configuration with SystemDB B. A technical user with limited authorizations C. The target database on SAP HANA 2.0 SPS00 or higher D. A usage type of production, test, or development

Correct Answer: B

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