SAP C_HANATEC_17 Online Practice Questions and Exam Preparation

SAP C_HANATEC_17 Online Questions & Answers

• Question 111:

  You install an SAP HANA database and SAP NetWeaver AS ABAP 7.5 on one productive system. Which of the following installation requirements are mandatory? There are 2 correct answers to this question.

  A. The system ID (SID) for the SAP NetWeaver AS ABAP system and the SAP HANA database must be different.
  B. The memory resources for the SAP NetWeaver AS ABAP system and the SAP HANA database must be added.
  C. The instance number for the SAP NetWeaver AS ABAP system and the SAP HANA database must be the same.
  D. The disk resources for the SAP NetWeaver AS ABAP system and the SAP HANA database must be the same.
  A. The system ID (SID) for the SAP NetWeaver AS ABAP system and the SAP HANA database must be different.
  B. The memory resources for the SAP NetWeaver AS ABAP system and the SAP HANA database must be added.

• Question 112:

  Which of the following traces is active after the SAP HANA installation is completed? Please choose the correct answer. Response:

  A. SQL
  B. Plan
  C. Performance
  D. Database
  D. Database

• Question 113:

  Who owns an SAP HANA Deployment Infrastructure (HDI) role? Please choose the correct answer.

  A. The SYSTEM user of the tenant database
  B. The user who created the role C. The _SYS_REPO technical user
  D. The container-specific technical user
  D. The container-specific technical user

• Question 114:

  SQL statements are rejected by the Workload Admission Control application, and you need to investigate the reason. Which parameters do you adjust to manage the event log? There are 2 correct answers to this question.

  A. max_queue_size
  B. queue_wait_time_threshold
  C. record_limit
  D. queue_timeout
  B. queue_wait_time_threshold
  C. record_limit

• Question 115:

  You suspect an authorization issue while executing SAP HANA reports that contain calculation views. How do you configure the authorization trace? There are 2 correct answers to this question.

  A. Specify the name of the table/view.
  B. Select INFO from the System Trace Level for the Indexserver component and then select AUTHORIZATION.
  C. Specify the user as the database user.
  D. Select INFO from the System Trace Level for the Preprocessor component and then select AUTHORIZATION.
  B. Select INFO from the System Trace Level for the Indexserver component and then select AUTHORIZATION.
  C. Specify the user as the database user.

• Question 116:

  You must design a high-availability SAP HANA database system with 8 hosts (6 worker and 2 standby) that also uses multitenant database containers. Which rules apply? There are 2 correct answers to this question.

  A. The system database must run on the standby host.
  B. The system database instance must run on all hosts (worker and standby).
  C. The tenant databases must be able to be scaled out to all hosts (worker and standby).
  D. The tenant databases must run on the worker hosts.
  B. The system database instance must run on all hosts (worker and standby).
  D. The tenant databases must run on the worker hosts.

• Question 117:

  Why does SAP HANA have a persistence storage layer that is disk-based? There are 2 correct answers to this question. Response:

  A. To generate indexes for the column store
  B. To allow row store operations
  C. To persist in-memory data
  D. To enable data recovery if the power fails
  C. To persist in-memory data
  D. To enable data recovery if the power fails

• Question 118:

  The data storage of your productive SAP HANA instance crashed and you need to recover the database. The log storage is still intact. You have a full data backup that is 9 hours old and an incremental backup that is 4 hours old.

  To which point in time can you recover to minimize the data loss? Please choose the correct answer.

  Response:

  A. The database can be recovered to the 4-hour-old incremental backup.
  B. The database can be recovered to the latest log backup.
  C. The database can be recovered up to when the crash occurred.
  D. The database can be recovered to the 9-hour-old data backup.
  C. The database can be recovered up to when the crash occurred.

• Question 119:

  From an architectural standpoint, which of the following components belong to the SAP HANA Indexserver?

  There are 2 correct answers to this question.

  Response:

  A. External Interfaces
  B. Preprocessor
  C. Relational Engines
  D. SAP Web Dispatcher
  A. External Interfaces
  C. Relational Engines

• Question 120:

  You need to analyze the high CPU load of running thread in more detail in the Thread Monitor. Which parameters do you need to change? Note: There are 2 correct answers.

  A. threshold_cpu_time
  B. cpu_time_measurement_mode
  C. load_monitor_granularity
  D. enable_tracking
  B. cpu_time_measurement_mode
  C. load_monitor_granularity