Exam DP-900 topic 1 question 254 discussion

Azure Data Explorer: KQL (Kusto Query Language), which is a proprietary query language specifically designed for Azure Data Explorer. It is used to analyze and query large volumes of structured and unstructured data in real-time. Azure Stream Analytics: SQL, which is a standard query language for relational databases. It is used to analyze and process high-velocity, real-time streaming data from various sources, such as IoT devices, social media platforms, and other real-time data streams. Azure Synapse Analytics: SQL and Python. SQL is used to query and analyze structured data stored in Azure Synapse Analytics, while Python can be used for data preprocessing, machine learning, and other data science tasks.

what is the answer?

KQL: Azure Data Explorer SQL: Azure Stream Analytics SQL: Azure Synapse Analytics Azure Stream Analytics uses a SQL query language that's augmented with powerful temporal constraints to analyze data in motion. You can create a Stream Analytics job using the Azure portal. You can also create jobs by using developer tools such as the following ones: **VS Code **Visual Studio **Azure CLI **Azure PowerShell **Bicep **ARM templates **Terraform

KQL is associated with Azure Data Explorer. Python is supported by Azure Stream Analytics. SQL is used in Azure Synapse Analytics. 1_ KQL (Kusto Query Language): ((What is about )) KQL is specifically designed for querying and analyzing data in Azure Data Explorer (ADX). ADX is a powerful service for ingesting, storing, and analyzing large volumes of data in real-time. 2_Python: ((Why?)) Python is a popular general-purpose programming language known for its readability and extensive libraries. It is widely used for data science, machine learning, and analytics. Azure Stream Analytics supports Python as a language for writing custom user-defined functions (UDFs) and enriching real-time data streams. 3_SQL (Structured Query Language): ((Of curse)) SQL is the standard language for managing and querying relational databases. It is commonly used for data manipulation and reporting. Azure Synapse Analytics (formerly known as SQL Data Warehouse) provides a powerful SQL-based analytics platform for both real-time and batch processing.

A. KQL B. SQL C. SQL

Was on exam 24/6/2023

Azure Synapse offers a choice of several languages such as SQL, Python, .NET, Java, Scala and R, so not sure what's the answer for the last one...