SAP C_HANATEC142 Online Practice Questions and Exam Preparation

SAP C_HANATEC142 Online Questions & Answers

• Question 21:

  A backup catalog became unusable.

  What can you do to recover existing backups?

  Please choose the correct answer.

  Choose one:

  A. Create a new data backup.
  B. In SAP HANA studio Backup Editor Display all backups select REFRESH
  C. Recreate the backup catalog based on the available backup files with the tool hdbbackupdiag.
  D. Use a third party backup tool to recover the backups.
  C. Recreate the backup catalog based on the available backup files with the tool hdbbackupdiag.

• Question 22:

  Which of the following components must be installed in SAP HANA to enable SAP Early Watch Alerts? There are 2 correct answers to this question.

  A. CCMS agent
  B. Collection script
  C. Host agent
  D. SMD agent
  B. Collection script
  C. Host agent

• Question 23:

  What is the minimum required disk space for the data volumes of an SAP HANA system in relation to its memory (RAM)?

  Please choose the correct answer.

  Choose one:

  A. 1 * RAM
  B. 3 * RAM
  C. 4 * RAM
  D. 2 * RAM
  C. 4 * RAM

• Question 24:

  Which of the following can you use to analyze an expensive SQL statement?

  There are 2 correct answers to this question.

  Choose:

  A. Open the Plan Explanation.
  B. Open the Plan Visualizer.
  C. Open the hdbcons tool.
  D. Open the SQL Plan Cache.
  A. Open the Plan Explanation.
  B. Open the Plan Visualizer.

• Question 25:

  Which delivered role is mandatory for a system administrator in SAP HANA? Please choose the correct answer.

  A. CONTENT_ADMIN
  B. IC MODELER
  C. SYS_ADMIN
  D. SAP_ALL
  A. CONTENT_ADMIN

• Question 26:

  Which of the following components need a server certificate when you configure the SAP HANA Automated Update function? There are 2 correct answers to this question.

  A. Host agent
  B. SAP HANA studio
  C. SAP HANA database
  D. Update Manager
  A. Host agent
  D. Update Manager

• Question 27:

  Which of the following must you do in the SAP HANA studio to be able to use the Change and Transport System (CTS)?

  There are 2 correct answers to this question.

  Choose:

  A. Configure the connection to the CTS in the preferences.
  B. Create a delivery unit that contains all of the information models.
  C. Create the HTTP connection CTSDEPLOY
  D. Use a user who is authorized to attach SAP HANA content to transport requests.
  A. Configure the connection to the CTS in the preferences.
  D. Use a user who is authorized to attach SAP HANA content to transport requests.

• Question 28:

  Which command is recommended by SAP to install an SAP HANA database via a graphical user interface (GUI)? Please choose the correct answer.

  A. ./hdbsetup
  B. ./sapinst
  C. ./hdbinst
  D. ./hdbinst ?install
  A. ./hdbsetup

• Question 29:

  You need to create a role that allows read-only access to the tabs of SAP HANA Administration Editor. Which of the following privileges do you need to assign to that role?

  There are 2 correct answers to this question.

  Choose:

  A. System privilege CONTENT_ADMIN
  B. SQL privilege SELECT for the SQL object SYS_STATISTICS
  C. System privilege SERVICE_ADMIN
  D. System privilege DATA_ADMIN
  B. SQL privilege SELECT for the SQL object SYS_STATISTICS
  D. System privilege DATA_ADMIN

• Question 30:

  After you install an SAP HANA database, you want to ensure that it is automatically started when the host is rebooted.

  Which of the following parameter settings allows you to do this?

  Please choose the correct answer.

  Choose one:

  A. Autostart to "TRUE" in the profile file /usr/sap//SYS/profile/DEFAULT.PFL
  B. Autostart to "1" in the profile file /usr/sap//SYS/profile/_HDB_
  C. Autostart to "Enable" in the profile file /usr/sap//SYS/profile/_HDB_
  D. Autostart to "Yes" in the profile file /usr/sap//SYS/profile/DEFAULT.PFL
  B. Autostart to "1" in the profile file /usr/sap//SYS/profile/_HDB_