C_HANATEC141 Online Practice Questions and Answers

You created an information model in the SAP HANA studio and activated it successfully. When you execute the data preview you get an error message indicating missing privileges.

Which of the following could solve the problem?

A. GRANT SELECT ON SCHEMA TO _SYS_BIC

B. GRANT CREATE ANY ON SCHEMA TO _SYS_REPO

C. GRANT SELECT ON SCHEMA TO _SYS_REPO WITH GRANT OPTION

D. GRANT SELECT ON SCHEMA TO _SYS_BI WITH GRANT OPTION

You need to combine unstructured data from an Apache Hadoop database with data in your SAP HANA system.

What do you use to achieve this?

A. SAP Sybase IQ

B. Full-text search indexes

C. Virtual tables

D. SAP Landscape Transformation

A backup catalog became unusable.

What can you do to recover existing backups?

A. Recreate the backup catalog based on the available backup files with the tool hdbbackupdiag.

B. Use a third party backup tool to recover the backups.

C. Create a new data backup.

D. In SAP HANA studio Backup Editor Display all backups select REFRESH

You are using continuous system replication between SAP HANA systems in two separate data centers. What are the advantages of this scenario? (Choose two)

A. The take-over happens in less than 3 minutes.

B. Database changes are continuously updated to the secondary site.

C. The take-over only requires a roll forward since the last synchronization point.

D. Memory and CPU are used on the secondary site for shadow processes.

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 are advantages of using the SAP CO-PA accelerator? (Choose two)

A. Transforms data during the load step

B. Eliminates the need for customization

C. Provides business configuration

D. Reduces reporting time

You have created a file named backup.sql with the following information to run a backup:

/c -n -i -u -p BACKUP DATA USING FILE ('backupDirectory/data/COMPLETE_BK')

Which of the following commands executes the backup?

A. hdbsql -I backup.sql

B. hdbsql c backup.sql

C. hdbsql -S backup.sql

D. hdbsql -o backup.sql

Which of the following SAP HANA tools is used to collect diagnostic information?

A. landscapeHostConfiguration.py

B. hdbnsutil

C. hdbsql

D. fullSystemInfoDump.py

Which of the following traces provides information about past SQL query runtime performance including the values of parameters?

A. Expensive statements trace

B. Performance trace

C. User-specific trace

D. SQL trace

What is the minimum required disk space for the data volumes of an SAP HANA system in relation to its memory (RAM)?

A. 4 * RAM

B. 3 * RAM

C. 2 * RAM

D. 1 * RAM