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.
Question
Options
- ABlob Storage
- BData Lake Analytics
- CAzure SQL Database
- DCosmos DB
How the community answered
(32 responses)- A3% (1)
- B91% (29)
- C6% (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.
Blob Storage is an object storage solution for unstructured data, primarily used for data storage, not for querying and transforming data for insights.
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.
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.
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.