Exam DP-203 All Questions

View all questions & answers for the DP-203 exam

Exam DP-203 topic 1 question 91 discussion

Actual exam question from Microsoft's DP-203

Question #: 91
Topic #: 1

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.

Show Suggested Answer

Suggested Answer:

by g2000 at Aug. 2, 2023, 1:59 p.m.

Comments

Submit Cancel

pramod4lk

Highly Voted 1 year, 11 months ago

The answer is No, Yes, No It will ignore "_" and "."

upvoted 54 times

...

pc1337xd

Highly Voted 1 year, 11 months ago

Both Hadoop(dedicated) and native(serverless) external tables will skip the files with the names that begin with an underline (_) or a period (.).

upvoted 12 times

...

AMJB

Most Recent 4 months ago

NO YES NO You can't read hidden files on both hadoop and native query tables . i.e _xxxx or .xxxxx will be hidden

upvoted 2 times

...

CezarioAbrantesPP

1 year ago

Both Hadoop and native external tables will skip the files with the names that begin with an underline (_) or a period (.)

upvoted 1 times

...

Dusica

1 year, 2 months ago

No No No

upvoted 2 times

...

shadow2332

1 year, 5 months ago

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.

upvoted 6 times

5a939c2

11 months, 4 weeks ago

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.

upvoted 3 times

...

lcss27

1 year, 3 months ago

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-

upvoted 1 times

...

moize

1 year, 6 months ago

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

upvoted 1 times

...

hcq31818

1 year, 7 months ago

No, Yes, No

upvoted 1 times

...

AvSUN

1 year, 10 months ago

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

upvoted 5 times

...

kkk5566

1 year, 10 months ago

NO YES NO see previous quizs.

upvoted 4 times

...

subhraz

1 year, 10 months ago

NO YES NO

upvoted 3 times

...

g2000

1 year, 11 months ago

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

upvoted 4 times

...