Online Access Free C_HANATEC131 Practice Test

You deleted billions of records from several tables in the SAP HANA database. However, the file system for the data volumes did not gain any free space.
What is the reason?

• A.You did not execute a full backup and restore to reduce the size of the data volumes.
• B.SAP HANA keeps the space for later reuse.
• C.SAP HANA did not trigger a delta merge yet.
• D.You did not execute the ALTER SYSTEM RECLAIM LOG.

After you install an SAP HANA database, you want to ensure that it is automatically started when the host is rebooted.
Which of the following parameter settings allows you to do this?

• A.Autostart to "1" in the profile file /usr/sap/<SAPSID>/SYS/profile/<SID>_HDB<Instance_No>_<host_name>
• B.Autostart to "Enable" in the profile file /usr/sap/<SAPSID>/SYS/profile/<SID>_HDB<Instance_No>_<host_name>
• C.Autostart to "Yes" in the profile file /usr/sap/<SAPSID>/SYS/profile/DEFAULT.PFL
• D.Autostart to "TRUE" in the profile file /usr/sap/<SAPSID>/SYS/profile/DEFAULT.PFL

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)

• A.Content node SALES schema node Tables folder right-click on the table CUST_DATA Open Definition
• B.Catalog node SALES schema node Tables folder right-click on the table CUST_DATA Open Definition
• C.Content node SALES schema node Tables folder right-click on the table CUST_DATA Open Content
• D.Catalog node SALES schema node Tables folder double-click on the table CUST_DATA

You are investigating a problem with the SAP HANA database. You opened a customer message with SAP support. SAP support asks you to provide diagnostic information from the SAP HANA instance.
How can you gather this information? (Choose two)

• A.Run the fullSystemInfoDump.py script on the SAP HANA server as <SID>adm
• B.Execute Diagnosis Files -> Diagnosis Information -> Collect function in the SAP HANA studio
• C.Run the HDB info command on the SAP HANA server as <SID>adm
• D.Select and download all files under Diagnosis Files in the SAP HANA studio

Which view allows you to find the name and the size of backup files?

• A.M_SYSTEM_OVERVIEW
• B.M_BACKUP_CATALOG
• C.M_BACKUP_CATALOG_FILES
• D.M_SERVICE_STATISTICS