SAP SAP Certifications C_HANATEC_17 Questions & Answers

• Question 81:

  Due to a hardware failure, you are using a different host to recover a crashed SAP HANA database. Which of the following configuration files must you use for the recovery? There are 2 correct answers to this question. Response:

  A. sapprofile.ini

  B. xsengine.ini

  C. nameserver.ini

  D. Indexserver.ini

  Correct Answer: BC

• Question 82:

  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//HDB/exe

  B. /usr/sap/HDB//exe

  C. /sap/usr/HDB//exe

  D. /usr/sap//HDB/exe

  Correct Answer: D

• Question 83:

  Which identity provider is used by default by SAP HANA extended application services, advanced model (XS Advanced)?

  Please choose the correct answer.

  Response:

  A. SAP HANA user store

  B. SAP Identity Management

  C. SAP ID service

  D. SAP Cloud Identity

  Correct Answer: A

• Question 84:

  What are the prerequisites for configuring audit logging? There are 2 correct answers to this question. Response:

  A. AUDIT ADMIN system privilege

  B. INIFILE ADMIN system privilege

  C. AUDIT OPERATOR system privilege

  D. INIFILE OPERATOR system privilege

  Correct Answer: AB

• Question 85:

  Which prerequisites must be met to set up high availability for a distributed SAP HANA system? There are 2 correct answers to this question. Response:

  A. The column tables were assigned to an index server manually.

  B. The name server is started on all nodes.

  C. The synchronized backup savepoint is set.

  D. The shared storage is connected to every host.

  Correct Answer: BD

• Question 86:

  In the Monitoring Expensive Statements trace, which additional trace option needs to be set to "false" to write the trace data directly to file.

  Choose the correct answer.

  Response:

  A. Threshold memory

  B. Use in-memory tracing

  C. Trace flush interval

  D. In-memory tracing records

  Correct Answer: B

• Question 87:

  Which of the following statements are true regarding In-Memory computing security? There are 2 correct answers to this question. Response:

  A. Data and undo log information (part of data) are automatically saved to disk at regular savepoints

  B. The log is also saved to disk continuously and synchronously after each COMMIT of a database transaction

  C. The redo log captures last 5 minutes changes by database transactions

  D. After a power failure the system returns to its last consistent state by replaying the undo log since the last savepoint

  Correct Answer: AB

• Question 88:

  Which connection is used when you view or edit alerts in the Configure Alerts app using SAP HANA cockpit 2.0?

  Please choose the correct answer.

  Response:

  A. The https connection with the adm user

  B. The https connection with the system user

  C. The SQL connection with a technical user

  D. The SQL connection with a named user

  Correct Answer: D

• Question 89:

  You need to reset the database migration option (DMO) procedure due to a hardware failure. What are the prerequisites if you want to use the DMO reset procedure? There are 2 correct answers to this question Response:

  A. The source database needs to be available.

  B. The SUM folder needs to exist.

  C. The before-downtime backup needs to be available.

  D. The cleanup procedure needs to be performed.

  Correct Answer: AB

• Question 90:

  What happens when an SAP HANA system is restarted?

  There are 2 correct answers to this question

  Response:

  A. The list of open transactions is left open.

  B. All row tables are loaded into the memory except the row tables that are configured to be loaded on demand.

  C. All row tables and row table attributes are loaded into the memory.

  D. The Redo log is replayed from the last savepoint.

  Correct Answer: CD