SAP C_HANATEC142 Online Practice Questions and Exam Preparation

SAP C_HANATEC142 Online Questions & Answers

• Question 11:

  The log volume is full and the SAP HANA database does not accept any new requests.

  How can you solve this problem and bring the SAP HANA database online?

  Please choose the correct answer.

  Choose one:

  A. Run "Delete older backups" in the Backup Catalog.
  B. Set the log_mode parameter to overwrite in global.ini.
  C. Move the log files to another volume and create a symbolic link to the new folder.
  D. Delete older log files from the log volume before the last successful database backup.
  C. Move the log files to another volume and create a symbolic link to the new folder.

• Question 12:

  Which of the following is most relevant for CPU sizing of a SAP HANA appliance? Please choose the correct answer.

  A. The amount of disk storage
  B. The SAP HANA hardware platform
  C. The number of concurrent users logged onto SAP HANA
  D. The number of users actively running analytics in SAP HANA
  D. The number of users actively running analytics in SAP HANA

• Question 13:

  How can you delete old data and log backups from both the backup catalog and physically from the server? Please choose the correct answer.

  A. Delete all files under $(DIR_GLOBAL)/hdb/log
  B. Run "DELETE from m_backup_catalog_files where backup_id = " in the SQL editor
  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 14:

  Which security settings can you apply in analytic privileges?

  There are 2 correct answers to this question.

  Choose:

  A. Restrict access within an analytic view using attribute values.
  B. Restrict access within an analytic view using measure values.
  C. Grant access to analytic views.
  D. Restrict access to hierarchies.
  A. Restrict access within an analytic view using attribute values.
  C. Grant access to analytic views.

• Question 15:

  Which of the following configuration files contains the backup locations of log and data files? Please choose the correct answer.

  A. attributes.ini
  B. global.ini
  C. indexserver.ini
  D. localclient.ini
  B. global.ini

• Question 16:

  Which of the following SAP HANA tools is used to collect diagnostic information? Please choose the correct answer.

  A. landscapeHostConfiguration.py
  B. hdbnsutil
  C. hdbsql
  D. fullSystemInfoDump.py
  D. fullSystemInfoDump.py

• Question 17:

  Which of the following components enables SAP HANA high availability?

  Please choose the correct answer.

  Choose one:

  A. Index server
  B. Name server
  C. Statistics server
  D. Preprocessor server
  B. Name server

• Question 18:

  You have an SAP HANA productive system with sensitive dat

  A. How can you restrict modeling users from viewing this data? There are 2 correct answers to this question.
  B. Remove SAP_DATA_ADMIN in the SQL privileges for the modeling users.
  C. Allow modeling only on the SAP HANA development system and export/import the models to the productive system.
  D. Use randomized data for the development of data models.
  E. Remove ALTER SYSTEM in the system privileges for the modeling users.
  B. Remove SAP_DATA_ADMIN in the SQL privileges for the modeling users.
  C. Allow modeling only on the SAP HANA development system and export/import the models to the productive system.

• Question 19:

  You are using continuous system replication between SAP HANA systems in two separate data centers.

  What are the advantages of this scenario?

  There are 2 correct answers to this question.

  Choose:

  A. Database changes are continuously updated to the secondary site.
  B. Memory and CPU are used on the secondary site for shadow processes.
  C. The take-over happens in less than 3 minutes.
  D. The take-over only requires a roll forward since the last synchronization point.
  A. Database changes are continuously updated to the secondary site.
  D. The take-over only requires a roll forward since the last synchronization point.

• Question 20:

  Which of the following are characteristics of a design-time role?

  There are 2 correct answers to this question.

  Choose:

  A. It is revoked if the grantee user is deleted.
  B. It is granted and revoked directly by an administrator.
  C. It is transportable between systems.
  D. It is granted through the execution of stored procedures.
  C. It is transportable between systems.
  D. It is granted through the execution of stored procedures.