Messaging services

 Application needs to listen and process events that are emitted from other Azure Services.

we can use the Azure Event Grid  ( messaging service ).

provide on-premises storage that has built-in replication to azure.

 Azure StorSimple replicated to Azure Blob Storage.

Add SQL managed instance to a failover group

 How to configure ? 

For two managed instances to participate in a failover group, there must be either expressroute or a gateway configured between the virtual networks of the two managed instances to allow network communication.

https://docs.microsoft.com/en-us/azure/azure-sql/managed-instance/failover-group-add-instance-tutorial?tabs=azure-portal#4---create-a-primary-gateway

storage accounts will generate storage ATP alerts

 Storage Threat Detection is available for the Blob Service.

how to identify underutilized resources ?

 Advisor helps you optimize and reduce your overall Azure Spend by identifying idle and underutilized resources. You can get cost recommendations from the cost tab on the advisor dashboard.

What is IntegrationRuntime in Data Factory ?

 The Integration Runtime ( IR ) is the compute infrastructure used by Azure Data Factory to provide data integration capabilities across different network environments. Azure SSIS  integration Runtime ( IR ) in Azure Data Factory ( ADF ) supports running SSIS  packages.

S

What are the plan available in Azure Functions ?

 When you create a function app in Azure, you must choose a hosting plan for your app.

There are three basic hosting plan available for Azure Functions:

Consumption plan

Premium Plan 

Dedicated ( App Service Plan )

For the Consumption plan, you dont have to pay for idle VMs or reserve capacity in advance Connect to private endpoints with Azure Functions.

We can also integrate with the existing resources and it could be databases, file storage, message queues or event streams or Rest APIs 

How to authenticate using third-party OAuth 2.0 identity management to authenticate its users

 Company A implements several Azure logic apps that have HTTP triggers: The logic apps provide access to an on-premises web service 

A company establishes partnership with B company 

Company B does not have an existing azure active directory ( AAD ) tenant and uses third-party OAuth 2.0 identity management to authenitcate its users.

preferred azure service, Azure API Management 

( what is Azure API Management Service ? )

API Managment helps organizations publish APIs to external, partner and internal developers to unlock the potential of their data and services.

You can secure API management using the OAuth 2.0 client credentials flow.

what are the activities performed by Azure Data Factory

 A data factory can have one or more pipelines. A pipeline is a logical grouping of activities that together perform a task.

The activities in a pipeline define actions to perform on your data.

Data Factory has three groupings activities : data movement activities , data transformation activities,  and control activities.

Azure Functions is now integrated with Azure Data Factory, allowing you to run an Azure Function as a step in your data factory pipelines.

https://docs.microsoft.com/en-us/azure/data-factory/concepts-pipelines-activities

Azure file shares based on their user account or their group membership

 Azure Filessupports identity-based-authentication over Server Message Block ( SMB ) 

through two types of domain services :

 On-prem Active Directory Domain Services ( AD DS ) and 

Azure Active Directory Domain Services ( Azure AD DS ).

What is Azure Policy ?

 Azure Policy evaluates resources in Azure by comparing the properties of those resources to business rules. Once your business rules have been formed, the policy definition or intiative is assigned to any scope of resources that Azure supports, such as management groups, subscriptions, resource groups or individual resources.

how to identify that take a long time to execute.

 Query Performance Insight provides intelligent query analysis for single and pooled databases. It helps identify the top resource consuming and long-running queries in your workload. This helps you find the queries to optimize to improve overall workload performance and efficiently use the resource that you are paying for.

https://docs.microsoft.com/en-us/azure/azure-sql/database/query-performance-insight-use

workflow of the data across the azure services

 Automate data movement  using Azure Data Factory, then load data into Azure Data Lake Storage, transform and clean it using Azure Databricks, and make it available for analytics using Azure Synapse Analytics. Modernize your data warehouse in the cloud for unmatched levels of data.

Note:

Integrate data silos with Azure Data Factory, a service built for all data integration needs and skill levels. Easily construct ETL and ELT processes code-free within the intuitive visual environment, or write your own code. Visually integrate data sources using more than 90+ natively built and maintainance-free connectors at no added cost. 

Focus on your data-the serverless integration service does the rest.

Transform the data by using mapping data flow

 For example, if you want to transfer the data files from Azure Storage to Azure Data Lake Storage.

we can use Copy Activity in Azure Data Factory to copy data from and to Azure Data Lake Storage Gen2 and use Data flow to transform data in Azure Data Lake Storage Gen2.