nerdexam
Microsoft

AZ-900 · Question #253

You want to extract insights by querying and transforming data for which you would require an Azure big data solution. Identify which of the following do you think is the most appropriate tool to use.

The correct answer is B. Data Lake Analytics. Azure Data Lake Analytics is the most appropriate tool for an Azure big data solution focused on querying and transforming large datasets to extract insights.

Submitted by haru.x· Mar 5, 2026Describe Azure Architecture and Services

Question

You want to extract insights by querying and transforming data for which you would require an Azure big data solution. Identify which of the following do you think is the most appropriate tool to use.

Options

  • ABlob Storage
  • BData Lake Analytics
  • CAzure SQL Database
  • DCosmos DB

How the community answered

(32 responses)
  • A
    3% (1)
  • B
    91% (29)
  • C
    6% (2)

Why each option

Azure Data Lake Analytics is the most appropriate tool for an Azure big data solution focused on querying and transforming large datasets to extract insights.

ABlob Storage

Blob Storage is an object storage solution for unstructured data, primarily used for data storage, not for querying and transforming data for insights.

BData Lake AnalyticsCorrect

Azure Data Lake Analytics is an on-demand analytics job service designed for big data. It allows you to run massive parallel data transformation and processing programs over petabytes of data using U-SQL, R, Python, and .NET, making it ideal for extracting insights from large datasets.

CAzure SQL Database

Azure SQL Database is a relational database service designed for transactional workloads and structured data, not typically classified as a big data solution for massive-scale querying and transformation of diverse data types.

DCosmos DB

Cosmos DB is a globally distributed, multi-model database service, suitable for transactional and analytical workloads but generally not the primary choice for large-scale, batch data transformation and querying specifically for big data insights in the way Data Lake Analytics is.

Concept tested: Azure services for big data analytics and transformation

Source: https://learn.microsoft.com/en-us/azure/data-lake-analytics/data-lake-analytics-overview

Community Discussion

No community discussion yet for this question.

Full AZ-900 Practice