SAP HANA Interview Questions & Answers Set-8

«« Previous
Next »»

1. 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.

2. What are the different privilege types that can be assigned to a user in HANA studio?

Ans: 
  • System Privilege
  • Object Privilege
  • Analytic Privilege
  • Package Privilege
  • Application Privilege
  • Privilege on roles
3. Which of the system privilege is required to perform auditing related work?

Ans: Audit Admin

4. 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.

5. 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.

6. 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.

7. What are different recovery mechanism can be performed in HANA system?

Ans: 
  • 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.

8. Which all Business Objects tools can be directly connected to HANA Information views?

Ans: 
  • SAP Lumira
  • Analysis edition for OLAP
  • SAP Crystal Reports
  • Design Studio
9. What are the different modes in HANA studio that can be used for migration?

Ans: 
  • Change and Transport system
  • Delivery Unit
  • Developer Mode
  • SAP support mode
10. Which of the export options allows you to export multiple packages locally or to other HANA system?

Ans: 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.

11. 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.

12. What is logging table?

Ans: Logging table records all replicated changes in the table, which can be further replicated to the target system.

13.How to define Transformation rules in HANA?

Ans: Using advanced replication settings, transformation rules are specified to transfer data from source tables during replication process. For instance, setting rules to covert fields, fill vacant fields and skip records. These rules are structured using advanced replication settings (transaction IUUC_REPL_CONT)

14.Explain the role of transaction manager and session?

Ans: SAP HANA transaction manager synchronizes database transactions keeping the record of closed and open transactions. When a transaction is committed or rolled back, the manager informs all the active stores and engines about the action so that they can perform required actions in time.

15.How is SQL statement processed in SAP HANA?

Ans: Each SQL statement in SAP HANA is carried out in the form of a transaction. Every time, a new session is allocated to a new transaction.

16. Define Master-Controller job.

Ans: A Master-controller job is responsible to build database logging table in the source system. It further creates synonyms and new entries in SLT server admin when the table loads / replicates.

17.How users can avoid un-necessary storage of logging information?

Ans: Pause the replication process and terminate the schema-related jobs.

18. Is the table size in source system and Sap HANA system same?

Ans: No

19. When to change the number of Data Transfer Jobs?

Ans: The number of data transfer jobs change when the initial loading speed or latency replication time is not up to the mark. At the end of the initial load, the number of initial load jobs may be reduced.

20. What is the default IMCE Studio perspective?

Ans: Administrator Console

«« Previous
Next »»

No comments:

Post a Comment