Practice Questions

Which Azure service is primarily used to host a single relational database with built in high availability?

A. Azure SQL Managed Instance B. Azure SQL Database C. SQL Server on Azure VM D. Azure Synapse Analytics

What feature helps automatically tune indexes based on workload patterns?

A. Azure Monitor B. Automatic tuning C. Azure Advisor D. SQL Agent

Which option should you configure to protect Azure SQL Database data at rest?

A. Transparent Data Encryption B. Always Encrypted only C. Dynamic Data Masking D. Firewall rules

What tool is best for identifying long running queries in Azure SQL Database?

A. Query Store B. Azure Cost Management C. Resource Group Locks D. Log Analytics

Which backup type allows point in time restore for Azure SQL Database?

A. Full backup only B. Differential backup C. Automated backups D. Manual export

What feature should you use to replicate data across regions for disaster recovery?

A. Failover groups B. Elastic pools C. SQL Data Sync D. Azure Backup Vault