Relational Transaction Storage on Azure - 1
Learning objective
- Understand Various types of SQL Instances available on Azure
- How to connect and work with Azure SQL
- Integrate Azure SQL data and work with it
Overview
Overview of Relational Transactional Storage and how it works on Azure
Story
Global Mart is one of the leading e-Commerce giants with a presence in North America and Europe region. It has a presence across 120 markets and primarily deals with 3 lines of business :
- Technology,
- Office Supplies
- Furniture
With an increase in customers and expansion in geography, GlobalMart has developed tie-ups with several local vendors to help them deliver their products to the end customers.
GlobalMart, an e-commerce company, currently stores its data on-premise, and they are facing multiple issues with its current setup. The on-premise data storage system has several limitations, such as limited scalability, insufficient redundancy, and increased risk of data loss in case of disasters. The data is not easily accessible, and the maintenance and management of the hardware are costly and time-consuming. They also face issues related to the backup and recovery process, which can be quite complex and time-consuming.
Furthermore, the on-premise database may not provide the required performance for a high-traffic e-commerce website. The slow speed of the database can result in a poor customer experience, leading to a loss in revenue and customer satisfaction. They may also have difficulty integrating with other applications and tools due to the inflexible nature of the on-premise database.
To address these challenges, GlobalMart is looking to migrate to a cloud-based relational database service on Azure that offers high scalability, availability, and disaster recovery capabilities
You are tasked with the responsibility in identifying right storage solution for the needs of GlobalMart