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_HANAIMP151 at C_HANAIMP151 Overview.
Now let us see what kind of questions you can expect in this certification.
We highly recommend you to also check below articles:
How to book SAP Certification - Prerequisites, Eligibility and Cost
C_HANAIMP151 Practice Quiz
C_HANAIMP151 Questions and Answers
What does SAP HANA smart data integration use for data provisioning? Note: There are 3 correct answers to this question.
- SAP HANA smart data access
- SAP HANA smart data streaming
- Real-time adapters
- Database logs
Which of the following SAP data provisioning methods provide complex transformations? Note: There are 2 correct answers to this question.
- SAP Data Services
- SAP HANA smart data access
- SAP Replication Server
- SAP HANA smart data quality
When loading data into SAP HANA, which of the following tasks can you perform using SAP Data Services?
- Replicate data using database triggers
- Read data from SAP ERP using the embedded SAP BW system
- Replicate data by reading database logs
- Read data from SAP ERP using ABAP data flows
How does SAP recommend modeling a view that contains actual measures from one fact table and planned measures from another fact table?
- Create one analytic view for each of the fact tables and create a calculation view that implements a union over both Analytic views
- Create one attribute view for each of the fact tables and create an analytic view that implements a union over both attribute views
- Create one analytic view for each of the fact tables and create a calculation view that implements a join over both analytic views
- Create one attribute view for each of the fact tables and create a calculation view that implements a join over both attribute views
Which of the following can you use as sources for the vocabulary in a decision table? Note: There are 3 correct answers to this question.
- Calculation views
- Table types
- OData models
- Physical tables
With which of the following do you build the vocabulary of a decision table?
When working with your data models, which of the following do you use to get detailed information about tables, number of rows, and partitioning? Note: There are 2 correct answers to this question.
- Performance analysis mode
- Catalog node of your system
- Visualize plan
- Explain plan
Which package privileges are required to extend an SAP HANA Live view? Note: There are 3 correct answers to this question.
In which order are views consumed by the SAP HANA Live virtual data model?
- 1. Reuse 2.Private 3. Query
- 1. Query 2.Reuse 3.Private
- 1. Reuse 2.Query 3.Private
- 1. Query 2.Private 3. Reuse
For which SAP HANA data types is a FULLTEXT index created automatically during table creation? Note: There are 2 correct answers to this question.
On which of the following servers can you configure SAP HANA Direct Extractor Connection (DXC) data sources? (Choose two)
- SAP Business Warehouse server
- SAP BusinessObjects Data Services server
- SAP HANA server
- SAP ECC server
A,D Question 12:
Which of the following are characteristics of SAP NetWeaver Business Warehouse (SAP BW) when migrating it to run on SAP HANA? (Choose three)
- The sizing of your current SAP BW application servers remains valid
- It allows co-deployment of the SAP BW application server on the SAP HANA database hardware
- It allows re-use of your available SAP BW application servers
- The system usage is the same as an equivalent SAP BW on non-SAP databases.
A,C,D Question 13:
Which of the following automatically aggregates data? (Choose two)
- Analytic view
- Calculation view
- Column table
- Attribute view
A,B Question 14:
Which of the following must you do in order to use SAP BusinessObjects Explorer on SAP HANA data? (Choose two)
- Create a delivery unit
- Create a business layer
- Create an information model
- Create an information space
C,D Question 15:
Using SAP BusinessObjects Data Services, in which of the following can you perform data transformations? (Choose two)
- XML File
A,D Question 16:
Which of the following can be grouped when multiple schemas exist in an SAP HANA database?
- Information models
- Data tables
B Question 17:
Which feature is supported by the backup and recovery process within the standard delivery of SAP HANA?
- Incremental backup
- Information model recovery
- Point-in-time recovery
- Automatic backup of archiving log files scheduled within SAP HANA
C Question 18:
Which of the following objects would SAP HANA identify as the left object of a join in the graphical calculation view?
- The object that has its field identified first in the join output
- The object that is displayed on the left hand side in the join details panel
- The object that is connected to the join node first
- The object that is displayed on the left hand side in the graphical calculation view
C Question 19:
What is the purpose of a template table in SAP BusinessObjects Data Services?
- To create pre-designed information models
- To fill an existing target table with new data
- To read source data and perform data transformations
- To create a target table and fill this table with data
D Question 20:
Which of the following are benefits of using accelerators with SAP HANA? (Choose two)
- They provide pre-built business content
- They provide pre-built customer-specific solutions
- They reduce the time required for implementation
- They eliminate the need for customization
Check C_HANAIMP151 Practice Quiz