1/19
Flashcards covering Microsoft Fabric variable libraries, deployment pipelines, configuration management, limitations, and development workflows.
Where must the Python decorator for a variable library connection be placed relative to the target function?
It must be placed right before the function.
What Python method is called on the variable library parameter to retrieve all stored variables?
.get_variables()
What feature in deployment pipelines helps automate the movement of Fabric items across workspaces?
Deployment plans
Which authentication identity type is supported when interacting with the variable library REST API?
Service principals
How do workspace roles determine permissions for variable libraries in Microsoft Fabric?
Viewers can view them, Contributors and Members can change them, and Admins have full access.
Does Microsoft Fabric provide lineage visibility for variable libraries?
No, there is no lineage visibility to see if a variable library is being consumed by items like notebooks or dataflows.
What service does the speaker recommend using for sensitive values instead of storing secrets in a variable library?
Azure Key Vault (Key Vaults)
Which built-in feature of variable libraries is recommended to record variable intentions and usage for documentation?
The notes feature
Can variables be reordered directly inside the Microsoft Fabric user interface (UI)?
No, they cannot be reordered in the UI; their order corresponds to the underlying JSON file in Git.
Are variable libraries shared globally across dev, test, and prod, or deployed as separate workspace items?
They are Fabric items that are deployed individually across each workspace, rather than a single shared library.
When a variable library is deployed from dev to test for the very first time, which value set becomes active in test?
The default value set
What happens to the active value set in a test workspace during subsequent deployments after it has been explicitly set?
It remains on the selected active set and is not overwritten by subsequent deployments.
What is the maximum limit of variables and value sets permitted in a single variable library?
Up to 1,000 variables and up to 1,000 value sets
What is the total cell limit for a single variable library?
10,000 total cells
What is the maximum number of variables allowed per Dataflow Gen2?
50 variables maximum per dataflow
What architecture pattern does the speaker recommend for reading Excel files from SharePoint instead of Dataflows?
Using SharePoint folder shortcuts into a lakehouse and reading/parsing the files using notebooks
What is the name of Laura Graham Brown's blog that is recommended for learning about Fabric variable libraries?
Hacked Full of Data
What lakehouse file can be edited directly to batch-update target lakehouse shortcuts for different environments?
shortcuts.json
Between GitHub Copilot, Codex, and Claude Code, which AI coding tool does the speaker prefer?
Claude Code
How does the speaker ensure AI does not access PII during automated testing?
By using skills and tools to restrict the AI to aggregates and counts unless explicitly instructed otherwise