Identify considerations for relational data on Azure — Microsoft Certified: Azure Data Fundamentals

The official AZURE documentation our Identify considerations for relational data on Azure practice questions are cited to. Review the primary sources, then practise.

practice 13 questions →

Official references for this objective

Microsoft — What is the Hyperscale service tier? - Azure SQL Database | Microsoft Learn

Hyperscale provides fast compute scaling on demand without data movement. Read scale-out strategies are easy, with up
Microsoft — Active Geo-Replication - Azure SQL Database | Microsoft Learn

Consider sending an alert if replication_lag_sec returns NULL for an extended period of time. It might indicate that the geo-secondary cannot communicate with the primary
Microsoft — Manage Multiple Databases with Elastic Pools - Azure SQL Database | Microsoft Learn

Pools are well suited for a large number of databases with specific utilization patterns. This pattern is characterized by low average utilization with infrequent utilization
Microsoft — T-SQL Differences Between SQL Server & Azure SQL Managed Instance - Azure SQL Managed Instance | Microsoft Learn

combine it with locally stored relational data using joins. Parquet and delimited text (CSV) file formats are directly supported
Microsoft — Cloud Business Continuity - Disaster Recovery - Azure SQL Database | Microsoft Learn

To achieve high availability in the Azure cloud environment, enable zone redundancy . With zone redundancy, the database or elastic pool uses Azure availability zones
Microsoft — Cloud Business Continuity - Disaster Recovery - Azure SQL Managed Instance | Microsoft Learn

Recovery Point Objective (RPO) : The time amount of data loss that can be tolerated from an unplanned disruptive event.
Microsoft — High Availability, Disaster Recovery, Business Continuity - SQL Server on Azure VMs | Microsoft Learn

Deploy your HADR solution with the assumption that there might be periods of high network latency between your on-premises network and Azure.
Microsoft — Purchasing Models - Azure SQL Database | Microsoft Learn

The serverless compute tier automatically pauses databases during inactive periods when only storage is billed and automatically resumes databases when activity returns.