SAP C_HANATEC_1 Certified Technology Associate Practice Exam Set 5

Which of the following traces provides information about past SQL query runtime performance including the values of parameters?


Options are :

  • User-specific trace
  • SQL trace
  • Performance trace
  • Expensive statements trace (Correct)

Answer : Expensive statements trace

When you install SAP HANA, which of the following disk size requirements apply? (Choose two)


Options are :

  • The log volume is at least four times the amount of memory (RAM) of the system.
  • The data volume is at least four times the amount of memory (RAM) of the system. (Correct)
  • The data volume equals the amount of memory (RAM) of the system.
  • The log volume equals the amount of memory (RAM) of the system. (Correct)

Answer : The data volume is at least four times the amount of memory (RAM) of the system. The log volume equals the amount of memory (RAM) of the system.

Which of the following must you implement for high availability in an SAP HANA production system? (Choose three)


Options are :

  • Shared file system for all nodes (Correct)
  • A name server on one active node
  • Index server processes on all nodes (Correct)
  • A statistics server on one active node (Correct)

Answer : Shared file system for all nodes Index server processes on all nodes A statistics server on one active node

Which of the following are allowed to be written to the disk space for the data volumes in an SAP HANA system? (Choose two)


Options are :

  • Log files
  • Backup data files
  • Data exports (Correct)
  • Runtime dump files (Correct)

Answer : Data exports Runtime dump files

Which of the following memory indicators can you reset to measure the impact of a new workload on memory usage?


Options are :

  • Virtual memory
  • Used memory
  • Peak used memory (Correct)
  • Resident memory

Answer : Peak used memory

How can you find out which SAP HANA parameters have been changed in your system? (Choose two)


Options are :

  • By running the SQL query select * from "PUBLIC"."M_CONFIGURATION" where options != 'DEFAULT'
  • By checking the configuration tab of the Administration Console in SAP HANA studio (Correct)
  • By running the SQL query select * from "PUBLIC"."M_INIFILE_CONTENTS" where layer_name != 'DEFAULT' (Correct)
  • By checking the indexserver trace file covering the last system startup.

Answer : By checking the configuration tab of the Administration Console in SAP HANA studio By running the SQL query select * from "PUBLIC"."M_INIFILE_CONTENTS" where layer_name != 'DEFAULT'

Which of the following is a result of using SAP HANA as an application platform?


Options are :

  • The need for indexes is eliminated.
  • Calculation-intensive logic is pushed down to the database (Correct)
  • Aggregates in data models are only materialized when required.
  • All database queries have a sub-second response time.

Answer : Calculation-intensive logic is pushed down to the database

Your SAP HANA usage scenario does not require SAP HANA XS.What do you have to consider before you remove the SAP HANA XS service from the configuration? (Choose three)


Options are :

  • A data backup must be taken after the SAP HANA XS service has been removed. (Correct)
  • All applications using the SAP HANA instance must be stopped. (Correct)
  • User adm is required to remove the SAP HANA XS service.
  • The SAP HANA XS service must be removed from all hosts of the SAP HANA instance. (Correct)

Answer : A data backup must be taken after the SAP HANA XS service has been removed. All applications using the SAP HANA instance must be stopped. The SAP HANA XS service must be removed from all hosts of the SAP HANA instance.

You are using the Change and Transport System (CTS) with SAP HANA.When is the transport strategy determined?


Options are :

  • When the objects are attached to a transport request in the SAP HANA studio
  • When the SAP HANA application type is configured in CTS
  • When the export system is configured in CTS (Correct)
  • When the connection to CTS is configured in SAP HANA studio

Answer : When the export system is configured in CTS

Which of the following tools can you use to create and manage SAP HANA database users? (Choose two)


Options are :

  • Microsoft Active Directory
  • SAP Solution Manager
  • hdbsql (Correct)
  • SAP Netweaver Identity Management (Correct)

Answer : hdbsql SAP Netweaver Identity Management

When does SAP recommend that you execute the first system backup?


Options are :

  • After completing the post-installation steps (Correct)
  • Before updating the system
  • After the first data load
  • After a complete load of master data

Answer : After completing the post-installation steps

You want the user SOLMAN_ADMIN to be able to modify the properties of the SAP HANA instance during system configuration in SAP Solution Manager. Which role must you assign to the user SOLMAN_ADMIN to achieve this?


Options are :

  • SAP_SOLAR02_ALL
  • SAP_SYSTEM_REPOSITORY_ALL (Correct)
  • SAP_SYSREC_ALL
  • SAP_SM_ADMIN_COMPONENT_ALL

Answer : SAP_SYSTEM_REPOSITORY_ALL

What is the minimum required disk space for the data volumes of an SAP HANA system in relation to its memory (RAM)?


Options are :

  • 1 * RAM
  • 2 * RAM
  • 4 * RAM (Correct)
  • 3 * RAM

Answer : 4 * RAM

You have to transport data models from one SAP HANA system to another using the Change and Transport System (CTS).Where do you install the CTS plug in?


Options are :

  • In the XS engine
  • In the source system
  • In the SAP HANA studio
  • In SAP Solution Manager (Correct)

Answer : In SAP Solution Manager

Which of the following authentication methods are provided by SAP HANA? (Choose two)


Options are :

  • Kerberos (Correct)
  • NTLM
  • RADIUS
  • Security Assertion Markup Language (SAML) (Correct)

Answer : Kerberos Security Assertion Markup Language (SAML)

Which of the following are characteristics of a design-time role? (Choose two


Options are :

  • It is granted through the execution of stored procedures. (Correct)
  • It is transportable between systems. (Correct)
  • It is revoked if the grantee user is deleted.
  • It is granted and revoked directly by an administrator.

Answer : It is granted through the execution of stored procedures. It is transportable between systems.

The log volume is full and the SAP HANA database does not accept any new requests.How can you solve this problem and bring the SAP HANA database online?


Options are :

  • Run "Delete older backups" in the Backup Catalog.
  • Move the log files to another volume and create a symbolic link to the new folder. (Correct)
  • Set the log_mode parameter to overwrite in global.ini.
  • Delete older log files from the log volume before the last successful database backup

Answer : Move the log files to another volume and create a symbolic link to the new folder.

Application users report that a query sometimes runs much slower than usual. You suspect that high system load is causing the slower query execution. Which of the following can you use to review overall system resource utilization at the time of query execution?


Options are :

  • SAP HANA Studio Administration Console->Performance LOAD (Correct)
  • DBA Cockpit (DBACOCKPIT) Current Status Alerts
  • SAP HANA Studio System Monitor Sessions
  • DBA Cockpit (DBACOCKPIT) Performance Expensive Statements

Answer : SAP HANA Studio Administration Console->Performance LOAD

In the SAP HANA studio, to which of the following does the loading status "partially" refer?


Options are :

  • To a row store table that is loaded in delta storage
  • To a column store table that is loaded in delta storage
  • To a row store table of which only some rows are loaded
  • To a column store table of which only some columns are loaded (Correct)

Answer : To a column store table of which only some columns are loaded

Which of the following SAP HANA tools is used to collect diagnostic information?


Options are :

  • fullSystemInfoDump.py (Correct)
  • hdbnsutil
  • hdbsql
  • landscapeHostConfiguration.py

Answer : fullSystemInfoDump.py

The statistics server was stopped during an upgrade by the system administrator.Which of the following parameters in statisticsserver.ini do you modify to restart the statistics server?


Options are :

  • statsserv in the trace section
  • active in the statisticsserver_general section (Correct)
  • editing in the statisticsserver_general section
  • statsconnect in the trace section

Answer : active in the statisticsserver_general section

You have exported a system landscape from an SAP HANA studio and imported it into a different SAP HANA studio.What information must you provide to make the imported landscape work?


Options are :

  • Connection path
  • Server instance numbers
  • Server host names
  • Passwords for all connections (Correct)

Answer : Passwords for all connections

You set up a data transfer architecture that replicates data to SAP HANA from an SAP source system using SAP Landscape Transformation (SLT).Which of the following SLT configuration parameter changes can improve the replication performance? (Choose three)


Options are :

  • Change initial load mode (Correct)
  • Increase the number of data transfer jobs (Correct)
  • Increase the number of calculation jobs (Correct)
  • Set data class of tablespace

Answer : Change initial load mode Increase the number of data transfer jobs Increase the number of calculation jobs

In the navigator tree of the SAP HANA studio, how can you find out which indexes are defined for table CUST_DATA from the SALES schema? (Choose two)


Options are :

  • Content node SALES schema node Tables folder right-click on the table CUST_DATA Open Content
  • Catalog node SALES schema node Tables folder double-click on the table CUST_DATA (Correct)
  • Content node SALES schema node Tables folder right-click on the table CUST_DATA Open Definition
  • Catalog node SALES schema node Tables folder right-click on the table CUST_DATA Open Definition (Correct)

Answer : Catalog node SALES schema node Tables folder double-click on the table CUST_DATA Catalog node SALES schema node Tables folder right-click on the table CUST_DATA Open Definition

When is the administration editor in SAP HANA studio opened automatically in diagnosis mode? (Choose two)


Options are :

  • When an SQL connection is not available (Correct)
  • When the system is restarting (Correct)
  • When the sapstartsrv service is not running
  • When the index server service is restarted

Answer : When an SQL connection is not available When the system is restarting

Which of the following can decrease the startup time of an SAP HANA system after a reboot?


Options are :

  • Reducing the number of column tables in the database
  • Reducing the number of fields in the master data
  • Reducing the size of the row-based tables (Correct)
  • Reducing the size of the transactional data records

Answer : Reducing the size of the row-based tables

Which of the following are valid authorization assignments? (Choose three)


Options are :

  • Privilege to user (Correct)
  • Role to role (Correct)
  • Privilege to role (Correct)
  • Role to privilege

Answer : Privilege to user Role to role Privilege to role

You have an SAP HANA development environment with 4 scale out servers of 512 GB RAM each (Hosts A, B, C, and D). You would like to allocate exactly 300 GB to install a BW on HANA development database.Which of the following are valid values for the global_allocation_limit parameter? (Choose two)


Options are :

  • 50 GB for the entire system and 150 GB individually for Host B (Correct)
  • 300 GB for the entire system
  • 100 GB for the entire system and 200 GB individually for Host A
  • 75 GB for the entire system (Correct)

Answer : 50 GB for the entire system and 150 GB individually for Host B 75 GB for the entire system

Which of the following can you do in the SAP HANA studio and also in the DBA Cockpit? (Choose three)


Options are :

  • View the tables in the _SYS_STATISTICS schema. (Correct)
  • Execute system recovery.
  • Monitor an SQLDBC trace. (Correct)
  • Display the statuses of database resources. (Correct)

Answer : View the tables in the _SYS_STATISTICS schema. Monitor an SQLDBC trace. Display the statuses of database resources.

Using SAP Landscape Transformation (SLT), you are replicating in real-time an SAP ERP system (source system) into an SAP HANA system. How can you check whether the source system and SLT are synchronized? (Choose two)


Options are :

  • By comparing the system time of the operating systems in SLT and the SAP ERP system (Correct)
  • By executing the ABAP program :TZCUSTHELP in SLT and the SAP ERP system (Correct)
  • By executing the ABAP program :SAPLATRA_TOOL_TIMES in SLT and the SAP ERP system
  • By comparing entries in table TTZCU (Customizing time zones) in SLT and the SAP ERP system

Answer : By comparing the system time of the operating systems in SLT and the SAP ERP system By executing the ABAP program :TZCUSTHELP in SLT and the SAP ERP system

Comment / Suggestion Section
Point our Mistakes and Post Your Suggestions