SAP C_HANATEC_12 Online Practice Questions and Exam Preparation

SAP C_HANATEC_12 Online Questions & Answers

• Question 31:

  Which of the following prerequisites must be met before you can install the SAP HANA studio on a Linux operating system? (Choose two.)

  A. You are logged on as the root user.
  B. The installation directory has at least 10 GB of free space.
  C. The Java runtime is accessible via the PATH or JAVA_HOME variable.
  D. You are logged on as the adm user.
  A. You are logged on as the root user.
  C. The Java runtime is accessible via the PATH or JAVA_HOME variable.

• Question 32:

  Which of the following privileges do you need to activate views?

  A. SELECT option on the _SYS_BIC schema
  B. SELECT option on the _SYS schema
  C. SELECT option on the _SYS_BI schema
  D. SELECT option on the _SYS_REPO schema
  D. SELECT option on the _SYS_REPO schema

• Question 33:

  Which of the following traces is active by default in SAP HANA?

  A. Performance trace
  B. Database trace
  C. SQL trace
  D. Expensive statements trace
  B. Database trace

• Question 34:

  What are the recommended ways to perform a database backup? (Choose two.)

  A. Use SQL commands
  B. Use the BRBACKUP command
  C. Use the./hdbsetup command
  D. Use SAP HANA Studio
  A. Use SQL commands
  D. Use SAP HANA Studio

• Question 35:

  When is the administration editor in SAP HANA studio opened automatically in diagnosis mode? (Choose two.)

  A. When the system is restarting.
  B. When the sapstartsrv service is not running.
  C. When an SQL connection is not available.
  D. When the index server service is restarted.
  A. When the system is restarting.
  C. When an SQL connection is not available.

• Question 36:

  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?

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

• Question 37:

  How can you delete old data and log backups from both the backup catalog and physically from the server?

  A. Run ''DELETE from m_backup_catalog_files where backup_id = '' in the SQL editor
  B. Delete all files under $(DIR_GLOBAL)/hdb/log
  C. Delete all files under $(DIR_INSTANCE)/backup/data and $(DIR_INSTANCE)/backup/log
  D. Go to Backup Editor -> Backup Catalog -> Delete Older Backups -> Catalog and backup location
  D. Go to Backup Editor -> Backup Catalog -> Delete Older Backups -> Catalog and backup location

• Question 38:

  Which of the following privileges are mandatory for the initial user to configure SAPLT to populate the SAP HANA database? (Choose two.)

  A. CREATE ANY in _SYS_BIC schema
  B. EXECUTE of REPOSITORY_REST(SYS)
  C. SELECT on SYS_REPL.RS_REPLICATION_COMPONENTS with grant option
  D. ROLE_ADMIN
  C. SELECT on SYS_REPL.RS_REPLICATION_COMPONENTS with grant option
  D. ROLE_ADMIN

• Question 39:

  A user is locked due to too many failed logon attempts. Which SQL command can solve this problem?

  A. ALTER USER ACCOUNT UNLOCK
  B. ALTER USER FORCE PASSWORD CHANGE AFTER ATTEMPTS
  C. ALTER USER RESET CONNECT ATTEMPTS
  D. ALTER USER DROP CONNECT ATTEMPTS
  C. ALTER USER RESET CONNECT ATTEMPTS

• Question 40:

  Which of the following steps is required for configuring SAP Landscape Transformation (SLT)?

  A. Define the number of background work processes in SLT.
  B. Define a DB connection from SLT to the source system.
  C. Define the number of jobs to be used for data replication.
  D. Define an RFC connection from SLT to SAP HANA.
  C. Define the number of jobs to be used for data replication.