Fabric Analytics Engineers Associate [draft]
Fabric Terms Capacity Lakehouse Managed Table Lakehouse Shortcut Lakehouse View Power BI DAX Formatter Power BI Model Explorer Power BI Tabular Editor (Best Practice Analyser) Tabular Editor Tenant Subscription Developer can deploy in Dev Test Workspace and view Prod Workspace Fabric Configuration Enable read-write access to dataset stored in Fabric via XMLA Endpoint Create and Publish custom Direct Lake semantic model using External Tools Lakehouse Handle frequent schema change in Copy Activity Convert Lakehouse files from CSV to Delta format for Power BI Reporting SQL Analytics Endpoint Performance Optimisation - Lots of useless logs, lots of small files Query S3 data with SQL Endpoint Prevent new tables been added to Lakehouse automatically Query data from multiple tables in different Lakehouses without copying data Data Factory Lookup Activity Pass values across multiple steps in Data Factory Pipeline Power BI Query Folding Incremental Refresh XMLA Endpoint Power BI Mode Display all rows including duplicates in PowerBI visual Distinct Count vs Unique Count in PowerQuery Calculate Duplicated Rows in PowerQuery Power BI File Formats Reduce Query Execution time for visuals on all pages on top of large dataset Incremental Refresh fails in Power BI report Semantic Model Enable Scale-out for a Semantic Model Analyse frequently used columns in memory Performance Optimisation Prevent implicit measures Identify Surrogate key column for SCD Type 2 table in Semantic Model Ensure user always use Direct Lake mode with semantic model PySpark Large dataset join a small dataset Necessary fields for Slow Change Dimension (SCD) Type2 Filver vs KeepFilters Table Maintenance Operations Miscellaneous Get maximum value of a column with PowerQuery Microsoft Fabric Capacity Metrics App Dynamic Management View (DMV) Fabric Terms Capacity Lakehouse Managed Table A managed table is a physical table that stores data in a Lakehouse....