SAP HANA Interview Questions and Answers
by Nithyanandham, on Sep 11, 2022 1:10:51 PM
Q1. Compare SAP HANA & Oracle?
- Compatibility to work with other databases
- Comparison on costs
- Customization, customer service & functionality
- Very Good
- More cost for internal resources and training
- Ease of use, quick deployment and flexibility
- Much lesser on both fronts
Q2. What is SAP HANA?
Ans: SAP HANA is an in-memory computing engine (IMCE) used for real-time processing of huge volumes of data and building and deploying real-world applications. Adopting the row-based and column-based DB technology, SAP HANA is an advanced relational DB product serviced by SAP SE. With this high-performance analytic (HANA) system, the big data exists on the main memory and not on the hard disk. It replaces the onus of data maintenance separately on the legacy system and simplifies the tasks of administrators in this digital world.
Q3. Explain the column and Row store in HANA?
Ans: HANA supports both type of data store in database. Row store is used when you need to use Select statement and no aggregations are performed.Column store is used to perform aggregations and HANA Modeling is supported only on Column based tables.
Q4. Which companies are providing SAP HANA hardware appliances?
Q5. What is the use of SAP HANA studio?
Ans: HANA studio is an eclipsed based tool and provides support for development and administration in HANA system. You can perform HANA Modeling on the top of tables in database, Data provisioning, HANA Administration and various other activities using HANA studio.
SAP HANA Studio client is available for Windows XP, Windows Vista, and Windows 7 for 32 bit and 64 bit operating system.
Q6. What do you understand by SAP HANA In-Memory Computing Engine IMCE?
SAP HANA uses multicore CPU architecture and stores data in row and column based storage in HANA database.
Q7: What is the development language used by SAP HANA?
Q8 Which operating system is supported by HANA system?
Ans: Only operating system that is supported by HANA is Suse Linux Enterprise Server SP1/SP2 (SLES SP1/2).
Q9 What is the functional difference between Row and Column based storage? Where do we use Row based storage and column based storage?
Ans: Consider below table- FCTSales
|India||Samsung Note 6||250|
Row Based Storage −
- Samsung Note 6
- Lenovo A110
Column Based Storage −
- Samsung Note6
- Lenovo A110
Q10. Where to use Row based storage?
Ans: Select * from FCTSales where Country=’US’
Q11. List advantages of using SAP HANA database?
- With the HANA technology, you can create gen-next applications giving effective and efficient results in the digital economy.
- By using singe data-in memory, SAP HANA supports smooth transaction process and fault-tolerant analytics
- Easy and simple operations using an open-source, unified platform in the cloud
- High-level Data Integration to access massive amounts of data
- Advanced tools for in-depth analysis of present, past and the future.
Q12. Where to use Column based storage?
Ans: Select SUM(Units_sold) from FCTSales where Product=’Lenovo A110’
Q13. What are the different components in SAP HANA Architecture? What is the use of Index server?
- Index Server
- Name Server
- Statistical Server
- Preprocessor Server
- XS Engine
- SAP Host Agent
- LM structure
- SAP Solution Manager Diagnostic Agent
Index server contains engine to process data in HANA database. These data engines are responsible to handle all SQL/MDX statement in HANA system. Index server also contains Session and Transaction Manager which is responsible to manage all running and completed transactions.
Q14. What is the use of Persistence layer in SAP HANA system?
Ans: Persistence layer provides inbuilt mechanism for disaster recovery in HANA system. It ensures that database is restored to most recent state in case of a system failure.
Persistence layer also manages data, transaction and configuration logs and backup of these files. Backups of data and log files are performed at save points and is normally scheduled every 5-10 minutes.
Q15. What are the different license keys type in HANA system? What is their validity?
- Temporary License key
- Permanent License Key
Temporary License keys are automatically installed when you install the HANA database. These keys are valid only for 90 days and you should request permanent license keys from SAP market place before expiry of this 90 days period after installation.
Permanent License keys are valid till the predefine expiration date. License keys specify amount of memory licensed to target HANA installation.
Q16. List the merits and demerits of using row-based tables?
- No data approach can be faster than row-based if you want to analyze, process and retrieve one record at one time.
- Row-based tables are useful when there is specific demand of accessing complete record.
- It is preferred when the table consists of less number of rows.
- This data storage and processing approach is easier and effective without any aggregations and fast searching.
The data retrieval and processing operations involve the complete row, even though all the information is not useful.
Go through this in-depth SAP HANA training and master the powerful columnar database now!
Q17: What are the different types of permanent license keys in HANA system?
Ans: There are two types of permanent License keys for HANA system −
- Unenforced − If unenforced license key is installed and consumption of HANA system exceeds the license amount of memory, operation of SAP HANA is not affected in this case.
- Enforced − If Enforced license key is installed and consumption of HANA system exceeds the license amount of memory, HANA system gets locked. If this situation occurs, HANA system has to be restarted or a new license key should be requested and installed.
Repository: Encountered an error in repository runtime extension; Deploy Attribute View: SQL: transaction rolled back by an internal error: insufficient privilege: Not authorized
Grant SELECT privileges on schemas of the used data foundation tables to user "_SYS_REPO"
GRANT SELECT ON SCHEMA "<SCHEMA_NAME>" TO _SYS_REPO WITH GRANT OPTION
Q18. In SAP HANA Studio, what is use of different folders when you add a HANA system to Studio?
- Backup−It is used to perform for backup and recovery in SAP HANA system. You can check backup configuration details, run manual backup, to check last successful back performed, etc. for data and log backup.
- Catalog −This contains RDBMS objects like schemas, tables, views, procedures, etc. You can open SQL editor and design database objects
- Content −This is used to maintain design time repository
- You can create new packages and design Information views in HANA system. Various views can be created under content tab to meet business requirement and to perform analytical reports on the top of the Modeling views.
- Provisioning −This is used for Smart data access to connect to other databases like HADOOP, TERADATA and SYBASE
- Security −This is used to define users and to assign roles. You can define various privileges on different users using Security tab. You can assign Database and Package privileges to different users to control the data access.
Q19. What is the difference between Open Data Preview and Open Definition?
Open Data Preview:
This is used to see the data stored in an object- table or a modeling view. When you open data preview, you get three options −
- Raw Data
- Distinct Values
This is used to see the structure of the table − column name, column data type, keys, etc.
Q20. If you want to see all active alerts, description and priority, where this can be checked?
Ans: Go to Administration → alerts
In Administration tab, you can check system overview, landscape, volumes, configuration, system information, etc.
Q21. What is SAP HANA cockpit?
Ans: SAP HANA cockpit is a SAP Fiori Launchpad site that allows you with a single point-of-access to a range of Web-based applications for the online administration of SAP HANA. You access the SAP HANA cockpit through a Web browser.
To open SAP HANA Cockpit → Right click on HANA system in Studio → configuration and monitoring → open SAP HANA cockpit
Q22. What is the difference between Catalog and Content tab?Ans: Catalog −
Ans: This contains RDBMS objects like schemas, tables, views, procedures, etc. You can open SQL editor and design database objects.
This is used to maintain design time repository. You can create new packages and design Information views in HANA system. Various views can be created under content tab to meet business requirement and to perform analytical reports on the top of the Modeling views.
Q23. Which Information view in SAP HANA is used to implement star schema queries?
Ans: Analytic View
Q24. What is difference between Copy and derived from option while creating a new SAP HANA Attribute information view?
Ans: Copy option allows you to copy an existing Information view and to make changes to it.
Derived option allows to create a copy of an existing view and you can’t make any changes to it.
Q25. What is the use of Data Foundation, Star Join and Semantics?
Ans: Data Foundation − to add column base tables.
Star Join − to add other type of views.
Semantic − to define user parameters and to define measures and dimensions
Q26. What are the different user parameters that can be defined in Semantic layer?
- Measure and Attribute
- New Calculated Colum
Q27. What is a new calculated column in a HANA Modeling view?
Ans: New calculated column is defined as a column added on the fly in Analysis tab when a view is activated. This column doesn’t exist at database level or in Data Foundation or Star Join level.
Q28. To improve the performance of Information view by validating joins and Cardinality, which option cab be used?
Ans: You can select Switch to Performance Analysis Mode. This allows you to do Performance Analysis by validating correct join type and Cardinality.
Q29. What are the benefits of using Calculation view with Star join?
Ans: It simplify the design process as allows you to select multiple measures from multiple fact tables.
You can implement 3NF using Star Join.
Q30. What is the use of parameters and variables in Semantic layer
Ans: Variables are used as an explicit SQL filter directive for view consumers to filter the view data, based on attribute column values specified in variable UI prompt of a BI Client. When you go to data preview, variables allow users to pass the value of attribute defined in the variable.
You can select a single value, range or range in selection type
Q31. What are the default nodes available in a Calculation view?
Q32. What is the default node, if you select a Dimension Calculation view?
Q33. How do you check if an Information view is saved and activated
Ans: There is a diamond mark on view name if it is not active.
Q34. Can you pass Attribute views and analytic views in a Calculation view with Star join?
Ans: No. In a Calculation view with Star Join, you can only use Dim Calculation views.
Q35. What is SAP HANA Analytic Privileges?
Ans: Analytic Privileges are used to limit access on HANA Information views. You can assign different types of right to different users on different component of a View in Analytic Privileges.
Q36. If you want that your Area Managers can only see data from their region and you want to assign this restriction for specific duration, how this can be achieved?
Ans: Using Analytic Privileges, you can add Region attribute and values to Attribute Restrictions and Time duration is defined in Privilege validity.
Analytic Privilege can be added to user profile in User and Roles under Security tab.
Q37. What are the different methods of data replication in HANA?
- SAP LT Replication SLT
- SAP Data Services
- Direct Extract Connection DXC
Q38. What are the different modes in data provision in HANA Studio?
Ans: On your source SAP system A1 you want to setup a trusted RFC to target system B1. When it is done it would mean that when you are logged onto A1 and your user has enough Authorization in B1, you can use the RFC connection and logon to B1 without having to re-enter user and password.
SM59 to create a trusted RFC
Ltr to configure the connection
Q40. How you can use Data provisioning in SAP HANA studio
Ans: Go to SAP HANA Modeler Perspective → Data Provisioning.
Q41. While creating data store in Data Services for SAP ECC, what is the datastore type in drop down list?
Ans: You have to select SAP Applications in data store type and SAP HANA in Database drop down list.
Q42. How you can perform trace, monitoring, error and performance monitoring of jobs in Data Services
Ans: Replication job can be performed in Data Services Management Console. You have to go to status tab and select the repository where job is created → Batch Job Status.
There you can find different tabs- Trace, Monitor, Error and Performance Monitor.
Q43. How can you enable auditing of batch jobs in Data Services?
Ans: To enable auditing of batch job, this can be done in job execution parameters.
Go to status tab and select the repository where job is created → Batch Job configuration → Add Schedule.
Here you can find job execution parameters while adding a schedule for the job
Q44. While configuring a batch job in SAP Data Services repository, what does owner name means?
Ans: Owner represents schema name where tables will be moved using batch job.
Q45. What are the different authentication methods configured in SAP HANA system for user creation?
Ans: Below is the list of authentication methods supported by SAP HANA −
- User name/Password
- SAML 2.0
- SAP Logon tickets
Q46. What is a restricted user in SAP HANA system?
Ans: Restricted users are those users who access HANA system with some applications and they don’t have SQL privileges on HANA system. When these users are created they don’t have any access initially.
If we compare restricted users with Standard users:
- Restricted users can’t create objects in HANA database or their own Schemas.
- They don’t have access to view any data in database as they don’t have generic Public role added to profile like standard users.
- They can connect to HANA database only using HTTP/HTTPS.
Q47. What system privilege is required for a user to enable him to create user and roles in HANA studio?
Ans: Only database users with the system privilege ROLE ADMIN are allowed to create users and roles in HANA studio
Q48. What are the different privilege types that can be assigned to a user in HANA studio?
- System Privilege
- Object Privilege
- Analytic Privilege
- Package Privilege
- Application Privilege
- Privilege on roles
Q49. Which of the system privilege is required to perform auditing related work?
Ans: Audit Admin
Q50. How you can configure Auditing and password policy in HANA studio?
Ans: Go to Security option in HANA system → Auditing
Under Global Settings→set Auditing status as enabled. You can also choose different Audit trail targets.
Q51. How you can connect SAP HANA to Microsoft Excel?
Ans: MDX Provider is used to connect MS Excel to SAP HANA database system. It provides driver to connect HANA system to Excel and is further used for data modelling. You can use Microsoft Office Excel 2010/2013 for connectivity with HANA for both 32 bit and 64 bit Windows.
Q52. How you can limit the size of data backup files in HANA system?
Ans: This can be done in File Based data backup settings. In Backup tab, go to Configuration → Limit Maximum file Size check box and enter the file size.
Q53. What are different recovery mechanism can be performed in HANA system?
- Most Recent State − Used for recovering the database to the time as close as possible to the current time. For this recovery the data backup and log backup have to be available since last data backup and log area are required to perform the above type recovery.
- Point in Time − Used for recovering the database to the specific point in time. For this recovery the data backup and log backup have to be available since last data backup and log area are required to perform the above type recovery.
- Specific Data Backup − Used for recovering the database to a specified data backup. Specific data backup is required for the above type of recovery option.
- Specific Log Position − This recovery type is an advanced option that can be used in exceptional cases where a previous recovery failed.
Note: To run recovery wizard you should have administrator privileges on HANA system.
Q54. Which all Business Objects tools can be directly connected to HANA Information views?
- SAP Lumira
- Analysis edition for OLAP
- SAP Crystal Reports
- Design Studio
Q55. What are the different modes in HANA studio that can be used for migration?
- Change and Transport system
- Delivery Unit
- Developer Mode
- SAP support mode
Q56. Which of the export options allows you to export multiple packages locally or to other HANA system?
Delivery Unit: Delivery unit is a single Unit which can be mapped to multiple packages and can be exported as single entity so that all the packages assigned to Delivery Unit can be treated as single unit.
Q57. How does SAP HANA support import from a local file?
Ans: Go to File → Import, You will see below option
This is used to import data from a flat file like .xls or.csv file. Click on Next → Choose Target System → Define Import Properties.
Select Source file by browsing local system. It also gives an option if you want to keep the header row. It also gives an option to create a new table under existing Schema or if you want to import data from a file to an existing table