SapHanaTutorial.Com HOME     Learning-Materials Interview-Q&A Certifications Quiz Online-Courses Forum Jobs Trendz FAQs  
     Explore The World of Hana With Us     
About Us
Contact Us
 Apps
X
HANA App
>>>
Hadoop App
>>>
Tutorial App on SAP HANA
This app is an All-In-One package to provide everything to HANA Lovers.

It contains
1. Courses on SAP HANA - Basics, Modeling and Administration
2. Multiple Quizzes on Overview, Modelling, Architeture, and Administration
3. Most popular articles on SAP HANA
4. Series of Interview questions to brushup your HANA skills
Tutorial App on Hadoop
This app is an All-In-One package to provide everything to Hadoop Lovers.

It contains
1. Courses on Hadoop - Basics and Advanced
2. Multiple Quizzes on Basics, MapReduce and HDFS
3. Most popular articles on Hadoop
4. Series of Interview questions to brushup your skills
Apps
HANA App
Hadoop App
';
Search
Stay Connected
Search Topics
Topic Index
+
-
Process and Overview
+
-
HANA Admin Certification
+
-
HANA Modeling Certification
+
-
ABAP for HANA Certifications
+
-
BW on HANA Certifications
+
-
SAPUI5/Fiori Certifications
+
-
HCP Certifications
+
-
S4HANA Certifications
+
-
Old HANA Certifications
SAP HANA Certification C_HANASUP_1 - Sample Questions

In our previous article SAP HANA Certification C_HANASUP_1 we provided the details of the certification C_HANASUP_1.
In this article we will provide some sample questions for this certification.

You may also check:
  1. In the SAP HANA studio, which of the following SQL thread details can you monitor by using the Threads sub tab of the Performance tab of the Administration editor?(3 answers)
    1. The SQL statement
    2. The generated data
    3. The service name
    4.  The blocking status
    5.  The visual execution plan
  2. Which parameters can you configure for an expensive statement trace?(2 answers)
    1. Passport trace level
    2. Threshold duration
    3. Trace status
    4.  Trace file
  3. 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)Restart the server
2)Execute the log backup in the SAP HANA studio.
3)Copy the log into a new folder.
4)Update the global.ini file with the new folder path.
  1.  
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.
  1.  
1)Initialize the log area from the file system folder.
2)Restart the server.
3)Execute the log backup into the SAP HANA studio.
4)Refresh the global.ini file.
  1.  
1)Restart the server.
2)Copy the log into a new folder.
3)Execute the log backup into the SAP HANA studio.
4)Update the global.ini file with the new folder path.
  1. In the SAP HANA studio, in which sub tab of the Landscape tab of the Administration editor can you check the statuses of all hosts in a high-availability scenario?
    1. Hosts
    2. Services
    3. Secondary System Replication
    4.  Redistribution
  2. In the SAP HANA studio Administration Editor, for the following purposes can you use the Sessions sub tab of the Performance tab?(2 answers)
    1. To view memory consumption by session
    2. To investigate blocking situations
    3. To set up session-based alerts
    4.  To configure the maximum allowed concurrent sessions
  3. How can you resolve a Disk Full event?
    1.  
1)Add additional memory.
2)Mark the event as handled in the Alerts tab of the Administration editor
3)Resume the SAP HANA database.
  1.  
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.
  1.  
1)Mark the event as handled in the Overview tab of the Administration editor.
2)Add additional memory.
3)Resume the SAP HANA database.
  1.  
1)Stop the SAP HANA database.
2)Mark the event as handled in the Overview tab of the Administration editor.
3)Restart the SAP HANA database
  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?
    1. Script server log
    2. Index server log
    3. Name server log
    4.  Statistics server log
  2. Which of the following are held in SAP HANA used memory? (2 answers)
    1. Free memory pool
    2. Temporary computations
    3. Heap memory
    4.  Column and row tables
  3. Which of the following events can trigger a delta merge?(2 answers)
    1. Memory consumption of delta storage drops below a specified limit.
    2. The delta log for a columnar table drops below a defined limit.
    3. The delta log for a columnar table exceeds a defined limit.
    4.  Memory consumption of delta storage exceeds a specified limit.
  4. You granted a user the system privileges INIFILE ADMIN and DATA ADMIN. What does this allow the user to do?
    1. Modify the nameserver_history.trc files.
    2. Reset the backup.log file.
    3. Modify configuration files.
    4.  Reset the log.txt file
  5. Which of the following can you determine using the Backup catalog report?(2 answers)
    1. The path for the backup files
    2. Whether a recovery is possible
    3. Which backup files are obsolete
    4.  When to execute the net backup
  6. For which purposes can you use the Table locks system report?
    1. To investigate locked table names
    2. To unlock tables
    3. To investigate table lock transaction owners
    4.  To kill locking transactions
  7. How can you set configurations at the system level using the SAP HANA studio?
    1. Enter values in the System column in the Configuration tab in the Administration editor.
    2. Right-click on a system in the Navigator pane and select Open Security from the context menu.
    3. Right-click on a setting in the Configuration tab in the Administration editor, select Change, and enter values for all hosts.
    4.  Enter values in the Properties view when you use the Overview tab of the Administration editor.
  8. Which of the following can you transport using CTS/CTS+? (2 answers)
    1. Analytic privilege
    2. Calculation view
    3. Index
    4.  Table
  9. Which part of an expensive statement trace would you investigate to identify possible performance improvements?
    1. Statement string
    2. Statement length
    3. TOTAL_LOCK_WAIT_TIME
    4.  ALLOC_MEM_SIZE_COLSTORE
  10. What do you have to consider when you want to unpartition an SAP HANA table? (3 answers) Unpartitioning blocks concurrentread access to the table during the process.
    1. An exclusive lock on the table is required.
    2. Unpartitioning can table a long time to complete.
    3. Only read access is allowed during the unpartitioning prcess.
    4.  Only tables of more than 2 billion rows can be unpartitioned.
  11. How can you restore a default parameter configuration setting in the SAP HANA studio? (2 answers)
    1. In the context menu of a configuration parameter, choose Configure Table, and the Restore Default.
    2. In the context menu of a configuration parameter, choose Change, and then Restore Default.
    3. In the context menu of a configuration parameter, choose Delete.
    4.  Choose Window
  12. You cancelled a running backup. Where in the SAP HANAstudio can you verify that the cancellation was successful?
    1. In the Backup folder of the Navigator pane
    2. In the vies M_BACKUP_CATALOG_FILE in the SYS schema
    3. In the System Information tab of the Administration editor
    4.  In the Session sub tab of the Performance tab of the Administration edit
  13. In the Administration Editor of the SAP HANA studio, how can you identify SQL statements with lock contention?
    1. Check the Overall Workload report of the System Information tab.
    2. Filter on the DURATION_MICROSEC column in the Expensive Statements Trace tab of the Performance tab.
    3. Check the Record Locks report of the System Information tab.
    4.  Filter on the LOCK_WAIT_COUNT column in the Expensive Statements Trace tab of the Performance tab.
  14. 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?
    1. SUPPORT
    2. CONTENT ADMIN
    3. MONITORING
    4.  MODELING

Answers:
1 B, C, D
2 B, C
3 B
4 A
5 A, B
6 B
7 D
8 B, D
9 C, D
10 C
11 B, C
12 A
13 C
14 A, B
15 A
16 A, C, D
17 B, C



Support us by sharing this article.



Explore More
Close X
Close X

12 thoughts on “SAP HANA Certification Sample Questions and Dumps – C_HANASUP_1

  1. Hetal says:

    Can You help me out with more C_HANASUP_1 certification questions.

  2. Sokita says:

    Very good information given on this site. I suggest to Prepare sample SAP HANA certification questions with SAP HANA Certification Guide . You will get all questions in your exam that premium questions only

  3. Admin says:

    Hi Sokita,
    Thank you for the feedback. Our team is working on the course materials and questions answers for the certification
    1. P_HANAIMP131 – SAP Certified Application Professional (Edition 2013) – SAP HANA
    2. C_HANAIMP131 – SAP Certified Application Associate (Edition 2013) – SAP HANA

    It will be published soon.

    Regards,
    SAPHANATutorial.com Team

  4. Manish says:

    I am looking for SAP hana exact certification Q&A.
    I would appreciate your help in this regard.
    Thanks,
    Manish

  5. Ramesh Narayanan says:

    In C_HANASUP_1 – Sample Questions, 4th question answer is A. Here configuartion is not a sub tab. Instead of Configuration, Host should be there…

  6. Almeida Nunes says:

    Hi,

    regarding question 20, I do not see any role named SUPPORT. From the studio I see the others that are in the question (CONTENT ADMIN, MONITORING, MODELING) but not SUPPORT. What I’ve found regarding authorization to delete trace files was the System privilege TRACE_ADMIN.

    Regards
    A. Nunes

    • Almeida Nunes says:

      Hu,

      meanwhile I ran the following query: SELECT * FROM “PUBLIC”.”GRANTED_PRIVILEGES” where grantee_type = ‘ROLE’ and object_type = ‘SYSTEMPRIVILEGE’ and privilege =’TRACE ADMIN’

      From this query I got the role SAP_INTERNAL_HANA_SUPPORT includes the the system privilege TRACE ADMIN (And not a role called SUPPORT).

  7. Almeida Nunes says:

    I just find that according with the HA200 training guide for SPS07 the former name for the role was ‘SUPPORT’. But this continue to be a very tricky question (the number 20) and these learning material help us because we need to go thru the training material remembering the subjects.

  8. Michael says:

    Regarding question 16,

    Where are limitations/restrictions for table un-partitioninig described?

    I cannot find such limitations in the documenttion http://help.sap.com/saphelp_hanaplatform/helpdata/en/48/10afe854254d46b947ef9cd4be3e11/content.htm

    Also, where can we find answers for questions 18, 19 and 20?

    Best regards,

    Michael

    Best

  9. waseem says:

    Hi,

    Still waiting for the answers for questions 18 through 20.

Leave a Reply

Your email address will not be published. Required fields are marked *

Current day month ye@r *

 © 2017 : saphanatutorial.com, All rights reserved.  Privacy Policy