QuestionQ84
VerifiedMonitor, configure, and optimize database resourcesHOTSPOT –
You are creating a database in an Azure Synapse Analytics serverless SQL pool. You have data held in Parquet files in an Azure Data Lake Storage Gen2 container. The records are structured as shown in the following sample.

The records have no more than two applicants. You need to create a table that contains only the address fields.
How should you complete the Transact-SQL statement?
Select
applications WITH ( LOCATION = 'applications/', DATA_SOURCE = applications_ds, FILE_FORMAT = applications_file_format ) AS SELECT id, [address_housenumber] as addressnumber, [address_line1] as addressline1 FROM (BULK 'https://contoso1.dfs.core.windows.net/ applications/year=*/*.parquet', FORMAT = 'PARQUET') AS [r] GO
Community Discussion