Exam DP-500 All Questions

View all questions & answers for the DP-500 exam

Exam DP-500 topic 1 question 48 discussion

Actual exam question from Microsoft's DP-500

Question #: 48
Topic #: 1

HOTSPOT -
You have an Azure Data Lake Storage Gen 2 container that stores more than 300,000 files representing hourly telemetry data. The data is organized in folders by the year, month, and day according to when the telemetry was captured.
You have the following query in Power Query Editor.

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 nbagchi at Dec. 13, 2022, 4:04 p.m.

Comments

Submit Cancel

eekman

Highly Voted 2 years, 5 months ago

1. No: the endpoint for HNS is dfs not blob. https://learn.microsoft.com/en-us/azure/storage/blobs/upgrade-to-data-lake-storage-gen2-how-to?tabs=azure-portal#migrate-data-workloads-and-applications 2. No 3. Yes

upvoted 19 times

...

nbagchi

Highly Voted 2 years, 6 months ago

I think the answers are correct. Check this: https://learn.microsoft.com/en-us/powerquery-m/azurestorage-datalake

upvoted 10 times

Chk88

2 years, 6 months ago

it is correct

upvoted 3 times

...

salvalcaraz

Most Recent 1 year, 6 months ago

1. Yes: I use ADLS Gen 2 blobs at work at it doest allow hierarchical namespaces. 2. No 3. Yes

upvoted 1 times

...

fireofsea

1 year, 10 months ago

I think answer is No Yes No

upvoted 1 times

fireofsea

1 year, 10 months ago

For in Editor uses "Table.AddColumn" and "TransformFiles" to load file data

upvoted 1 times

fireofsea

1 year, 10 months ago

Update No Yes Yes

upvoted 1 times

fireofsea

1 year, 10 months ago

if there is no funtion name in the script?

upvoted 1 times

fireofsea

1 year, 10 months ago

Sorry, Update No No Yes

upvoted 1 times

...

SamuComqi

1 year, 10 months ago

I took the exam a few days ago (14/8/2023) and I passed the exam with a score of 915. My answer was: - No - No - Yes

upvoted 3 times

...

AlanMont

2 years ago

I think the first one is "No" because HierarchicalNavigation is not an option for "AzureStorage.Blobs", see here: https://learn.microsoft.com/en-us/powerquery-m/azurestorage-datalake HierarchicalNavigation is an option for AzureStorage.Datalake: https://learn.microsoft.com/en-us/powerquery-m/azurestorage-datalake

upvoted 6 times

...