SAP HANA Interview Questions with Answers

Question.1  What is SAP HANA One?

Answer:  SAP HANA One is a single HANA instance hosted on Amazon Web Services. Customers and Partners can use SAP HANA One to provision a secured instance of SAP HANA database. This instance can be used to build and deploy on-demand applications that leverage SAP HANA’s in-memory computing capabilities. The applications can then be consumed by end users for productive use.

Question.2  Is SAP HANA One appropriate for my needs?

Answer:  SAP HANA One enables real-time analytics and in-memory computing on data about 30GB in size. It is appropriate for: Enterprise of all sizes, to build and deploy SAP HANA-based solutions for production use. Startups looking to use SAP HANA for production ISVs looking to build and deliver applications on SAP HANA Those who require high performance and do not need more than ~30GB capacity for data Those looking for subscription model pricing. Those building solutions that are also hosted in AWS.

Question.3  What is the duration of the SAP HANA One license?

Answer:  SAP HANA One is configured for a 1-year renewable license from the date it is available in AWS Marketplace.

Question.4 Does SAP offer short-term licenses?

Answer:  There are no long-term obligations involved; the subscription is hourly.

Question.5  How am I paying for my SAP HANA One instances?

Answer:  All charges are billed by Amazon Web Services, paid by credit card, and the use of the service is governed by Amazon Web Services. Customers pay a single hourly rate for the SAP HANA One instance.

Question.6  Can I take my SAP HANA One solution from the AWS cloud to on-premise or another cloud later?

Answer:  The license associated with the hourly SAP HANA usage is limited to AWS only.  You can contact SAP Service to transition the cloud scenario to HANA on-premise.

Question.7  Can I download my SAP HANA One instance to run on my own environment?

Answer:  No. SAP HANA One instances can only be run on Amazon Web Services. No downloads are permitted, with the exception of SAP HANA Studio and Client components.

Question.8  Can I apply my on-premise SAP HANA software license for SAP HANA One on AWS?

Answer:  Not at this time.

Question.9 If I start with SAP HANA One instances and then purchase on-premise software, do I get a credit?

Answer:  No. There are no credits for switching between deployment models.

Question.10  How does this compare to the SAP HANA Developer Sandbox offered in the SAP HANA Developer Center on SCN?

Answer:  The SAP HANA One license and instance type enables production use, whereas the developer license does not.

Question.11  How does SAP HANA One Platform compare to SAP HANA on-premise?

Answer:  SAP HANA One allows fast deployment, operational, flexibility and faster time-to-market to develop and deploy for use-cases that can be satisfied by 60.5GB memory. SAP HANA on-premise is recommended for use cases that deal with larger data sets.

Question.12  Are there other SAP products available in AWS Marketplace?

Answer:  SAP Business Objects and SAP Afaria cloud edition are available on AWS Marketplace.

Question.13  How much does SAP HANA One cost?

Answer:  SAP HANA One on the cc2.8xlarge instance is offered at $0.99 per hour. AWS infrastructure costs are additional.

Your total cost of using SAP HANA One will vary on your workload, but let us look at typical examples of always-on SAP HANA One for 30 days.

Using on-demand EC2 instances:

Cost of EC2 instance, storage, and data-transfer: $2000.24 per month

Cost of HANA One license (720 hours X $0.99): $712.80 per month

Total monthly cost: $2713.04 per month

Approximate hourly cost: $3.77 per hour

Using Reserved Instance (heavy user, 1 year):

One-time payment for using reserved instance for one year: $5192 per year

One-time payment spread out over 12 months: $432.67 per month

Cost of EC2 instance, storage, and data-transfer: $520.29 per month

Cost of HANA One license ($0.99 X 720 hours): $712.80 per month

Total monthly cost: $1665.76 per month

Approximate hourly cost: $2.31 per hour

Question.14  How can I control cost?

Answer:  You are responsible for operating your AWS account and  paying for the hosting costs. A great way to minimize costs is to stop your instance when you are not using it. Starting your instance just takes a few minutes, so you can fire it up when you need it. To stop your instance, go to AWS EC2 console, right click the instance and choose “Stop” from the context menu. To start it again, choose “Start” from the same context menu.

Please note that even after stopping the EC2 instance, there are a few items that can still incur costs, such as EBS volumes. If you wish to stop using your HANA One instance, and do not want to pay related monthly bills, you will need to terminate your instance.

To terminate your instance, choose “Terminate” from your context menu. Once the instance is terminated, by default, only the root volume is deleted; other EBS volumes attached to the instance are not deleted automatically. If you wish to terminate your instance and no longer need your data, you may delete detached EBS volumes using AWS EC2 Console or AWS APIs to avoid storage charges for unused EBS volumes.

AWS also provides tools to monitor your usage, so there are no surprises when you get your monthly bill – from your “My Account / Console” menu on the top right corner of the screen on, choose “Account Activity” and you will see your activity for the current month.

Question.15  How can I set billing alerts?

Answer:  Billing alerts enable you to monitor your AWS usage charges and recurring fees automatically, making it easier to track and manage your spending on AWS. You can set up billing alerts to receive e-mail notifications when your charges reach a specified threshold. First 10 alerts are free. Please check AWS website for the latest services.

Question.16  What is the maximum database size for SAP HANA One?

Answer:  There are 2 flavors of compute optimized instance available from SPS7 onwards –

a. cc2.8xlarge (Previous generation) 60.5 GB memory.

b. c3.8xlarge (Current generation) 60 GB memory. This type provides highest performing processors.

However, for optimal performance, we do not recommend exceeding the size of the database beyond the 30 GB in memory.

Question.17  What do I do if  outgrow the maximum database size?

Answer:  Consider using SAP HANA on-premise for database requirements that exceed  AWS’s current offering.

Question.18  Can you use AWS clustering functionality?

Answer:  This is not currently supported for SAP HANA One.

Question.19  How do I load data to my SAP HANA One instance?

Answer:  You can load data to your SAP HANA One instance by importing CSV files.