Which of the following are held in SAP HANA used memory? (Choose two)
A. Free memory pool
B. Temporary computations
C. Heap memory
D. Column and row tables
Your SAP HANA database performs slowly. Which of the following might be reasons for the performance decrease? (Choose two).
A. Many replication jobs are running.
B. Backup jobs are running.
C. Too many information models have been created.
D. Large tables are updated with frequent delta merges
Which is the dominant statement (see attached table)?
A. Statement2
B. Statement3
C. Statement1
D. Statement4
How can you find default values for SAP HANA configuration settings?
A. Double-click the Database Information row in the System information tab in the Administration editor.
B. Go to the Configuration tab in the Administration editor and inspect the Default column.
C. Go to the Configuration tab in the Administration editor and inspect the System column.
D. Right-click on a configuration setting in the Configuration tab in the Administration editor.
How can you avoid filling up the space of the log backup file area?
A. Enable automatic log backup.
B. Increase the value of the log_segment_size_mb parameter.
C. Change the log_backup_timeout_s to a small value.
D. Disable automatic log backup.
Which of the following can you use to create an index in the SAP HANA database? (Choose two)
A. Execute a CE_PROJECTION statement from a stored procedure.
B. Execute a CERATE INDEX SQL statement from the SQL console.
C. 1. Open the SAP HANA studio
2.
Expand the Catalog tree and select the schema.
3.
Expand the Table tree.
4.
Select Open Definition and create an index
D. 1. Open the SAP HANA studio
2.
Expand the Content tree and select the package.
3.
Expand the Package tree.
4.
Select New and then Decision table.
You are working with a multimode SAP HANA database.
How can you identify the master indexserver? (Choose two)
A. Select the Landscape tab in the SAP HANA Administration Console Navigate to the Services subtab In the Service column, identify the row with the value "indexserver", and in the Detail column, identify the row with the value "master"
B. Select the Landscape tab in the SAP HANA Administration Console Navigate to the Configuration subtab
In the indexserver Role (Configured), identify the row with the value "MASTER 1"
C. Select the Volumes tab In the Show dropdown list, select Services Identify the master indexserver in the Service column
D. Select the Landscape tab in the SAP HANA Administration Console Navigate to the Configuration subtab In the indexserver Role (Actual) column, identify the row with the value "MASTER"
How can you identify often-used SQL statements? Note: 2 correct answers
A. Review the SQL Plan Cache subtab in the Performance tab of the SAP HANA studio Administration editor
B. Create an SQL query on the view SYS.M_SQL_PLAN_CACHE
C. Review the Sessions subtab in the Performance tab of the SAP HANA studio Administration editor
D. Create an SQL query on the view SYS.M_CONNECTION_STATISTICS
What are the purposes of executing a delta merge operation in an SAP HANA database? (Choose three)
A. To move updated records from delta storage to column store
B. To move new records from SAP ECC tables to delta storage
C. To move merge data from row tables to column store
D. To move inserted records from delta storage to column store
E. To move deleted records from delta storage to column store
Which of the following columns are displayed in the Merge Statistics system report? (Choose three)
A. TYPE
B. PART_ID
C. STATEMENT_STRING
D. MOTIVATION
E. CONNECTION_ID