KQL Database Query Basics for Fabric Data Engineers

Submit

2. In Microsoft Fabric, which statement best describes the role of KQL in data querying?

KQL is used only for data visualization

KQL enables flexible querying and analysis of structured and unstructured data

KQL replaces SQL entirely in Fabric

KQL is limited to administrative tasks only

Submit

4. What is the correct way to write a case-insensitive string comparison in KQL?

== (ignorecase)

=~ operator

LIKE operator

Contains operator

Submit

6. Which KQL operator allows you to rename columns in query results?

Rename

Alias

Project

Extend

Submit

8. What does the 'union' operator accomplish in KQL?

Merges results from multiple queries

Combines columns from two tables

Filters duplicate records

Joins tables on matching keys

Submit

10. Which comparison operator is used to check if a value exists in a list in KQL?

Contains

In

Exists

Matches

11. What does KQL stand for in the context of Microsoft Fabric?

Kusto Query Language

Kernel Query Logic

Key Query Library

Knowledge Query Layer

12. What is the purpose of the 'distinct' operator in KQL?

Removes duplicate rows

Filters by unique values

Sorts data uniquely

Identifies distinct tables

13. Which operator limits the number of rows returned by a KQL query?

Top

Limit

Take

Restrict

Submit

15. What does the 'extend' operator do in KQL?

Removes columns from results

Creates new calculated columns

Filters rows based on conditions

Joins two tables together

Submit

17. Which KQL operator groups rows by one or more columns and applies aggregation functions?

Partition

Group

Summarize

Aggregate

18. What is the correct syntax to sort results in descending order in KQL?

Sort by column

Order by column desc

Sort by column desc

Order column descending

Submit

20. Which operator is used to filter rows in a KQL query that match a specific condition?

Select

Where

Filter

Match

Fabric Data Engineer KQL Database Query Basics Quiz

1. The ____ function calculates the average value of a numeric column in KQL.

2.

What first name or nickname would you like us to use?

2. In Microsoft Fabric, which statement best describes the role of KQL in data querying?

3. The ____ operator in KQL is used to apply transformations to the result set in a pipeline.

4. What is the correct way to write a case-insensitive string comparison in KQL?

5. In KQL, the ____ function returns the minimum value from a numeric column.

6. Which KQL operator allows you to rename columns in query results?

7. The ____ function returns the maximum value in a column during aggregation in KQL.

8. What does the 'union' operator accomplish in KQL?

9. In KQL, the ____ operator is used for pattern matching with wildcards in string comparisons.

10. Which comparison operator is used to check if a value exists in a list in KQL?

11. What does KQL stand for in the context of Microsoft Fabric?

12. What is the purpose of the 'distinct' operator in KQL?

13. Which operator limits the number of rows returned by a KQL query?

14. In KQL, the ____ operator combines rows from two tables based on matching column values.

15. What does the 'extend' operator do in KQL?

16. The ____ function in KQL counts the number of rows in a group.

17. Which KQL operator groups rows by one or more columns and applies aggregation functions?

18. What is the correct syntax to sort results in descending order in KQL?

19. In KQL, the ____ operator is used to retrieve specific columns from a table.

20. Which operator is used to filter rows in a KQL query that match a specific condition?