Exam DP-900 topic 1 question 254 discussion

Actual exam question from Microsoft's DP-900

Question #: 254
Topic #: 1

DRAG DROP
-

Match the data processing languages to the appropriate real-time analytics services.

To answer, drag the appropriate language from the column on the left to its service on the right. Each language may be used once, more than once, or not at all.

NOTE: Each correct match is worth one point.

Show Suggested Answer

Suggested Answer:

by _lene_ at Feb. 13, 2023, 5:16 p.m.

Comments

Submit Cancel

tangerine141

Highly Voted 1 year, 9 months ago

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.

upvoted 12 times

...

AIEngineer1

Most Recent 1 day, 14 hours ago

after a quick research: KQL SQL Can be (SQL) and (Python) but i go with SQL

upvoted 1 times

...

tczubat

7 months ago

what is the answer?

upvoted 2 times

...

Yomzie

10 months, 1 week ago

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

upvoted 1 times

...

Mega2

10 months, 1 week ago

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.

upvoted 1 times

...