Week 1 What is Cloud?
what is dedicated SQL pool (azure data warehousing)? Very imp
Download 2.55 Mb.
|
| what is dedicated SQL pool (azure data warehousing)? Very imp
Azure Synapse Analytics is an analytics service that brings together enterprise data warehousing and Big Data analytics. Dedicated SQL pool (formerly SQL DW) refers to the enterprise data warehousing features that are available in Azure Synapse Analytics. what is service principle id? Very imp Service Principal is an application within Azure Active Directory whose authentication tokens can be used as the client_id, client secret, and tenant_id. If we are trying to access ADLS then we need to setup service principle id. what is managed identity access? Very imp When creating a data factory, a managed identity can be created along with factory creation. The managed identity is a managed application registered to Azure Active Directory, and represents this specific data factory. Managed identity for Data Factory benefits the following features: Store credential in Azure Key Vault, in which case data factory managed identity is used for Azure Key Vault authentication. Connectors including Azure Blob storage, Azure Data Lake Storage Gen1, Azure Data Lake Storage Gen2, Azure SQL Database, and Azure Synapse Analytics. Web activity. what is external tables and have you used? Very imp An external table points to data located in Hadoop, Azure Storage blob, or Azure Data Lake Storage. External tables are used to read data from files or write data to files in Azure Storage. With Synapse SQL, you can use external tables to read and write data to dedicated SQL pool or server less SQL pool. what is polybase and what is the use of it? Very imp PolyBase is a technology that accesses external data stored in Azure Blob storage, Hadoop, or Azure Data Lake Store via the Transact-SQL language. PolyBase is the fastest and most scalable way to load data. PolyBase can read data from several file formats and data sources. Download 2.55 Mb. Share with your friends:
|