Frequently Asked SAP HANA ADMIN Interview Questions For Beginners | SAP Trainings Online

SAP HANA ADMIN training interview questions

1.How do you perform BW-on-HANA Migration?

DMO- Database Migration. This is a new feature available in SUM (Software Update Manager Tool). Learn concepts from SAP BW on HANA training.

2.How many VMs are supported on a single HANA Production System?

Multiple SAP HANA Virtual Machines on a Single server are only supported today in non-production environments. Learn more from SAP HANA Training video classes.

3.What are the different perspectives available in HANA STUDIO?

• Administrator
• Modeler
• Development
• Debug

4.Does HANA/IMDB replace Oracle?

Once the Business Suite keeps running on IMDB, Oracle won’t be required any more by SAP clients who purchase HANA. This doesn’t affect anything in the short term because those people buying HANA today will still need an Oracle ERP system. Join Oracle training from Learn IT Training.

5.Can I just increase the memory of my traditional Oracle database to 2TB and get similar performance?

 NO. You might have performance gains due to more memory available for your current Oracle/Microsoft/Teradata database but HANA is not just a database with bigger RAM.
It is a combination of a lot of hardware and software technologies. The way data is stored and processed by the In-Memory Computing Engine (IMCE) is the true differentiator. Having that data available in RAM is just the icing on the cake.

6. How do you update SAP HANA Studio/Client & HANA Revisions?

Use HDBLCM Tool
1. Stop all processes
2. Make a System Backup if necessary
3. Perform an update
4. Update the depending Components
5. Perform the post update steps
6. Restart all processes

7. If I can run NetWeaver BW on IMDB/HANA, why can’t I run the Business Suite/ERP 6.0?

Just on the grounds that it’s not develop enough yet to bolster business basic applications. From an innovation viewpoint, it is as of now conceivable to maintain the Business Suite on IMDB and SAP has trialed moving some vast databases into IMDB as of now. Want to learn concepts of Netweaver click on SAP Netweaver training.

 

8. Why materialized aggregates are not required in HANA?

Since the SAP HANA database resides entirely in-memory all the time, additional complex calculations, functions and data-intensive operations can happen on the data directly in the database. Hence materialized aggregations are not required.
It also provides benefits like
Simplified data model
Higher level of concurrency
Simplified application logic

9. Mention what are the different compression techniques?

There are three different compression techniques
Run-length encoding
Cluster encoding
Dictionary encoding

10.How does SAP HANA support Massively Parallel Processing?

With availability of Multi-Core CPUs, higher CPU execution speeds can be achieved.
Also HANA Column-based storage makes it easy to execute operations in parallel using multiple processor cores.
In a column store data is already vertically partitioned. This means that operations on different columns can easily be processed in parallel. If multiple columns need to be searched or aggregated, each of these operations can be assigned to a different processor core.
In addition operations on one column can be parallelized by partitioning the column into multiple sections that can be processed by different processor cores. With the SAP HANA database, queries can be executed rapidly and in parallel.

11.What is the main SAP HANA database component?

Index Server consists of actual data engines for data processing including input SQL and MDX statements and performs authentic transactions.

12. List the different compression techniques in HANA?

Run-length encoding
Cluster encoding
Dictionary encoding

13. What is ad hoc analysis?

In traditional data warehouses, such as SAP BW, a lot of pre-aggregation is done for quick results. That is the administrator (IT department) decides which information might be needed for analysis and prepares the result for the end users. This results in fast performance but the end user does not have flexibility.
The performance reduces dramatically if the user wants to do analysis on some data that is not already pre-aggregated. With SAP HANA and its speedy engine, no pre-aggregation is required. The user can perform any kind of operations in their reports and does not have to wait hours to get the data ready for analysis.

14.Which are the top five use cases in SAP HANA?

The top use cases of SAP HANA are:
Real time financial planning
Genome analysis
Customer segmentation
Detective HANA and
Profitability analysis

15.What’s new with SPS09 - Admin Features?

SAP HANA Cockpit - Web-based tool for administration and monitoring of a single SAP HANA Database.
SAP DB Control Center - Web-based tool for administration and monitoring of your landscape of SAP Database.

For any queries regarding concepts related to SAP HANA ADMIN please login to complete course structure: www.learnittraining.com/sap-hana-admin-online-training

Want to excel in SAP HANA ADMIN then register for SAP HANA ADMIN training which is designed virtually interactive:

Register for SAP Training here: http://www.learnittraining.com/student-registration/

For more details..

Visit:  www.learnittraining.com

Email: contact@learnittraining.com

Phone: India +91 9912989639, USA +12108585008