C_HANATEC_17 Online Practice Questions and Answers

How are save points triggered? There are 2 correct answers to this question

A. By a database soft shutdown.

B. By issuing a transactional commit.

C. By performing a delta merge.

D. By performing a database backup.

Which diagnostic file can you use to monitor the status of database recovery?

A. backint.log

B. backup.log

C. sapstartsrv.log

D. available.log

Which information is recorded in the database trace of the SAP HANA database?

A. Executed SQL statements on database level

B. Performance indicators on a query level

C. Database activities with the trace level ERROR

D. Query execution plans on an application level

You are registering an SAP HANA database resource using SAP HANA cockpit manager. Which privileges are automatically assigned when you initially create the COCKPIT_MONITOR technical user?

There are 2 correct answers to this question.

A. DATABSE ADMIN

B. CATALOG READ

C. SELECT on the SYS_TELEMETRY schema

D. SELECT on the SYS_STATISTICS schema

Your application runs with a technical user in a database of an SAP HANA multitenant database container. You want to execute a query across tenant databases. Which of the following prerequisites are required? There are 2 correct answers to this question.

A. User mapping

B. User sharing

C. Communication channel whitelist

D. Bi-directional communication channels

Which information is provided by the backup catalog? Please choose the correct Answer:.

A. Backup destination

B. Progress of a backup

C. Backup configuration

D. Backup ID

After confirming Lock now, which actions are still possible? Choose the correct Answer:.

A. Releasing and importing transport requests via the Transport Manager (SE09) and Transport Management System (STMS)

B. 88Creating and changing application data (e.g. VA01) and user master records SU01)

C. Developing via ABAP workbench (SE80)

D. Applying SAP notes via Note Assistant (SNOTE)

To maintain good read performance in a constantly changing database, which two components are used?

There are 2 correct answers to this question.

Response:

A. Column store

B. Memory store

C. Delta storage

D. Main storage

Which statement is wrong regarding Operational Data Marts? Please choose the correct answer. Response:

A. Views calculate results for reports in real time on the actual operational data

B. No transformation during load step (only selection of relevant data if applicable)

C. Real-time replication of time critical data (SLT/SRS)

D. Typically contains no time critical data and therefore utilize traditional ETL

During Installation 3 users are created automatically, which of the following statement is wrong regarding default users description? Please choose the correct answer. Response:

A. The password of the adm user is set during installation with the password parameter

B. SYSTEM is the SAP Host Agent administrator

C. SYSTEM is the database superuser

D. The password of the SYSTEM user is set during installation with the system_user_password parameter