Online Access Free C-HANATEC141 Exam Questions

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.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
• B.In SAP HANA studio, check the session overview
  Identify the logical CONNECTION ID for the SAP NetWeaver work process
  Check the columns APPLICATIONSOURCE and APPLICATIONUSER
• C.Open Transaction Global Work Process Overview (SM66) in the SAP NetWeaver system
  Sort the list by CPU time
  Select the top entry
• D.Go to the Performance tab of SAP HANA studio
  Check the System load diagram

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.PUBLIC
• B.CONTENT_ADMIN
• C.MODELING
• D.MONITORING

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?

• A.Set the log_mode parameter to overwrite in global.ini.
• B.Move the log files to another volume and create a symbolic link to the new folder.
• C.Run "Delete older backups" in the Backup Catalog.
• D.Delete older log files from the log volume before the last successful database backup.

You have an SAP HANA development environment with 4 scale out servers of 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.50 GB for the entire system and 150 GB individually for Host B
• B.75 GB for the entire system
• C.300 GB for the entire system
• D.100 GB for the entire system and 200 GB individually for Host A

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