HOTSPOT
-
You have an Azure subscription that contains the resources shown in the following table.
The storage1 account contains a container named container1. The container1 container contains the following files.
In Pool1, you run the following script.
In the Built-in serverless SQL pool, you run the following script.
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
The answer is No, Yes, No It will ignore "_" and "."
Both Hadoop(dedicated) and native(serverless) external tables will skip the files with the names that begin with an underline (_) or a period (.).
No, No, No Because names that begin with an underline (_) or a period (.) are ignored and in the mentioned location, it will not be going to read subfolders, until '/**' is mentioned.
when you use DATA SOURCE to create an External Table you also use LOCATION (where you specified the relative path e.g. '/directory/**') https://learn.microsoft.com/en-us/sql/t-sql/statements/create-external-table-transact-sql?view=azure-sqldw-latest&tabs=dedicated#b-import-data-from-parquet-into-
No, Yes, No In serverless SQL pools must be specified /** at the end of the location path. In Dedicated pool the folders are always scanned recursively.
NO, YES, NO https://learn.microsoft.com/en-us/sql/t-sql/statements/create-external-table-transact-sql?view=azure-sqldw-latest&tabs=dedicated#location--folder_or_filepath-1
NO YES NO see previous quizs.
The last one is No. File is prefxied with a period and therefore can't be returned. https://learn.microsoft.com/en-us/sql/t-sql/statements/create-external-table-transact-sql?view=azure-sqldw-latest&tabs=dedicated#location--folder_or_filepath-1
NO YES NO
Both Hadoop and native external tables will skip the files with the names that begin with an underline (_) or a period (.)
No No No
Réponse trouvée : Non - Oui - Non. Lien de référence est : https://learn.microsoft.com/en-us/sql/t-sql/statements/create-external-table-transact-sql?view=azure-sqldw-latest&tabs=dedicated#location--folder_or_filepath-1
No, Yes, No