DP-600
Microsoft exam for implementing analytics solutions using Microsoft Fabric.
Getting Started: Your DP-600 Journey
Free knowledge base
Microsoft Certified: Fabric Analytics Engineer Associate — key terms, tricks & tips
Everything from the course in one searchable place: 254 entries. Use it to review before a practice test or look up a word you forgot.
254 results
Microsoft Fabric
Unified analytics platform integrating data warehousing, data engineering, BI.
Getting Started: Your DP-600 Journey
Analytics Engineer
Professional designing and implementing data solutions for analysis.
Getting Started: Your DP-600 Journey
Skill Areas Measured
Categories of knowledge and abilities tested in the exam.
Getting Started: Your DP-600 Journey
Certification
Official recognition of validated skills by a credentialing body.
Getting Started: Your DP-600 Journey
Power BI
Business intelligence tool for data visualization and reporting.
Getting Started: Your DP-600 Journey
Data Warehousing
Storing large amounts of historical data for analysis.
Getting Started: Your DP-600 Journey
Understanding the DP-600 Exam and Certification
To remember the exam's focus areas, think 'FABRIC': **F**abric **A**nalytics, **B**uilding data, **R**eporting (Power BI), **I**mplementing data warehousing, **C**ertification.
Getting Started: Your DP-600 Journey
Understanding the DP-600 Exam and Certification
Memorize the four main skill areas measured by the DP-600 exam: Plan, implement, and manage a data solution; Build and serve data; Implement data warehousing; and Implement Power BI solutions. These are directly from the official exam guide.
Getting Started: Your DP-600 Journey
Understanding the DP-600 Exam and Certification
Underestimating the hands-on experience required; theoretical knowledge alone is insufficient.
Getting Started: Your DP-600 Journey
Understanding the DP-600 Exam and Certification
Not reviewing the official 'Skills Measured' document, leading to studying irrelevant topics.
Getting Started: Your DP-600 Journey
Understanding the DP-600 Exam and Certification
Failing to practice with scenario-based questions, which are common on the exam.
Getting Started: Your DP-600 Journey
Microsoft Fabric Portal
Web interface for managing all Fabric experiences and items.
Getting Started: Your DP-600 Journey
Workspace
Logical container for Fabric items, defining security and organization.
Getting Started: Your DP-600 Journey
Fabric Capacity
Dedicated set of resources for running Fabric workloads.
Getting Started: Your DP-600 Journey
Fabric Capacity Units (FCUs)
Standardized measure of compute power for Fabric workloads.
Getting Started: Your DP-600 Journey
Trial Capacity
Temporary, limited capacity for evaluating Microsoft Fabric.
Getting Started: Your DP-600 Journey
Organizational Account
Microsoft Entra ID account, preferred for enterprise use.
Getting Started: Your DP-600 Journey
Experience
Specific persona-focused view in Fabric, e.g., Data Engineering.
Getting Started: Your DP-600 Journey
Setting Up Your Microsoft Fabric Environment
To remember the portal, think 'Fabric App' – app.fabric.microsoft.com. It's where the magic happens!
Getting Started: Your DP-600 Journey
Setting Up Your Microsoft Fabric Environment
The DP-600 exam expects you to know that a Fabric workspace must always be assigned to a Fabric capacity, and that capacity dictates the available compute resources.
Getting Started: Your DP-600 Journey
Setting Up Your Microsoft Fabric Environment
Trying to create items without an assigned capacity, leading to errors.
Getting Started: Your DP-600 Journey
Setting Up Your Microsoft Fabric Environment
Not understanding the difference between personal and organizational accounts for Fabric.
Getting Started: Your DP-600 Journey
Setting Up Your Microsoft Fabric Environment
Ignoring the importance of workspace roles for security and access control.
Getting Started: Your DP-600 Journey
Lakehouse
A data architecture combining data lake flexibility with data warehouse structure.
Planning & Implementing Fabric Analytics Solutions
Capacity Units (CUs)
Measure of compute resources consumed by Fabric workloads.
Planning & Implementing Fabric Analytics Solutions
Data Engineering
Fabric component for large-scale data transformation and processing (Spark).
Planning & Implementing Fabric Analytics Solutions
Real-Time Analytics
Fabric component for high-throughput, low-latency data ingestion and querying (KQL).
Planning & Implementing Fabric Analytics Solutions
Data Activator
Fabric component for detecting patterns and triggering actions from data.
Planning & Implementing Fabric Analytics Solutions
Data Governance
Processes for managing data availability, usability, integrity, and security.
Planning & Implementing Fabric Analytics Solutions
RBAC
Role-Based Access Control, managing permissions based on user roles.
Planning & Implementing Fabric Analytics Solutions
SQL Endpoint
Query interface for Data Warehousing in Fabric, compatible with T-SQL.
Planning & Implementing Fabric Analytics Solutions
Designing Fabric Analytics Solutions
Remember 'CRISP' for good design: **C**omponents, **R**equirements, **I**ntegration, **S**calability, **P**erformance (and Cost).
Planning & Implementing Fabric Analytics Solutions
Designing Fabric Analytics Solutions
The exam often tests your ability to choose the *most appropriate* Fabric component for a given scenario. Pay close attention to keywords like 'real-time,' 'large-scale batch,' 'structured reporting,' or 'machine learning' to guide your selection.
Planning & Implementing Fabric Analytics Solutions
Designing Fabric Analytics Solutions
Overlooking business requirements, leading to a solution that doesn't meet user needs.
Planning & Implementing Fabric Analytics Solutions
Designing Fabric Analytics Solutions
Choosing a single Fabric component for all tasks when a combination would be more efficient.
Planning & Implementing Fabric Analytics Solutions
Designing Fabric Analytics Solutions
Ignoring scalability and cost optimization until after deployment, leading to unexpected expenses or performance issues.
Planning & Implementing Fabric Analytics Solutions
Data Pipeline
Fabric tool for orchestrating complex batch data movement and transformations.
Planning & Implementing Fabric Analytics Solutions
Dataflow Gen2
Low-code Fabric tool for data extraction, transformation, and loading (ETL).
Planning & Implementing Fabric Analytics Solutions
Eventstream
Fabric feature for real-time data streaming, capture, and processing.
Planning & Implementing Fabric Analytics Solutions
Shortcut
A reference in Lakehouse to data stored externally, like ADLS Gen2 or S3.
Planning & Implementing Fabric Analytics Solutions
Incremental Loading
Ingesting only new or changed data since the last load, optimizing performance.
Planning & Implementing Fabric Analytics Solutions
Delta Lake
Open-source storage layer enabling ACID transactions on data lakes.
Planning & Implementing Fabric Analytics Solutions
Ingesting Data into a Lakehouse using various methods
To remember the main ingestion tools, think 'P.E.D.S.': Pipelines for ETL, Eventstream for real-time, Dataflows for easy prep, and Shortcuts for external data.
Planning & Implementing Fabric Analytics Solutions
Ingesting Data into a Lakehouse using various methods
The exam frequently tests your ability to choose the correct ingestion tool for a given scenario. Pay close attention to keywords like 'real-time,' 'batch ETL,' 'low-code,' and 'existing data lake' to guide your choice between Eventstream, Data Pipelines, Dataflows Gen2, and Shortcuts.
Planning & Implementing Fabric Analytics Solutions
Ingesting Data into a Lakehouse using various methods
Using Dataflows Gen2 for highly complex, large-scale ETL that requires robust orchestration and error handling, where Data Pipelines would be more appropriate.
Planning & Implementing Fabric Analytics Solutions
Ingesting Data into a Lakehouse using various methods
Attempting to manually upload large, frequently updated datasets instead of automating the process with Pipelines or Dataflows.
Planning & Implementing Fabric Analytics Solutions
Ingesting Data into a Lakehouse using various methods
Not considering incremental loading strategies for ongoing data ingestion, leading to inefficient full data reloads each time.
Planning & Implementing Fabric Analytics Solutions
OneLake
Microsoft Fabric's unified, logical data lake across an organization.
Planning & Implementing Fabric Analytics Solutions
ACID Transactions
Atomicity, Consistency, Isolation, Durability; properties ensuring reliable database transactions.
Planning & Implementing Fabric Analytics Solutions
Schema Evolution
Ability to modify a table's schema over time without data rewrite.
Planning & Implementing Fabric Analytics Solutions
Time Travel
Querying previous versions of a Delta table based on timestamp or version number.
Planning & Implementing Fabric Analytics Solutions
OneLake Shortcut
A symbolic link to data in other OneLake workspaces or external cloud storage.
Planning & Implementing Fabric Analytics Solutions
Managing Data within a Lakehouse Environment
Imagine a 'Lake House' (Lakehouse) where 'One Lake' (OneLake) connects everything. Inside, there are 'Delta' (Delta Lake) tables for structured data and 'Files' for everything else. 'Shortcuts' let you visit other lakes without moving your boat!
Planning & Implementing Fabric Analytics Solutions
Managing Data within a Lakehouse Environment
The exam frequently tests your understanding of OneLake's role as the single, unified data lake for Fabric and the distinction between the 'Tables' (Delta Lake) and 'Files' sections within a Lakehouse. Know that all tables in a Fabric Lakehouse are Delta tables.
Planning & Implementing Fabric Analytics Solutions
Managing Data within a Lakehouse Environment
Confusing the 'Files' section for only unstructured data; it can hold semi-structured too.
Planning & Implementing Fabric Analytics Solutions
Managing Data within a Lakehouse Environment
Forgetting that all tables in a Fabric Lakehouse are inherently Delta tables.
Planning & Implementing Fabric Analytics Solutions
Managing Data within a Lakehouse Environment
Underestimating the importance of 'OPTIMIZE' and 'VACUUM' for Delta table performance and cost management.
Planning & Implementing Fabric Analytics Solutions
Microsoft Purview
Unified data governance solution for discovery, classification, lineage, and policy enforcement.
Planning & Implementing Fabric Analytics Solutions
Row-Level Security (RLS)
Restricts data access at the row level based on the user's identity or role.
Planning & Implementing Fabric Analytics Solutions
Object-Level Security (OLS)
Restricts access to specific database objects like tables or columns.
Planning & Implementing Fabric Analytics Solutions
Data Loss Prevention (DLP)
Policies to identify, monitor, and protect sensitive information from unauthorized sharing.
Planning & Implementing Fabric Analytics Solutions
Azure Active Directory
Microsoft's cloud-based identity and access management service for authentication.
Planning & Implementing Fabric Analytics Solutions
Role-Based Access Control (RBAC)
Method of restricting system access to authorized users based on their role.
Planning & Implementing Fabric Analytics Solutions
Least Privilege
Security principle granting users only the minimum access needed to perform their job.
Planning & Implementing Fabric Analytics Solutions
Implementing Data Governance & Security Principles
To remember the key security layers: 'A Nasty Worm Invaded Our Little Purview.' (Azure AD, Network, Workspace, Item, Object, Row, Purview)
Planning & Implementing Fabric Analytics Solutions
Implementing Data Governance & Security Principles
The exam often tests your understanding of where specific security or governance features are implemented. For example, know that RLS can be defined in Power BI datasets or SQL endpoints, and Purview is the central hub for data classification and DLP.
Planning & Implementing Fabric Analytics Solutions
Implementing Data Governance & Security Principles
Forgetting to apply the principle of least privilege, granting users more access than necessary.
Planning & Implementing Fabric Analytics Solutions
Implementing Data Governance & Security Principles
Neglecting to classify sensitive data, making it harder to apply effective DLP policies.
Planning & Implementing Fabric Analytics Solutions
Implementing Data Governance & Security Principles
Relying solely on workspace-level permissions and not implementing granular RLS/OLS where appropriate.
Planning & Implementing Fabric Analytics Solutions
Power Query Online
Web-based editor for data transformation.
Preparing and Transforming Data in Fabric
M Language
Functional language behind Power Query transformations.
Preparing and Transforming Data in Fabric
On-premises Data Gateway
Connects cloud services to on-premises data sources.
Preparing and Transforming Data in Fabric
Data Ingestion
Process of bringing data into a system.
Preparing and Transforming Data in Fabric
Data Transformation
Modifying data to improve quality/usability.
Preparing and Transforming Data in Fabric
Ingesting Data with Dataflows Gen2
Imagine a 'DataFLOW' like a river, and 'Gen2' means it's a super-powered, modern river with a 'POWERful Query' boat that can reach any 'SOURCE' and dump its cargo into a 'LAKEhouse'!
Preparing and Transforming Data in Fabric
Ingesting Data with Dataflows Gen2
The exam often tests your understanding of the core differences and advantages of Dataflows Gen2 over Gen1, especially concerning integration with Fabric components like Lakehouse and enhanced performance. Look for keywords like 'Fabric-native,' 'Lakehouse destination,' or 'high-scale ingestion' when identifying Gen2 features.
Preparing and Transforming Data in Fabric
Ingesting Data with Dataflows Gen2
Confusing Dataflows Gen1 capabilities with Dataflows Gen2, especially regarding destinations and performance.
Preparing and Transforming Data in Fabric
Ingesting Data with Dataflows Gen2
Attempting to use Dataflows Gen2 for true real-time, low-latency streaming scenarios.
Preparing and Transforming Data in Fabric
Ingesting Data with Dataflows Gen2
Underestimating the importance of initial data cleansing and transformation steps within Power Query before loading to the Lakehouse.
Preparing and Transforming Data in Fabric
Activity
A processing step within a Data Pipeline, performing a specific action.
Preparing and Transforming Data in Fabric
Linked Service
Defines connection information for external data stores.
Preparing and Transforming Data in Fabric
Dataset
A named data structure pointing to data used or produced by activities.
Preparing and Transforming Data in Fabric
Trigger
Defines when a Data Pipeline should run, e.g., on a schedule or event.
Preparing and Transforming Data in Fabric
Copy Data Activity
A fundamental activity for moving data between various data stores.
Preparing and Transforming Data in Fabric
Notebook Activity
Executes a Spark notebook within a Data Pipeline for custom processing.
Preparing and Transforming Data in Fabric
Building Data Pipelines for Data Ingestion
To remember pipeline components: 'A Little Data Triggered My Copy Notebook.' (Activity, Linked Service, Dataset, Trigger, Copy Data, Notebook)
Preparing and Transforming Data in Fabric
Building Data Pipelines for Data Ingestion
The DP-600 exam heavily tests your understanding of Data Pipeline activities. Memorize the purpose of key activities like Copy Data, Notebook, Dataflow, and Lookup, and how they integrate into a complete pipeline.
Preparing and Transforming Data in Fabric
Building Data Pipelines for Data Ingestion
Forgetting to configure Linked Services correctly, leading to connection errors.
Preparing and Transforming Data in Fabric
Building Data Pipelines for Data Ingestion
Not setting up appropriate triggers, causing pipelines to run at the wrong time or not at all.
Preparing and Transforming Data in Fabric
Building Data Pipelines for Data Ingestion
Overlooking error handling and monitoring within pipelines, making debugging difficult.
Preparing and Transforming Data in Fabric
Building Data Pipelines for Data Ingestion
Trying to perform complex transformations directly in a Copy Data activity instead of using Dataflows or Notebooks.
Preparing and Transforming Data in Fabric
Spark Notebook
Interactive environment for running Spark code (PySpark, Scala) in Fabric.
Preparing and Transforming Data in Fabric
PySpark
Python API for Apache Spark, widely used for data processing.
Preparing and Transforming Data in Fabric
DataFrame
Distributed collection of data organized into named columns in Spark.
Preparing and Transforming Data in Fabric
Lazy Evaluation
Spark operations build a logical plan without immediate execution.
Preparing and Transforming Data in Fabric
Action
A Spark operation that triggers computation and returns a result.
Preparing and Transforming Data in Fabric
UDF (User Defined Function)
Custom function written by users to extend Spark's capabilities.
Preparing and Transforming Data in Fabric
Transforming Data using Spark Notebooks
SPARK: S-cale, P-rogrammatic, A-dvanced, R-eal-time, K-ustom. Use Spark when your transformations need these qualities!
Preparing and Transforming Data in Fabric
Transforming Data using Spark Notebooks
The exam often tests your understanding of when to use Spark notebooks versus Dataflows Gen2. Remember, notebooks are for highly custom, programmatic, or complex transformations, especially with large datasets, while Dataflows Gen2 are better for low-code, visual transformations and common data integration patterns.
Preparing and Transforming Data in Fabric
Transforming Data using Spark Notebooks
Forgetting that Spark operations are lazy and require an action to trigger execution.
Preparing and Transforming Data in Fabric
Transforming Data using Spark Notebooks
Using Pandas DataFrames for large datasets instead of PySpark DataFrames, leading to out-of-memory errors.
Preparing and Transforming Data in Fabric
Transforming Data using Spark Notebooks
Overusing UDFs when built-in Spark functions could achieve the same result more efficiently.
Preparing and Transforming Data in Fabric
Custom Function
A reusable set of M transformation steps encapsulated into a single callable unit.
Preparing and Transforming Data in Fabric
Parameter
A dynamic input value that can be used to control dataflow behavior or queries.
Preparing and Transforming Data in Fabric
Try...Otherwise
An M expression for error handling, attempting an operation and providing a fallback.
Preparing and Transforming Data in Fabric
Query Folding
Optimizing dataflows by pushing transformation logic to the source database system.
Preparing and Transforming Data in Fabric
Computed Entity
A dataflow entity whose data is derived from other entities, promoting reusability.
Preparing and Transforming Data in Fabric
List.Accumulate
An M function for performing iterative calculations over a list.
Preparing and Transforming Data in Fabric
Table.Group
An M function used for complex aggregations and grouping of table rows.
Preparing and Transforming Data in Fabric
Advanced Data Transformations with Dataflows Gen2
To remember advanced Dataflow Gen2 features, think 'C.P.E.O.': Custom functions, Parameters, Error handling, Optimization (Query folding).
Preparing and Transforming Data in Fabric
Advanced Data Transformations with Dataflows Gen2
The exam frequently tests query folding capabilities. Remember that transformations like adding an index column or merging queries from different data sources can break query folding. Always aim to perform filter and aggregate operations early to maximize folding.
Preparing and Transforming Data in Fabric
Advanced Data Transformations with Dataflows Gen2
Not utilizing query folding, leading to slow dataflow performance and increased resource consumption.
Preparing and Transforming Data in Fabric
Advanced Data Transformations with Dataflows Gen2
Ignoring error handling, causing dataflows to fail on unexpected data and requiring manual intervention.
Preparing and Transforming Data in Fabric
Advanced Data Transformations with Dataflows Gen2
Hardcoding values instead of using parameters, resulting in inflexible and difficult-to-maintain dataflows.
Preparing and Transforming Data in Fabric
Orchestration
Automating the sequence and execution of data tasks.
Preparing and Transforming Data in Fabric
Scheduling
Configuring pipelines to run automatically at set times or events.
Preparing and Transforming Data in Fabric
Monitoring
Tracking pipeline execution status, logs, and performance.
Preparing and Transforming Data in Fabric
Dataflow Activity
Runs a Dataflow Gen2 item within a pipeline.
Preparing and Transforming Data in Fabric
Orchestrating Data Preparation Workflows
Think of an 'Orchestra Conductor' for data. The conductor (pipeline) tells each musician (activity) when to play (execute) to create a beautiful symphony (prepared data).
Preparing and Transforming Data in Fabric
Orchestrating Data Preparation Workflows
The exam often tests your understanding of which Fabric component is used for orchestration. Remember that 'Data Pipelines' are the primary tool, built on Azure Data Factory principles, for automating workflows.
Preparing and Transforming Data in Fabric
Orchestrating Data Preparation Workflows
Forgetting to handle dependencies: Activities must run in the correct order.
Preparing and Transforming Data in Fabric
Orchestrating Data Preparation Workflows
Not implementing proper error handling: Pipelines should gracefully manage failures.
Preparing and Transforming Data in Fabric
Orchestrating Data Preparation Workflows
Overlooking scheduling for automation: Manual triggers defeat the purpose of orchestration.
Preparing and Transforming Data in Fabric
Semantic Model
An abstraction layer over data, defining relationships, measures, and security.
Implementing and Managing Semantic Models
DAX
Data Analysis Expressions; a formula language used for calculations in semantic models.
Implementing and Managing Semantic Models
Measure
A dynamic calculation defined in a semantic model, e.g., 'Total Sales'.
Implementing and Managing Semantic Models
Relationship
A connection between two tables based on common columns.
Implementing and Managing Semantic Models
Calculation Group
A collection of calculation items that apply to multiple measures.
Implementing and Managing Semantic Models
Aggregation Table
A pre-summarized table used to speed up queries on large datasets.
Implementing and Managing Semantic Models
Hierarchy
A logical structure that organizes data at different levels, e.g., Date hierarchy.
Implementing and Managing Semantic Models
Designing and Developing Semantic Models
To remember the Semantic Model design steps: 'C-S-R-M-H-P' — Connect, Select, Relate, Measure, Hierarchy, Publish. It's like building a 'CSR Model' for your 'HP' (Hewlett Packard) data!
Implementing and Managing Semantic Models
Designing and Developing Semantic Models
The exam often tests your understanding of when to use specific features. For instance, know that calculation groups reduce measure proliferation and aggregation tables improve query performance for large datasets. Be ready to distinguish between calculated columns (computed at refresh) and measures (computed at query time).
Implementing and Managing Semantic Models
Designing and Developing Semantic Models
Over-normalizing or under-normalizing tables, leading to performance issues or complex DAX.
Implementing and Managing Semantic Models
Designing and Developing Semantic Models
Creating too many calculated columns instead of measures, increasing model size and refresh time.
Implementing and Managing Semantic Models
Designing and Developing Semantic Models
Ignoring business requirements, resulting in a model that doesn't answer user questions.
Implementing and Managing Semantic Models
Incremental Refresh
Refreshes only new/updated data, not the entire dataset, for faster updates.
Implementing and Managing Semantic Models
Star Schema
Data model with a central fact table and surrounding dimension tables.
Implementing and Managing Semantic Models
DAX Studio
Tool for analyzing and optimizing DAX queries and semantic model performance.
Implementing and Managing Semantic Models
Aggregations
Pre-calculated, summarized tables used to speed up common queries.
Implementing and Managing Semantic Models
Performance Analyzer
Power BI tool to identify slow visuals/queries in reports.
Implementing and Managing Semantic Models
Cardinality
The uniqueness of data values in a column, impacting relationship performance.
Implementing and Managing Semantic Models
DirectQuery
Connects directly to the data source, querying data in real-time.
Implementing and Managing Semantic Models
Optimizing Semantic Model Performance
To optimize, remember 'MODEL': Monitor, Optimize Data, DAX, Refresh, Aggregations, Evolve.
Implementing and Managing Semantic Models
Optimizing Semantic Model Performance
The exam often presents scenarios where you must choose the most effective optimization technique for a given problem. Pay close attention to keywords like 'large dataset,' 'slow refresh,' 'real-time data,' or 'complex calculations' to guide your answer.
Implementing and Managing Semantic Models
Optimizing Semantic Model Performance
Ignoring the root cause and applying random optimizations without diagnosing the actual bottleneck.
Implementing and Managing Semantic Models
Optimizing Semantic Model Performance
Over-optimizing small tables or simple DAX measures when the real issue lies in large, unindexed fact tables.
Implementing and Managing Semantic Models
Optimizing Semantic Model Performance
Not considering the trade-offs between different optimization techniques (e.g., DirectQuery for real-time data vs. import mode for performance).
Implementing and Managing Semantic Models
Role
A collection of users with similar data access permissions in a semantic model.
Implementing and Managing Semantic Models
DAX Filter Expression
A formula used in RLS to define which rows of data are visible to a role.
Implementing and Managing Semantic Models
USERPRINCIPALNAME()
A DAX function that returns the user's UPN, often used for dynamic RLS.
Implementing and Managing Semantic Models
Securing Semantic Models with Roles and RLS
Remember 'R-L-S: Rows Live Secretly' to recall that RLS hides rows of data based on rules.
Implementing and Managing Semantic Models
Securing Semantic Models with Roles and RLS
The exam expects you to know how to implement both static and dynamic RLS. Static RLS uses fixed values in DAX (e.g., `[Region] = "East"`), while dynamic RLS uses functions like `USERPRINCIPALNAME()` or `USERNAME()` to filter based on the logged-in user's identity.
Implementing and Managing Semantic Models
Securing Semantic Models with Roles and RLS
Forgetting to assign users or security groups to roles after publishing the semantic model.
Implementing and Managing Semantic Models
Securing Semantic Models with Roles and RLS
Not thoroughly testing RLS rules with different user accounts to ensure correct data filtering.
Implementing and Managing Semantic Models
Securing Semantic Models with Roles and RLS
Confusing RLS (row filtering) with OLS (object hiding) or workspace permissions (overall access).
Implementing and Managing Semantic Models
Data Gateway
Connects Power BI/Fabric to on-premises data sources.
Implementing and Managing Semantic Models
Scheduled Refresh
Automated process to update semantic model data.
Implementing and Managing Semantic Models
Parameters
Dynamic variables in Power Query for flexible queries.
Implementing and Managing Semantic Models
Q&A
Natural language querying feature for semantic models.
Implementing and Managing Semantic Models
Endorsement
Labels (Promoted/Certified) indicating model quality/trust.
Implementing and Managing Semantic Models
RLS
Row-Level Security, restricts data visible to users.
Implementing and Managing Semantic Models
Configuring and Managing Semantic Model Settings
Credentials, Refresh, Security, Parameters, Endorsement: CRSPE! Remember these are the core settings you'll manage.
Implementing and Managing Semantic Models
Configuring and Managing Semantic Model Settings
The exam often tests your knowledge of WHERE to find specific settings. Memorize that data source credentials, refresh schedules, and RLS role assignments are all configured within the semantic model's 'Settings' page in the Fabric/Power BI service, not in Power BI Desktop.
Implementing and Managing Semantic Models
Configuring and Managing Semantic Model Settings
Forgetting to update data source credentials after a password change, leading to refresh failures.
Implementing and Managing Semantic Models
Configuring and Managing Semantic Model Settings
Scheduling refreshes during peak business hours, causing performance degradation for reports.
Implementing and Managing Semantic Models
Configuring and Managing Semantic Model Settings
Not configuring refresh failure notifications, so issues go unnoticed until users complain.
Implementing and Managing Semantic Models
Deployment Pipeline
A structured process in Fabric to move content through Dev, Test, and Prod stages.
Implementing and Managing Semantic Models
CI/CD
Continuous Integration/Continuous Deployment; automates code changes through testing and deployment.
Implementing and Managing Semantic Models
Version Control
System (e.g., Git) to track and manage changes to code or model definitions.
Implementing and Managing Semantic Models
Rollback Strategy
A plan to revert a deployed system to a previous stable state if issues arise.
Implementing and Managing Semantic Models
TMDL
Tabular Model Definition Language; a textual representation of a semantic model.
Implementing and Managing Semantic Models
Parameter Rules
Configurations within deployment pipelines to set environment-specific parameter values.
Implementing and Managing Semantic Models
Advanced Semantic Model Deployment and Lifecycle
D-P-V-R-A: Deploy, Parameterize, Version, Rollback, Automate. Remember these five key actions for advanced semantic model lifecycle management!
Implementing and Managing Semantic Models
Advanced Semantic Model Deployment and Lifecycle
The exam often tests your understanding of deployment pipeline stages (Development, Test, Production) and their purpose. Be familiar with how to configure deployment rules for parameters and data sources, and the benefits of integrating with source control.
Implementing and Managing Semantic Models
Advanced Semantic Model Deployment and Lifecycle
Not using version control, making it impossible to track changes or revert to previous stable versions.
Implementing and Managing Semantic Models
Advanced Semantic Model Deployment and Lifecycle
Manually updating parameters and connection strings in each environment, leading to human error and inconsistencies.
Implementing and Managing Semantic Models
Advanced Semantic Model Deployment and Lifecycle
Skipping the Test stage, resulting in production issues that could have been caught earlier.
Implementing and Managing Semantic Models
T-SQL
Microsoft's proprietary extension to SQL, used for querying relational databases.
Exploring and Analyzing Data in Fabric
SQL View
A virtual table based on the result-set of a SQL query, not storing data.
Exploring and Analyzing Data in Fabric
Querying Data using T-SQL in Lakehouse
SQL Endpoint: 'S' for 'Structured' data access, 'Q' for 'Querying' with T-SQL, 'L' for 'Lakehouse' integration. It's the 'SQL' for your 'Lake'.
Exploring and Analyzing Data in Fabric
Querying Data using T-SQL in Lakehouse
The exam often tests your understanding of how the SQL endpoint integrates with Lakehouse. Remember that it provides a T-SQL interface over the Delta Lake tables without requiring data movement or transformation into a separate SQL database.
Exploring and Analyzing Data in Fabric
Querying Data using T-SQL in Lakehouse
Trying to use Spark-specific functions directly in the T-SQL query editor.
Exploring and Analyzing Data in Fabric
Querying Data using T-SQL in Lakehouse
Forgetting that SQL endpoint views are virtual and don't store their own data.
Exploring and Analyzing Data in Fabric
Querying Data using T-SQL in Lakehouse
Assuming the SQL endpoint is a full-fledged SQL Server instance with all its features.
Exploring and Analyzing Data in Fabric
Spark SQL
Spark module for structured data processing with SQL.
Exploring and Analyzing Data in Fabric
Notebook
Interactive web-based environment for code execution.
Exploring and Analyzing Data in Fabric
Analyzing Data with Spark SQL and Notebooks
SQL in Spark: 'S' for Scalable, 'Q' for Queries, 'L' for Large data. Notebooks are your 'N'ice 'O'pen 'T'ool for 'E'xploring 'B'ig data.
Exploring and Analyzing Data in Fabric
Analyzing Data with Spark SQL and Notebooks
The DP-600 exam frequently tests your ability to choose the right tool for a given data analysis task. Recognize that Spark SQL and notebooks are ideal for large-scale, interactive, and programmatic data exploration and transformation, especially with Delta Lake tables in a Lakehouse.
Exploring and Analyzing Data in Fabric
Analyzing Data with Spark SQL and Notebooks
Trying to perform complex, iterative data transformations solely with SQL in a notebook when PySpark DataFrames would be more efficient and readable for programmatic logic.
Exploring and Analyzing Data in Fabric
Analyzing Data with Spark SQL and Notebooks
Forgetting to register a DataFrame as a temporary view before attempting to query it using `spark.sql()` syntax in a notebook.
Exploring and Analyzing Data in Fabric
Analyzing Data with Spark SQL and Notebooks
Not understanding the difference between `spark.sql()` for direct SQL execution and DataFrame API operations for programmatic transformations.
Exploring and Analyzing Data in Fabric
Report
A multi-page canvas containing interactive visualizations and data.
Exploring and Analyzing Data in Fabric
Dashboard
A single-page, curated view of key metrics and visualizations.
Exploring and Analyzing Data in Fabric
Dataset (Semantic Model)
The underlying data source and model for Power BI reports.
Exploring and Analyzing Data in Fabric
Slicer
An interactive filter control in Power BI reports.
Exploring and Analyzing Data in Fabric
Fabric Workspace
A collaborative environment in Microsoft Fabric for analytics items.
Exploring and Analyzing Data in Fabric
Creating Interactive Data Visualizations with Power BI
To remember the Power BI components: 'D.R.D.' - Datasets feed Reports, which can then be summarized on Dashboards.
Exploring and Analyzing Data in Fabric
Creating Interactive Data Visualizations with Power BI
The exam often tests your understanding of Power BI's integration with Fabric items like Lakehouses and Data Warehouses. Be prepared to differentiate between Power BI reports and dashboards, and know when to use DirectQuery versus Import mode for Fabric data sources.
Exploring and Analyzing Data in Fabric
Creating Interactive Data Visualizations with Power BI
Over-cluttering reports with too many visuals or colors, making them hard to read.
Exploring and Analyzing Data in Fabric
Creating Interactive Data Visualizations with Power BI
Using inappropriate visualization types (e.g., pie charts for comparing more than 5 categories).
Exploring and Analyzing Data in Fabric
Creating Interactive Data Visualizations with Power BI
Not considering the audience's needs, leading to reports that don't answer their questions.
Exploring and Analyzing Data in Fabric
Jupyter Notebooks
An open-source web application for creating and sharing documents containing live code.
Exploring and Analyzing Data in Fabric
Tableau
A popular business intelligence tool for data visualization and interactive dashboards.
Exploring and Analyzing Data in Fabric
pyodbc
A Python module for connecting to databases using ODBC drivers.
Exploring and Analyzing Data in Fabric
Scikit-learn
A popular Python library for machine learning algorithms.
Exploring and Analyzing Data in Fabric
Integrating Data Exploration with External Tools
SQL E.P. (Endpoint) is your 'Easy Pass' to connect external tools to your Fabric Lakehouse data, just like an express lane for data.
Exploring and Analyzing Data in Fabric
Integrating Data Exploration with External Tools
The exam often tests your understanding of the SQL endpoint's role in external tool integration. Remember that the SQL endpoint provides a T-SQL interface and is read-only for Lakehouse data.
Exploring and Analyzing Data in Fabric
Integrating Data Exploration with External Tools
Trying to write data back to the Lakehouse via the SQL endpoint (it's read-only).
Exploring and Analyzing Data in Fabric
Integrating Data Exploration with External Tools
Forgetting to configure proper authentication for external tools, leading to access denied errors.
Exploring and Analyzing Data in Fabric
Integrating Data Exploration with External Tools
Assuming all external tools connect the same way; always check specific tool documentation.
Exploring and Analyzing Data in Fabric
Capacity
Dedicated pool of resources powering Fabric experiences.
Governing and Administering Microsoft Fabric
F-SKU
Stock Keeping Unit defining Fabric capacity's compute and memory.
Governing and Administering Microsoft Fabric
Admin Role
Workspace role with full control over settings and content.
Governing and Administering Microsoft Fabric
Member Role
Workspace role to create, edit, delete, and share content.
Governing and Administering Microsoft Fabric
Contributor Role
Workspace role to create, edit, delete content; no permission management.
Governing and Administering Microsoft Fabric
Viewer Role
Workspace role with read-only access to content.
Governing and Administering Microsoft Fabric
Managing Fabric Workspaces and Capacities
W-C-A-R: Workspaces Contain All Resources. Remember that Workspaces are assigned to Capacities, and Access is managed by Roles.
Governing and Administering Microsoft Fabric
Managing Fabric Workspaces and Capacities
The exam frequently asks about the relationship between capacities and workspaces. Remember that a workspace MUST be assigned to a capacity to function, and a capacity can host multiple workspaces. Also, know the primary workspace roles and their permissions.
Governing and Administering Microsoft Fabric
Managing Fabric Workspaces and Capacities
Assigning a workspace to a capacity that is too small, leading to performance issues.
Governing and Administering Microsoft Fabric
Managing Fabric Workspaces and Capacities
Granting 'Admin' roles to too many users, violating the principle of least privilege.
Governing and Administering Microsoft Fabric
Managing Fabric Workspaces and Capacities
Not organizing workspaces logically, making it difficult to find items or manage access.
Governing and Administering Microsoft Fabric
Managing Fabric Workspaces and Capacities
Forgetting that a workspace needs an active capacity to function.
Governing and Administering Microsoft Fabric
Capacity Metrics app
Tool for monitoring Fabric capacity usage.
Governing and Administering Microsoft Fabric
Activity Log
Records all user and system actions.
Governing and Administering Microsoft Fabric
Execution History
Details of past runs for pipelines/jobs.
Governing and Administering Microsoft Fabric
Workload
Specific type of processing (e.g., Spark, Power BI).
Governing and Administering Microsoft Fabric
Resource Utilization
Measure of how much CPU/memory is used.
Governing and Administering Microsoft Fabric
Alerting
Notifications for critical events or thresholds.
Governing and Administering Microsoft Fabric
Monitoring and Managing Fabric Items and Activities
MONITOR: My Operations Need Immediate Tracking Of Resources.
Governing and Administering Microsoft Fabric
Monitoring and Managing Fabric Items and Activities
On the DP-600 exam, be prepared to differentiate between monitoring tools for different Fabric items (e.g., Data Pipelines vs. Power BI semantic models). Keywords like 'Capacity Metrics app', 'Activity Log', and 'execution history' are crucial.
Governing and Administering Microsoft Fabric
Monitoring and Managing Fabric Items and Activities
Ignoring alerts and warnings, leading to preventable outages.
Governing and Administering Microsoft Fabric
Monitoring and Managing Fabric Items and Activities
Only monitoring after a problem occurs, instead of proactively.
Governing and Administering Microsoft Fabric
Monitoring and Managing Fabric Items and Activities
Not understanding the difference between capacity and item-specific monitoring.
Governing and Administering Microsoft Fabric
Workspace Roles
Predefined permissions for access to a Fabric workspace.
Governing and Administering Microsoft Fabric
Item-Level Permissions
Specific access control for individual Fabric items (e.g., reports, Lakehouses).
Governing and Administering Microsoft Fabric
Principle of Least Privilege
Granting only the minimum necessary permissions for a user's job function.
Governing and Administering Microsoft Fabric
Microsoft Entra ID
Microsoft's cloud-based identity and access management service.
Governing and Administering Microsoft Fabric
Build Permission
Allows users to connect to a dataset to create new reports or analyses.
Governing and Administering Microsoft Fabric
Implementing and Managing Fabric Security Roles
To remember the Fabric workspace roles, think 'A.M.C.V.': Admins Manage, Members Create, Contributors Can't Share, Viewers View.
Governing and Administering Microsoft Fabric
Implementing and Managing Fabric Security Roles
On the DP-600 exam, pay close attention to scenarios involving different levels of access. Know the specific capabilities of Admin, Member, Contributor, and Viewer roles. Questions often test your ability to apply the principle of least privilege, so choose the role or permission that grants the minimum necessary access.
Governing and Administering Microsoft Fabric
Implementing and Managing Fabric Security Roles
Granting 'Admin' or 'Member' roles when 'Contributor' or 'Viewer' would suffice, violating the principle of least privilege.
Governing and Administering Microsoft Fabric
Implementing and Managing Fabric Security Roles
Forgetting that item-level permissions can provide more granular access than workspace roles for specific items.
Governing and Administering Microsoft Fabric
Implementing and Managing Fabric Security Roles
Not using Microsoft Entra ID security groups for role assignments, leading to difficult individual user management.
Governing and Administering Microsoft Fabric
Auditing
Tracking and recording user and system activities for security and compliance.
Governing and Administering Microsoft Fabric
Compliance
Adhering to rules, laws, and standards for data handling.
Governing and Administering Microsoft Fabric
Audit Log
A chronological record of events and activities in a system.
Governing and Administering Microsoft Fabric
Sensitive Information Types (SITs)
Predefined patterns for detecting sensitive data like credit card numbers.
Governing and Administering Microsoft Fabric
GDPR
General Data Protection Regulation, a European data privacy law.
Governing and Administering Microsoft Fabric
Auditing and Compliance in Microsoft Fabric
AUDIT: Always Understand Data's Integrity and Traceability.
Governing and Administering Microsoft Fabric
Auditing and Compliance in Microsoft Fabric
The exam often tests your knowledge of where to find audit logs and the purpose of DLP. Remember that audit logs are primarily accessed via the Microsoft Purview compliance portal, not directly within the Fabric UI for comprehensive searches.
Governing and Administering Microsoft Fabric
Auditing and Compliance in Microsoft Fabric
Assuming Fabric's internal logs are sufficient for all compliance needs without leveraging Microsoft Purview.
Governing and Administering Microsoft Fabric
Auditing and Compliance in Microsoft Fabric
Not regularly reviewing audit logs, leading to delayed detection of security incidents.
Governing and Administering Microsoft Fabric
Auditing and Compliance in Microsoft Fabric
Failing to implement DLP policies for sensitive data, relying solely on access controls.
Governing and Administering Microsoft Fabric