C_HANATEC_16 Exam Training Practice Tests (SAP Certified Technology Associate

Question 1

Which prerequisites must be fulfilled when recovering a tenant database? There are 2 correct answers to this question.

A. You need the logon credentials of the system database user. B. You need the logon credentials of the <sid> adm user. C. The whole system is shut down, including all tenant databases D. Before the recovery starts, the tenant database must be stopped.

Correct Answer: B,D

Question 2

Which scale-out roles can you assign to the hosts in the nameserver.ini file? There are 2 correct answers to this question.

A. STANDBY B. SLAVE C. MASTER 1 D. WORKER

Correct Answer: A,D

Question 3

Where are the R3load processes located when performing the Database Migration Option (DMO) procedure using the in-place migration? Please choose the correct answer.

A. On the Primary Application Server (PAS) host B. On the Additional Application Server (AAS) host C. On the remote target database host D. On the source and target host

Correct Answer: A

Question 4

What must you do to configure the data backup on a scale-out SAP HANA system? Note: There are 2 correct answers

A. Verify that data and log backup destinations are valid throughout the system B. Ensure the availability of shared backup storage C. Specify the individual backup destination on each node D. Change the backup configuration for each node

Correct Answer: A,B

Question 5

How do you trigger a savepoint in an SAP HANA database?

A. Commit a transaction B. Start a log backup C. Perform a soft shutdown D. Execute a delta merge

Correct Answer: C

Question 6

Which application do you use to reset the memory statistics before you analyze a tenant database using SAP HANA cockpit?

A. Manage Databases B. Performance Monitor C. Resource Directory D. Manage Services

Correct Answer: D

Question 7

Which preparation tasks do you need to perform before starting the Database Migration Option (DMO) procedure? There are 2 correct answers to this question.

A. Extract the SAP HANA database software installation archive. B. Move the latest R3trans update archive into the download folder. C. Update the SAP Host Agent to the latest version D. Check if the latest SPAM/SAINT update is applied.

Correct Answer: C,D

Question 8

Which SAP HANA feature ensure that committed data is NOT lost if there is a power failure? Note: There are
2 correct answers.

A. Automatic savepoints B. Persisted redo logs C. Delta merge D. Memory allocation limit

Correct Answer: A,B

Question 9

Which SAP HANA features can you use to manage the database peak load? There are 2 correct answers to this question.

A. Thread throttling B. Admission control C. Capture and replay D. Workload classes

Correct Answer: B,D

Question 10

In which replication mode is the primary system blocked until the secondary system is available?

A. sync B. full sync C. async D. syncmem

Correct Answer: B

Question 11

Which alert configuration properties can you configure in SAP HANA cockpit? There are 3 correct answers to this question.

A. Email alert notification B. Schedule activation C. Schedule period D. Alert checker category E. Alert threshold values

Correct Answer: A,D,E

Question 12

What are the merge methods that are triggered by the SAP HANA system processes? There are 2 correct answers to this question.

A. Smart B. Auto C. Hard D. Critical

Correct Answer: B,D

Question 13

Which diagnostic file can you use to monitor the status of database recovery?

A. backup.log B. available.log C. sapstartsrv.log D. backint.log

Correct Answer: A

SAP Certified Technology Associate - SAP HANA 2.0 SPS04 - C_HANATEC_16 Exam Practice Test