AZ-305 FlashCards
Azure SQL Managed Instance max DB size
2-8 TB
When to use Azure SQL Serverless Databases
Azure SQL Database Serverless used for database with infrequent use. It pauses database when not active
Benefits of Azure SQL Hyperscale
Supports multiple secondary and read only replicas
Scales up to 100 TB
Supports auto replication between primary and secondary replicas
Supports failover between primary and secondary replicas within 15 mins
Supports geo replications with a 15 min RTO
What is Azure Batch
Is a cloud service for job scheduling and computes resource management
Azure Monitor Data Collection Endpoint
Helps you setup the endpoint to which logs will be sent to. A data collection endpoint is connected to your log analytics workspace in the same region
Always Encrypted
Not even cloud administrators can see the data. The encryption and de-encryption is transparently handled by the client application by using keys managed by the application
TDE Encryption
Will not prevent cloud admins from seeing the data. This encryption works at the page level–this encrypts the entire database. This service does not allow encryption of specific columns like social security numbers for example
Azure Data Factory
Azure Data Factory is a managed cloud service that’s built for hybrid extract-transform-load (ETL), extract-load-transform (ELT), and data integration projects.
Azure Entra Enterprise Application
This is a service that integrates your on-prem apps with Azure Entra. This provides an identity solution for these on-prem apps.
Azura Entra Application Proxy
(Used to be called Azure AD application proxy)
The proxy makes your on-prem web apps accessible to users outside your corp network (off network). A connector is downloaded and installed on a on-prem server
What is SQL Edge
Is basically used for IOT devices–its basically a scaled down version of SQL for receiving data from IOT devices
What is Azure Bicep
Is the more streamlined version of an arm template–you create the template in bicep and then its converted to json template
SQL Managed Instance Features
- Supports user initiated backups
- Supports multiple automictically replicated instances across Azure regions
- Minimizes admin effort
- Also uses auto failover groups
User Delegated Shared Access Signature for block blobs
- Maximize security
- Prevents the use of shared access keys
- Supports time-limited access to storage accounts storing block blobs
You need to maximize security for file shares- limited time access and prevent key sharing
Azure AD creds