Get 50+ SAP BW on HANA Interview Questions and Answers

Last updated on 14th Nov 2021, Blog, Interview Questions

If you’re looking for SAP BW on Hana Interview Questions & Answers for Experienced & Freshers, you are in right place. There are a lot of opportunities from many reputed companies in the world. According to research SAP BW on Hana has a market share of about 22.2%. So, You still have the opportunity to move ahead in your career in SAP BW on Hana. ACTE offers advanced SAP BW on Hana Interview Questions 2021 that helps you in cracking your interview & acquire a dream career as SAP BW on Hana Developer.

1. Explain the SAP HANA- Architecture?

Ans:

2. what is SAP HANA?

Ans:

SAP HANA stands for High Performance Analytical Appliance- in-memory computing engine. HANA is linked to ERP systems; Frontend modeling studio can be used for replication server management and load control.

3. What is SAP HANA optimized planning?

Ans:

he SAP HANA-optimized InfoCube is a standard InfoCube that is optimized for use with SAP HANA. When you create SAP HANA-optimized InfoCubes, you can assign characteristics and key figures to dimensions. The system does not create any dimension tables apart from the package dimension however.

4. What are the different perspectives in SAP HANA Studio?

Ans:

The SAP HANA Studio contains different perspectives which we can choose to work on. Some commonly used perspectives are:
• SAP HANA Administration Console
• SAP HANA Modeler
• Application Development
• Lifecycle Management
• SAP HANA Development
• ABAP
• BW Modeling

5. what is the role of the persistence layer in SAP HANA?

Ans:

SAP HANA has an in-memory computing engine and access the data straightaway without any backup. To avoid the risk of losing data in case of hardware failure or power cutoff, persistence layer comes as a savior and stores all the data in the hard drive which is not volatile.

6. What is a Data Warehouse Mixed Architecture?

Ans:

It’s an SAP best practice for modern data warehousing. Simply put, it’s a data model that is implemented at the same time in SAP BW and native SAP HANA.

7. Explain the Use of SAP BW Analytical Engine?

Ans:

8. What is data flow in BW/BI?

Ans:

Data flows from a transactional system to the analytical system (BW). DS ( Data Service) on the transactional system needs to be replicated on B side and attached to infosource and update rules respectively.

9. What is the Use of lean and dedicated layers in BW/4HANA?

Ans:

A lean Architecture needs Dynamic Models, LSA++ (Layered Scalable Architecture) for SAP BW/4HANA and SAP BW powered by HANA, Dynamic Dimensional.

10. What is a source system?

Ans:

Any system that is sending data to BW like R/3, lat file, oracle database, or external systems.

11. How would you optimize the dimension in BW?

Ans:

A dimension in BW is a collection of reference information about a measurable event in data warehousing. In this context, events are known as “facts”. For example, a customer dimension’s attributes could include first and last name, gender, birth date etc. To optimize the dimensions, do not add most dynamic characteristics into the same dimension and make the dimension smaller. Also, define as many dimensions as possible, and the dimension should not exceed 20% of the fact table size.

12. Mention the Key Components of SAP BI System?

Ans:

13. What is ODS (Operational Data Store)?

Ans:

‘Operational Data Store’ or ‘ODS’ is used for detailed storage of data. It is a BW architectural component that appears between PSA ( Persistent Staging Area) and infocubes, it allows BEX (Business Explorer) reporting. It is primarily used for detail reporting rather than dimensional analysis, and it is not based on the star schema. ODS (Operational Data Store) objects do not aggregate data as infocubes do. To load the data into an IDS object, new records are inserted, existing records are updated, or old records are deleted as specified by RECORDMODE value.

14. What is Visual BI Document Management for SAP Lumira?

Ans:

Visual BI’s Document Management for SAP Lumira is a small service that integrates with the SAP BusinessObjects platform

15. what is the advantage of SLT replication?

Ans:

SAP SLT works on trigger based approach; such approach has no measurable performance impact in the source system

• It offers filtering capability and transformation
• It enables real-time data replication, replicating only related data into HANA from non-SAP and SAP source systems
• It is fully integrated with HANA studios
• Replication from several source systems to one HANA system is allowed, also from one source system to multiple HANA systems is allowed.

16. Explain the SAP Profitability and Performance Management?

Ans:

17. what is the role of master controller job in SAP HANA?

Ans:

The job is arranged on demand and is responsible for

• Creating database triggers and logging table into the source system
• Creating Synonyms
• Writing new entries in admin tables in SLT server when a table is replicated/loaded.

18. What is Data Integration with SAP BW/4HANA?

Ans:

BryteFlow for SAP is a completely automated SAP data integration tool that extracts SAP data from silos and replicates SAP data to your cloud data warehouse, data lake, or operational data store including AWS and Azure in real-time.

19. Name various components of SAP HANA?

Ans:

• SAP HANA DB
• SAP HANA Studio
• SAP HANA Appliance
• SAP HANA Application Cloud

20. What’s the Difference Between a Classic #SAPBW and #BWonHANA?

Ans:

21. what is the relation between BW-IP and the planning applications kit?

Ans:

22. What are the steps to load a noncumulative cube?

Ans:

• initialize opening balance in R/3 (S278)
• activate extract structure MCO3BFO for data source 2LIS_03_BF
• set up historical material documents in R/3
• load opening balance using data source 2LIS_40_S278
• load historical movements and compress without marker update.
• set up V3 update
• load deltas using 2LIS_03_BF.

23. What are the types of attributes?

Ans:

Display only and navigational; display only attributes are only for display and no analysis can be done; navigational attributes behave like regular characteristics; for example, assume that we have customer characteristics with the country as a navigational attribute; you can analyze the data using customer and country.

24. what is SAP Business Planning and Consolidation?

Ans:

25. What is the time distribution option in the update rule?

Ans:

This is to distribute data according to time; for example, if the source contains calendar week and the target contains calendar day, the data is a spit for each calendar day. Here you can select either the normal calendar or the factory calendar.

26. What is Agile Data Modeling with SAP BW/4 HANA?

Ans:

Modeling refers to an activity of refining or slicing data in database tables by creating information views that depict a business scenario. You can use these information views for any reporting and decision making purposes.

27.What is global transfer, Nile?

Ans:

This is a transfer routine (ABAP) defined at the info object level; this is common for all source systems.

28. Explain the Migration of S/4HANA applications?

Ans:

29.What is technically contained in the appliance ?

Ans:

The appliance consists of four virtual machines that are automatically bundled into one solution instance:

• SAP S/4HANA (the core ABAP backend incl. the SAP HANA database)
• SAP NW JAVA with Adobe Document Services (for forms and output management)
• An SAP BusinessObjects BI Platform
• MS Windows remote desktop for easy access to the solution

30.Mention the Deployment options for BW ?

Ans:

SAP BW/4HANA can be deployed via managed cloud offerings such as SAP HANA Enterprise Cloud (HEC), Amazon Web Services (AWS), Google Cloud Platform (GCP) or Microsoft Azure

31.How to use an appliance?

Ans:

An appliance can be consumed in two ways:

• Within 1-2 hours in a hosted environment, using a cloud provider infrastructure such as Amazon Web Services (AWS), Microsoft Azure, or Google Cloud Platform (GCP).
• Within typically ~ 2-3 days on your own on-premise hardware that has a supported Linux release installed (everything else will come with the appliance).

32.What is the content & scope ?

Ans:

The scope of the appliance centers around the SAP Best Practices content for SAP S/4HANA and is enhanced by further scenarios, also depending on the exact release version of the appliance.

33.what is the Linux operating system?

Ans:

• Overview Pages
• Sell from stock / outbound delivery processing
• Accounting & Financial Close
• Lease-in accounting
• Investments
• Universal Allocation
• Bank account management
• Overdue receivables
• Group Reporting

34.Data Tiering Optimization with SAP BW/4HANA?

Ans:

SAP customers running larger Hana databases frequently ask Microsoft what technologies are supported on Azure to reduce the Hana memory footprint. SAP Hana Database by its design creates a hard dependency on physical memory and SAP Applications by their design create ever increasing Database sizes. These two competing design principles create challenges for large customers.

35. Explain the Data lifecycle management in BW/4HANA?

Ans:

36.What is Data volume performance in BW/4HANA?

Ans:

Data and logs of a system are stored in volumes. … SAP HANA persists in-memory data by using savepoints. Each SAP HANA service has its own separate savepoints. During a savepoint operation, the SAP HANA database flushes all changed data from memory to the data volumes.

37. What is SAP applications and non-SAP RDBMS system?

Ans:

SAP administers ERP software which integrates various business processes and functional areas including: manufacturing, sales, inventory control, finance and human resources. … Any computer which has SAP software installed on it is called an SAP system. Computers which don’t have SAP software are non-SAP systems

38.BODS – Object Hierarchy?

Ans:

All the objects are hierarchical in nature.

• Properties − They are used to describe an object and do not affect its operation.
• Example − Name of an object, Date when it is created, etc.
• Options − Which control the operation of objects.

39.What are BODS – Tools and Functions?

Ans:

Based on the architecture illustrated below, we have many tools defined in SAP Business Objects Data Services. Each tool has its own function as per system landscape.

40.Explain the SUSE Linux 12 sp3 for SAP applications?

Ans:

41.The following steps are performed on AWS?

Ans:

• Now use the latest snapshot which was replicated from the on-premises FlashArray. We apply this latest snapshot on to the SAP HANA data volume.
• After we apply the snapshot, we start the recovery process for the SAP HANA instance on EC2. Remember this is an SAP HANA 2.0 Multi-tenant system. This means we need to first recover the System database and then the tenant database. Please refer to my other blog which explains the whole process in detail for the recovery of an SAP HANA 2.0 multi-tenant system.

42.The performed on the on-premises S/HANA system?

Ans:

• The Cloud Block Store on AWS is connected to the on-premises FlashArray as an asynchronous-replication target.
• We have a protection group for this on-premises SAP HANA’s data volume. This protection group is configured to replicate to Cloud Block Store.
• Now we take an application-consistent snapshot of the on-premises SAP HANA system. We put SAP HANA in create snapshot mode (Back up mode) and then we freeze the data volume’s file system to an application-consistent snapshot. Then we unfreeze the file system and close the SAP HANA backup mode. Please refer to my other blog which explains the whole process in detail for backing up an SAP HANA 2.0 multi-tenant system.

43.What is HANA SQL DW with Smart Data Integration?

Ans:

SAP HANA smart data integration and SAP HANA smart data quality load data, in batch or real-time, into HANA (on premise or in the cloud) from a variety of sources using pre-built and custom adapters. … However, the data provisioning agent needs to be hosted on an Intel machine. It is possible to connect between the two.

44.When and why would you extract from ABAP to the SQL DW?

Ans:

The SAP HANA SQL DW provides you with a complete DW toolset in line with the SQL approach. SAP positions the SQL DW next to SAP BW/4HANA, allowing you to run them individually or together as one data warehouse. Where the SAP HANA SQL DW is a relative new offering, SAP BW has a long and known history. That also goes for the extraction of data from ABAP based SAP source systems. If you are running that scenario with SAP BW, and see no need to change this, then you are perfectly fine. The functions described here are for the customers that have a use case for direct extraction of ABAP sources to their SAP HANA SQL DW or other use cases where the data needs to land in SAP HANA.

45.How did people load from ABAP to SQL DW before?

Ans:

The need for loading from ABAP based source systems to non-ABAP systems is not a new requirement at all, and SAP supports this for quite some time already. You had the following options:

• Direct extraction from the database source tables: can be the fastest data transfer option, but you are then bypassing extractor logic, and as you directly access the source database, you might violate database license restrictions.
• Using SAP Data Services, which supports the ODP protocol to load via the ABAP application layer.
• Smart Data Integration (SDI), which also supports the ODP protocol, but which is built straight into SAP HANA. This is where the functionality has been extended.

46.Explain the Basic concept of data warehousing?

Ans:

47.What is Data Warehousing?

Ans:

A simple answer to this is, Data warehousing is a technique or system that collects transformed data from either or both homogenous and heterogeneous data sources and transfers into a single data store. It provides the data to the analytical tools. The data warehouses are known to be the central repositories of a business intelligence system.

48.What are the Components of Data Warehouse Architecture?

Ans:

A typical data warehouse has four main components: a central database, ETL (extract, transform, load) tools, metadata, and access tools. All of these components are engineered for speed so that you can get results quickly and analyze data on the fly.

49.Benefits of SAP HANA Data Warehousing?

Ans:

Data warehousing solution in SAP HANA has several benefits:

• Instantly access real-time or historical data from SAP or non-SAP data sources. It accesses data to carry out real-time analysis and business insights either on-premise or on-cloud.
• It offers high-volume and real-time data processing.
• Utilize the most of this tool by the virtue of a Big Data warehouse. It allows complete capitalization on your data.
• You can develop the application according to your requirements and use processed data from the data warehouse. Conduct advanced analytics and integrate with machine learning capabilities.

50.Mention the Career Prospects in SAP HANA?

Ans:

51.What are SAP HANA Lines of Business?

Ans:

There are varied lines of business and industries, which use the SAP HANA application. The latest SAP HANA version, SAP S/4 HANA is currently being used worldwide by sectors like:

• Automotive
• Engineering, Construction, and Operations
• Food production
• Mining
• Research and Development
• Chemicals
• Health care and hospitals
• Computer software and hardware
• Management Consulting

52.Future in SAP HANA?

Ans:

Although, it is a solidified notion about SAP HANA that it is costlier than other in-memory database tools available in the market. Nevertheless, SAP HANA remains to be a popular database technology in the market.

SAP works meticulously on the development and evolution of the tool and releases new updates and software packages at regular intervals.

Although, there have come new technologies in the market such as Hadoop, Scala, Apache Spark, Hive, Pig, Python, R, etc., which serves as fierce competition to SAP HANA in terms of being a cost-effective choice for users.

But, being the perfect and efficient technology that SAP HANA is, it ensures you a well paying and secure career if you keep on upskilling yourself in this technology and keep on learning newer and latest aspects of it.

53.What is a Star Schema?

Ans:

Star schema is the backbone of all data warehouse modelling be it SAP or Oracle. It is a fairly simple concept and is really important for any kind of analysis.

54.Doesn’t look like much of a Star for a Star schema model right?

Ans:

55. What Are the Options Post-Migration?

Ans:

After migrating from one of the supported source platforms, you can perform a post-migration check to verify that the transferred websites, email accounts, databases, and so on are available on the destination server. Websites. … Mail.

56. What is SAP and Azure Data Factory?

Ans:

Azure Data Factory now enables you to ingest data from SAP Table and SAP Business Warehouse (BW) via Open Hub by using Copy Activity. SAP Table connector supports integrating SAP data in SAP ECC, SAP S/4HANA, and other products in SAP Business Suite. For more information, see the SAP Table connector article.

57.The following objects will take part in this scenario?

Ans:

• SAP BW Composite Provider
• SAP BW External SAP HANA View
• Integration Runtime (ODBC)
• Azure Data Factory
• Azure BLOB

58. What is SAP and Azure Analysis Services?

Ans:

Azure Analysis Services (AAS) enables you to build a master semantic layer sitting on top of all your data sources. In essence, it acts as a single source of truth for all your other BI models, created by business users with Power BI or Power Apps. Providing self-service access to data and guided discovery, AAS empowers your teams to distill insights from large datasets faster. This service also eliminates the need for extra data manipulations (cleansing, preparation, modeling, etc.)

59.What is SAP and Power Apps Integration?

Ans:

Power Apps is a handy low-code platform that has already won over both professional and citizen developers. With drag & drop front-end development functionality, pre-made integrators, and reusable code snippets, Power Apps significantly reduces the development time and costs for business apps.

60.Explain the SAP and Dynamics 365?

Ans:

61. What is Azure Active Directory (AAD)?

Ans:

Azure Active Directory (Azure AD) is Microsoft’s cloud-based identity and access management service, which helps your employees sign in and access resources in: External resources, such as Microsoft 365, the Azure portal, and thousands of other SaaS applications

62.SAP and Azure Active Directory features?

Ans:

• SSO is based on the user’s email address or another personal identifier. Users can log in to all Azure and SAP products without the need to create separate logins/passes.
• Single point of control for all identity management tasks. Security, access provisioning, and de-provisioning can be performed in a centralized manner.
• Multi-factor authentication can be added as an extra security layer to protect the most sensitive applications and operations.

63.What is Microsoft Azure?

Ans:

Microsoft Azure (formerly known as Windows Azure) is a cloud computing platform launched by Microsoft. We are all aware of the immense popularity cloud computing has gained over time. Through cloud computing, a large and wide user base gets access to computing resources such as servers, storage, a dedicated network, virtual machine, security etc. through the internet (cloud).

64.Show the SAP HANA on Azure Architecture?

Ans:

65.Services Provided by Microsoft Azure?

Ans:

Microsoft Azure provides a gamut of services which are broadly categorized into 18 categories. The services in particular ranges up to 200. The service categories are –

• Computing
• Networking
• Storage
• Migration
• Mobile
• Analysis
• Containers

66.What are SAP HANA use cases?

Ans:

• Application and IT infrastructure security.
• Asset operation and maintenance.
• Business planning and consolidation.
• Customer Relationship Management (CRM)
• Database and data warehouse management.
• Enterprise information and performance management.
• Human resource management.
• Logistics and order fulfilment.

67.Mention the Cloud advantages?

Ans:

• Flexibility
• Scalability
• Hybrid integration with on-premises datacentres
• Agile implementation of new solutions
• Data integrity
• Cost-effectiveness – charges based on usage

68.Why Azure?

Ans:

• Microsoft spends over 1 billion dollars on cyber-attack research and cybersecurity improvements.
• Azure meets the requirements of over 90 compliance certifications from across different sectors and regions.
• More than 95% of Fortune 500 companies use Microsoft cloud solutions.

69.Azure Data Factory provides 3 kinds of connectors for connecting with SAP BW?

Ans:

• SAP Open Hub
• SAP MDX
• SAP Table

70.What is SAP BW Open Hub connector Flow?

Ans:

71.Mention the Features available in ADF Pipeline activities?

Ans:

A pipeline is a logical grouping of activities that performs a unit of … those processes in a scaled-out manner from your ADF pipelines.

72. SAP BW Limitations?

Ans:

• Since Open Hub does not support Infoset, the data cannot be brought directly from Infoset. It can be done using another BW object like DSO or cube in between Infoset and Open Hub to stage the Infoset.
• The output data is flat and not multidimensional. The data type of the output cannot be changed
• Delta loading from BEx query to Open Hub is not possible. So, if delta is necessary, then it must be handled in the design of BEx Query.

73.What is SQL Server and SAP HANA?

Ans:

Most RDBMS database uses SQL as database language, the reason of being popular is – it is powerful, vendor independent and standardized. SAP HANA also supports SQL. In SAP HANA, SQL is the main database language.

74. Mention the Development models integrating HANA models and BW?

Ans:

There are four types of InfoObjects in SAP BW/4HANA: characteristic, key figure, unit, and XXL.

75.Explain the API based SAP S4 HANA Business Architecture?

Ans:

76.How Does Azure Data Factory Differ from other ETL Tools?

Ans:

ADF, which resembles SSIS in many aspects, is mainly used for E-T-L, data movement and orchestration, whereas Databricks can be used for real-time data streaming, collaboration across Data Engineers, Data Scientist and more, along with supporting the design and development of AI and Machine Learning Models by Data

77.What is a Real-World Retailer?

Ans:

78.What is ADP Integration Runtime?

Ans:

The Integration Runtime (IR) is the compute infrastructure used by Azure Data Factory and Azure Synapse pipelines to provide the following data integration capabilities across different network environments: Data Flow: Execute a Data Flow in managed Azure compute environment

79. What is Data Capture (CDC)?

Ans:

The technology emerged two decades ago to help replication software vendors deliver real-time transactions to data warehouses. It works via standard change-log mechanisms to continuously identify and capture incremental changes to data and data schemas from sources such as enterprise-grade databases. These small incremental changes are then automatically propagated to target systems via a low-latency data transfer. The impact on operational systems is also extremely low since the source systems don’t require integration agents or additional database queries. As a result, CDC has the benefit of being easier to administer and manage than other types of data integration. Furthermore, there’s no “batch window” and the data in target systems are always up-to-date.

80.How do you replicate data from premise to Azure?

Ans:

Replication can be configured by using SQL Server Management Studio or by executing Transact-SQL statements on the publisher. You cannot configure replication by using the Azure portal. Replication can only use SQL Server authentication logins to connect to Azure SQL Database. Replicated tables must have a primary key.

81.How is Comparing Azure Data Factory and Attunity Replicate?

Ans:

82.What is Automated SAP HANA System Replication?

Ans:

SAP HANA System Replication is implemented between two different SAP HANA systems with same number of active nodes.

83.Explain HA Solution for S/4HANA based on ABAP Platform?

Ans:

84.SAP HANA on Microsoft Azure Certification?

Ans:

• You can either deploy an SAP HANA instance on Azure Virtual Machines which goes up to the GS-5 virtual machines (GS5 VM) with 448GB of memory.
• The other way is to deploy SAP HANA instances on the AZURE large instances for SAP HANA. It is a physical center that is offered in locations in a data center by Azure specifications.

85.Which is the Microsoft Azure public cloud off links?

Ans:

86.What is the OS is managed by both customer and Microsoft?

Ans:

Microsoft Windows, also called Windows and Windows OS, computer operating system (OS) developed by Microsoft Corporation to run personal computers (PCs).

87.How to run SAP HANA non-production environment Azure?

Ans:

From the infrastructure wise layer given in the image below you can see the first numbered segment on the left refers to a Customer Datacenter with a HANA production instance deployed.

On the bottom right side, you see a number of Virtual Machines labelled ECC Applications for QA and ECC Applications for DEV/TEST. They are the application server layers that you deployed on the Microsoft Azure Virtual Machines.

88.Running SAP HANA Production Environment on Azure?

Ans:

89.Activities that can perform with SDA?

Here are some of the sample activities, which can be performed with the HANA SDA: Consume data mart scenarios of the SAP HANA from the connected database. Consolidate the data warehouse landscape. Create another data warehouse absolutely transparent for the SAP BW/4 HANA database of the BW system.

90.Common Use Cases for SDA?

The following are some of the common use cases for the SDA: The main use cases for the SAP HANA SDA is archiving data in a different source and retaining active data in the SAP HANA. It is possible to access IQ in the way of archived storage in order to store real-time hot data in the HANA and cold data in the IQ. Create applications by the way of running SAP HANA models across different data sources. Overcome challenges of Big Data by linking to Hadoop by means of Hive interface.

91.Why Is Data Visualization Important?

Data visualization is a quick and easy way to convey concepts or information in a universal manner. Data visualization can help to: Identify key areas and hidden patterns. Get factors that give better customer insights. Analyse and associate data and products properly. Make proper predictions.