nerdexam
Microsoft

DP-500 · Question #70

Changing the source to use AzureStorage.DataLake will reduce the load time of the query. Select Yes if the statement is true. Otherwise, select No.

The correct answer is A. Yes. Switching the data source connector to AzureStorage.DataLake will reduce query load times due to its optimized architecture for analytical workloads.

Implement and manage a data analytics environment

Question

Changing the source to use AzureStorage.DataLake will reduce the load time of the query. Select Yes if the statement is true. Otherwise, select No.

Options

  • AYes
  • BNo

How the community answered

(40 responses)
  • A
    93% (37)
  • B
    8% (3)

Why each option

Switching the data source connector to `AzureStorage.DataLake` will reduce query load times due to its optimized architecture for analytical workloads.

AYesCorrect

`AzureStorage.DataLake` is designed for Azure Data Lake Storage Gen2, which offers significant performance advantages for analytical queries and large datasets compared to traditional Azure Blob Storage connectors, by reducing latency and increasing throughput for data retrieval.

BNo

Not using `AzureStorage.DataLake` or a similar ADLS Gen2 connector for analytical workloads often results in slower performance due to the flat namespace and less optimized access patterns of standard blob storage.

Concept tested: Azure Data Lake Storage Gen2 performance benefits

Source: https://learn.microsoft.com/en-us/azure/storage/blobs/data-lake-storage-introduction

Topics

#Azure Data Lake Storage#Data source optimization#Query performance#Data loading

Community Discussion

No community discussion yet for this question.

Full DP-500 Practice