No matching guide sections
Change the search or section filter.
Study Guide preview
Unlock Pro for every DP-600 flashcard-note lesson.
Preview the beginning of Section 1. Pro includes the complete Study Guide by section, plus Course Notes, guided course access, and Pro downloads.
Unlock with Pro
Opens the DP-600 Practice Test purchase options.
Section 1
Select, filter, and aggregate by using Visual Query Editor, SQL, KQL, and DAX
Preview
Preview: Prepare data
Preview includes- 4 of 8 lesson topics
- 1 overview segment
- 3 core concepts
- 2 exam tips
Lesson Topics
- No-Code Warehouse Querying
- Data Selection
- Filtering
- Aggregation
Overview
This objective covers building warehouse queries using no-code tools like the Visual Query Editor, SQL, KQL, and DAX. The core task involves selecting, filtering, and aggregating data based on the provided data sources and transformations.
Core Concepts
- Visual Query Editor: A no-code canvas for constructing warehouse queries, supporting selection, joins, filters, and aggregations.
- SQL: Suitable for relational selection, joins, grouping, and creating reusable database objects within warehouses and SQL analytics endpoints.
- KQL: Optimized for fast exploration of event, log, and time-series data in Eventhouse and KQL databases.
Exam Tips
- Prioritize the no-code approach with Visual Query Editor whenever possible, especially for initial prototyping and simpler queries.
- When SQL is required, focus on relational selection, joins, and aggregations – the core strengths of SQL in the warehouse environment.
Section 1 continues in Pro.Unlock Pro to read the full Select, filter, and aggregate by using Visual Query Editor, SQL, KQL, and DAX lesson plus every remaining DP-600 Study Guide section.
Unlock with Pro
Section 2
Implement workspace, item, row, column, object, and file access controls
Pro
Implement workspace, item, row, column, object, and file access controls unlocks with Pro.Unlock Pro to read the full 2 topics flashcard-note study guide for this section.
Unlock with Pro
Section 3
Configure Git integration, PBIP projects, and deployment pipelines
Pro
Configure Git integration, PBIP projects, and deployment pipelines unlocks with Pro.Unlock Pro to read the full 3 topics flashcard-note study guide for this section.
Unlock with Pro
Section 4
Choose storage modes and implement star-schema relationships
Pro
Choose storage modes and implement star-schema relationships unlocks with Pro.Unlock Pro to read the full 6 topics flashcard-note study guide for this section.
Unlock with Pro
Section 5
Choose Fabric data stores and implement OneLake integration
Pro
Choose Fabric data stores and implement OneLake integration unlocks with Pro.Unlock Pro to read the full 5 topics flashcard-note study guide for this section.
Unlock with Pro
Section 6
Create connections, discover data, and choose ingestion or access
Pro
Create connections, discover data, and choose ingestion or access unlocks with Pro.Unlock Pro to read the full 3 topics flashcard-note study guide for this section.
Unlock with Pro
Section 7
Create SQL views, functions, procedures, and enrichment logic
Pro
Create SQL views, functions, procedures, and enrichment logic unlocks with Pro.Unlock Pro to read the full 5 topics flashcard-note study guide for this section.
Unlock with Pro
Section 8
Implement star schemas, denormalization, and aggregations
Pro
Implement star schemas, denormalization, and aggregations unlocks with Pro.Unlock Pro to read the full 5 topics flashcard-note study guide for this section.
Unlock with Pro
Section 9
Optimize models with Direct Lake, DAX tuning, and incremental refresh
Pro
Optimize models with Direct Lake, DAX tuning, and incremental refresh unlocks with Pro.Unlock Pro to read the full 5 topics flashcard-note study guide for this section.
Unlock with Pro
Section 10
Write DAX with variables, iterators, table filters, windowing, and information functions
Pro
Write DAX with variables, iterators, table filters, windowing, and information functions unlocks with Pro.Unlock Pro to read the full 5 topics flashcard-note study guide for this section.
Unlock with Pro
Section 11
Implement calculation groups, dynamic format strings, and field parameters
Pro
Implement calculation groups, dynamic format strings, and field parameters unlocks with Pro.Unlock Pro to read the full 5 topics flashcard-note study guide for this section.
Unlock with Pro
Section 12
Apply sensitivity labels and endorse analytics items
Pro
Apply sensitivity labels and endorse analytics items unlocks with Pro.Unlock Pro to read the full 5 topics flashcard-note study guide for this section.
Unlock with Pro
Section 13
Perform impact analysis and manage reusable semantic assets through XMLA
Pro
Perform impact analysis and manage reusable semantic assets through XMLA unlocks with Pro.Unlock Pro to read the full 5 topics flashcard-note study guide for this section.
Unlock with Pro
Section 14
Resolve duplicates, nulls, data types, joins, and filters
Pro
Resolve duplicates, nulls, data types, joins, and filters unlocks with Pro.Unlock Pro to read the full 6 topics flashcard-note study guide for this section.
Unlock with Pro
Section 15
Design composite models and large semantic models
Pro
Design composite models and large semantic models unlocks with Pro.Unlock Pro to read the full 4 topics flashcard-note study guide for this section.
Unlock with Pro