SAP EDUCATION
SAMPLE QUESTIONS: C_HANATEC_10
SAP Certified Technology Associate - SAP HANA (Edition 2015)
Disclaimer: These sample questions are for self-evaluation purposes only and do not appear on the actual certification exams.
Answering the sample questions correctly is no guarantee that you will pass the certification exam. The certification exam
covers a much broader spectrum of topics, so do make sure you have familiarized yourself with all topics listed in the exam
competency areas before taking the certification exam.
Questions
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.
a)
O
global.ini
b)
O
Backup catalog
c)
O
Backup editor
d)
O
executor.ini
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?
Please choose the correct answer.
a)
O
Use the Plan Visualizer in the SAP HANA studio.
b)
O
Use Performance Trace in HDB admin.
c)
O
Use Job Progress in the SAP HANA studio.
d)
O
Use EXPLAIN (graphically) in the DBA Cockpit.
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.
a)
O
SAP HANA Application Lifecycle Manager (SAP HALM)
b)
O
SAP HANA Transport Container (SAP HTC)
c)
O
Enhanced Change and Transport System (CTS+)
d)
O
Export and Import of the Delivery Unit (DU)
4. Which of the following can you use to analyze an expensive SQL statement?
Note: There are 2 correct answers to this question.
a)
O
The plan explanation
b)
O
The performance trace view
c)
O
The hdbcons tool
d)
O
The plan visualizer
5. Which combination of authorizations is required for this user?
Please choose the correct answer.
a)
O
USER ADMIN, SERVICE ADMIN, ROLE ADMIN
b)
O
USER ADMIN, CREATE STRUCTURED PRIVILEGE, CATALOG READ
c)
O
USER ADMIN, CREATE STRUCTURED PRIVILEGE, ROLE ADMIN
d)
O
USER ADMIN, SERVICE ADMIN, DATA ADMIN
6. Which tasks can you perform using the resident SAP HANA lifecycle management tool?
Note: There are 3 correct answers to this question.
a)
O
Uninstall SAP HANA components.
b)
O
Add additional hosts to the SAP HANA system.
c)
O
Copy an SAP HANA system.
d)
O
Change the license of the SAP HANA system.
e)
O
Rename the SAP HANA system.
7. You need to recover an SAP HANA database.
What is a prerequisite?
Please choose the correct answer.
a)
O
Use the SAP DBA Cockpit to perform a database recovery.
b)
O
An offline SAP HANA database
c)
O
Use the SAP HANA cockpit to perform a database recovery.
d)
O
An online SAP HANA database
8. What can you do on the Configure Alerts tile in the SAP HANA cockpit?
Note: There are 2 correct answers to this question.
a)
O
Run the checks regardless of their status.
b)
O
Schedule the execution of the checks.
c)
O
Set a threshold value which triggers the check run.
d)
O
Cancel a running check from the list.
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.
a)
O
hdbinst
b)
O
hdbsetup
c)
O
hdblcmgui
d)
O
hdblcm
10. You execute an authorization trace in the SAP HANA studio.
Where can you review the outcome?
Please choose the correct answer.
a)
O
In the result screen of the trace configuration.
b)
O
In the indexserver trace diagnosis file.
c)
O
In the authorization dependency viewer.
d)
O
In the monitoring view M_SERVICE_TRACES.
Solutions
1 a) Correct
2 a) Correct
3 a) Incorrect
4 a) Correct
1 b) Incorrect
2 b) Incorrect
3 b) Correct
4 b) Incorrect
1 c) Correct
2 c) Incorrect
3 c) Correct
4 c) Incorrect
1 d) Incorrect
2 d) Incorrect
3 d) Incorrect
4 d) Correct
6 a) Correct
7 a) Incorrect
8 a) Correct
9 a) Incorrect
10 a) Incorrect
6 b) Correct
7 b) Correct
8 b) Correct
9 b) Incorrect
10 b) Correct
6 c) Incorrect
7 c) Incorrect
8 c) Incorrect
9 c) Correct
10 c) Incorrect
6 d) Incorrect
7 d) Incorrect
8 d) Incorrect
9 d) Correct
10 d) Incorrect
6 e) Correct
Want to learn more?
Contact SAP for more information.