Monthly Archives: March 2021

In the previous post, we discussed about Pipelines in Azure Synapse Analytics (Synapse Pipelines, for short). In today’s post, we are going to elaborate some of the major differences between Synapse Pipelines and Azure Data Factory Pipelines. S. No. Feature Azure Data Factory Azure Synapse Analytics 1. Using SSIS and SSIS Integration Runtime Yes NoContinue reading “Difference Between Synapse Pipelines and Azure Data Factory Pipelines”

If you are familiar with Azure Data Factory, then you must be familiar with the concept of activity orchestration through Azure Data Factory Pipelines. For a brief overview of Azure Data Factory pipelines, please have a look at this previous post. Synapse Analytics is positioned as the primary hybrid Data Warehousing and Big Data analyticsContinue reading “Pipelines in Azure Synapse Analytics”

1. Which index type should be used for increasing the performance of queries that use multiple fields? A. Range Index B. Spatial Index C. Composite Index D. None of the above 2. Which of the following is true for an Azure Stream Analytics Job in a “Degraded” state: A. The job is not processing anyContinue reading “ADE Q06: Cosmos DB, Azure Synapse Analytics and Stream Analytics Quiz”

Azure Synapse Link for Azure Cosmos DB provides seamless integration between Synapse Analytics and Cosmos DB. As we discussed in the previous post, the analytics workloads have evolved from the traditional structured data warehouse requiring ETL (Extract Transform Load) integration to a more flexible and semi-structured big data and multi format data analysis. Azure SynapseContinue reading “Azure Synapse Link for Cosmos DB”

In the previous post, we discussed about Dedicated SQL Pool in Azure Synapse Analytics. This post will focus on serverless SQL Pool in Synapse Analytics. Serverless SQL Pool is a SQL query service that comes built-in within Synapse Analytics. It enables users to query non-relational data sources without the need of underlying provisioned hardware orContinue reading “Serverless SQL Pool in Azure Synapse Analytics”

In this post, we are going to discuss about Dedicated SQL Pool (formerly known as SQL DW) in Azure Synapse Analytics. Microsoft launched Azure Synapse Analytics as a platform which reflects the changing analytics landscape. Today’s analytics workloads and requirements have evolved from the more traditional data warehousing concepts of nightly ETL (Extract Transform Load)Continue reading “Dedicated SQL Pool in Azure Synapse Analytics”