Preparing Practice Exam…
Please wait a moment while the system generates the exam questions, answers, and study session.
Please wait a moment while the system generates the exam questions, answers, and study session.
Microsoft Certified: Fabric Data Analytics Engineer Associate · Microsoft
Select one answer.
Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.
| Requirement | Query implementation | | -------------------------- | ----------------------------------------- | | Return only Sands End | `Neighbourhood == "Sands End"` | | No_Bikes at least 15 | `No_Bikes >= 15` | | Sort ascending by No_Bikes | `sort by No_Bikes` (ascending is default) | | Return selected columns | `project ...` |
| Requirement | Query implementation | | -------------------------- | ----------------------------------------- | | Return only Sands End | `Neighbourhood == "Sands End"` | | No_Bikes at least 15 | `No_Bikes >= 15` | | Sort ascending by No_Bikes | `sort by No_Bikes` (ascending is default) | | Return selected columns | `project ...` |
The table in the requirements is written with first capital letters of the two words Bike_Location while in the KQL script in the question itself it is bike_location. According to the Kusto documentation "Identifiers are case-sensitive. For example, you can't refer to a table called ThisTable as thisTABLE." https://learn.microsoft.com/en-us/kusto/query/schema-entities/entity-names?view=azure-data-explorer&preserve-view=true#reference-identifiers-in-queries