Free SAP Certified Technology Associate – SAP HANA 2.0 SPS04 C_HANATEC_16 Exam Practice Test

Which of the following tools can be used for User Administration? There are 3 correct Answers to this question.

• SAP NetWeaver Identity Management
• hdbsql
• Resident hdblcm
• SAP HANA Cockpit

In an SAP HANA database system running in log mode 'normal', in which situation does the system automatically execute a regular log backup? There are 2 correct answers to this question.

• When the log buffer is full.
• When the time threshold is exceeded.
• When the log segment is full.
• When a commit occurs.

Which parameter do you set to protect an SAP HANA database system against uncontrolled queries that consume excessive memory? There are 2 correct answers to this question.

• memory_tracking
• statement_memory_limit
• reject_memory_threshold
• total_statement_memory_limit

Once you start the SAP HANA cockpit 2.0, From the Aggregated Health Monitor, navigate to the SAP HANA system overview pag This page displays the detailed status of the selected SAP HANA system. Which of thefollowing options are listed? There are 3 correct answers to this question.

• Monitoring and Administration
• Performance Management
• Resource Management
• Security
• Memory Management

Which tool shows the difference of tables and indexes between your ABAP dictionary and your SAP HANA database?

• DBA Cockpit
• hdblcm
• hdbsql
• SAP HANA cockpit

Your application runs with a technical user in a database of an SAP HANA multitenant database container. You want to execute a query across tenant databases. Which of the following prerequisites are required? Thereare 2 correct answers to this question.

• User mapping
• User sharing
• Communication channel whitelist
• Bi-directional communication channels

Reloading column tables in this way restores the database to a fully operational state more quickly. However, it does create performance overhead, and may not be necessary in nonproductive systems, how can youdeactivate the the reload feature? Please choose the correct answer.

• Edit the indexserver.xml file by setting the reload_tables parameter in the sql section to false
• Edit the indexserver.xml file by setting the reload_tables parameter in the sql section to false
• Edit the indexserver.ini file by setting the reload_tables parameter in the sql section to true
• Edit the indexserver.ini file by setting the reload_tables parameter in the sql section to false

A user is complaining about missing privileges when executing a query. How do you configure the indexserver trace to obtain the missing privileges? Please choose the correct Answer:.

• Select trace level Warning for the authentication component.
• Select trace level Error for the auditing component.
• Select trace level Info for the authorization component.
• Select trace level Debug for the authenticationcodec component.

You migrate an SAP HANA system using SUM database migration option. Which activities do you perform to activate the viewer mode for SAP support? Note: There are 2 correct answers.

• Provide the sum observer URL to SAP support
• Provide the SUM URL to SAP support
• Create the OS user <sid>obs on the application server
• Create the database user <sid>obs on the application server

Which migration features are supported when using the Database Migration Option (DMO) feature of SAP Software Update Manager (SUM)? There are 2 correct answers to this question.

• The source and target database system are of the same type
• The Primary Application Server can be moved to a target system Landscape
• The target database is SAP Adaptive Server Enterprise (ASE)
• The source system is Application Server (AS) Java-base