Exam AZ-305 topic 2 question 32 discussion

Data Lake Analytics does not work with ADLS Gen2 and it will be retired on February 29, 2024. So I support the answer for Data Explorer + KQL. https://learn.microsoft.com/en-us/azure/data-lake-analytics/data-lake-analytics-overview

Sept 24 2023 Data Explorer + KQL This is my own research & logic (Google + my brain), not a ChatGPT answer. I haven't taken the exam yet. The scenario criteria maps directly to Data Explorer “Decision Criteria” & tree in this link: When to use Data Explorer https://learn.microsoft.com/en-us/training/modules/intro-to-azure-data-explorer/4-when-to-use-azure-data-explorer The scenario does not include anything that prevents the use of DE based on that link & Data Explorer CAN scale to PB (it's a big data platform) The scenario doesn’t specifically say “real-time” or say what’s producing the data, but ingesting/storing PBs of data + interactive analytics ... to me that means "streaming + real-time analytics". and KQL (Kusto Query Language) because that's the query language for Data Explorer

Azure Data Lake Analytics will be discontinued after February 29th, 2024. Microsoft has officially retired the service, and users will not be able to provision new instances.

Azure Data Explorer for box 1 and KQL for box 2

This question appeared in the exam, August 2024, I gave the answer Azure Data Explorer for box 1 and answered KQL for box 2. I scored 870

I think the answer is correct. U-SQL (Unified Structured Query Language) is a query language developed by Microsoft for large-scale distributed and parallel data processing. It combines the familiarity and ease of use of SQL with the ability to handle structured and unstructured data. U-SQL is designed to work in big data environments like Azure Data Lake Analytics, enabling developers and analysts to write powerful queries that efficiently process data from multiple sources and formats.

Azure Data Explorer: Highly optimized for real-time and ad-hoc data exploration, especially for large volumes of data. KQL: The primary query language for Azure Data Explorer, offering powerful and efficient querying capabilities.

I would go for 1. Data Explorer as meets the requirements and built for it 2. KQL Azure Data Explorer (ADX) is a fast and highly scalable data exploration and analytics service that is designed to ingest, analyze, and visualize large volumes of structured and unstructured data in real-time. ADX provides a powerful query language that allows users to perform ad-hoc analysis and explore large datasets quickly. It is commonly used for log analytics, IoT telemetry data analysis, and other real-time analytics use cases.

Final Answer: 1. Data Explorer 2. KQL

Answer: Data Explorer + KQL https://learn.microsoft.com/en-us/azure/data-explorer/data-explorer-overview#when-should-you-use-azure-data-explorer When should you use Azure Data Explorer? Use the following questions to help decide if Azure Data Explorer is right for your use case: Interactive analytics: Is interactive analysis part of the solution? For example, aggregation, correlation, or anomaly detection. Variety, Velocity, Volume: Is your schema diverse? Do you need to ingest massive amounts of data in near real-time? Data organization: Do you want to analyze raw data? For example, not fully curated star schema. Query concurrency: Will multiple users or processes use Azure Data Explorer? Build vs Buy: Do you plan on customizing your data platform?

Analytics: Azure Data Explorer + KQL Azure Data Explorer provides interactive analytics. It allows you to examine structured, semi-structured, and unstructured data with improvised, interactive, fast queries4. You can use Azure Data Explorer Web UI, web client for Azure Data Explorer, or Kusto.Explorer, a rich windows client for Azure Data Explorer. To connect to your Azure Data Explorer cluster, you can use Jupyter notebooks, Spark connector, any TDS-compliant SQL client, and JDBC and ODBC connections

ASKED% IMPORTant

Data Lake Analytics doesn't work with Azure Data Lake Storage Gen2 yet until further notice. https://learn.microsoft.com/en-us/azure/data-lake-analytics/data-lake-analytics-overview#works-with-all-your-azure-data

Right answer, Azure Data Lake Analytics with U-SQL. "Data Lake Analytics dynamically provisions resources and lets you do analytics on terabytes to petabytes of data." "Data Lake Analytics includes U-SQL, a query language that extends the familiar, simple, declarative nature of SQL with the expressive power of C#." https://learn.microsoft.com/en-us/azure/data-lake-analytics/data-lake-analytics-overview Data Explorer is not an answer because it can only elastically scale to terabytes of data.

Data Lake Analytics will soon be retired so I guess this question will be removed from the exam but. Language for Data Lake Analytics is U-SQL. https://learn.microsoft.com/en-us/azure/data-lake-analytics/data-lake-analytics-overview