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
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
Hadoop App
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
SAP BW/4HANA Certifications
Expired Certifications

SAP Certified Technology Associate - SAP HANA 2.0 - Questions and Answers

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_13 at C_HANATEC_13 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_13 Practice Quiz

Certification C_HANATEC_13 - Questions and Answers

Question 1: You created data and log backups on the file system. Due to a hardware failure, you use the Recover Database app in SAP HANA cockpit 2.0 to recover the crashed SAP HANA database. From which location does the Recover Database app read the recovery information by default?
  1. $(DIR_INSTANCE)/../global/hdb/custom/config
  2. $(DIR_INSTANCE)/backup/log
  3. $(DIR_INSTANCE)//trace
  4. $(DIR_INSTANCE)/backup/data
Answer B
Question 2: What can you do to shorten the startup time of an SAP HANA system after a reboot?
  1. Set the preload column value in the Tables system table to FULL.
  2. Flag all columnar tables for preload.
  3. Set the savepoint interval to a lower value.
  4. Partition the row store across nodes
Answer C
Question 3: Which of the following traces is active after the SAP HANA installation is completed?
  1. SQL
  2. Plan
  3. Performance
  4. Database
Answer D
Question 4: Which prerequisites must be met to set up high availability for a distributed SAP HANA system? Note: There are 2 correct answers to this question.
  1. The column tables were assigned to an index server manually.
  2. The name server is started on all nodes.
  3. The synchronized backup savepoint is set.
  4. The shared storage is connected to every host.
Answer B,D
Question 5: Which security settings can you monitor in SAP HANA cockpit 2.0? Note: There are 2 correct answers to this question.
  1. Data Storage Security
  2. Password Policy
  3. Manage Database Backups
  4. Manage Users
Answer A,B
Question 6: You are monitoring the application server of an SAP S/4 HANA system. You need to investigate on the SAP HANA database, but someone locked your personal SAP HANA user. Which tools can you use to execute an SQL query? Note: There are 2 correct answers to this question.
  1. SQL Command Editor of the DBA Cockpit on the application server
  2. SAP HANA studio on the SAP HANA server
  3. HDBSQL command line tool on the SAP HANA server
  4. SAP HANA cockpit 2.0 on a central server
Answer A,D
Question 7: Which tasks must you perform to convert a single database to a multitenant database system? Note: There are 2 correct answers to this question.
  1. Set the password for the system database user.
  2. Trigger the conversion in the SAP HANA cockpit 2.0.
  3. Generate the system database before the conversion.
  4. Create an operating system user for the converted tenant database.
Answer A,B
Question 8: You implement a multi-host SAP HANA system with auto-failover capabilities. What are the requirements for the disk storage? Note: There are 2 correct answers to this question.
  1. The slave node is set to backup standby.
  2. The failed worker host gets fenced during failover.
  3. The standby host has file access.
  4. The master node is fully clustered.
Answer B,C
Question 9: You need to enable single sign-on for SAP HANA with Microsoft Active Directory. Which authentication method allows you to use the Active Directory groups?
  1. X.509 client certificates
  2. Security Assertion Markup Language (SAML)
  3. SAP Logon and assertion tickets
  4. Kerberos
Answer D
Question 10: Your customer sets up an SAP HANA system as tailored datacenter integration (TDI) deployment. What are the enterprise network requirements? Note: There are 2 correct answers to this question.
  1. 8 GbE storage area
  2. 4 GbE fiber channel
  3. 15 GbE internode
  4. 10 GbE backup
Answer C,D

Question 11: On which tile can you monitor the operation mode of the SAP HANA cockpit?
  1. System Replication
  2. Database Status
  3. General Information
  4. Latest Alerts
Answer A
Question 12: Which of the following tools can you use to create and manage SAP HANA databaseusers?Note: There are 2 correct answers to this question.
  1. SAP Solution Manager
  2. SAP Identity Management
  3. SAP Web IDE
  4. Microsoft Active Directory
Answer B,C
Question 13: By default all authentication mechanisms are enabled, but it is possible andrecommended to disable those that are not used in your environment. Which of thefollowing methods helps you to change default parameter?Please choose the correct answer.
  1. configuring the parameter [authentication] authentication_methods in theglobal.ini configuration file
  2. configuring the parameter [global] authentication_methods in the global.iniconfiguration file
  3. configuring the parameter [authentication] global_methods in the global.iniconfiguration file
  4. configuring the parameter [authentication] authentication_methods in theauthentication.ini configuration file
Answer A
Question 14: For one-step logon to the system on the PARMA host with instance number 01 asdatabase user MONA with the password RED, which of the following commandhelps?Please choose the correct answer
  1. hdbsql -n PARMA -i 1 -u MONA -p RED
  2. hdbsql -n PARMA -p 1 -u MONA -i RED
  3. hdbsql -i PARMA -n 1 -u MONA -p RED
  4. hdbsql -p PARMA -i 1 -u MONA -n RED
Answer A
Question 15: You want to analyse the root cause of a query that is performing poorly. What doe SAP recommend that you use in the SAP HANA studio?
  1. The Database trace
  2. The expensive statement trace
  3. The Visualize plan functionality
  4. The prepare statement functionality
Answer C
Question 16: What can you do in both the SAP HANA studio and the DBA Cockpit? Note: There are 3 correct answers to this question.
  1. View the tables in the _SYS-STATISTICS schema.
  2. Recover a system
  3. Monitor an SQLDBC trace
  4. Display the status of database resources
Answer A,C,D
Question 17: What is the correct hierarchy of the SAP HANA component model?
  1. Product -> Package -> Delivery Unit -> Object
  2. Package -> Product -> Delivery Unit -> Object
  3. Delivery Unit -> Product -> Package -> Object
  4. Product -> Delivery Unit -> Package -> Object
Answer D
Question 18: You plan to migrate a non-SAP database to SAP HANA using the Database Migration Option of the Software Update Manager SP16. Which URL should you use?
  1. http://<host>:<port>/lmsl/sumabap/<SID>/doc/sluigui
  2. http://<host>:<port>/lmsl/HDBLCM/<SID>/index.html
  3. http://<host>:<port>/lmsl/upgrade/<SID>/doc/gui
  4. http://<host>:<port>/lmsl/sumabap/<SID>/doc/gui
Answer A
Question 19: You are using SAP Solution Manager to troubleshoot your SAP HANA database. What can you analyze? There are 3 correct answers to this question.
  1. Memory usage
  2. Linux system logs
  3. Alert status
  4. Services availability
Answer A,C,D
Question 20: Which role do you need to have assigned to configure the kernel profiler?
  3. sap.hana.xs.lm.roles::Administrator
  4. sap.hana.admin.roles::Monitoring
Answer B

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_13 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 :, All rights reserved.  Privacy Policy