DP-900 · Question #269
Which language is used to define queries in Azure Synapse Data Explorer?
The correct answer is C. KQL. Azure Synapse Data Explorer is optimized for log and telemetry analytics and uses Kusto Query Language (KQL) to query data. KQL is a read-only query language designed for fast exploration of large datasets.
Question
Options
- ABash
- BPowerShell
- CKQL
- DSQL
How the community answered
(37 responses)- B3% (1)
- C92% (34)
- D5% (2)
Why each option
Azure Synapse Data Explorer is optimized for log and telemetry analytics and uses Kusto Query Language (KQL) to query data. KQL is a read-only query language designed for fast exploration of large datasets.
Bash is a Unix shell scripting language used for system administration tasks and is not a query language for Azure Synapse Data Explorer.
PowerShell is a scripting and automation language used for managing Azure resources via CLI, not for querying data within Synapse Data Explorer.
KQL (Kusto Query Language) is the native query language for Azure Synapse Data Explorer and Azure Data Explorer. It is purpose-built for time-series and log analytics workloads, using a pipe-based syntax to filter, aggregate, and visualize data efficiently at scale.
SQL is used in Azure Synapse Analytics dedicated and serverless SQL pools, but not in the Data Explorer pool, which exclusively uses KQL.
Concept tested: KQL query language for Azure Synapse Data Explorer
Source: https://learn.microsoft.com/en-us/azure/synapse-analytics/data-explorer/data-explorer-overview
Topics
Community Discussion
No community discussion yet for this question.