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

SAP HANA Certification C_HANATEC_12 - 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_12 at C_HANATEC_12 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_12 Practice Quiz

Certification C_HANATEC_12 - Questions and Answers

Question 1: To which roles must you be assigned in the SAP HANA cockpit to plan SAP HANAbackups?Note: There are 2 correct answers to this question.
  1. sap.hana.xs.admin.roles::JobSchedulerAdministrator
  2. sap.hana.ide.roles::SecurityAdmin
  3. sap.hana.backup.roles::Scheduler
  4. sap.hana.xs.admin.roles::JobAdministrator
Answer A,C
Question 2: 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 3: What happens when you start the SAP HANA database?Note: There are 2 correct answers to this question.
  1. For the ROW tables, the secondary indexes are created during load.
  2. For the COLUMN tables, the primary indexes are created during load.
  3. The ROW store is completely loaded into the memory.
  4. The COLUMN store is completely loaded into the memory.
Answer A,C
Question 4: 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 5: During encryption key management, SAP HANA generates unique root keys oninstallation. Which of the following root keys can be changed?There are 2 correct answers to this question
  1. Instance SSFS master key
  2. System volume SSFS master key
  3. Data volume encryption root key
  4. Data PKI service root key
Answer A,D
Question 6: Authorization grants access to application resources and services based on thedefined user permissions. Which of the following combinations are true regardinguser type and role/role collections?There are 2 correct answers to this question
  1. Administrator Developer ? XS_CONTROLLER_USER role collection
  2. Administrator ? A role collection containing the XS_Administrator role template
  3. Developer ? A role collection containing the WebIDE_Developer
  4. Administrator Developer ? WebIDE_CONTROLLER_USER role collection
Answer A,C
Question 7: Trace files are used to troubleshoot problems in the SAP HANA database, which ofthe following Trace types helps to generate Trace files through its activation?There are 3 correct answers to this question
  1. SQL trace
  2. Database trace
  3. Performance trace
  4. Security trace
Answer A,B,C
Question 8: 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 9: 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 10: In SAP HANA supports recovery measures from failures, which of the followingoptions are not valid for disaster recovery support?There are 2 correct answers to this question
  1. Backups
  2. Storage replication
  3. Service auto-restart
  4. Host auto-failover
Answer A,B


Question 11: For which activities do you use the diagnosis mode of the SAP HANa studio? Note: There are 2 correct answers
  1. To change the configuration files when the system is down
  2. To analyse problems during database startup
  3. To view memory usage during database startup
  4. To view diagnosis files when the system is down
Answer A,C
Question 12: 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 13: 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 14: You have to load data in real time from external systems into SAP HANA. Which Data Provisioning tools can you use? There are 3 correct answers to this question.
  1. SAP LT Replication Server (SLT)
  2. Smart Data Access (SDA)
  3. SAP Replication Server (SRS)
  4. Smart Data Integration (SDI)
Answer A,C,D
Question 15: Your customer is performing a full data backup every week and a delta backup daily. You need to implement the shortest recovery method for an SAP HANA database. Which recovery order is the fastest? Please choose the correct answer.
  1. 1. Full data backup - 2. Log backup - 3. Incremental backup
  2. 1. Full data backup - 2. Incremental backup - 3. Log backup
  3. 1. Full data backup - 2. Differential backup - 3. Log backup
  4. 1. Full data backup - 2. Log backup - 3. Differential backup
Answer C
Question 16: 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 17: You are setting up a disaster recovery system using system replication. You want the transaction processing of the primary system to be suspended if the network to the secondary system fails. What log replication mode must you use?
  1. async
  2. syncmem
  3. sync
  4. full sync
Answer D
Question 18: You are planning a batch installation for a scale-out system. Which settings do you need to make in the configuration file? There are 2 correct answers to this question.
  1. he instances on all hosts must use an identical instance number.
  2. The user ID of the <sid>adm user must be identical on all hosts.
  3. The max_mem parameter must be specified for the sum of all hosts
  4. The hostname specified must be identical on all hosts.
Answer A,B
Question 19: Which of the following tools can you use to create and manage SAP HANA database users? 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 20: What privileges can you manage with the SAP HANA Live authorization assistant? There are 2 correct answers to this question.
  1. Analytical
  2. Application
  3. System
  4. Object
Answer A,D
Question 21: 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 22: 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 23: Which role do you need to have assigned to configure the kernel profiler?
  1. MONITORING
  2. SAP_INTERNAL_HANA_SUPPORT
  3. sap.hana.xs.lm.roles::Administrator
  4. sap.hana.admin.roles::Monitoring
Answer B
Question 24: Your customer has security restrictions which prohibit direct SQL connections from you pc to the productive SAP HANA system. Which tool do you use to monitor the system alerts of the SAP HANA database from you PC? Note : There are 2 correct answers.
  1. DBA Cockpit
  2. SAP HANA cockpit
  3. SAP HANA studio
  4. HDBSQL command line tool
Answer A,C
Question 25: Which services must be configures and running on the SAP HANA server to monitor the SAP HANA instance in SAP solution Manager? Note: There are 2 correct answers.
  1. SMD Agent
  2. Backup Agent
  3. Host Agent
  4. SDI Agent
Answer A,C



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_12 Practice Quiz


Support us by sharing this article.



Explore More
Close X
Close X

SAP HANA Certification C_HANATEC_12 – Questions and Answers

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