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

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

You may also check:
  1. You want to repeatedly load data from a flat file into SAP HANA with SAP Data Services. The target table is not available in SAP HANA and must be recreated with every scheduled data load. The structure of the target table is identical to the structure of the source table. Which of the following steps must you perform? Note: There are 3 correct answers to this question.

  1. Enter the table name and schema name.
  2. Import metadata of the target table from the SAP HANA datastore.
  3. Drop a template table into the data flow.
  4. Map the source structure to the template table.
  5. Create a table in the SAP HANA studio.

  1. What are characteristics of a constraint filter? Note: There are 2 correct answers to this question.

  1. It is applied on a table before the query execution.
  2. It is applied on the result set of an SQL query.
  3. It is defined during the design time on a table.
  4. It is defined during the runtime in the SQL query.

  1. Which connection type is required from the SAP ERP system to SAP HANA to enable a CO-PA side-byside scenario? Please choose the correct answer

  1. Secondary database connection
  2. JDBC
  3. HTTP connection
  4. Remote Function Call

  1. You want to create a customer segmentation on your SAP HANA data. Which of the following do you use? Please choose the correct answer.

  1. RODBC library
  2. SAP HANA Business Function Library
  3. SAPUI5 runtime library
  4. SAP HANA Predictive Analysis Library

  1. Two attribute views in the same analytic view contain the same column name: the ID from the Customer attribute view and the ID from the Product attribute view. In the output, the system automatically renamed one column to ID_1. You want to indicate that ID_1 originated from the Product attribute view by renaming it to ID_PRODUCT. Where in the attribute properties of ID_1 can you change this? Note: There are 2 correct answers to this question.
    1. In the alias label
    2. In the label
    3. In the alias name
    4. In the name

  1. You have a replicated an SAP ERP transaction table that contains a language field and a text table containing descriptions in various languages. You create an attribute view by joining these two tables using a text join. As which of the following join types does the text join act in this context? Please choose the correct answer.

  1. Referential join
  2. Inner join
  3. Left outer join
  4. Right outer join

  1. Which of the following describe an SAP HANA attribute view?  Note: There are 3 correct answers to this question.

  1. It is a persistent store of data.
  2. It is a reusable object in analytic views.
  3. It is a copy of data after transformation.
  4. It is a set of tables joined together.
  5. It is a reusable object in calculation views.

  1. Which CE function do you use to implement an inner join between two tables on a list of join attributes? Please choose the correct answer.

  1. CE_COLUMN_TABLE
  2. CE_JOIN_VIEW
  3. CE_OLAP_VIEW
  4. CE_JOIN

  1. You have created several information models. A colleague has to create new tables in the existing schema and extend your information models. Which privileges do you give to your colleague? Note: There are 2 correct answers to this question.

  1. System privileges
  2. Analytic privileges
  3. Package privileges
  4. Object privileges
Answers:
1 A, C, D
2 A, C
3 A
4 D
5 A, C
6 C
7 B, D, E
8 D
9 C, D

Reference: https://training.sap.com


Support us by sharing this article.



Explore More
Close X
Close X

2 thoughts on “SAP HANA Certification Sample Questions and Dumps – C_HANAIMP142

  1. MoonHui.Kim says:

    please sample question or dumps ~~ ^^ thank you.

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