Featured Post

SQL Query: 3 Methods for Calculating Cumulative SUM

SQL provides various constructs for calculating cumulative sums, offering flexibility and efficiency in data analysis. In this article, we explore three distinct SQL queries that facilitate the computation of cumulative sums. Each query leverages different SQL constructs to achieve the desired outcome, catering to diverse analytical needs and preferences. Using Window Functions (e.g., PostgreSQL, SQL Server, Oracle) SELECT id, value, SUM(value) OVER (ORDER BY id) AS cumulative_sum  FROM your_table; This query uses the SUM() window function with the OVER clause to calculate the cumulative sum of the value column ordered by the id column. Using Subqueries (e.g., MySQL, SQLite): SELECT t1.id, t1.value, SUM(t2.value) AS cumulative_sum FROM your_table t1 JOIN your_table t2 ON t1.id >= t2.id GROUP BY t1.id, t1.value ORDER BY t1.id; This query uses a self-join to calculate the cumulative sum. It joins the table with itself, matching rows where the id in the first table is greater than or

AWS to Understand EC2 Security

Amazon Elastic Computing Cloud, you can call it EC2. Here're EC2 top security features and shared frequently asked interview questions on EC2.

Based on your requirement, you can increase or decrease computing power. Before you enable the Autoscaling feature, you need to know its impacts since it's the Administrator's responsibility.

AWS to Understand EC2 Security
AWS to Understand EC2 Security


Making your existing hardware to the requirement always is not so easy. So EC2 service in AWS helps you to allocate computing power according to your needs. 

AWS EC2 instance acts as your physical server. It has a memory. You can increase the instance size in terms of CPU, Memory, Storage, and GPU. 

EC2 auto scaling is a property, where it automatically increase your computing power.

Security Features in EC2

  • Virtual Private Cloud. The responsibility of Virtual Private Cloud is to safeguard each instance separately. That means, you cannot access other instances, which are already created by other organizations.
  • Network Access Control List. It acts as a firewall to both incoming and outgoing requests.
  • Access Management. Control level of access granted to each user.
  • Security Groups. Each instance can have 5 security groups. It acts as a firewall. It is something more detailed over the Network Access Control List.
  • Hardware Security Device. A security device, to control security between on-premise network hardware and AWS cloud hardware.

AWS EC2 or Elastic Computing Instance

The instance is one server virtual in nature created on behalf of an organization on the AWS cloud. You can find different AWS instances. Those are A1, T3, T2, M5, M5a, M4, etc. Instance type means it has different combinations of computing power.

3 Top methods to start AWS EC2
  1. AWS management console
  2. CLI
  3. AWS SDKs

AWS Security Group

  • Each Security group associated with an instance. You can create a security group and define rules for that depending on the requirement.
  • How to learn about AWS EC2 is a big question for many developers. Some people read AWS EC2 tutorials, and some people learn from good AWS books. The best option is to create an AWS-free account and use your tutorials and books to elaborate more.

AWS Top Instance Types According to the wiki

  • General Purpose: M5, M4, T2
  • Compute Optimized: C5, C4
  • Memory-Optimized: X1e, X1, R4
  • Accelerated Computing: P3, P2, G3, F1
  • goog_1389995598Storage Optimized: H1, I3, D2

15 Frequently Asked Questions on EC2

1. When was EC2 introduced?

A) 2006

2. Does EC2 has a graphical user interface (GUI)?

A) Yes, it has.

3. What are the real applications of EC2?

A) It is scalable and faster Docker container management features.

4. What is an instance?

A). The virtual computing power you can say as an instance.

5. What is an AMI?

A) This is a pre-configured template to use in an instance. 

6. What is AWS Lambda?

A). This is a compute service that runs code without the need to provision or manage servers.

7. What is AWS Elastic beanstalk?

A). This is a service that enables you to quickly deploy and manage applications on the AWS Cloud without worrying about the infrastructure that runs those applications

8. What is Amazon Light Sail?

A). This service is for developers who need virtual private servers. Amazon Lightsail includes everything you need to launch your project quickly—a virtual machine, SSD-based storage, data transfer, Domain Name System (DNS) management, and a static IP address—for a low, predictable price.

9. What is AWS Batch?

A). This service enables you to run batch computing workloads on the AWS Cloud. Batch computing is a common way for developers, scientists, and engineers to access large amounts of computing resources

10. What is Amazon EBS volume?

A). The persistent storage volumes for your data using Amazon Elastic Block Store (Amazon EBS), known as Amazon EBS volumes

aws Iaas leader in the market

11. What is an Elastic IP address?

A). The IP Address, which is assigned to an instance is called Elastic IP Address.

12. What is Amazon Virtual Private Networks?

A). Virtual networks that you can create that are logically isolated from the rest of the AWS Cloud and that you can optionally connect to your own network.

13. What is Amazon AMI?

A). An AMI provides the information required to launch an instance.

14. How many ways you will get AMI? and what are those methods?

A). You will get by 4 methods.
Those are:
  1. Provided by AWS
  2. AWS Marketplace
  3. You can create and manage your own AMIs.
  4. A shared AMI
 15. What is Shared AMI?

A). A shared AMI is an AMI that a developer created and made available for other developers to use.

**Note: The Amazon ECS. You can call it Amazon Container Service. You can manage Docker containers on Amazon ECS

Download AWS EC2 PDF
  • The Questions Available in PDF format to download HERE


Post a Comment

Thanks for your message. We will get back you.

Popular posts from this blog

How to Fix datetime Import Error in Python Quickly

Explained Ideal Structure of Python Class

How to Check Kafka Available Brokers