SAP SAP Certifications C_HANATEC141 Questions & Answers

• Question 71:

  You want to create a role that grants read-only access to the content of the system and monitoring views and to statistics services.

  Which of the following privileges should the role contain? (Choose two)

  A. DATA ADMIN

  B. ALTER for SQL schema _SYS_STATISTICS

  C. SERVICE ADMIN

  D. SELECT for SQL schema _SYS_STATISTICS

  Correct Answer: AD

• Question 72:

  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 "Enable" in the profile file /usr/sap//SYS/profile/_HDB_

  B. Autostart to "TRUE" in the profile file /usr/sap//SYS/profile/DEFAULT.PFL

  C. Autostart to "Yes" in the profile file /usr/sap//SYS/profile/DEFAULT.PFL

  D. Autostart to "1" in the profile file /usr/sap//SYS/profile/_HDB_

  Correct Answer: D

• Question 73:

  Which of the following are characteristics of SAP NetWeaver Business Warehouse (SAP NetWeaver BW) when it is migrated to run on the SAP HANA database? (Choose two)

  A. The SAP NetWeaver BW application server can be installed on the SAP HANA hardware.

  B. The current SAP NetWeaver BW application server hardware can be re-used.

  C. All SAP NetWeaver BW 7.x application versions can be used.

  D. The sizing of the current SAP NetWeaver BW application server remains valid.

  Correct Answer: BD

• Question 74:

  How can you make space available inside the log volume in a productive SAP HANA system?

  A. Compress the log backups at file system level.

  B. Set the log mode to Overwrite.

  C. Perform log backups.

  D. Delete log backups at the operating system level.

  Correct Answer: C

• Question 75:

  Which Linux kernel parameters need to be adapted during SAP HANA installation depending on the SAP HANA system size?

  A. net.ipv4.tcp_slow_start_after_idle and kernel.shmmni

  B. kernel.shmall and fs.file-max

  C. fs.file-max and net.core.wmem_max

  D. net.core_rmem_max and kernel.sysrq

  Correct Answer: A

• Question 76:

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

  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

  Correct Answer: D

• Question 77:

  Which of the following would you use to upgrade an SAP HANA system and keep the downtime to a minimum?

  A. High availability

  B. Storage replication

  C. Partitioning

  D. System replication

  Correct Answer: D

• Question 78:

  Which of the following connection types does Direct Extractor Connection (DXC) use to transfer data to SAP HANA?

  A. RFC connection

  B. Secondary database connection

  C. http connection

  D. BICS connection

  Correct Answer: C

• Question 79:

  You want to make sure that all data accesses to a specific view will be logged in the audit trail. As part of an update of the database schema, the view is dropped and recreated under the same name.

  What is the consequence for auditing?

  A. The audit log-object references must be reinitialized.

  B. Auditing continues to work for the view.

  C. The audit policy needs to be reactivated.

  D. Auditing needs to be set up again for the recreated view.

  Correct Answer: B

• Question 80:

  You have to size an SAP HANA system for SAP NetWeaver BW. The SAP NetWeaver BW system is currently running on a non-SAP RDBMS.

  Which of the following factors influences the size of the SAP HANA system?

  A. The partitioning of tables

  B. The number of indexes

  C. The size of aggregates

  D. The number of tables in the row store

  Correct Answer: D