SqlPackage Extract for Synapse Dedicated SQL Pool - throws error SQL73068: Unsupported collation 'Latin1_General_100_CI_AS_SC_UTF8'

- SqlPackage or DacFx Version: 162.1.167.1
- .NET Framework (Windows-only) or .NET Core: 7.0.401
- Environment (local platform and source/target platforms): Windows 10 22H2

**Steps to Reproduce:**

1. Running SqlPackage from PowerShell to export dedicated SQL Pool to storage container (SQL Pool using UTF8 collation: Latin1_General_100_CI_AS_SC_UTF8 )
SqlPackage /Action:Extract /p:CompressionOption=NotCompressed /at:$access_token /SourceServerName:MY_SYNAPSE.sql.azuresynapse.net /SourceDatabaseName:MY_DedSQLPoolName /TargetFile:databaseschema.dacpac /p:AzureStorageBlobEndpoint=https://myBlob.blob.core.windows.net /p:AzureStorageContainer=myStorContainter /p:AzureStorageKey=myStorageKey

2. Getting the error after many lines of 'Processing Table.... ' lines :
~~~
SqlPackage : *** Error extracting database:
At line:4 char:1
SqlPackage /Action:Extract /p:CompressionOption=NotCompressed /at:$ac ...

CategoryInfo : NotSpecified: (*** Error extracting database::String) [], RemoteException
FullyQualifiedErrorId : NativeCommandError

Error SQL73068: Unsupported collation 'Latin1_General_100_CI_AS_SC_UTF8'.
~~~
And when run with /Diagnostic:true
~~~
Microsoft.Data.Tools.Diagnostics.Tracer Information: 25 : 2023-12-05T20:38:49 : Perf: Operation ended (name, details, elapsed in ms): Exporting data,,44793
Microsoft.Data.Tools.Diagnostics.Tracer Error: 19 : 2023-12-05T20:38:49 : Microsoft.SqlServer.Dac.DacServicesException:
Error SQL73068: Unsupported collation 'Latin1_General_100_CI_AS_SC_UTF8'.

Microsoft.Data.Tools.Diagnostics.Tracer Information: 25 : 2023-12-05T20:38:49 : Perf: Operation ended (name, details, elapsed in ms): Extracting schema,,354159
SqlPackage : *** Error extracting database:
At line:4 char:1
SqlPackage /Action:Extract /Diagnostics:true /p:CompressionOption=Not ...

CategoryInfo : NotSpecified: (*** Error extracting database::String) [], RemoteException
FullyQualifiedErrorId : NativeCommandError

Error SQL73068: Unsupported collation 'Latin1_General_100_CI_AS_SC_UTF8'.
~~~
**Did this occur in prior versions? If not - which version(s) did it work in?**
This is the first time I'm executing it.
(DacFx/SqlPackage/SSMS/Azure Data Studio)

Start at the SqlPackage Extract action and reproduce the failure against a Synapse dedicated SQL Pool using the Latin1_General_100_CI_AS_SC_UTF8 collation. Compare the normal and /Diagnostics:true runs around schema extraction and data export; done means the extraction completes without SQL73068.

Written by the indexing model from the issue text.