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_HANATEC142 - Sample Questions

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

You may also check:
  1. You want to create a user that can do the following: Create test users. Create roles for developers. Assign role-based authorizations to analytic views. Which combination of authorizations is required for this user? Please choose the correct answer.
    1. USER ADMIN, SERVICE ADMIN, DATA ADMIN
    2. USER ADMIN, CREATE STRUCTURED PRIVILEGE, RESOURCE ADMIN
    3. USER ADMIN, CREATE STRUCTURED PRIVILEGE, ROLE ADMIN
    4. USER ADMIN, SERVICE ADMIN, ROLE ADMIN
  2. What is the maximum number of master name servers that you can define in a distributed landscape? Please choose the correct answer.
    1. 3
    2. 1
    3. 8
    4. 2
  3. Which of the following can performed in the SAP HANA lifecycle manager? Note: There are 3 correct answers to this question
    1. Rename an SAP HANA system.
    2. Add an additional SAP HANA system.
    3. Change the SAP HANA license type.
    4. Copy an SAP HANA system.
    5. Uninstall an SAP HANA system.
  4. Which of the following actions are required in the SAP HANA studio to use the Enhanced Change and Transport System (CTS+)? Note: There are 2 correct answers to this question.
    1. Configure the connection to the CTS in the preferences.
    2. Create a delivery unit that contains all of the runtime objects.
    3. Create the HTTP connection named CTSDEPLOY.
    4. Use an authorized user to attach SAP HANA content to transport requests.
  5. Which of the following are pre-delivered template roles? Note: There are 2 correct answers to this question.
    1. SAP_INTERNAL_HANA_SUPPORT
    2. IMPORT
    3. MONITORING
    4. MODELING
  6. 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. executor.ini
    2. global.ini
    3. Backup catalog
    4. Backup editor
  7. A user cannot query an information model because of missing authorizations. What is the fastest way to find out which authorization is missing? Please choose the correct answer.
    1. Use the authorization dependency viewer.
    2. Check the assigned roles in the user editor.
    3. Query the system view EFFECTIVE_PRIVILEGES.
    4. Investigate the authorization trace.
  8. Which of the following update scenarios can be selected for execution in the SAP HANA lifecycle manager? Note: There are 2 correct answers to this question.
    1. Apply support package stacks.
    2. Update SAP HANA replication technology components.
    3. Update the SAP HANA studio on local machines.
    4. Perform automated updates of SAP HANA and SAP HANA components.
  9. Which of the following can you use to analyze an expensive SQL statement? Note: There are 2 correct answers to this question.
    1. Open the hdbcons tool.
    2. Open the SQL Plan Cache.
    3. Open the Plan Visualizer.
    4. Open the Plan Explanation.

Answers:
1 C
2 A
3 A, B, C
4 A, D
5 C, D
6 B, D
7 A
8 A, D
9 C, D
10 D

Reference: https://training.sap.com



Support us by sharing this article.



Explore More
Close X
Close X

7 thoughts on “SAP HANA Certification Sample Questions – C_HANATEC142

  1. Javed Akhter says:

    Hi,

    I am looking lates dump for C_HANATEC142 exam, Please can you send me information.

    Thanks,
    Javed Akhter

  2. Rishi says:

    Can you please provide more Sample questions.

    Regards,
    Rishi

  3. Sunil says:

    Can you please confirm the validity of a HANA Certification
    For example I do not see any more options available on training.sap.com for C_HANATEC141(SPS07) does it mean this certification is no more valid
    In that case what would be validity of C_HANATEC142(SPS08) and the recently introduced C_HANATEC151(SPS09)

    • Admin says:

      Hi Sunil,
      SAP keeps introducing new certification with new HANA SPS. For example C_HANATEC142 was for SPS08. For SPS09, a new certification was introduced C_HANATEC151.

      The contents are more or less similar except the latest certification contains the new topics added in SPS09.

      This is a little tricky. Obviously you cannot do certification every year. But officially there is no expiry period or validation of a certification.
      In my opinion, if you do a certification (say C_HANATEC142 for SPS08), this will still be valuable after SPS09 or SPS10. You just need to update yourself on the latest topic.

  4. Deepak says:

    Hi Sunil,

    According to SAP, the certification will expire after the release of the 4th SPS certification.
    In other words, if you have certified on HANATEC142 SPS08, this certification will expire when the HANATEC161 exam is released.

    Hope this clarifies.

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