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. |
This deck focuses on relational database services in Azure, including Azure SQL Database, SQL Managed Instance, and operational features.