SAP SAP Certifications C_HANATEC_10 Questions & Answers

• Question 41:

  How can you make space available inside the log volume in a productive SAP HANA system?

  Please choose the correct answer.

  Response:

  A. Compress the log backups at file system level.

  B. Set the log mode to Overwrite.

  C. Perform log backups.

  D. Delete log backups at the operating system level.

  Correct Answer: C

• Question 42:

  You installed SAP HANA Database using 51 as your system number. Which network port is used for

  Standard SQL communication for client access?

  Please choose the correct answer.

  Response:

  A. 55113

  B. 31551

  C. 35100

  D. 35115

  Correct Answer: D

• Question 43:

  You need to replicate data from an SAP ERP production system to SAP HANA.

  Where does SAP recommend that you install the productive SAP Landscape Transformation (SLT)

  instance?

  Please choose the correct answer.

  Response:

  A. With the SAP Solution Manager system

  B. On the SAP HANA server

  C. On a dedicated server

  D. With the SAP ERP system

  Correct Answer: C

• Question 44:

  How do you configure an SAP HANA system of 4 nodes when implementing high availability?

  Please choose the correct answer.

  Response:

  A. 3 master nodes 1 standby node

  B. 2 master nodes 1 slave node 1 standby node

  C. 1 master node 2 slave nodes 1 standby node

  D. 1 master node 3 slave nodes

  Correct Answer: C

• Question 45:

  In the SAP HANA studio, in which tab can you find information about the performance of queries?

  Please choose the correct answer.

  Response:

  A. Alerts

  B. Diagnosis Files

  C. System Information

  D. Trace Configuration

  Correct Answer: B

• Question 46:

  Which of the following do you add when you "scale out" SAP HANA?

  Please choose the correct answer.

  Response:

  A. Data storage

  B. Memory

  C. Servers

  D. CPUs

  Correct Answer: C

• Question 47:

  Which component of SAP HANA Database is used when you query an SAP HANA information model to

  populate a pivot table in Microsoft Excel?

  Please choose the correct answer.

  Response:

  A. The Log Volumes

  B. The Calculation Engine

  C. The Transaction Manager

  D. The SQL Interface

  Correct Answer: B

• Question 48:

  A company wants to restrict data access to a specific year for certain users. Which privilege type must you define in SAP HANA to achieve this requirement?

  Please choose the correct answer.

  Response:

  A. SQL privileges

  B. Package privileges

  C. System privileges

  D. Analytic privileges

  Correct Answer: D

• Question 49:

  You have created a file named backup.sql with the following information to run a backup:

  /c -n -i -u -p

  BACKUP DATA USING FILE ('backupDirectory/data/COMPLETE_BK')

  Which of the following commands executes the backup?

  Please choose the correct answer.

  Response:

  A. hdbsql -I backup.sql

  B. hdbsql -c backup.sql

  C. hdbsql -S backup.sql

  D. hdbsql -o backup.sql

  Correct Answer: A

• Question 50:

  What happens when you add a standby host to an existing SAP HANA system?

  There are 2 correct answers to this question.

  Response:

  A. The standby host takes over one of the active index servers.

  B. The standby host registers with the index server.

  C. The standby host starts an index server and waits.

  D. The standby host registers with the master name server.

  Correct Answer: CD