SAP C_HANATEC142 Online Practice Questions and Exam Preparation

SAP C_HANATEC142 Online Questions & Answers

• Question 61:

  Which of the following are recovery types in SAP HANA database? There are 2 correct answers to this question.

  A. Recovery with incremental backup
  B. Recovery until cancel
  C. Full recovery
  D. Point in time recovery
  C. Full recovery
  D. Point in time recovery

• Question 62:

  Which operating system commands show the SAP HANA processes?

  There are 2 correct answers to this question.

  Choose:

  A. HDB admin
  B. HDB info
  C. HDB version
  D. HDB proc
  B. HDB info

• Question 63:

  When you try to stop SAP HANA using the sapcontrol command, you receive the error messagE. "Command not found". What is the reason for the error?

  Please choose the correct answer.

  Choose one:

  A. The SAP HANA client is not installed.
  B. SAP SUM is not installed.
  C. The host agent is not installed.
  D. The SAP HANA database is not installed.
  C. The host agent is not installed.

• Question 64:

  You are reviewing the execution plan of an SQL statement. You want to find out which plan operators (POPs) have been executed in parallel and for how long each of them has been active. How can you accomplish this? Please choose the correct answer.

  A. Use the Visualize Plan functionality in the SAP HANA studio.
  B. Use Job Progress in the SAP HANA studio.
  C. Use Performance Trace in HDB admin.
  D. Use EXPLAIN (graphically) in the DBA Cockpit.
  A. Use the Visualize Plan functionality in the SAP HANA studio.

• Question 65:

  What do you have to consider when you design a backup plan? There are 2 correct answers to this question.

  A. The newest data must be backed up most often.
  B. The column table data needs to be compressed before a backup.
  C. The backup execution must be monitored.
  D. The database backup must be stored at a different location than the database server.
  C. The backup execution must be monitored.
  D. The database backup must be stored at a different location than the database server.

• Question 66:

  You created an information model in the SAP HANA studio and activated it successfully. When you execute the data preview you get an error message indicating missing privileges.

  Which of the following could solve the problem?

  Please choose the correct answer.

  A. GRANT SELECT ON SCHEMA TO _SYS_BIC
  B. GRANT CREATE ANY ON SCHEMA TO _SYS_REPO
  C. GRANT SELECT ON SCHEMA TO _SYS_REPO WITH GRANT OPTION
  D. GRANT SELECT ON SCHEMA TO _SYS_BI WITH GRANT OPTION
  C. GRANT SELECT ON SCHEMA TO _SYS_REPO WITH GRANT OPTION

• Question 67:

  Which of the following must be running to view SAP HANA Diagnosis Files if the SAP HANA database is offline? Please choose the correct answer.

  A. sapstartsrv
  B. SMD Agent
  C. r3trans
  D. disp+work
  A. sapstartsrv

• Question 68:

  Which of the following are allowed to be written to the disk space for the data volumes in an SAP HANA system? There are 2 correct answers to this question.

  A. Data exports
  B. Backup data files
  C. Log files
  D. Runtime dump files
  A. Data exports
  D. Runtime dump files

• Question 69:

  You have an SAP HANA development environment with 4 scale out servers of 512 GB RAM each (Hosts A, B, C, and D). You would like to allocate exactly 300 GB to install a BW on HANA development database.

  Which of the following are valid values for the global_allocation_limit parameter?

  There are 2 correct answers to this question.

  Choose:

  A. 100 GB for the entire system and 200 GB individually for Host A
  B. 50 GB for the entire system and 150 GB individually for Host B
  C. 75 GB for the entire system
  D. 300 GB for the entire system
  B. 50 GB for the entire system and 150 GB individually for Host B
  C. 75 GB for the entire system

• Question 70:

  What is the connection type for communication between the SAP LT Replication Server and the non-SAP source system?

  Please choose the correct answer.

  Choose one:

  A. QRFC
  B. Database
  C. Web service
  D. TRFC
  B. Database