azure sql server vs synapse dedicated sql pool
Azure Synapse Dedicated SQL Pool Azure Synapse Dedicated SQL Pool (Previously Azure SQL Data Warehouse), a massively parallel processing database similar to other columnar-based scale-out database technologies such as Snowflake, Amazon Redshift, and Google BigQuery. To the end-user it is much like a traditional SQL Server, however, behind the scenes it distributes the storage and…
Copy and duplicate an Azure Analaysi Services cube with the same measures, calculations, etc
Steps:1) Configure storage settings2) backup the cube to the storage account location3) restore the cube with a different name(as you wants a duplicate cube here) from the storage location