DP-600 - Prepare Data - Section 2.7
Select, filter, and aggregate data using the Visual Query Editor and SQL against the SQL analytics endpoint.
Write T-SQL SELECT statements using WHERE, JOIN, and GROUP BY aggregation against the SQL analytics endpoint to retrieve and summarise data. Use the Visual Query Editor as a no-code alternative and recognise when each tool is appropriate based on user skill and query complexity.
Visual Query EditorT-SQLSQL analytics endpointGROUP BY aggregationresult set filtering
More in this domain
Back to all Prepare Data objectives, or the DP-600 cert hub.
Examworthy is not affiliated with or endorsed by Microsoft. Original, blueprint-aligned practice material only.