C_HANATEC_12 Online Practice Questions and Answers

Which view displays the current SAP HANA Support Package level?

A. M_VERSION_MEMORY

B. M_DATABASE

C. M_HOST_INFORMATION

D. M_LANDSCAPE_HOST_CONFIGURATION

You need to create a role that allows read-only access to the tabs of SAP HANA Administration Editor. Which of the following privileges do you need to assign to that role? (Choose two.)

A. SQL privilege SELECT for the SQL object SYS_STATISTICS

B. System privilege CONTENT_ADMIN

C. System privilege SERVICE_ADMIN

D. System privilege DATA_ADMIN

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. Memory and CPU are used on the secondary site for shadow processes.

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. The take-over happens in less than 3 minutes.

You need to replicate data from an SAP ERP production system to SAP HANA.

Where does SAP recommend that you install the productive SAP Landscape Transformation (SLT) instance?

A. With the SAP Solution Manager system

B. On the SAP HANA server

C. On a dedicated server

D. With the SAP ERP system

What is the correct hierarchy of the below?

A. Delivery unit->package->object->product

B. Product->Delivery unit->package->object

C. Object->Delivery unit->package->product

D. Package>product-> Delivery unit-> object

You have an SAP HANA development environment with 4 scale out servers 512 GB RAM each (Hosts A, B, C, and D). You would like to allocate exactly 300 GB to install a BW on HANA development database.

Which of the following are valid values for the global_allocation_limit parameter? (Choose two.)

A. 100 GB for the entire system and 200 GB individually for Host A

B. 50 GB for the entire system and 150 GB individually for Host B

C. 75 GB for the entire system

D. 300 GB for the entire system

A long-running SQL query issued by an SAP NetWeaver work process also seems to use a lot of system resources.

How can you find out which ABAP module and which SAP NetWeaver user called the query?

A. Go to the Performance tab of SAP HANA studio- Check the System load diagram

B. Open Transaction Global Work Process Overview (SM66) in the SAP NetWeaver system- Sort the list by CPU time- Select the top entry

C. Open Transaction Process Overview (SM50) in the SAP NetWeaver system-Sort the list by CPU time-Select the top entry- Check the User and Report columns

D. In SAP HANA studio, check the session overview- Identify the logical CONNECTION ID for the SAP NetWeaver workprocess- Check the columns APPLICATIONSOURCE and APPLICATIONUSER

Which of the following can you use to analyze an expensive SQL statement? (Choose two.)

A. The hdbcons tool

B. The plan explanation

C. The plan visualizer

D. The performance trace view

Which tab in SAP HANA studio displays CPU load history data?

A. Volumes

B. Overview

C. Performance

D. Landscape

What can you do on the Configure Alerts tile in the SAP HANA cockpit? (Choose two.)

A. Run the checks regardless of their status.

B. Set a threshold value which triggers the check run.

C. Schedule the execution of the checks.

D. Cancel a running check from the list.