Azure Sql Database — Microsoft Azure Administrator (AZ-104) Practice Questions
Azure SQL Database is a fully managed platform-as-a-service relational database built on the SQL Server engine, and AZ-104 tests the administrative tasks associated with deploying and managing it. The exam covers purchasing models (DTU versus vCore), service tiers, and how to right-size a database based on workload requirements. You must understand how to configure firewall rules and private endpoints, enable transparent data encryption, implement geo-replication and failover groups for high availability, and configure automated backups with appropriate retention policies. Monitoring Azure SQL Database using metrics, diagnostics logs, and Query Performance Insight is also assessed.
Free questions on azure sql database
You are migrating a large database to Azure SQL Database. Which tool helps estimate cost and performance impact before migration?
Free question · medium · full answer + explanation
More azure sql database questions in the full bank
- You need to set up automatic patching for SQL databases. Which configuration option is available? Unlock answer & explanation →
- How can you ensure SQL Database backups are geo-redundant? Unlock answer & explanation →
- You need to migrate a SQL Server database to Azure SQL Database. Which Azure service provides a managed SQL database? Unlock answer & explanation →