C_HANATEC_10 Online Practice Questions and Answers

Using SAP Landscape Transformation (SLT), you are replicating in real-time an SAP ERP system (source system) into an SAP HANA system.

How can you check whether the source system and SLT are synchronized?

There are 2 correct answers to this question.

Response:

A. By executing the ABAP program :SAPLATRA_TOOL_TIMES in SLT and the SAP ERP system

B. By comparing the system time of the operating systems in SLT and the SAP ERP system

C. By comparing entries in table TTZCU (Customizing time zones) in SLT and the SAP ERP system

D. By executing the ABAP program :TZCUSTHELP in SLT and the SAP ERP system

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.

Response:

A. Delete older log files from the log volume before the last successful database backup.

B. Set the log_mode parameter to overwrite in global.ini.

C. Run "Delete older backups" in the Backup Catalog.

D. Move the log files to another volume and create a symbolic link to the new folder.

Which of the following are pre-delivered template roles? There are 2 correct answers to this question. Response:

A. MONITORING

B. IMPORT

C. SAP_INTERNAL_HANA_SUPPORT

D. MODELING

Which driver is required for the connection between SAP HANA and SAP BusinessObjects Explorer?

Please choose the correct answer.

Response:

A. BICS

B. JDBC

C. ODBO

D. ODBC

You need to retrieve data from SAP HANA that is restricted to a certain region and specific users. How can

you implement this security strategy?

Please choose the correct answer.

Response:

A. By assigning package privileges to the necessary users

B. By assigning analytic privileges to the necessary users

C. By assigning SQL privileges to the necessary users

D. By assigning system privileges to the necessary users

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?

Please choose the correct answer.

Response:

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.

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

server?

Please choose the correct answer.

Response:

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 can you use to analyze an expensive SQL statement?

There are 2 correct answers to this question.

Response:

A. Open the Plan Visualizer.

B. Open the Plan Explanation.

C. Open the hdbcons tool.

D. Open the SQL Plan Cache.

Which technologies use trigger-based replication? There are 2 correct answers to this question. Response:

A. Test Data Migration Server (TDMS)

B. ABAP extractors

C. TREX engine

D. Near Zero Downtime

E. Standard SQL database replication

Which of the following are benefits of implementing SAP HANA?

There are 3 correct answers to this question.

Response:

A. SAP HANA provides real-time analytics

B. SAP HANA performs much faster than the standard SAP ERP

C. SAP HANA replaces SAP BW

D. SAP HANA provides pre-configured BI Content

E. SAP HANA combines OLTP and OLAP in one system