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
+
-
SAP Cloud Certifications
+
-
S4HANA Certifications
+
-
Old HANA Certifications

HANA Certification C_HANATEC_10 - Sample Questions

In our previous article All about SAP HANA Certifications we provided the list of all SAP HANA certifications and their details. We also provided basic details of the certification C_HANATEC_10 at C_HANATEC_10 Overview.
Now let us see what kind of questions you can expect in this certification.

Note: We highly recommend you to also check below articles:
  1. How to book SAP Certification - Prerequisites, Eligibility and Cost
  2. C_HANATEC_10 Practice Quiz

Certification C_HANATEC_10 - Questions and Answers

Question 1: Where in the SAP HANA studio can you change the path of the backup folder? Note: There are 2 correct answers to this question.
  1. global.ini
  2. Backup catalog
  3. Backup editor
  4. executor.ini
Answer A,C
Question 2: You are reviewing the execution plan of an SQL statement. You want to find out which operators have been executed in parallel in the current plan and for how long each of them has been active. How can you accomplish this?
  1. Use the Plan Visualizer in the SAP HANA studio
  2. Use Performance Trace in HDB admin
  3. Use Job Progress in the SAP HANA studio
  4. Use EXPLAIN (graphically) in the DBA Cockpit
Answer A
Question 3: You have SAP HANA and ABAP content that is exclusively used by ABAP for SAP HANA. You want to transport this content together. Which of the following options can you use for this transport? Note: There are 2 correct answers to this question.
  1. SAP HANA Application Lifecycle Manager (SAP HALM)
  2. SAP HANA Transport Container (SAP HTC)
  3. Enhanced Change and Transport System (CTS+)
  4. Export and Import of the Delivery Unit (DU)
Answer B,C
Question 4: Which of the following can you use to analyze an expensive SQL statement? Note: There are 2 correct answers to this question.
  1. The plan explanation
  2. The performance trace view
  3. The hdbcons tool
  4. The plan visualizer
Answer A,D
Question 5: Which combination of authorizations is required for this user?
  1. "USER ADMIN, SERVICE ADMIN, ROLE ADMIN
  2. "USER ADMIN, CREATE STRUCTURED PRIVILEGE, CATALOG READ
  3. "USER ADMIN, CREATE STRUCTURED PRIVILEGE, ROLE ADMIN
  4. "USER ADMIN, SERVICE ADMIN, DATA ADMIN
Answer C
Question 6: Which tasks can you perform using the resident SAP HANA lifecycle management tool? Note: There are 3 correct answers to this question.
  1. Uninstall SAP HANA components
  2. Add additional hosts to the SAP HANA system
  3. Copy an SAP HANA system
  4. Rename the SAP HANA system
Answer A,B,D
Question 7: You need to recover an SAP HANA database. What is a prerequisite?
  1. Use the SAP DBA Cockpit to perform a database recovery
  2. An offline SAP HANA database
  3. Use the SAP HANA cockpit to perform a database recovery
  4. An online SAP HANA database
Answer B
Question 8: What can you do on the Configure Alerts tile in the SAP HANA cockpit? Note: There are 2 correct answers to this question.
  1. Run the checks regardless of their status
  2. Schedule the execution of the checks
  3. Set a threshold value which triggers the check run
  4. Cancel a running check from the list
Answer A,B
Question 9: You plan to install an SAP HANA database in an SAP HANA Tailored Datacenter Integration (TDI) scenario. Which SAP HANA installation tools are required? Note: There are 2 correct answers to this question.
  1. hdbinst
  2. hdbsetup
  3. hdblcmgui
  4. hdblcm
Answer C,D
Question 10: You execute an authorization trace in the SAP HANA studio. Where can you review the outcome?
  1. In the result screen of the trace configuration
  2. In the indexserver trace diagnosis file
  3. In the authorization dependency viewer
  4. In the monitoring view M_SERVICE_TRACES
Answer B


Question 11: Which of the following are functions of the controller on the SAP Landscape Transformation (SLT) server? There are 2 correct answers to this question.
  1. Schedule replication processes
  2. Write data to the SAP HANA system using the DB connection
  3. Create repositories in the source system
  4. Map database structures between SAP HANA and the source system
Answer A,D
Question 12: Which of the following are pre-delivered template roles? There are 2 correct answers to this question.
  1. MONITORING
  2. IMPORT
  3. SAP_INTERNAL_HANA_SUPPORT
  4. MODELING
Answer A,D
Question 13: Which of the following can you use to update SAP HANA?
  1. SAP HANA lifecycle manager
  2. SAP HANA update wizard
  3. SAP HANA on-site configuration tool
  4. Software update manager (SUM) for SAP HANA
Answer A
Question 14: Which of the following must be shared by SAP HANA nodes in a high availability scenario?
  1. Virtual host name
  2. Storage
  3. Shared memory
  4. Network
Answer B
Question 15: What is the minimum required disk space for the data volumes of an SAP HANA system in relation to its memory (RAM)?
  1. 4 * RAM
  2. 3 * RAM
  3. 2 * RAM
  4. 1 * RAM
Answer A
Question 16: 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?
  1. In the SAP HANA studio
  2. In SAP Solution Manager
  3. In the XS engine
  4. In the source system
Answer B
Question 17: What must you configure in Data Services 4.0 to establish a connection to SAP ERP?
  1. A DB connection
  2. A datastore
  3. An RFC connection
  4. An InfoObject
Answer B
Question 18: Which of the following must be installed during the installation of SAP Landscape Transformation (SLT)? There are 2 correct answers to this question.
  1. SAP NetWeaver 7.02 or higher
  2. DMIS add-on to the SAP source system
  3. SAP HANADB libraries to the source system
  4. Java stack for the SLT Server
Answer A,B
Question 19: You are reviewing the execution plan of an SQL statement. You want to find out which plan operators (POPs) have been executed in parallel and for how long each of them has been active. How can you accomplish this?
  1. Use the Visualize Plan functionality in the SAP HANA studio
  2. Use Job Progress in the SAP HANA studio
  3. Use Performance Trace in HDB admin
  4. Use EXPLAIN (graphically) in the DBA Cockpit
Answer A
Question 20: A customer complains about poor performance when they query a column table with 5 billion records. You suspect that this table is partially loaded into memory. Where can you to check the load status of this table? There are 2 correct answers to this question.
  1. On the Runtime Information tab of the table definition
  2. In the M_TABLES view
  3. In the M_CS_TABLES view
  4. In the M_TABLE_PERSISTENCE_LOCATIONS view
Answer A,C
Question 21: Which security settings can you apply in analytic privileges? There are 2 correct answers to this question.
  1. Restrict access to hierarchies
  2. Restrict access within an analytic view using measure values
  3. Restrict access within an analytic view using attribute values
  4. Grant access to analytic views
Answer C,D
Question 22: Which of the following memory indicators can you reset to measure the impact of a new workload on memory usage?
  1. Virtual memory
  2. Used memory
  3. Peak used memory
  4. Resident memory
Answer C
Question 23: Which of the following Kerberos implementations is supported for single sign-on in SAP HANA? There are 2 correct answers to this question.
  1. Red Hat Linux version 4 and later Kerberos implementation
  2. """Advanced Encryption Standard (AES) Encryption for Kerberos 5"" on HP-UX
  3. MIT's Kerberos Network Authentication Protocol
  4. Windows Active Directory Domain Kerberos implementation
Answer C,D
Question 24: A long-running SQL query issued by an SAP NetWeaver work process also seems to use a lot of system resources. How can you find out which ABAP module and which SAP NetWeaver user called the query?
  1. Open Transaction Process Overview (SM50) in the SAP NetWeaver system > Sort the list by CPU time > Select the top entry > Check the User and Report columns
  2. Go to the Performance tab of SAP HANA studio > Check the System load diagram
  3. Open Transaction Global Work Process Overview (SM66) in the SAP NetWeaver system > Sort the list by CPU time > Select the top entry
  4. "In SAP HANA studio, check the session overview > Identify the logical CONNECTION ID for the SAP NetWeaver work process > Check the columns APPLICATIONSOURCE and APPLICATIONUSER
Answer D
Question 25: SAP Support needs to access a customer's SAP HANA studio remotely. Which entry must the client maintain in SAP Service Marketplace?
  1. Preprocessor server
  2. Statistics server
  3. Name server
  4. Master index server
Answer D
Question 26: 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)
  1. By executing the ABAP program :SAPLATRA_TOOL_TIMES in SLT and the SAP ERP system
  2. By comparing the system time of the operating systems in SLT and the SAP ERPsystem
  3. By comparing entries in table TTZCU (Customizing time zones) in SLT and the SAPERP system
  4. By executing the ABAP program :TZCUSTHELP in SLT and the SAP ERP system
Answer B,D
Question 27: You are using the Change and Transport System (CTS) with SAP HANA. When is the transport strategy determined?
  1. When the objects are attached to a transport request in the SAP HANA studio
  2. When the SAP HANA application type is configured in CTS
  3. When the connection to CTS is configured in SAP HANA studio
  4. When the export system is configured in CTS
Answer D
Question 28: Which of the following template roles allows a user who has been assigned this role to grant the privileges of this role to other users?
  1. CONTENT_ADMIN
  2. MODELING
  3. PUBLIC
  4. MONITORING
Answer A
Question 29: An administrator should be enabled to cancel long running commands and end sessions. Which privilege must the user be granted?
  1. SESSION ADMIN
  2. USER ADMIN
  3. RESOURCE ADMIN
  4. MONITOR ADMIN
Answer A
Question 30: Which of the following are characteristics of a design-time role? (Choose two)
  1. It is revoked if the grantee user is deleted
  2. It is transportable between systems
  3. It is granted and revoked directly by an administrator
  4. It is granted through the execution of stored procedures
Answer B,D
Question 31: 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)
  1. 100 GB for the entire system and 200 GB individually for Host A
  2. 50 GB for the entire system and 150 GB individually for Host B
  3. 75 GB for the entire system
  4. 300 GB for the entire system
Answer B,C
Question 32: Which of the following authentication methods are provided by SAP HANA? (Choose two)
  1. Security Assertion Markup Language (SAML)
  2. NTLM
  3. RADIUS
  4. Kerberos
Answer A,D
Question 33: 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?
  1. statsconnect in the trace section
  2. editing in the statisticsserver_general section
  3. active in the statisticsserver_general section
  4. statsserv in the trace section
Answer C
Question 34: Which of the following can be monitored in SAP Solution Manager system monitoring? (Choose three)
  1. Expensive SQL statements
  2. Host level monitoring
  3. User-specific traces
  4. Alert status of SAP HANA internal alerting
Answer B,C,D
Question 35: You need to replicate data from an SAP ERP production system to SAP HANA.Where does SAP recommend that you install the productive SAP Landscape Transformation(SLT) instance?
  1. With the SAP Solution Manager system
  2. On the SAP HANA server
  3. On a dedicated server
  4. With the SAP ERP system
Answer C
Question 36: 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?
  1. Delete older log files from the log volume before the last successful database backup
  2. Set the log_mode parameter to overwrite in global.ini
  3. "Run ""Delete older backups"" in the Backup Catalog
  4. Move the log files to another volume and create a symbolic link to the new folder
Answer D
Question 37: Which of the following SAP HANA tools is used to collect diagnostic information?
  1. landscapeHostConfiguration.py
  2. hdbnsutil
  3. hdbsql
  4. fullSystemInfoDump.py
Answer D
Question 38: 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 theconfiguration? (Choose three)
  1. All applications using the SAP HANA instance must be stopped
  2. User adm is required to remove the SAP HANA XS service
  3. A data backup must be taken after the SAP HANA XS service has been removed
  4. The SAP HANA XS service must be removed from all hosts of the SAP HANA instance
Answer A,C,D
Question 39: Which of the following traces provides information about past SQL query runtime performance including the values of parameters?
  1. Expensive statements trace
  2. Performance trace
  3. User-specific trace
  4. SQL trace
Answer A
Question 40: In the SAP HANA studio, to which of the following does the loading status ""partially"" refer?
  1. To a row store table that is loaded in delta storage
  2. To a column store table that is loaded in delta storage
  3. To a row store table of which only some rows are loaded
  4. To a column store table of which only some columns are loaded
Answer D
Question 41: Which of the following tools can you use to create and manage SAP HANA database users? (Choose two)
  1. SAP Solution Manager
  2. Microsoft Active Directory
  3. SAP Netweaver Identity Management
  4. hdbsql
Answer C,D
Question 42: 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?
  1. SAP_SYSREC_ALL
  2. SAP_SOLAR02_ALL
  3. SAP_SM_ADMIN_COMPONENT_ALL
  4. SAP_SYSTEM_REPOSITORY_ALL
Answer D
Question 43: 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)
  1. By executing the ABAP program :SAPLATRA_TOOL_TIMES in SLT and the SAP ERP system
  2. By comparing the system time of the operating systems in SLT and the SAP ERP system
  3. Bycomparing entries in table TTZCU (Customizing time zones) in SLT and the SAP ERPsystem
  4. By executing the ABAP program :TZCUSTHELP in SLT and the SAP ERP system
Answer B,D



Have you got some more sample questions for this certification? Share those in comment section and help others!

What’s Next?


Challenge yourself! Check how much you can score in the exam - C_HANATEC_10 Practice Quiz


Support us by sharing this article.



Explore More
Close X
Close X

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