C_HANATEC141 Online Practice Questions and Answers

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

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.

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

Which of the following situations can trigger a delta merge?

A. The memory consumption of the delta storage exceeds a limit.

B. A pre-defined time of day has arrived.

C. An SQL statement must read merged data.

D. The number of records in the main storage exceeds a limit.

Which of the following is influenced by the audit level?

A. The messages that are sent to the security administrator

B. The amount of data transferred to SAP Solution Manager

C. The order of the audit log entries in the audit log

D. The information that is printed with the audit log entry

In the SAP HANA studio, where can you check the throughput performance of SAP HANA backups?

A. Administration Console Diagnosis files Backup.log

B. Backup Editor Backup Catalog Backup Details

C. System Information Database Information

D. Administration Console Performance Job Progress

A company is planning to upgrade from an SAP HANA platform license to an SAP HANA enterprise license.

Which additional component will be provided?

A. XS application development

B. SAP Sybase ASE

C. Database for SAP NetWeaver BW

D. Data replication

What do you have to consider when you design a backup plan? (Choose two)

A. The newest data must be backed up most often.

B. The column table data needs to be compressed before a backup.

C. The backup execution must be monitored.

D. The database backup must be stored at a different location than the database server.

Which of the following can decrease the startup time of an SAP HANA system after a reboot?

A. Reducing the number of column tables in the database

B. Reducing the size of the transactional data records

C. Reducing the number of fields in the master data

D. Reducing the size of the row-based tables

Which of the following can you do in the SAP HANA studio and also in the DBA Cockpit? (Choose three)

A. Execute system recovery.

B. Implement backup scheduling.

C. Monitor an SQLDBC trace.

D. Display the statuses of database resources.

E. View the tables in the _SYS_STATISTICS schema.

In the SAP HANA studio, to which of the following does the loading status "partially" refer?

A. To a row store table that is loaded in delta storage

B. To a column store table that is loaded in delta storage

C. To a row store table of which only some rows are loaded

D. To a column store table of which only some columns are loaded

You want the user SOLMAN_ADMIN to be able to modify the properties of the SAP HANA instance during system configuration in SAP Solution Manager.

Which role must you assign to the user SOLMAN_ADMIN to achieve this?

A. SAP_SYSREC_ALL

B. SAP_SOLAR02_ALL

C. SAP_SM_ADMIN_COMPONENT_ALL

D. SAP_SYSTEM_REPOSITORY_ALL

Which of the following template roles allows a user who has been assigned this role to grant the privileges of this role to other users?

A. CONTENT_ADMIN

B. MODELING

C. PUBLIC

D. MONITORING

Which of the following authentication methods are provided by SAP HANA? (Choose two)

A. Security Assertion Markup Language (SAML)

B. NTLM

C. RADIUS

D. Kerberos

The statistics server was stopped during an upgrade by the system administrator.

Which of the following parameters in statisticsserver.ini do you modify to restart the statistics server?

A. statsconnect in the trace section

B. editing in the statisticsserver_general section

C. active in the statisticsserver_general section

D. statsserv in the trace section