Exam DP-500 topic 1 question 46 discussion

it says: query all folders and subfolders, hence /** . https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/query-folders-multiple-csv-files#traverse-folders-recursively

Correct answer is BULK 'csv/taxi/**' : although 'csv/taxi/*.csv' also works (tested it), the file extension is not specified. It can be the case that the files are .txt files but still in CSV format. and FIRSTROW=2: you need to skip the headers (tested it). FIRSTROW=1 is the default value and will return the data including the headers.

BULK 'csv/taxi/**' FIRSTROW=2

1) https://mydatalake.blob.core.windows.net/data/files/**: All files in the files folder, and recursively its subfolders. 2) FIRSTROW=1 The FIRSTROW attribute isn't intended to skip column headers. Skipping headers isn't supported by the BULK INSERT statement. If you choose to skip rows, the SQL Server Database Engine looks only at the field terminators, and doesn't validate the data in the fields of skipped rows. https://learn.microsoft.com/en-us/training/modules/query-data-lake-using-azure-synapse-serverless-sql-pools/3-query-files https://learn.microsoft.com/en-us/sql/t-sql/statements/bulk-insert-transact-sql?view=sql-server-ver16

Serverless SQL pool can recursively traverse folders if you specify /** at the end of path. The following query will read all files from all folders and subfolders located in the csv/taxi folder. The answer is correct.

The answer is correct: https://mydatalake.blob.core.windows.net/data/files/file*.csv: All .csv files in the files folder with names that start with "file". Source: https://learn.microsoft.com/en-us/training/modules/query-data-lake-using-azure-synapse-serverless-sql-pools/3-query-files And it should be FIRSTROW = 2, because it has headers. In the example (follow the link below), you can see that when the file has now header then FIRSTROW = 1. Source: https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/develop-openrowset#read-specific-columns-from-csv-file In Source

Correct answer is BULK 'csv/taxi/**' and FIRSTROW=1

Correct answer is BULK 'adl://<your_adls_account_name>.dfs.core.windows.net/csv/taxi/',