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. |
About the Flashcards
Flashcards for the Microsoft Azure Data Fundamentals exam give you quick drills on Microsoft's cloud database options. Review what Azure SQL Database is, when to choose SQL Managed Instance, and how these services simplify migration from on-premises SQL Server. Each card sharpens your recall of core definitions needed to answer exam scenario questions fast.
You will practice key metrics like DTU, service tiers, and elastic pools, understand automated backups, geo-replication, and high-availability groups, and compare security measures such as encryption and role-based access. Coverage of autoscaling, Intelligent Query Processing, and monitoring tools ensures you're ready to optimize performance and protect data in any test case.
Topics covered in this flashcard deck:
- Azure SQL Database features
- SQL Managed Instance migration
- Backups & high availability
- Performance tiers & scaling
- Security, auditing & compliance
- Monitoring & query insights