Synapse and ADF Copy Activity Internals In Azure Data Factory (ADF), the maximum number of concurrent connections for a copy activity depends on the type of source and sink data stores you are using. The maximum number of concurrent connections is determined by the data store's capabilities and limitations. For example, if you are copying data from an on-premises SQL Server database to an Azure SQL Database, the maximum number of concurrent connections is determined by the SQL Server's maximum number of concurrent connections and the Azure SQL Database's maximum number of concurrent connections. In Azure Synapse Analytics, the maximum number of concurrent connections for a copy activity is determined by the number of concurrent queries you have configured for your service. By default, the maximum number of concurrent queries is set to 32 Performance : 1. Increase you max number of concurrent connections
Posts
Azure Data Engineer Interview Questions
- Get link
- X
- Other Apps
azure databricks and ADf , Synapse questions 1. What is the difference between narrow and wide transformation 2. Explain the archtitecture of pyspark 3. Can we execute notebook activity in adf, can we pass parameters to it 4 Do you know autoloader, and structured streaming 5. What is delta tables, how do they work 6. How do we create delta tables in serverless pool and powerbi users can access it 7. what is integration runtime, where can we install it 8. Can we use SHIR inside mapping data flow 9 How do you connect to on premise source from ADF 10. How to create a pipeline that fetches data from two databases from two different schema , two tables 11. How can you load a huge table from SQL server in ADF activity 12. How to do SCD type 2 using ADF 13. Difference between type 2 and type 3 SCD 14 Read a csv file, Create a delta table using pyspark 15. Join two datasets in Pypark 16. SQL Query question on Window functions 17, Read a csv file, skip 5 rows of it, create schema man...