C_HANASUP_1 - SAP Certified Support Associate - SAP HANA 1.0
Go back to SAP
You are asked to configure the SAP HANA database to recompile every query prior execution. What do you have to disable to accomplish this?
The SQL trace
How can you avoid filling up the space of the log backup file area?
Enable automatic log backup.
In the Volumes tab of the SAP HANA studio Administration Console, which of the following provides you with the total disk space (in MB)?
The value in the Total Disk Size (MB) column.
Which of the following can you use to schedule a periodic SAP HANA database backup?
SAP HANA studio
Which role must you grant to an SAP HANA user to enable this user for replication tasks only?
In a scaled-out, high-availability environment for an SAP HANA database, how can you monitor the status of the hosts in the cluster? (Choose three)
1. In the SAP HANA studio, right-click to add a new system. 2. Create an entry for each of the hosts in this environment. 3. Log into each of the hosts.
1. In the SAP HANA studio, navigate to the Landscape tab. 2. Select the Services subtab. 3. Check the Detail column.
1. Log into the Linux operating system of the SAP HANA appliance. 2. Launch the SAP HDB Admin console. 3. Navigate to the Management Console tab. 4. Verify that all SAP HANA database processes are running.
Which trace do you have to configure to identify only long-running queries in the SAP HANA database?
Expensive statements trace.
How can you restore a default parameter configuration setting in the SAP HANA studio? (Choose two)
In the context menu of a configuration parameter, choose Change, and then Restore Default.
In the context menu of a configuration parameter, choose Delete.
Which steps are required to identify dominant SQL statements? (Choose two)
Go to the SQL Plan Cache tab on the Performance tab
Sort SQL plan cache by total execution time, from largest to smallest
In SAP HANA, the automatic backup is disabled. The log area has grown and now the file system is full. The database has frozen. After you stop the database , what do you have to do to restart SAP HANA?
1. Copy the log into a new folder. 2. Update the global.ini file with the new folder path. 3. Restart the server and execute the log backup in the SAP HANA studio. 4. Copy the log to the initial folder and restore the global.ini file.
Your SAP HANA database performs slowly. Which of the following might be reasons for the performance decrease? (Choose two).
Many replication jobs are running.
Large tables are updated with frequent delta merges
In the Administration editor in the SAP HANA studio, which reports can you use to first investigate (1) And then release (2) deadlocks?
The Diagnosis Files tab The Sessions subtab of the Performance tab
You cancelled a running backup. Where in the SAP HANA studio can you verify that the cancellation was successful?
In the Session subtab of the Performance tab of the Administration edit
You are supporting an SAP Netweaver BW Powered by HANA system that is in productive operation. Inadvertently, a table was deleted. The last data backup was three days ago. You need to recover the system to the point before the table deletion. What do you have to do accomplish this?
Restore the SAP HANA database from backup and apply the logs to recover to a point in time.
How can you identify often-used SQL statements? Note: 2 correct answers
Review the SQL Plan Cache subtab in the Performance tab of the SAP HANA studio Administration editor
Create an SQL query on the view SYS.M_SQL_PLAN_CACHE
What does a data snapshot do?
It creates a backup of the database
Which of the following tasks can you perform only with system privilege TRACE ADMIN? (Choose two)
Delete trace files
Start SQL traces
How can you perform a manual backup of the Sap HANA database? (Choose two)
Select Backup in the SAP HANA studio
Execute SQL statements in the SQL Console
Which parameters can you configure for an expensive statement trace? (Choose two)
You granted a user the system privileges INIFILE ADMIN and DATA ADMIN. What does this allow the user to do?
Modify configuration files.
You have an application that runs on the SAP HANA database. The application loads relatively large volumes of data for hint to the database. Which mergedog configuration parameter in the indexserver.ini file must you set to accomplish this?
You have executed a kernel trace where can you view the trace results?
In the SAP HANA studio diagnosis files
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)
Enable expensive SQL statements tracing.
Set the trace level.
You have selected SAP HANA as product in SAP Solution Manager and checked the prerequisites. What are the next steps to configure SAP HANA as a managed system in SAP Solution Manager?
1. Assign diagnosis agents. 2. Enter system parameters. 3. Enter landscape parameters. 4. Create logical components. 5. Check configuration.
What does peak used memory represent?
The maximum values of used memory over time
How can you resolve a Disk Full event?
1. Add additional storage space. 2. Mark the event as handled in the Overview tab of the Administration editor. 3. Resume the SAP HANA database.
In an expensive statement trace configuration, you want to identify queries that run longer than two minutes. Which value do you enter? Please choose the correct answer.
For which purposes can you use the Table locks system report?
To investigate locked table names
Which of the following are minimum requirements for the installation of an SAP HANA server? (Choose two)
<WORKING_DIRECTORY>is empty before the start of the installation
<WORKING_DIRECTORY>has 200MB or more of free disk space
When you deploy the SAP HANA client package on UNIX, which drivers are installed?) 3 answers)
Why do you configure a standby host?
To reduce recovery time from an outage
You are working with a multimode SAP HANA database. How can you identify the master indexserver? (Choose two)
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"
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"
An SAP HANA developer receives an error when running an SAP HANA Predictive Analysis Library procedure. In which of the following files can you find more information?
Statistics server log
In the SAP HANA studio, which of the following enables you to identify the memory consumption of loaded tables?
Load subtab of the Performance tab of the Administration editor
For what purpose do you visualize a query plan?
To investigate which engines are executing an SQL query
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?
The host of the service is configured as a standby host.
You receive an alert: "XYZ TABLE has a record count of 508000408. How can you prevent the alert from being generated again? (Choose two).
Apply constraint filters in analytic views
Modify the alert thresholds
Which system privilege do you need to modify the global_allocation_limit parameter?
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.
1. Open the Administration Console. 2. Select Volumes. 3. Select Storage from the dropdown list
1. Open the Administration Console. 2. Select System Information. 3. Select Size of Tables on Disk.
You have to set the alert levels for CPU utilization: Low alert-75% Medium alert-85% High alert-95% You have opened the ConfigureCheck threshold tab in the Administration editor of the SAP HANA studio To which values do you set the alert levels in the Check Host CPU Utilization row?
75, 85, 95
Which of the following events can trigger a delta merge? (Choose two)
The delta log for a columnar table exceeds a defined limit.
Memory consumption of delta storage exceeds a specified limit.
How can you set configurations at the host level using the SAP HANA studio?
Right-click on a row in the Host column of the Configuration tab in the Administration editor. Select Configure Table and change settings
In the SAP HANA studio, which of the following SQL thread details can you monitor by using the Threads subtab of the Performance tab of the Administration editor? (Choose three)
The generated data
The service name
The blocking status
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?
You want to configure an SQL trace with trace level set to ALL_WITH_RESULTS. How can you limit the size of the trace file? (Choose two).
Specify the database user to trace.
Specify the tables and views to trace.
Your SAP HANA project has gone live. The client requires to build a new sandbox environment, using a copy of the production data, for prototyping and technical upgrades What is the SAP recommended approach to meet the requirement?
Install a new SAP HANA instance with help from the hardware vendor Restore the production database from a data backup
Your customer is designing a role exclusively for performing database backups of the SAP HANA database. Which system privileges must be assigned to this role? (Choose two).
In the SAP HANA studio Administration Editor, for the following purposes can you use the Sessions subtab of the Performance tab? (Choose two)
To view memory consumption by session
To investigate blocking situations
Which of the following columns are displayed in the Merge Statistics system report? (Choose three)
Which SAP Solution Manager 7.1 capabilities enhance transport management in CTS/CTS+? (Choose three)
Diagnostics in SAP Solution Manager
Change analysis and reporting
Quality gate management