CORRECT TEXT An SAP HANA administrator has asked you to retrieve size information for one table How can you retrieve this information? (Choose two). A 1. Open the Catalog node. 2. Open the Table Definition. 3. Select Runtime Information. A.…
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
In the Administration Editor of the SAP HANA studio, how can you identify SQL statements with lock contention? A. Check the Overall Workload report of the System Information tab. B. Filter on the DURATION_MICROSEC column in the Expensive Statements Trace…
You cancelled a running backup. Where in the SAP HANA studio can you verify that the cancellation was successful? A. In the Backup folder of the Navigator pane B. In the vies M_BACKUP_CATALOG_FILE in the SYS schema C. In the…
How can you restore a default parameter configuration setting in the SAP HANA studio? (Choose two) A. In the context menu of a configuration parameter, choose Configure Table, and the Restore Default. B. In the context menu of a configuration…
What do you have to consider when you want to unpartition an SAP HANA table? (Choose three) Unpartitioning blocks concurrent read access to the table during the process. A. An exclusive lock on the table is required. B. Unpartitioning can…
Which part of an expensive statement trace would you investigate to identify possible performance improvements? A. Statement string B. Statement length C. TOTAL_LOCK_WAIT_TIME D. ALLOC_MEM_SIZE_COLSTORE
Which of the following can you transport using CTS/CTS+? (Choose two) A. Analytic privilege B. Calculation view C. Index D. Table
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…
For which purposes can you use the Table locks system report? A. To investigate locked table names B. To unlock tables C. To investigate table lock transaction owners D. To kill locking transactions