ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam DP-203 All Questions

View all questions & answers for the DP-203 exam
Go to Exam

Exam DP-203 topic 1 question 68 discussion

Actual exam question from Microsoft's DP-203
Question #: 68
Topic #: 1
[All DP-203 Questions]

HOTSPOT
-

You have an Azure Data Lake Storage Gen2 account that contains a container named container1. You have an Azure Synapse Analytics serverless SQL pool that contains a native external table named dbo.Table1. The source data for dbo.Table1 is stored in container1. The folder structure of container1 is shown in the following exhibit.



The external data source is defined by using the following statement.



For each of the following statements, select Yes if the statement is true. Otherwise, select No.

NOTE: Each correct selection is worth one point.

Show Suggested Answer Hide Answer
Suggested Answer:
by ZIMARAKI at Jan. 13, 2023, 11:19 a.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
shoottheduck
Highly Voted 2 years, 5 months ago
I have just tested this on Synapse Serverless: ./Folder3 AND _mydata4.csv were ignored. Therefor; Yes, No, No
upvoted 97 times
HUSSAIN_ALYAFEI
7 months ago
For sure the corrected answers are: - YES ✅ - NO ✅ - NO ✅ EXPLAIN: Recursive Wildcard (/**): The wildcard at the end (/**) means all files in /folder1 and its subfolders will be included. Hidden Files and Folders: Files or folders starting with . (e.g., .folder3) or _ (e.g., _mydata4.csv) are ignored by Synapse serverless SQL pool. Files Included: 1. /folder1/mydata.csv → Included 2. /folder1/folder2/mydata2.csv → Included 3. /folder1/.folder3/mydata3.csv → Ignored (starts with a dot .). 4. /folder1/_mydata4.csv → Ignored (starts with an underscore _). Final Answer: The query will return mydata.csv and mydata2.csv only.
upvoted 9 times
...
RMK2000
7 months ago
thanks, and did you try it with a native external table ?
upvoted 1 times
...
tlb_20
1 year, 3 months ago
I think it should be: 1 - NO: It would be needed to specify the "/**" option to traverse folders: https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/query-folders-multiple-csv-files 2 - NO: since it's a hidden folder: https://learn.microsoft.com/en-us/sql/t-sql/statements/create-external-table-transact-sql?view=sql-server-ver16&tabs=dedicated Not sure if this documentation is well suited... 3 - NO: It starts with "_": Same link as question 2
upvoted 2 times
...
MuruAzure
2 years, 4 months ago
its not ./Folder3 . it is /.Folder3 still ignored?
upvoted 5 times
VikkiC
2 years, 1 month ago
Folder or file that starts with . or _ Reference documentation: 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
upvoted 26 times
AvSUN
1 year, 11 months ago
Thanks for the link
upvoted 1 times
...
darkraijin
1 year, 10 months ago
Its same for AD credz of team members / brass that get das-boot at work. Recent times seeing a whole lotta " _ " lol. Trying to exit hence here before catching " _ "
upvoted 1 times
...
...
...
...
PGiagkoulas
Highly Voted 2 years, 6 months ago
1.Yes, 2.Yes: "Unlike Hadoop external tables, native external tables don't return subfolders unless you specify /** at the end of path" which is the case here. 3. No: "Both Hadoop and native external tables will skip the files with the names that begin with an underline (_) or a period (.)", refers to files, not directories, so the last file with the underscore will be exluded. https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/develop-tables-external-tables?tabs=hadoop#arguments-create-external-table
upvoted 47 times
matiandal
2 years, 1 month ago
ένα like για το nickname ;-)
upvoted 3 times
...
Paulkuzzio
2 years, 1 month ago
@PGiagkoulas, read this link again : 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 See this part in the link: native external tables don't return subfolders unless you specify /** at the end of path. In this example, if LOCATION='/webdata/', a serverless SQL pool query, will return rows from mydata.txt. It won't return mydata2.txt and mydata3.txt because they're located in a subfolder. Based on this, the answer is Yes, No and No
upvoted 7 times
semauni
2 years ago
But /** is specified at the end?
upvoted 4 times
dakku987
1 year, 7 months ago
yes thats why it will return the all folders
upvoted 1 times
...
...
...
...
8ac3742
Most Recent 8 months, 2 weeks ago
"Unlike Hadoop and PolyBase, serverless SQL pool doesn't return subfolders unless you specify /** at the end of path. Just like Hadoop and PolyBase, it doesn't return files for which the file name begins with an underline (_) or a period (.)." The answer is Yes, Yes, No
upvoted 1 times
...
mavdplas
8 months, 4 weeks ago
Yes, No, No If you specify LOCATION to be a folder, a PolyBase query that selects from the external table will retrieve files from the folder and all of its subfolders. Just like Hadoop, PolyBase doesn't return hidden folders. It also doesn't return files for which the file name begins with an underline (_) or a period (.). 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
upvoted 1 times
...
jarobdataeng
10 months, 1 week ago
yes-no-no -> https://learn.microsoft.com/en-us/sql/t-sql/statements/create-external-table-transact-sql
upvoted 1 times
...
uncledana
10 months, 1 week ago
Selected Answer is correct: 1) Yes 2) Yes 3) No Link: https://learn.microsoft.com/en-us/sql/t-sql/statements/create-external-table-transact-sql?view=sql-server-ver16&tabs=dedicated Link
upvoted 1 times
...
34c89bf
1 year ago
All should be No, Since we cannot provide ** in data source , it should be there in external table.
upvoted 1 times
...
dgerok
1 year, 3 months ago
you can use a wildcard character (*) in the path to reference multiple files within a directory. However, the wildcard character should not be used consecutively. You will get an error message trying to select data from the external table: Consecutive wildcard characters present in path '<data_source_location>/container1/*'. So, I suppose, all the answers should be NO
upvoted 1 times
...
Nitin9in
1 year, 5 months ago
YES,NO,NO The "." and "-" are hidden. The native external tables and Hadoop external tables won't return anything from hidden folders. https://learn.microsoft.com/en-us/sql/t-sql/statements/create-external-table-transact-sql?view=azure-sqldw-latest&preserve-view=true&tabs=dedicated
upvoted 7 times
...
rocky48
1 year, 5 months ago
Yes, No, No. /.Folder 3 2ill be ignored because it is a hidden folder and _mydata4.csv will also be ignored because it is a hidden file
upvoted 1 times
...
be8a152
1 year, 6 months ago
Yes, No, No. /.Folder 3 2ill be ignored because it is a hidden folder and _mydata4.csv will also be ignored because it is a hidden file
upvoted 2 times
...
Joanna0
1 year, 6 months ago
Y - Visible / N - Hidden Folder / N - Hidden File https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/design-guidance-for-replicated-tables
upvoted 2 times
...
blazy001
1 year, 7 months ago
yes, no, no >> Both Hadoop and native external tables will skip the files with the names that begin with an underline (_) or a period (.).
upvoted 2 times
...
Lscranio
1 year, 8 months ago
Yes / No / 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
upvoted 2 times
...
ellala
1 year, 10 months ago
In my opinion YES NO NO from this doc: 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
upvoted 5 times
...
Chemmangat
1 year, 10 months ago
Yes, No, No Anything that starts with '_' or '.' will be ignored. And if you are having a doubt that files are in the form of /.{name_of_folder}, Note that these are folders and '/' is used for representing the folders. Pretty basic thing, but hope it helps someone.
upvoted 4 times
...
hassexat
1 year, 11 months ago
YES / NO / NO
upvoted 1 times
...
Load full discussion...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel