How can you set configurations at the system level using the SAP HANA studio?
A. Enter values in the System column in the Configuration tab in the Administration editor.
B. Right-click on a system in the Navigator pane and select Open Security from the context menu.
C. Right-click on a setting in the Configuration tab in the Administration editor, select Change, and enter values for all hosts.
D. Enter values in the Properties view when you use the Overview tab of the Administration editor.
You want to enable a new database user to view and delete trace files.
Which of the following standard roles must you assign to the user?
A. SUPPORT
B. CONTENT ADMIN
C. MONITORING
D. MODELING
Which of the following are prerequisites for the integration of SAP Solution Manager and SAP HANA? (Choose two)
A. Register SAP HANA in the System Landscape Directory.
B. Create a connection to SAP HANA in the managed system configuration.
C. Configure SAP NetWeaver Landscape Virtualization Management.
D. Configure SAP Early Watch Alets for SAP HANA.
When you are monitoring hosts statuses, you find that the status of one of the index server services is IGNORE (gray square).
What is the reason for this?
A. The index server service has been stopped.
B. The host's actual role is different from its configured role.
C. The host of the service is configured as a worker host.
D. The host of the service is configured as a standby host.
You have just finish the baseline installation of an SAP HANA sever. Which activity should you perform next?
A. Create user accounts.
B. Back up the SAP HANA server.
C. Patch the SAP HANA server.
D. Create a scheduled backup.
Which of the following tasks can you perform only with system privilege TRACE ADMIN? (Choose two)
A. Delete trace files
B. Start a Python
C. Start SQL traces
D. Delete SYS.P_SQLSCRIPTTRACE_.
How can you set configurations at the host level using the SAP HANA studio?
A. Update settings in the_SYS_REPO.CHANGES table
B. Enter values in the Host column in the Configuration tab in the Administration editor
C. Update settings in the _SYS_REPO.CHANGE_ENTRIES table
D. Right-click on a row in the Host column of the Configuration tab in the Administration editor. Select Configure Table and change settings
For what purpose do you visualize a query plan?
A. To update SAP HANA database statistics
B. To analyze query results
C. To investigate which engines are executing an SQL query
D. To generate a new execution plan on SQL queries
Your client tells you that the SAP HANA database backup is not working.
In the SAP HANA studio, where could you start to investigate the issue? (Choose three)
A. _SYS_BI schema
B. SYS schema
C. Administration editor - System Information
D. Administration editor - Performance overview
E. Administration editor ?Alerts
An ABAP program in SAP ECC is being optimized for the SAP HANA database. You have been asked to identify expensive SQL statements of this program that run for longer than one second.
What do you have to do to identify these expensive SQL statements? (Choose two)
A. Filter expensive SQL statements by DB user.
B. Enable expensive SQL statements tracing.
C. Set the trace level.
D. Set the threshold duration.
