Activity – 1
- Scenario:
- Your organization has an existing database Azure SQL Database with Basic DTU
- This is used with a service which has less number of requests, so Basic DTU was decided, Now your customers have increased and the number of users using you service has increased but not constant
- We need to resize the Database.
- What would be right plan?
- Solution:
- We need to change the database size, So since the demand is not constant it is recommended to use serverless
- Current db size
- Now lets scale it to General Purpose with Serverless
Actvitity-2
- Scenario:
- The application hosted by your organization is used by lot of customers on the east coast of United states, so you have deployed your application and database in east Us
- Now your organization has a head quarters on the west coast and they have BI (Business Intelligence) application which will use the database only for querying so that right dashboards are build for the senior management.
- These dashboards are performing slowly, and it needs to be fixed.
- Solution:
- Create a Geo-Replication (Standby).
- Standby supports read operations & your BI System requires only read operations.
Activity-3
- Scenario
- Your organiazation is acquired by a new organization and according to the new organization policy, we need to have backups of the database for atleast 10 days and for Long-Term Retention we need to have 2 years of annual backup and atleast 4 weeks of weekly backups
- Navigate to the server and select Backups and Retention policies
