Bash, the Crucial Exams Chat Bot
AI Bot
Relational Data in Azure Flashcards
Microsoft Azure Data Fundamentals DP-900 Flashcards
| Front | Back |
| How do you implement geo-replication in Azure SQL Database | By creating readable secondary databases in other Azure regions. |
| How does Azure SQL Database handle backups | Automated backups are created and retained for up to 35 days with point-in-time restore. |
| How does scalability differ between SQL Managed Instance and Azure SQL Database | SQL Managed Instance scales up to 8TB per database, whereas Azure SQL Database uses performance tiers or elastic pools. |
| How is data loss prevented in SQL Managed Instance | Through advanced data recovery options like backups and high availability setups. |
| How is security implemented in Azure SQL Database | Built-in encryption, role-based access control, and virtual network integration. |
| What are elastic pools in Azure SQL Database | A cost-effective solution to share resources across multiple databases. |
| What are service tiers in Azure SQL Database | Offer different levels of performance such as Basic, Standard, and Premium. |
| What authentication methods does Azure SQL Database support | Azure Active Directory authentication and SQL authentication. |
| What does Intelligent Query Processing in Azure SQL Database do | Enhances query performance using machine learning optimizations. |
| What does SQL Managed Instance offer for high availability | Built-in availability groups and automated failover capabilities. |
| What is a primary feature of database auditing in Azure SQL Database | Tracks database events for compliance and monitoring purposes. |
| What is Azure SQL Database | A fully managed relational database service in Azure optimized for app development. |
| What is DTU in Azure SQL Database | Database Transaction Unit representing a blended measure of CPU, memory, and I/O performance. |
| What is SQL Managed Instance | A scalable cloud service that offers near 100% compatibility with SQL Server on-premises. |
| What is the key benefit of autoscaling in Azure SQL Database | Dynamically adjusts compute resources based on workload requirements. |
| What is the key difference between SQL Managed Instance and Azure SQL Database | SQL Managed Instance offers near 100% feature compatibility with on-premises SQL Server. |
| What is the major use case for SQL Managed Instance | Migration of on-premises SQL Server databases to the cloud with minimal changes. |
| What is the purpose of Query Performance Insights in Azure SQL Database | Monitors and analyzes query execution to optimize performance. |
| What tool can be used to manage Azure SQL resources | Azure Portal, PowerShell, or Azure CLI. |
Front
How does Azure SQL Database handle backups
Click the card to flip
Back
Automated backups are created and retained for up to 35 days with point-in-time restore.
Front
What is the purpose of Query Performance Insights in Azure SQL Database
Back
Monitors and analyzes query execution to optimize performance.
Front
How does scalability differ between SQL Managed Instance and Azure SQL Database
Back
SQL Managed Instance scales up to 8TB per database, whereas Azure SQL Database uses performance tiers or elastic pools.
Front
What is a primary feature of database auditing in Azure SQL Database
Back
Tracks database events for compliance and monitoring purposes.
Front
What is the key benefit of autoscaling in Azure SQL Database
Back
Dynamically adjusts compute resources based on workload requirements.
Front
What authentication methods does Azure SQL Database support
Back
Azure Active Directory authentication and SQL authentication.
Front
What is DTU in Azure SQL Database
Back
Database Transaction Unit representing a blended measure of CPU, memory, and I/O performance.
Front
What does SQL Managed Instance offer for high availability
Back
Built-in availability groups and automated failover capabilities.
Front
What are service tiers in Azure SQL Database
Back
Offer different levels of performance such as Basic, Standard, and Premium.
Front
What is the major use case for SQL Managed Instance
Back
Migration of on-premises SQL Server databases to the cloud with minimal changes.
Front
How is security implemented in Azure SQL Database
Back
Built-in encryption, role-based access control, and virtual network integration.
Front
How do you implement geo-replication in Azure SQL Database
Back
By creating readable secondary databases in other Azure regions.
Front
What does Intelligent Query Processing in Azure SQL Database do
Back
Enhances query performance using machine learning optimizations.
Front
What tool can be used to manage Azure SQL resources
Back
Azure Portal, PowerShell, or Azure CLI.
Front
What is Azure SQL Database
Back
A fully managed relational database service in Azure optimized for app development.
Front
What are elastic pools in Azure SQL Database
Back
A cost-effective solution to share resources across multiple databases.
Front
What is SQL Managed Instance
Back
A scalable cloud service that offers near 100% compatibility with SQL Server on-premises.
Front
What is the key difference between SQL Managed Instance and Azure SQL Database
Back
SQL Managed Instance offers near 100% feature compatibility with on-premises SQL Server.
Front
How is data loss prevented in SQL Managed Instance
Back
Through advanced data recovery options like backups and high availability setups.
1/19
This deck focuses on relational database services in Azure, including Azure SQL Database, SQL Managed Instance, and operational features.