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_12 at C_HANAIMP_12 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_HANAIMP_12 Practice Quiz
C_HANAIMP_12 Questions and Answers
What must you do to enable currency conversions with a fxed currency in an analytc view?
- Set the Enable for Conversion opton
- Create a measure with the measure type Simple
- Base the target currency on a currency column
- Create the target currency using an input parameter
You create a graphical calculaton view that is based on analytc views. What do you use to combine the data from the analytc views?
- Referental join
- Projecton node
- Aggregaton node
You want to model customer master data. Which of the following must you select? (Choose two)
- Key atribute
You modifed an actve analytc view in the SAP HANA studio and saved it without actvatng it. What is the consequence?
- The inactve view is not available
- "The inactve view is in ""Read Only"" mode
- The actve view is not available
- "The actve view is in ""Read Only"" mode
When you actvate a procedure, in which schema is the procedure stored?
You want to create a graphical calculaton view using the SAP HANA studio. Which steps aremandatory for this task? (Choose three)
- Defne a projecton
- Save and actvate the view
- Defne output felds
- Choose a data source
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?
- In the universe
- In the Web Intelligence report
- In the analytc view
- In the calculaton view using an atribute value variable
What is the lowest level of granularity you can use in an analytc privilege?
- An atribute
- A view
- An atribute value
- A column
What must you confgure to directly access an SAP HANA analytc view using SAP BusinessObjects Analysis editon for Microsof Office?
- RFC connecton
- SAP HANA Direct Extractor Connecton (DXC)
- Pre-delivered MODELING role
- System DSN
Where can you create a restricted column in a graphical calculation view?
- Aggregation node
- Join node
- Union node
- Projection node
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)
- SAP HANA smart data access
- Remote providers
- Virtual column
- Virtual table
A,D Question 12:
What does SAP recommend to improve performance of data models in SAP HANA?
- Move intensive calculations to the front-end application
- Perform calculation before aggregation
- Utilize as many different engines as possible
- Minimize data transfer between the engines
D Question 13:
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?
- You have not created a calculation view to expose the data to the users
- The data has not been loaded into SAP HANA memory yet
- The schema mapping was not set up correctly
- The import of business content was performed with the _SYS_REPO user
C Question 14:
Which of the following are mandatory to create a decision table? (Choose two)
- A condition
- An action
- ACE function
- A parameter
A,B Question 15:
Which of the following can you set up to enable the extraction of data from SAP Business Warehouse (BW) into SAP HANA?
- SAP System Landscape Directory (SLD)
- SAP BusinessObjects Data Services
- Open hub
- SAP HANA Direct Extractor Connection (DXC)
B,C,D Question 16:
Which connection type is required from the SAP ERP system to SAP HANA to enable CO- PA side by side scenario?
- HTTP connection
- Secondary database connection
- Remote Function Call
C Question 17:
Which of the following steps is required for configuring SAP Landscape Transformation (SLT)?
- Define the number of background work processes in SLT
- Define an RFC connection from SLT to SAP HANA
- Define a DB connection from SLT to the source system
- Define the number of jobs to be used for data replication
D Question 18:
Which of the following are included in a rapid-deployment solution (RDS) implemented on SAP HANA? (Choose three)
- A step-by-step Configuration Guide
- Packages with views and procedures
- The SAP HANA database license
- A fixed-price consulting project
A,B,D Question 19:
Which of the following must an analytic view contain?
- A measure
- A calculated measure
- A hierarchy
- An attribute view
A Question 20:
Which tool do you use for real-time data provisioning into SAP HANA?
- SAP Landscape Transformation (SLT)
- SAP BusinessObjects Data Federation Administration
- SAP BusinessObjects Data Services
- SAP Direct Extractor Connection (DXC)
Check C_HANAIMP_12 Practice Quiz