SAP HANA Interview Questions & Answers Set-7

«« Previous
Next »»

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

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

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

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

5. What are the default nodes available in a Calculation view?

Ans: 
  • Join
  • Union
  • Project
  • Aggregation
  • Rank.
6. What is the default node, if you select a Dimension Calculation view?

Ans: Projection

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

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

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

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

11. What are the different methods of data replication in HANA?

Ans: 
  • SAP LT Replication SLT
  • SAP Data Services
  • Direct Extract Connection DXC
12. What are the different modes in data provision in HANA Studio?

Ans: 
  • Load
  • Replicate
  • Suspend
  • Resume
13. What do you understand by trusted RFC connection? Which transaction is used to create and configure trusted RFC?

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

14. How you can use Data provisioning in SAP HANA studio?

Ans: Go to SAP HANA Modeler Perspective → Data Provisioning.

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

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

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

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

19. 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
  • Kerberos
  • SAML 2.0
  • SAP Logon tickets
  • X.509
What are the different authentication methods configured in SAP HANA system for user creation?

20. 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.
«« Previous
Next »»

No comments:

Post a Comment