Top Azure Synapse frequently asked interview questions.

In this post we will look at Azure Synapse Interview questions. Examples are provided with explanations.

1. What is Azure Synapse?
2. What are the components consisted by Azure Synapse?
3. What is Azure Synapse Analytics?
4. What Azure Data Services are connected by Azure Synapse?
5. What are the Key Service Capabilities provided by Azure Synapse?
6. What is the process of Data Warehouse?
7. What are the Query options in Azure Synapse Analytics?
8. Can we connect Power BI?
9. How does one insert Synapse DW in SSMS?
10. What to create date dimension in Azure synapse Analytics?

What is Azure Synapse?

Azure Synapse helps by providing single services for the workload while processing, serving and managing all the data for immediate business intelligence and for data protection needs.Azure Synapse also provides us in handling queries of huge amount of information on demand serverless for the data exploration and provisioned resources at scale.

What are the components consisted by Azure Synapse?

Components consisted by Azure Synapse are SQL Analytics, Apache Spark, Data Integration and Studio.

What is Azure Synapse Analytics?

Azure Synapse Analytics helps in bringing together Data Integration, Big Data Analytics and Enterprise Data Warehousing.Synapse Analytics also gives us the freedom to query data on our terms and using serverless and dedicated resources at scale.It also gives an experience in ingesting, exploring, preparing, managing and serving data for immediate Machine Learning and BI.

What Azure Data Services are connected by Azure Synapse?

Azure Data Services connected by Azure Synapse are as follows:
Azure Purview
Azure Machine Learning
Microsoft PowerBI
Azure Data Lake
Azure Blob Synapse
Azure Active Directory

What are the Key Service Capabilities provided by Azure Synapse?

Key Service Capabilities provided by Azure Synapse:

• Unified Analytics Platform - helps in performing data integrating, data explorating, data warehousing and machine learning from a single Unified Environment.
• Serverless and Dedicated Options - helps in supporting Data Warehouse and Lake in using cases abd in choosing most effective pricing option.
• Enterprise Data Warehousing - helps in building our mission critical data warehouse pn the foundation of the Industry's top performing SQL Engine.
• Data Lake Exploration - used in bringing relational and nonrelational data and query files in the data lake with the service we used in building data warehousing solutions.
• 
  

What is the process of Data Warehouse?

Data Warehouse helps in controlling and managing storagre and compute.It has flexible compute workload elasticity and also allows us in pausing the compute layer when we persist the data for reducing cost in a pay-as-you-go environment.

What are the Query options in Azure Synapse Analytics?

Azure Synapse Analytics has 3 compute options and has 4 types of storage that it can access.
The 3 compute options are:
Dedicated SQL Pool
Serverless SQL Pool
Apache Spark Pool

Can we connect Power BI?

Yes
Power BI supports queries with Azure Synapse and is not intended for large number of users or real time data.For optimizing Power BI performance we might consider using Power BI instead of Azure Analysis Services.

How does one insert Synapse DW in SSMS?

We can insert Synapse DW in SSMS by using the following command:

INSERT INTO dbo.countryCurrency
SELECT 'ABC', 'DEF', 'GHI'
UNION ALL
SELECT 'UVW', 'XYZ', 'LMNO'
UNION ALL
SELECT 'AB', 'CD', 'EF'
UNION ALL
SELECT 'CC', 'XX', 'FVF'
UNION ALL
SELECT 'TYH', '$', 'ASD'
-- ... etc

What to create date dimension in Azure synapse Analytics?

We can create date dimension by using the following command:

SELECT
        ...
INTO #tmp
FROM #month m
    CROSS JOIN #days d
WHERE d.days <= m.numberofdays


INSERT ourDateDim
SELECT * FROM #tmp

See Also
Spring Boot Interview Questions
Apache Camel Interview Questions
Drools Interview Questions
Java 8 Interview Questions
Enterprise Service Bus- ESB Interview Questions.
JBoss Fuse Interview Questions
Angular 2 Interview Questions