Dojo AZ-305 Flashcards
Does Azure file have an archive tier?
No
Azure Files also has no option to set blobs in the archive tier.
Can you set the default access tier to archive on a general purpose v2 storage account
No
you cant set the default access tier to archive on a general purpose v2 storage account–you can only pick hot or cool
What is Azure AD entitlement management
It leverages Azure AD business-to-business (B2B) functionality to facilitate access sharing and collaboration with external individuals who are not part of your organization. By utilizing Azure AD B2B, external users can authenticate through their home directory while also having a presence within your directory.
This representation in your directory enables you to assign access permissions to these external users, granting them the ability to access your organization’s resources.
What is Azure Functions Premium plan
The Functions Premium plan is the best option for the given scenario. It supports long-running functions and event-driven autoscaling. This means that the plan will automatically scale up as needed to handle the load, and it will scale down when the load is low.
This will help to ensure that the app is always available and that you are only paying for the resources that you need.
What is Azure Data Migration Assistant
The Data Migration Assistant (DMA) is an Azure tool designed to facilitate the migration of databases to Azure SQL.
It assesses on-premises SQL Server instances for migration, identifies any migration-blocking compatibility issues, detects partially supported or deprecated features, and offers comprehensive recommendations to resolve these issues.
Part of Azure Data Studio
Features of Azure SQL Business Critical/Premium Tier
The Business Critical service tier model is based on a cluster of database engine processes. This architectural model relies on a quorum of database engine nodes to minimize performance impacts on your workload, even during maintenance activities.
High availability is implemented using technology similar to SQL Server Always On availability groups. Every database is a cluster of database nodes with one primary replica that is accessible for customer workloads and three secondary replicas containing copies of data.
In addition, the Business Critical cluster has a built-in Read Scale-Out capability that provides a free-of-charge read-only replica used to run read-only queries (such as reports) that won’t affect the performance of the workload on your primary replica.
You need to establish a site-to-site VPN connection between the on-premises network and the Azure virtual network.
- Configure a connection.
- Configure a local network gateway.
- Configure a route-based VPN gateway.
What is the difference between azure service endpoint and private endpoint
A Service Endpoint remains a publicly routable IP address. A Private Endpoint is a private IP in the address space of the virtual network where the private endpoint is configured.
You have been assigned to design a highly available Azure SQL database. The solution should meet the following requirements:
– Zero data loss during failover
– Availability during zone outage
– Cost efficient
Which of the following options should you use?
Azure SQL Managed Instance
Note- this requires business critical/premium
Azure SQL Database Business Critical/premium does as well.
What is Azure SQL Failover Group
A failover group allows for all user databases within a managed instance to fail over as a unit to another Azure region in case the primary managed instance becomes unavailable due to a primary region outage.
Since failover groups for SQL Managed Instance contain all user databases within the instance, only one failover group can be configured on an instance.
Supports manual failover (customer managed) and automatic (Microsoft managed)
What is Azure SQL Geo-Replication
Active geo-replication is a feature that lets you create a continuously synchronized readable secondary database for a primary database.
The readable secondary database might be in the same Azure region as the primary, or, more commonly, in a different region
Note- Only supports manual failover
