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

HANA Certification C_HANAIMP_11 - Sample Questions

This certification is obsolete. Click here to check the latest version of this certification - C_HANADEV_13.
You may contact us if you have any question.
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_HANAIMP_11 at C_HANAIMP_11 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_HANAIMP_11 Practice Quiz

Certification C_HANAIMP_11 - Questions and Answers

Question 1: When loading data to SAP HANA using SAP Data Services, where can job definitions be stored?
  1. In an SAP HANA XS application
  2. In the SAP HANA studio
  3. In an SAP HANA database
  4. In an SAP HANA flowgraph 2
Answer C
Question 2: In a graphical calculation view of type cube, two tables are joined on multiple columns in a join node. Most queries using the view have no problems, but one query always gets a query runtime error. What is the cause of this error?
  1. The two tables do NOT have referential integrity.
  2. An incorrect column was selected when the join was formed.
  3. The language column is NOT specified in the join.
  4. The two tables are joined with a dynamic join.
Answer D
Question 3: Which SAP HANA studio function displays the views that will be affected when you rename an attribute view?
  1. Neighbor
  2. Where-used list
  3. Properties
  4. Tables used
Answer B
Question 4: You want to reuse a decision table on multiple tables with a similar data structure. You design the decision table that passes a specific table name as an input parameter when you execute the decision table. What do you have to use in the data foundation to achieve this?
  1. A dynamic join
  2. A scripted calculation view
  3. A table type
  4. A virtual table
Answer C
Question 5: You create a graphical calculation view that is consumed in ABAP. What setting in the currency semantics dialog box ensures that a currency column is interpreted correctly in the ABAP layer?
  1. Decimal shift back
  2. Conversion
  3. Rounding
  4. Decimal shift
Answer A
Question 6: What information is available when you use the Explain Plan functionality on an SQL statement? Note: There are 2 correct answers to this question.
  1. Estimated number of records
  2. Estimated execution time
  3. Execution engines
  4. Operator names
Answer C,D
Question 7: Prior to modeling in SAP HANA, you want to check whether a table is row-based or column-based. How can you do this in the SAP HANA studio? Note: There are 2 correct answers to this question.
  1. View the icon of the table
  2. Select the Open Definition option
  3. Select the Open Content option
  4. Select the Open Data Preview option
Answer A,B
Question 8: Modeling package Shops is a subpackage of package Regions. You want to authorize a user to list the content of package Regions, but prevent listing the content of package Shops. How can you achieve this?
  1. Refactor package Shops to another package
  2. Assign REPO.EXPORT only to package Shops
  3. Assign REPO.READ privilege only to package Regions
  4. Revoke analytic privileges for models in package Shops
Answer A
Question 9: You are writing SQLScript code for handling sensitive data. What statement is prone to the SQL injection?
  3. GRANT
  4. EXEC
Answer D
Question 10: You are using the SAP HANA studio. Which of the following SAP HANA modeling artifacts require the SAP HANA application function modeler (AFM) to be installed? Note: There are 3 correct answers to this question.
  1. SAP HANA enterprise information manager (EIM) jobs
  2. SAP HANA smart data streaming (SDS) projects
  3. SAP HANA predictive analytics library (PAL) flows
  4. SAP HANA extended application services (XS) programs
Answer A,B,C

Question 11: Which of the following can you use to implement currency conversion in an information model? (Choose two)
  1. A calculated column in a calculation view
  2. A calculated column in an attribute view
  3. A calculated column in an analytic view
  4. A restricted column in an analytic view
Answer A,C
Question 12: What are characteristics of a constraint filter?
  1. It is defined during the design time on a table
  2. It is applied on a table before the query execution
  3. It is applied on the result set of an SQL query
  4. It is defined during the runtime in the SQL query
Answer A,B
Question 13: Your customer requires real-time replication. Where do you select the tables to be replicated to SAP HANA?
  1. in transaction LTR in SAP Landscape Transformation (SLT)
  2. in the Import dialog of the Quick Launch of SAP HANA studio
  3. in transaction SAP ERP Tables and Indexes Monitor (DB02)
  4. in the Data Provisioning dialog of SAP HANA studio
Answer D
Question 14: Which of the following describes an SAP HANA analytic view?
  1. It is a set of tables joined together in a star schema
  2. It is a copy of data after transformation
  3. It is a reusable object in attribute views
  4. It is a materialized set of data
Answer A
Question 15: Which of the following would you create to ensure the fastest calculation performance?
  1. A calculated measure in an SAP BusinessObjects universe
  2. An input parameter in an SAP HANA information model
  3. A report variable in an SAP BusinessObjects reporting client
  4. A calculated column in an SAP HANA information model
Answer D
Question 16: You want to use an extractor to build a model in SAP HANA. Which table can you use to viewdetailed information about the extractor?
  1. BSEG
Answer C
Question 17: You have to extract entities such as persons, countries, products, and places from business text such as PDF files. Which of the following tools in SAP HANA could you use?
  1. Python-based text analysis scripts
  2. Full-text search Ul toolkit
  3. Application function libraries
  4. Fuzzy search
Answer A
Question 18: Which of the following objects can you use when you build an analytic view? (Choose three)
  1. Attribute Views
  2. Hierarchies
  3. Variables
  4. Analytic Views
Answer A,B,C
Question 19: Which technologies use trigger-based replication?
  1. ABAP extractors
  2. Test Data Migration Server (TDMS)
  3. Standard SQL database replication
  4. Near Zero Downtime
Answer B,D
Question 20: You need to create an SAP HANA data model based on a star schema. Which SAP HANA engine is recommended for analytical purposes?
  1. Calculation engine
  2. OLAP engine
  3. Row store engine
  4. Join engine
Answer B
Question 21: Which of the following are direct outputs of an analytc view? (Choose three)
  1. Hierarchies
  2. Private atributes
  3. Atribute views
  4. Measures
Answer B,C,D
Question 22: When you actvate an analytc view, a column view is created. In which schema is this column view stored?
  1. _SYS_BIC
  2. _SYS_BI
  3. _SYS_REPO
  4. _SYS
Answer A
Question 23: Which of the following SAP data provisioning methods provide complex transformatons? (Choose two)
  1. SAP Data Services
  2. SAP HANA smart data access
  3. SAP Replicaton Server
  4. SAP HANA smart data quality
Answer A,D
Question 24: Which of the following are restrictons of the SAP HANA fat fle upload? (Choose two)
  1. A table must have the same column order as the fat fle when you append data
  2. The upload does not allow to change the column names of new tables
  3. A new table must have a 1:1 mapping between the fat fle columns and the table columns
  4. The upload prevents data type changes when appending data
Answer C,D
Question 25: In an analytc view, you need two diferent logical joins from the data foundaton to an atributeview. The analytc view already contains the atribute view but you have to use the atribute view again. To which of the following do you connect the second join? (Choose two)
  1. To a shared atribute view
  2. To a derived atribute view
  3. To a new instance of the atribute view
  4. To a copy of the atribute view
Answer B,D
Question 26: What must you do to enable currency conversions with a fxed currency in an analytc view?
  1. Set the Enable for Conversion opton
  2. Create a measure with the measure type Simple
  3. Base the target currency on a currency column
  4. Create the target currency using an input parameter
Answer A
Question 27: You create a graphical calculaton view that is based on analytc views.What do you use to combine the data from the analytc views?
  1. Referental join
  2. Projecton node
  3. Aggregaton node
  4. Union
Answer D
Question 28: You want to model customer master data. Which of the following must you select? (Choose two)
  1. Filter
  2. Table
  3. Hierarchy
  4. Key atribute
Answer B,D
Question 29: You modifed an actve analytc view in the SAP HANA studio and saved it without actvatng it.What is the consequence?
  1. The inactve view is not available
  2. "The inactve view is in ""Read Only"" mode
  3. The actve view is not available
  4. "The actve view is in ""Read Only"" mode
Answer D
Question 30: When you actvate a procedure, in which schema is the procedure stored?
  2. _SYS_BIC
  4. _SYS_BI
Answer B
Question 31: You want to create a graphical calculaton view using the SAP HANA studio. Which steps aremandatory for this task? (Choose three)
  1. Defne a projecton
  2. Save and actvate the view
  3. Defne output felds
  4. Choose a data source
Answer B,C,D
Question 32: You have a Web Intelligence report that requires data from SAP HANA fltered for a specifc year. Where do you apply the flter for optmal performance?
  1. In the universe
  2. In the Web Intelligence report
  3. In the analytc view
  4. In the calculaton view using an atribute value variable
Answer C
Question 33: What is the lowest level of granularity you can use in an analytc privilege?
  1. An atribute
  2. A view
  3. An atribute value
  4. A column
Answer C
Question 34: What must you confgure to directly access an SAP HANA analytc view using SAP BusinessObjects Analysis editon for Microsof Office?
  1. RFC connecton
  2. SAP HANA Direct Extractor Connecton (DXC)
  3. Pre-delivered MODELING role
  4. System DSN
Answer D
Question 35: Where can you create a restricted column in a graphical calculation view?
  1. Aggregation node
  2. Join node
  3. Union node
  4. Projection node
Answer A
Question 36: You have 2 SAP HANA systems. You are working in 1 of these systems. Which of the following do you use to read data from and write data to the other, remote SAP HANA system? (Choose two)
  1. SAP HANA smart data access
  2. Remote providers
  3. Virtual column
  4. Virtual table
Answer A,D
Question 37: What does SAP recommend to improve performance of data models in SAP HANA?
  1. Move intensive calculations to the front-end application
  2. Perform calculation before aggregation
  3. Utilize as many different engines as possible
  4. Minimize data transfer between the engines
Answer D
Question 38: You implemented SAP-delivered business content on SAP HANA. When you try to activate the business content the activation fails. What could be a reason for this?
  1. You have not created a calculation view to expose the data to the users
  2. The data has not been loaded into SAP HANA memory yet
  3. The schema mapping was not set up correctly
  4. The import of business content was performed with the _SYS_REPO user
Answer C
Question 39: Which of the following are mandatory to create a decision table? (Choose two)
  1. A condition
  2. An action
  3. ACE function
  4. A parameter
Answer A,B
Question 40: Which of the following can you set up to enable the extraction of data from SAP Business Warehouse (BW) into SAP HANA?
  1. SAP System Landscape Directory (SLD)
  2. SAP BusinessObjects Data Services
  3. Open hub
  4. SAP HANA Direct Extractor Connection (DXC)
Answer B,C,D
Question 41: Which connection type is required from the SAP ERP system to SAP HANA to enable CO- PA side by side scenario?
  1. HTTP connection
  2. JDBC
  3. Secondary database connection
  4. Remote Function Call
Answer C
Question 42: Which of the following steps is required for configuring SAP Landscape Transformation (SLT)?
  1. Define the number of background work processes in SLT
  2. Define an RFC connection from SLT to SAP HANA
  3. Define a DB connection from SLT to the source system
  4. Define the number of jobs to be used for data replication
Answer D
Question 43: Which of the following are included in a rapid-deployment solution (RDS) implemented on SAP HANA? (Choose three)
  1. A step-by-step Configuration Guide
  2. Packages with views and procedures
  3. The SAP HANA database license
  4. A fixed-price consulting project
Answer A,B,D
Question 44: Which of the following must an analytic view contain?
  1. A measure
  2. A calculated measure
  3. A hierarchy
  4. An attribute view
Answer A
Question 45: Which tool do you use for real-time data provisioning into SAP HANA?
  1. SAP Landscape Transformation (SLT)
  2. SAP BusinessObjects Data Federation Administration
  3. SAP BusinessObjects Data Services
  4. SAP Direct Extractor Connection (DXC)
Answer A

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_HANAIMP_11 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