On an SAP HANA production system /the log area has grown and the file system is now full. This has resulted in a database freeze. Which parameters must you set to avoid this situation in the future? (Choose two)
A. enable_auto_log_backup = no
B. enable_auto_log_backup = yes
C. log_mode = overwrite
D. log_mode = normal
You have just finish the baseline installation of an SAP HANA sever. Which activity should you perform next?
A. Create user accounts.
B. Back up the SAP HANA server.
C. Patch the SAP HANA server.
D. Create a scheduled backup.
You are asked to configure the SAP HANA database to recompile every query prior execution.
What do you have to disable to accomplish this?
A. The SQL trace
B. The SQL result cache
C. The expensive statements trace
D. The SQL plan cache
Which of the following can you use to create an index in the SAP HANA database? (Choose two)
A. Execute a CE_PROJECTION statement from a stored procedure.
B. Execute a CERATE INDEX SQL statement from the SQL console.
C. 1. Open the SAP HANA studio
2.
Expand the Catalog tree and select the schema.
3.
Expand the Table tree.
4.
Select Open Definition and create an index
D. 1. Open the SAP HANA studio
2.
Expand the Content tree and select the package.
3.
Expand the Package tree.
4.
Select New and then Decision table.
Which SAP Solution Manager 7.1 capabilities enhance transport management in CTS/CTS+? (Choose three)
A. Diagnostics in SAP Solution Manager
B. Change analysis and reporting
C. Configuration validation checks
D. SAP NetWeaver Landscape Virtualization Management
E. Quality gate management
You receive an alert: "XYZ TABLE has a record count of 508000408.
How can you prevent the alert from being generated again? (Choose two).
A. Scale out the SAP HANA system
B. Partition the table
C. Apply constraint filters in analytic views
D. Modify the alert thresholds
How do you display the available disk space (in %) for data from the Volumes tab of the SAP HANA editor?
A. 1. Locate the Details for Data Storage section
2.
Navigate to the File subtab
3.
In the Type column, identify the row with the value "DATA"
4.
Subtract the Used/Total Size (%) value from 100
B. 1. In the Show dropdown list; select Storage
2.
In the Type column/identify the row with the value "DATA"
3.
Retrieve the Available Disk Size (%) value.
C. 1. In the Show dropdown list, select Service
2.
Select the row with the master index server
3.
Retrieve the Available Disk Size (%) value.
D. 1. Locate the Details for Data Storage section
2.
Navigate to the Data Volume Superblock Statistics subtab
3.
In the Used Superbolcks column, identify the row with the largest value
4.
Subtract the Used/Total Superblocks (%) value from 100
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).
A. Delete the trace file if it grows too large.
B. Increase the flush limit.
C. Specify the database user to trace.
D. Specify the tables and views to trace.
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?
A. 25,15,5
B. 75, 85, 95
C. 0.25, 0.15, 0.05
D. 0.75, 0.85, 0.95
You want to partition a large table in an SAP HANA database. One of the columns on which you want to base the partition is non-primary key column YEAR.
Which partitioning method can you use?
A. Single-level round robin.
B. Single-level hash.
C. Mutilevel round robin.
D. Mutilevel hash hash.
Nowadays, the certification exams become more and more important and required by more and more enterprises when applying for a job. But how to prepare for the exam effectively? How to prepare for the exam in a short time with less efforts? How to get a ideal result and how to find the most reliable resources? Here on Vcedump.com, you will find all the answers. Vcedump.com provide not only SAP exam questions, answers and explanations but also complete assistance on your exam preparation and certification application. If you are confused on your C_HANASUP_1 exam preparations and SAP certification application, do not hesitate to visit our Vcedump.com to find your solutions here.