SAP C_HANATEC_17 Online Practice Questions and Exam Preparation

SAP C_HANATEC_17 Online Questions & Answers

• Question 161:

  Which diagnostic file can you use to monitor the status of database recovery?

  A. backint.log
  B. backup.log
  C. sapstartsrv.log
  D. available.log
  B. backup.log

• Question 162:

  You administer a single-host system with 100GB physical memory. The global allocation limit and the individual service allocation limit are set to 90%. Three services are running- Service 1 has 25 GB of memory allocated and service 2 has 40 GB allocated. What is the effective allocation limit of service 3?

  A. 100 GB
  B. 90 GB
  C. 35 GB
  D. 25 GB
  D. 25 GB

• Question 163:

  Your SAP HANA database is locked down. Which action can you still perform?

  A. Check database license
  B. Check overall database status
  C. Check session memory
  D. Configure system properties
  A. Check database license

• Question 164:

  What is a characteristic of the synchronous in-memory system replication mode in SAP HANA?

  A. The primary system waits until the secondary system confirms receiving the log
  B. The primary system waits until the secondary system confirms the log was persisted
  C. The primary system does NOT wait for confirmation of the secondary system
  D. The primary system suspends transactions processing until the connection to the secondary system is established
  A. The primary system waits until the secondary system confirms receiving the log

• Question 165:

  Which tools can you use to monitor the response time of individual SQL queries?

  Note: There are 2 correct answers.

  A. SQL Trace
  B. Statement Monitor
  C. SQL plan cache
  D. Thread Monitor
  A. SQL Trace
  C. SQL plan cache

• Question 166:

  USER A grants a privilege to USER B, and USER B grants the same to USER C afterwards. What happens if you drop USER B from the HANA database?

  A. The privilege remains assigned to both USER A and USER C.
  B. The privilege is revoked from USER A, but not USER C.
  C. The privilege is revoked from both USER A and USER C.
  D. The privilege is revoked from USER C, but not USER A.
  D. The privilege is revoked from USER C, but not USER A.

• Question 167:

  Which actions are performed during the database migration option (DMO) procedure when you select the 'Do not compare table contents' option? There are 2 correct answers to this question.

  A. A row count is executed for the migrated tables.
  B. The content comparison is performed for repository tables.
  C. A check sum is generated every 10000 rows.
  D. The clustered tables are decluttered.
  C. A check sum is generated every 10000 rows.
  D. The clustered tables are decluttered.

• Question 168:

  Which action do you perform when SAP HANA Database is running out of space Please choose the correct answer. Response:

  A. Create a new tenant database
  B. extend the file system size on the operating system level
  C. create a new databse volume
  D. extend the size of database volume
  C. create a new databse volume

• Question 169:

  Which technology is used to install the SAP Landscape Management tool? Please choose the correct answer.

  A. SAP NetWeaver Application Server for ABAP
  B. SAP Fiori launchpad
  C. SAP NetWeaver Application Server for Java
  D. SAP HANA XS advanced runtime
  C. SAP NetWeaver Application Server for Java

• Question 170:

  Your customer has purchased a 1.5 TB SAP HANA license. To which value do you set the GLOBAL_ALLOCATION_LIMIT parameter when you have four 1TB nodes in an SAP HANA scale-out system with three worker and one standby nodes? Please choose the correct answer.

  A. 375 GB
  B. 1.5 TB
  C. 512 GB
  D. 1.0 TB
  C. 512 GB