You need to deploy an Azure SQL Database for a web app with unpredictable traffic and require automatic scaling. Which service tier should you choose?
Think about a tier that adjusts compute resources automatically based on workload.
The Serverless tier automatically scales compute based on workload demand and can pause during inactivity, saving cost. Other tiers have fixed or manual scaling.
You want to allow access to your Azure SQL Database only from your office IP address 203.0.113.5. Which firewall rule configuration is correct?
To restrict access to a single IP, start and end IP must be the same.
Setting both start and end IP to the office IP address allows only that IP to access the database. Other options allow broader or all IPs.
You enable active geo-replication on your Azure SQL Database to a secondary region. What happens if the primary region experiences an outage?
Consider how failover works in active geo-replication.
Active geo-replication requires manual failover to promote the secondary database to primary. Until then, the secondary is read-only.
Which statement about Transparent Data Encryption (TDE) on Azure SQL Database is true?
Think about what TDE protects and its default status in Azure SQL Database.
TDE encrypts the database files and backups at rest automatically and is enabled by default in Azure SQL Database. It does not encrypt data in transit.
You have an Azure SQL Database with unpredictable and spiky workloads. Which combination of features best balances cost and performance?
Consider features that automatically adjust resources and reduce cost during idle times.
The Serverless tier automatically scales compute resources based on workload and pauses during inactivity, optimizing cost and performance for unpredictable workloads.