⚡ Microsoft Power Apps & Fabric Ultimate Guide
300+ Analytical Q&A · Certifications · Viva · Job Interviews · AI Trends · Hands‑On Labs
Imagine walking into a Microsoft certification exam or a high‑stakes interview, and you can narrate how you built an enterprise‑grade Power Apps canvas app, or designed a lakehouse architecture in Microsoft Fabric. This guide goes beyond basics—it’s a complete analytics‑driven journey through Power Apps (Canvas, Model‑Driven, Power Automate, Dataverse) and Microsoft Fabric (Data Engineering, Data Factory, Data Science, Real‑Time Analytics, Power BI, Governance). Every question is crafted to reveal deep understanding, from beginner to most expert. Let’s begin.
📑 Full Table of Contents (300+ Q&A)
- Power Apps: Beginner (0‑2 yrs) – 60 Q&A
- Power Apps: Intermediate (2‑5 yrs) – 50 Q&A
- Power Apps: Expert/Architect (5+ yrs) – 50 Q&A
- Microsoft Fabric: Foundation – 40 Q&A
- Fabric Data Engineering – 30 Q&A
- Fabric Data Factory – 30 Q&A
- Fabric Data Science & AI – 25 Q&A
- Fabric Real‑Time Analytics – 20 Q&A
- Fabric Governance & Admin – 20 Q&A
- Integrated Scenarios (Power Apps + Fabric) – 15
- Hands‑On Labs & Code Exercises – 10
- Mock Viva/Job Interview – 20 Q&A
🟦 Power Apps: Beginner (0‑2 Years) – 60 Q&A
1. What is Power Apps?
Microsoft Power Apps is a low‑code platform for building custom business apps that connect to your data and work across web and mobile.
2. What are the three types of Power Apps?
Canvas apps, model‑driven apps, and portals (now Power Pages).
3. What is a canvas app?
An app where you design the interface by dragging controls onto a canvas, similar to PowerPoint, with Excel‑like formulas for logic.
4. What is a model‑driven app?
An app where the UI is generated automatically from your data model and business processes, built on Dataverse. Ideal for complex data relationships.
5. What is Dataverse?
A cloud‑based, scalable data service and app platform that stores and manages data used by business applications. It includes security, logic, and data modeling.
6. What is Power Fx?
The low‑code formula language used across Power Apps, similar to Excel formulas. It's declarative and strongly typed.
7. How do you share a canvas app?
Share it with users or security groups by assigning the app a connection and granting the appropriate permission (User or Co‑owner).
8. What is a connector in Power Apps?
A wrapper around an API that allows Power Apps to communicate with various data sources like SharePoint, SQL Server, or custom services.
9. What is Power Automate?
A cloud‑based service for creating automated workflows between apps and services to synchronize files, get notifications, collect data, etc.
10. What is the difference between a flow and a canvas app?
A flow automates a process (triggered by an event), while a canvas app provides an interactive user interface.
11. What is the purpose of a gallery control?
To display multiple records from a data source in a scrollable list.
12. How do you navigate between screens?
Use the Navigate function: `Navigate(Screen2, Fade)`.
13. What is a variable in Power Apps?
A temporary storage for values. Use `Set(globalVar, value)` for global variables, and `UpdateContext({localVar: value})` for screen‑specific variables.
14. How do you filter a gallery based on a text input?
Set the gallery's Items property to: `Filter(DataSource, StartsWith(Title, TextInput1.Text))`.
15. What is the `Patch` function?
Used to create or modify records in a data source. `Patch(DataSource, Defaults(DataSource), {Title: "New"})`.
16. What is a collection in Power Apps?
An in‑memory table created with `Collect(collectionName, items)` that can be used offline or as temporary storage.
17. What are delegation limits?
Power Apps can only process a certain number of records locally (500 by default). Delegation pushes processing to the data source, and not all functions are delegable.
18. Name three delegable functions for SharePoint.
Filter, LookUp, StartsWith, etc., but only with specific conditions.
19. What is the difference between `ClearCollect` and `Collect`?
`ClearCollect` first clears the collection then adds items, while `Collect` appends items to the existing collection.
20. How do you bind a form to a data source?
Use the Edit form control, set its DataSource property, and connect fields using the form's `Item` property.
21. What is a component in Power Apps?
A reusable building block that encapsulates controls and logic, which can be imported into multiple apps.
22. How do you handle offline capability?
Use the `SaveData` and `LoadData` functions to cache data locally, combined with `Connection.Connected` to detect network status.
23. What is the purpose of the App OnStart property?
It runs formulas when the app starts, useful for initializing global variables and loading data.
24. How can you call a Power Automate flow from a canvas app?
Add the flow as a data source and use `MyFlow.Run(parameters)` to trigger it.
25. What is a solution in Power Apps?
A container for apps, flows, tables, and other components, used for application lifecycle management (ALM) across environments.
26. What are environments in Power Platform?
A space to store, manage, and share your organization's business data, apps, and flows. Each has its own Dataverse database.
27. What is the Common Data Model (CDM)?
A standardized, extensible data schema that allows data integration across Microsoft services. Now known as Dataverse standard tables.
28. What are standard vs. custom tables in Dataverse?
Standard tables (like Account, Contact) come out‑of‑the‑box; custom tables are created by users to meet specific business needs.
29. How do you create a model‑driven app?
Start from a solution, define the data model (tables, columns, relationships), create a site map, and then build the app from the model.
30. What is a business rule in Dataverse?
A server‑side logic that applies to a specific table, used to set field values, validate data, or show/hide fields without code.
31. What is a business process flow?
A guided step‑by‑step process that ensures users follow a consistent business process across multiple entities.
32. What are environment variables?
Used to store parameters that can vary between environments, making solutions portable without hard‑coding values.
33. How do you implement role‑based security in Dataverse?
By creating security roles with specific privileges on tables, and assigning them to users or teams.
34. What is the difference between canvas and model‑driven app security?
Canvas apps rely on connector permissions and Dataverse security roles for tables; model‑driven apps fully use Dataverse security model.
35. What is AI Builder in Power Apps?
A set of AI models (object detection, form processing, prediction) that can be added to apps without writing code.
36. How do you embed Power BI in a Power Apps canvas app?
Use the Power BI tile control and specify the dashboard or report to display.
37. What is a custom connector?
A wrapper around a REST API that you create to connect Power Apps to any external service not available in standard connectors.
38. Explain the `ForAll` function.
It iterates over a table and performs a formula for each record, returning a table of results.
39. What is the difference between `Update` and `UpdateIf`?
`Update` modifies a specific record in a data source; `UpdateIf` modifies records that match a condition.
40. How do you handle errors in Power Apps?
Use `IfError` function, or check `DataSource.Error` property after operations like `Patch`.
41. What is the Timer control used for?
To run logic on a schedule or after a delay, or to create animations.
42. How can you implement deep linking in canvas apps?
Use the `Param` function to read query string parameters from the URL.
43. What is the `Concurrent` function?
It runs multiple formulas simultaneously, reducing load time when fetching data from different sources.
44. What are the main limitations of canvas apps with SharePoint lists?
Delegation constraints, 12 lookup column limit, throttling, and complex permissions handling.
45. How do you use the Office 365 Users connector?
To retrieve user profile information, manager details, and direct reports for use in the app.
46. What is the `User()` function?
Returns the current user's email, full name, and image.
47. How do you create a responsive canvas app?
Use fluid grids, containers, and relative sizing (e.g., `Parent.Width`), along with `App.ActiveScreen.Size` to adapt layout.
48. What is the purpose of the `Reset` function?
Resets a control to its default value, often used to clear a form.
49. How do you publish a canvas app?
Save and then select Publish; it becomes available to shared users in the Power Apps mobile app or browser.
50. What is Power Apps per‑app vs per‑user licensing?
Per‑app license allows a user to run one specific app; per‑user allows unlimited apps for that user.
51. How do you migrate a canvas app between environments?
Package it in a solution, export the solution from the source environment, and import it into the target.
52. What is a component library?
A centralized repository of components that can be shared across multiple apps in an environment.
53. What is the `Switch` function?
Evaluates a formula against multiple cases, similar to a case statement; cleaner than nested `If`.
54. What is the `With` function?
Creates a temporary variable scoped to a block, allowing simplified expressions.
55. How do you set a field value based on another field?
Using the `Default` property of a control with a formula, e.g., `If(Dropdown1.Selected.Value = "High", "Urgent", "Normal")`.
56. What is the `DataSourceInfo` function?
Retrieves metadata about a data source, such as whether it allows create/delete operations.
57. What is a modern control in Power Apps?
Updated versions of classic controls with better performance and theming capabilities, still evolving.
58. How do you use the barcode scanner control?
Add it and use the `BarcodeScanner1.Value` property to get the scanned barcode.
59. What is the camera control used for?
To capture photos directly within the app; the `Photo` property holds the captured image.
60. How do you implement app notifications?
Use the `Notify` function for in‑app messages, or integrate with Power Automate for push notifications.
🟦 Power Apps: Intermediate (2‑5 Years) – 50 Q&A
61. Explain delegation in detail and how to overcome limits.
Delegation pushes query processing to the data source. For non‑delegable functions, fetch records in batches using `Filter` with indexed columns, or switch to Dataverse which supports more delegation.
62. How does the `GroupBy` function work?
It groups records by a column and returns a nested table. Useful for creating summaries, e.g., `GroupBy(Orders, "Customer", "GroupedOrders")`.
63. What is the difference between `AddColumns` and `DropColumns`?
`AddColumns` adds new calculated columns to a table; `DropColumns` removes specified columns.
64. How do you optimize performance of a canvas app?
Use `Concurrent` for parallel data loads, avoid unnecessary controls, enable `DelayedLoad` for heavy screens, use collections wisely, and minimize non‑delegable queries.
65. What are application lifecycle management (ALM) strategies for Power Apps?
Use solutions, environment variables, connection references, and Azure DevOps pipelines for automated deployment across Dev/Test/Prod.
66. How do you create a custom connector for a REST API that requires OAuth 2.0?
Define the authentication type in the connector’s security settings, configure the identity provider, and use policies to map the token.
67. What is the difference between a connection reference and an environment variable in solutions?
Connection reference stores the connector and connection details; environment variable stores any configurable value (text, number, secret) that changes per environment.
68. How do you implement complex business logic across multiple tables in Dataverse?
Use Power Automate flows triggered by Dataverse events, or classic workflows and custom plugins if real‑time sync logic is needed.
69. Explain the `SetProperty` function.
Used to change the property of a control within a component from the parent app, enabling reusable dynamic components.
70. What are the best practices for naming conventions in Power Apps?
Prefix controls with type (e.g., `lblName`, `btnSubmit`), use camelCase, and name variables clearly. Follow Microsoft’s recommended standards.
71. How do you implement cascading dropdowns with SharePoint data?
Set the second dropdown’s Items to `Filter(List, Category = Dropdown1.Selected.Value)`, ensuring delegation-friendly columns.
72. What is a PCF control?
Power Apps Component Framework control – a custom code component built with TypeScript that can be used in canvas and model‑driven apps for advanced UI.
73. How do you create a PCF control and deploy it?
Develop using the Power Apps CLI (`pac pcf init`), build, then package into a solution and import into an environment.
74. What is the difference between `Today()` and `Now()`?
`Today()` returns midnight of the current date; `Now()` returns the current date and time.
75. How do you use the `JSON` function to work with APIs?
`JSON(record, Format.IndentFour)` converts a record/table into a JSON string, useful for sending to custom APIs.
76. What is the `ParseJSON` function?
Converts a JSON string into a Power Fx untyped object, which can be accessed with dot notation.
77. How do you implement infinite scroll in a gallery?
Use a combination of a collection, a threshold on the gallery's scroll position, and `Collect` to append more records from the data source.
78. What is the purpose of the `DateDiff` function?
Returns the difference between two dates in the specified unit (days, hours, months, etc.).
79. How can you debug canvas apps?
Use the formula bar's live preview, enable the debug panel to check variable values, and use `Trace` to write to the monitor tool.
80. What is the Power Apps Monitor tool?
A real‑time debugging tool that shows network calls, formula evaluations, and errors.
81. How do you integrate AI Builder object detection into a canvas app?
Add the AI Builder component, select the model, and use the `OnSelect` event to retrieve detected objects and process them.
82. What is the difference between a flow button trigger and an automated trigger?
Button trigger is manual (user clicks a button in Power Apps); automated trigger runs when an event occurs (e.g., record created).
83. How do you pass parameters from Power Apps to Power Automate and back?
Use `FlowName.Run(param1, param2)`; the flow receives parameters, and can `Respond to Power Apps` with output values.
84. What are the benefits of using Dataverse over SharePoint for complex apps?
Rich data types, relational modeling, role‑based security, business rules, and server‑side logic, plus better delegation.
85. How do you manage row‑level security in Dataverse?
Through security roles with access levels (user, business unit, organization) and by configuring hierarchical security models.
86. What is a virtual table in Dataverse?
A table that represents data from an external source, allowing it to be used within model‑driven apps without replication.
87. How do you implement custom business logic with plugins in Dataverse?
Write a C# class library, register the assembly in Dataverse, and trigger on specific messages (Create, Update). Requires a strong .NET background.
88. What is the `IfError` function and why is it useful?
It replaces nested `IsError` checks, simplifying error handling by returning an alternative value when an error occurs.
89. How do you build a multilingual canvas app?
Store translated strings in a data source (e.g., SharePoint list), load them at startup, and reference them using a language variable.
90. What is the `Sequence` function?
Generates a table of sequential numbers, often used to create loops or populate galleries with fixed numbers of items.
91. How do you use the `Ungroup` function?
Expands a nested table created by `GroupBy` back into a flat table.
92. What is the role of the Power Platform admin center?
Manage environments, data policies, security roles, capacity, and analytics for all Power Platform components.
93. How do you implement a custom approval flow linked to a canvas app?
The app triggers a flow with item details; the flow uses the Approvals connector and sends the response back to update the item status.
94. What are canvas app templates and how to use them?
Pre‑built app layouts for common scenarios like budget tracking. They can be customized and serve as a quick start.
95. How do you create a cascading dropdown using Dataverse and model‑driven forms?
Use the “quick view” form or JavaScript to filter the second lookup based on the first, or implement a custom PCF control.
96. What is the `Coalesce` function?
Returns the first non‑blank value from a list of arguments. Useful for default values.
97. How do you implement role‑based UI visibility in canvas apps?
Check user roles using the `User().Email` or Dataverse security roles via a custom connector, then set the `Visible` property of controls accordingly.
98. What is the difference between `Remove` and `RemoveIf`?
`Remove` deletes a specific record; `RemoveIf` deletes all records that match a condition.
99. How do you handle large file uploads in Power Apps?
Use the Attachment control with Dataverse (supports large files), or integrate with SharePoint and set appropriate field limits. For very large files, use Azure Blob Storage with a custom connector.
100. How do you optimize the loading time of a model‑driven app?
Limit the number of views and charts on dashboards, use quick view forms wisely, and enable early binding for lookups.
101. What is the purpose of the `DataCard` in a form?
A container that groups a label, input control, and error message for a single field.
102. How can you use Power Apps with Microsoft Teams?
Embed a canvas app as a tab in Teams, or use the Power Apps app in Teams to build and run apps directly.
103. What is the “Power Apps Ideas” feature?
An AI‑powered assistant that suggests formulas and helps build apps using natural language (in preview).
104. How do you create a custom page in a model‑driven app?
A custom page is a canvas app embedded within a model‑driven app, providing flexible layout options alongside data‑centric forms.
105. What are the limits of the free Power Apps Developer Plan?
Allows individual development, no production use, limited capacity, but full access to premium features for learning.
106. How do you use the `Match` function for pattern validation?
`Match` applies a regular expression; e.g., `Match(TextInput1.Text, "^[A-Za-z]+$")` to check letters only.
107. What is the `Defaults` function used for?
Returns a record with default values for a data source, typically used to create new records.
108. How do you implement a search across multiple columns?
Combine `Filter` with multiple conditions or use the `Search` function (delegable on Dataverse text columns).
109. What is the `RowCount` function?
Returns the number of rows in a table, but beware of delegation issues when used directly on a data source.
110. How do you create a drill‑down experience in a gallery?
Use a secondary gallery that filters based on the selected item of the primary gallery, and optionally navigate to a detail screen.
🟦 Power Apps: Expert/Architect (5+ Years) – 50 Q&A
111. Design a scalable enterprise canvas app architecture using multiple environments.
Use a Dev/Test/Prod environment strategy with solutions, environment variables, connection references, and Azure DevOps pipelines. All components versioned in Git.
112. How do you handle multi‑tenant deployment of Power Apps solutions?
Use service principal authentication, cross‑tenant connections, and deploy solutions via PowerShell and Azure DevOps, adjusting environment variables per tenant.
113. What is the role of the Power Platform CLI (pac) in CI/CD?
It enables solution import/export, packing/unpacking, and managing environment settings via command line, integrated into build/release pipelines.
114. How do you implement a custom API in Dataverse using a custom connector and Azure Functions?
Write an Azure Function with REST endpoints, secure with Azure AD, create a custom connector with that API, and use it in Power Apps. For Dataverse, you can also use virtual tables.
115. Explain the event pipeline in Dataverse and plugin execution order.
Plugins are registered on messages (Create, Update, etc.) and run in a pipeline: Pre‑Validation, Pre‑Operation, Post‑Operation. They can be synchronous or asynchronous.
116. How do you manage complex concurrency issues in Power Apps?
Use the `Patch` function with the `ETag` of a record to implement optimistic concurrency, and handle errors when records are modified by others.
117. What is the difference between a solution upgrade and a solution update?
Update adds/removes components without removing existing ones (incremental). Upgrade can replace or remove components based on actions defined in the solution.
118. How do you integrate Power Apps with Azure Service Bus for real‑time messaging?
Use Power Automate to post messages to Service Bus, and have a listener (Azure Function) process them, updating the app via a custom connector or SignalR.
119. How do you build a metadata‑driven UI in canvas apps?
Store control definitions in a data source; dynamically create controls using `AddColumns` and nested galleries or the experimental `Dynamic` controls.
120. What are the best practices for code components (PCF) in terms of performance and security?
Minimize DOM manipulation, use asynchronous calls, implement caching, avoid storing secrets in code, and follow the principle of least privilege.
121. How do you implement application‑level caching in canvas apps?
Use global variables or collections that are loaded once at startup (App OnStart) and refreshed only when needed, combined with `LoadData`/`SaveData` for persistent cache.
122. How can you implement a custom authentication flow within Power Apps?
Use the `Launch` function to redirect to an external OAuth provider, capture the token via a deep link, and use it in custom connectors or API calls.
123. How do you monitor and analyze app usage at scale?
Enable auditing in Dataverse, integrate with Application Insights via custom connectors or Power Automate, and use Power BI to build analytics dashboards.
124. How to architect a global multi‑language solution with Dataverse?
Enable languages in Dataverse, use translation files for labels, and leverage the `Language()` function in canvas apps to switch text, plus localized data tables.
125. What are the limitations of Power Apps Portals (Power Pages) and how to overcome them?
Limited server‑side logic; use Liquid templates, web templates, and companion Power Automate flows. For complex functionality, embed a custom SPA using Azure.
126. How do you design a disaster recovery strategy for Power Apps and Dataverse?
Leverage Microsoft’s built‑in Dataverse replication and backup. For custom components, store solution source code in Git, automate environment provisioning, and have runbooks.
127. What is the role of a Power Platform Center of Excellence (CoE) starter kit?
It provides a set of components and templates to govern, monitor, and manage Power Platform adoption across the organization.
128. How do you manage API throttling and request limits in Power Apps?
Implement retry policies with exponential backoff, use caching, batch operations where possible, and monitor the consumption reports in the admin center.
129. Explain how to use the `Trace` function for advanced debugging and logging.
`Trace("message", TraceSeverity.Information, record)` writes to the Monitor and can be sent to Application Insights via a custom connector.
130. How do you build a custom connector that supports file uploads and multipart requests?
Define the API with `multipart/form-data` in the swagger definition, use the `OnSelect` of a button to call the connector with the file content.
131. What is the “Dataverse search” and how does it compare to standard search?
Dataverse search provides relevance‑based, full‑text search across multiple tables, with automatic indexing and better performance than the older categorized search.
132. How do you implement a custom command bar button in model‑driven apps?
Use the Ribbon Workbench or the modern commanding interface to add JavaScript web resources or Power Fx commands.
133. What is the Dataverse TDS endpoint?
Tabular Data Stream endpoint allows SQL‑like queries to Dataverse, enabling integration with tools like Power BI or SSMS.
134. How do you handle large data migrations into Dataverse?
Use the Data Migration Utility, Azure Data Factory with the Dataverse connector, or KingswaySoft for SSIS. Plan for throttling and use batch sizes.
135. What is the “solution layering” and how does it affect managed solutions?
Managed solutions stack in layers; the top layer wins for customizations. You can view layers to identify conflicts.
136. How can you enforce data loss prevention (DLP) policies across multiple environments?
Define DLP policies in the Power Platform admin center, classify connectors into Business, Non‑Business, and Blocked, and assign to specific environments or all.
137. How do you implement a real‑time dashboard in Power Apps using SignalR?
Host a SignalR hub in Azure, connect from a canvas app using a custom connector or embedded iframe, and update UI elements when messages are received.
138. Explain the use of `ForAll` with `Patch` to bulk update records, and the pitfalls.
`ForAll(collection, Patch(...))` can cause performance issues due to many network calls. Use batch APIs like `UpdateIf` or a custom connector that accepts bulk data.
139. How to use the `SdkMessage` in Dataverse plugins?
Create custom actions that can be called from plugins or Power Automate, encapsulating business logic.
140. What is the Power Apps Test Engine and how to use it for automated testing?
An open‑source tool (Power Apps Test Engine) that uses Playwright to automate UI tests for canvas apps. Integrate into CI/CD pipelines.
141. How do you architect an application that uses both Power Apps and Azure Logic Apps for complex workflows?
Power Apps for UI, Power Automate for simple workflows, and Azure Logic Apps for complex integrations requiring enterprise connectors or long‑running processes.
142. What are the security considerations when embedding Power BI reports in Power Apps?
Ensure Row‑Level Security (RLS) is configured in Power BI, and the app passes user identity context to the report; use the Power BI service principal if needed.
143. How do you implement a custom authentication provider for Power Apps Portals?
Use OpenID Connect or SAML 2.0 to integrate with external identity providers like Azure AD B2C or Okta, configuring site settings.
144. Explain the concept of “Application Insights for Power Apps” and its benefits.
By integrating, you can capture telemetry, performance metrics, and errors, enabling proactive monitoring and diagnostic analysis.
145. How do you manage Power Platform capacity and add‑on licensing at enterprise scale?
Use the capacity management reports, allocate capacity to environments, monitor usage, and purchase add‑ons for Dataverse storage, API calls, or Power Automate runs.
146. What is the “Power Platform unified client” concept?
A vision to combine the Power Apps, Power Automate, and Power BI experiences into a single, seamless interface for makers.
147. How do you integrate Azure Machine Learning models into Power Apps?
Deploy the model as a web service, create a custom connector to it, and call the prediction from Power Apps, or use AI Builder if applicable.
148. What is the significance of “Dataverse for Teams” vs full Dataverse?
Dataverse for Teams is a lightweight, Teams‑integrated version with a subset of features, designed for collaboration apps; full Dataverse offers enterprise‑grade capabilities.
149. How do you implement a robust error handling framework across all Power Apps in an enterprise?
Create a centralized error handling component (PCF or canvas component) that logs errors to a custom table in Dataverse or Application Insights, with context details.
150. What is the future of Power Apps with Copilot and generative AI?
Copilot allows building apps and writing formulas via natural language, auto‑generating screens and data connections, greatly accelerating development and citizen developer enablement.
151. How to design a multi‑app ecosystem with shared components and common data services?
Use a shared Dataverse environment with common tables, a component library for UI, and shared canvas components or PCF controls. Leverage solutions to package and deploy updates.
152. What is the role of the “Power Platform Advisor” and how do you act on its recommendations?
It analyzes environments and suggests improvements for security, performance, and governance. Review regularly and implement high‑priority fixes.
153. How do you manage secret and connection strings in Power Automate and Power Apps securely?
Use Azure Key Vault with a custom connector, or environment variables for non‑secret values. Never hard‑code in canvas apps.
154. Explain the architectural differences between managed and unmanaged solutions.
Unmanaged are used during development (all customizations allowed). Managed are for deployment (locked down, can’t be directly modified in the target environment).
155. How do you build a multi‑step wizard in a model‑driven app?
Use a business process flow or a custom page with multiple screens/tabs, leveraging client‑side scripting for navigation.
156. What are the common causes of “502 Bad Gateway” errors in Power Apps and how to troubleshoot?
Often due to network proxy issues or request timeouts. Check the monitor, review the custom connector’s timeout settings, and optimize API calls.
157. How do you incorporate Microsoft Purview data classification into your Power Apps strategy?
Apply sensitivity labels to apps and flows, use DLP policies, and integrate with Purview to track and protect sensitive data used in Power Platform.
158. What is the “Power Platform landing zone” in Azure?
An architectural framework for deploying Power Platform at scale with governance, networking, and identity best practices, often part of the Cloud Adoption Framework.
159. How do you use Azure API Management with Power Apps?
Publish APIs through APIM, create a custom connector from the APIM endpoint, benefiting from throttling, transformation, and analytics.
160. How can you run Python scripts from Power Apps?
Wrap the Python script in an Azure Function or container and expose it via HTTP; call it with a custom connector.
🧬 Microsoft Fabric: Foundation – 40 Q&A
161. What is Microsoft Fabric?
An end‑to‑end analytics platform that unifies data engineering, data integration, data science, real‑time analytics, and business intelligence on a single SaaS platform.
162. What are the core workloads in Fabric?
Data Factory, Data Engineering, Data Science, Data Warehouse, Real‑Time Analytics, Power BI, and Data Activator.
163. What is OneLake?
A single, unified, multi‑cloud data lake that stores all Fabric data in open formats (Delta Parquet) and eliminates data silos.
164. How does OneLake differ from Azure Data Lake Storage?
OneLake is a SaaS, logical data lake automatically provisioned with every Fabric tenant, with shortcuts and unified governance, while ADLS is a PaaS storage account.
165. What is a lakehouse in Fabric?
A data architecture that combines a data lake and a data warehouse, storing data in open Delta format and providing SQL analytics and Spark capabilities.
166. What is a shortcut in OneLake?
A symbolic link to data stored in other locations (ADLS, Amazon S3, Google Cloud Storage) that appears as if it's in OneLake, enabling virtual data integration without copying.
167. How do you create a lakehouse?
In the Fabric workspace, select + New > Lakehouse, name it, and it's ready to load data via pipelines, notebooks, or upload.
168. What is the difference between a lakehouse and a warehouse in Fabric?
Lakehouse supports Spark and SQL analytics on Delta tables. Warehouse is a relational MPP engine optimized for T‑SQL, with full transactional support.
169. What is a semantic model in Fabric?
The analytical model (previously Power BI dataset) that defines business logic, measures, and hierarchies for reporting, automatically created from lakehouse or warehouse.
170. What is the role of Data Activator in Fabric?
A no‑code tool that monitors data patterns and triggers actions (alerts, Power Automate flows) when conditions are met, enabling real‑time reactions.
171. How do you govern data in Fabric?
Use Microsoft Purview integration, domains, workspaces, item‑level security, and endorsement (certified/promoted) to manage data assets.
172. What is the Fabric capacity and how is it measured?
Capacity is compute power measured in Capacity Units (CU). It underlies all Fabric operations and can be scaled up/down or paused.
173. What are the Fabric licensing options?
Fabric is included in Power BI Premium capacities (P SKUs) and also available as F SKUs (F2, F4, ...). Each user needs a Power BI Pro or PPU license for content sharing, or use the free Fabric capacity trial.
174. How does the Data Factory workload differ from the Data Engineering workload in Fabric?
Data Factory focuses on data ingestion and orchestration using pipelines and dataflows. Data Engineering uses Spark notebooks and lakehouses for transformation.
175. What is a dataflow Gen2 in Fabric?
The next‑generation dataflow that provides low‑code data transformation, with Power Query, and can load data into a lakehouse or warehouse, using Fabric compute.
176. What is the SQL analytics endpoint for a lakehouse?
A serverless SQL endpoint automatically generated for every lakehouse, enabling T‑SQL queries over Delta tables without any setup.
177. How do you share a lakehouse across workspaces?
Using OneLake shortcuts, you can reference a lakehouse from another workspace, maintaining a single copy of data.
178. What are the open data formats used in Fabric?
Delta Lake (Parquet files with transaction log) is the standard. All engines can read Delta tables natively.
179. What is the default data retention and backup in OneLake?
OneLake provides built‑in backup and disaster recovery; data is replicated within the region. Time travel via Delta log allows querying historical versions.
180. How do you connect Power BI Desktop to a Fabric lakehouse?
Use the OneLake data hub in Power BI Desktop to directly connect to the lakehouse’s SQL analytics endpoint or the semantic model.
181. What is the “SQL analytics endpoint” connection string?
It’s in the format `xxxxx.datawarehouse.fabric.microsoft.com` and can be used with tools like SSMS and Azure Data Studio.
182. Can you use Git integration with Fabric?
Yes, Fabric workspaces can be connected to Azure DevOps or GitHub for version control of data items like notebooks, pipelines, and semantic models.
183. What is the purpose of a “domain” in Fabric?
A domain is a logical grouping of workspaces for a specific business area, allowing data mesh architecture and decentralized ownership with governance.
184. How do you monitor Fabric capacity utilization?
Use the Fabric Capacity Metrics app to track CU consumption, identify throttling, and smooth usage over time.
185. What is the purpose of “shortcut caching” in OneLake?
Caches data from external shortcuts to improve query performance; can be enabled or disabled per shortcut.
186. How do you apply row‑level security in a Fabric warehouse?
Use standard T‑SQL security policies (e.g., `CREATE SECURITY POLICY`) and predicate functions to filter rows based on user roles.
187. What is a “mirrored database” in Fabric?
A feature (preview) that creates a read‑only replica of a database like Azure Cosmos DB or Snowflake in OneLake, auto‑syncing data continuously.
188. How do you create a data pipeline to copy data from SQL Server to a lakehouse?
Use Data Factory pipeline with a Copy Data activity, define source (SQL Server connector) and sink (Lakehouse), and schedule it.
189. What is the difference between a notebook and a dataflow for transformation?
Notebooks use code (PySpark, Spark SQL) for advanced transformations; dataflows use Power Query for low‑code, visual transformations.
190. How do you schedule a Fabric notebook?
You can schedule it directly in the notebook interface or orchestrate it via a Data Factory pipeline.
191. What is the “lakehouse explorer” in Fabric?
A UI within the lakehouse that lets you browse tables, files, and create shortcuts, load data, and view properties.
192. How can you secure a Fabric workspace?
Assign workspace roles (Admin, Member, Contributor, Viewer) and use item‑level permissions to control access to individual lakehouses, warehouses, etc.
193. What is the significance of the “Fabric trial capacity”?
A free 60‑day trial of 64 CU capacity that allows users to evaluate all Fabric experiences without any cost.
194. How do you export data from a Fabric lakehouse to on‑premises?
Use a data pipeline with an on‑premises data gateway to connect to local sources, or use Azure Data Factory integration.
195. Explain the concept of “time travel” in Delta Lake within Fabric.
Every write to a Delta table generates a new version. You can query older versions using `TIMESTAMP AS OF` or `VERSION AS OF` to see previous data states.
196. What is the “capacity throttling” and how does it impact workloads?
When consumption exceeds capacity, operations are delayed or rejected. Smoothing helps spread usage, but sustained overage may require scaling up.
197. How do you create a data mesh with Fabric?
Align business domains with Fabric domains, give each domain its own workspace, and use OneLake shortcuts to share trusted data products across domains.
198. What are the different ways to load data into a Fabric lakehouse?
Upload files, data pipelines, dataflows Gen2, notebooks, streaming via Eventstream, or shortcuts.
199. What is the “Data Engineering” experience in Fabric?
It provides a Spark‑based environment with notebooks, job definitions, and the lakehouse for large‑scale data transformation and engineering.
200. How do you optimize Delta tables in Fabric for query performance?
Run `OPTIMIZE` and `VACUUM` commands, use Z‑ordering on filter columns, choose appropriate partition strategy, and maintain small file sizes.
⚙️ Fabric Data Engineering – 30 Q&A
201. How do you create a Spark job definition in Fabric?
In the Data Engineering experience, create a new Spark job definition, reference a script file, set environment parameters, and run on a Spark pool.
202. What languages are supported in Fabric notebooks?
PySpark, Spark SQL, Scala, and R (with limitations). Python is the most common.
203. How do you read a Delta table in a notebook?
`spark.read.format("delta").load("Tables/table_name")` or use the SQL endpoint.
204. Explain V‑Order optimization in Fabric.
A write optimization for Parquet files that improves read performance by sorting and compressing column data, applied automatically in Fabric.
205. How do you implement incremental data load in a Fabric pipeline?
Use a watermark column and Lookup activity to get last loaded value, then copy only records greater than that watermark.
206. What is the “Medallion architecture” in Fabric?
A data design pattern with Bronze (raw), Silver (cleansed), Gold (curated) layers, implemented as lakehouse schemas or separate lakehouses.
207. How do you perform schema evolution in Delta tables?
Set `mergeSchema` option to `true` when writing, or use `autoMerge` to allow new columns automatically.
208. What is the purpose of the `DeltaTable` API in PySpark?
Provides programmatic operations like `delete`, `merge`, `update`, and time travel on Delta tables.
209. How do you handle corrupted records in a data pipeline?
Use schema validation, store bad records in a quarantine area, and alert via Data Activator or Power Automate.
210. How do you monitor Spark job performance in Fabric?
Use the Spark UI from the notebook, or the monitoring hub in Fabric workspace to view logs and execution times.
211. What is the role of the lakehouse “default” schema?
The default schema `dbo` is where tables are created if no schema is specified; it's the landing area for unmanaged tables.
212. How can you share a Spark table across multiple lakehouses?
Use OneLake shortcuts to reference tables from another lakehouse, or create a warehouse that unifies them.
213. What is the “Fabric Runtime” and why does it matter?
It is the pre‑configured Spark environment with specific library versions. Choosing the right runtime ensures compatibility and performance.
214. How do you install custom Python libraries in a Fabric notebook?
Use `%pip install` in a notebook cell, or create an environment with required libraries and attach to the notebook.
215. Explain the difference between managed and external tables in Fabric lakehouse.
Managed tables store data in the lakehouse's managed location; external tables reference data in another location via shortcut or direct path.
216. How do you implement a Slowly Changing Dimension (SCD) Type 2 in Fabric?
Use Delta Lake merge with matched/not matched clauses to expire old records and insert new ones with surrogate keys.
217. What is “Auto Loader” equivalent in Fabric?
While not directly called Auto Loader, you can use Eventstream + Spark streaming to incrementally process new files.
218. How do you execute SQL queries against a lakehouse from a notebook?
`spark.sql("SELECT * FROM lakehouse.table")` or using `%%sql` magic.
219. How can you integrate Azure Machine Learning with Fabric notebooks?
Call Azure ML web service endpoints from the notebook using Python `requests` or `azureml-core` SDK.
220. What are the best practices for partitioning in Fabric Delta tables?
Partition by columns used in filters/joins, keep partitions to a manageable size (avoid over‑partitioning), and use `OPTIMIZE` to compact files.
221. How do you implement data quality checks in a Fabric pipeline?
Use a notebook after ingestion to run validation rules (e.g., null checks, range checks) and write failures to an error table.
222. What is the “Data Engineering” persona’s typical workflow?
Ingest raw data → clean and transform using notebooks → build medallion layers → serve to data scientists or Power BI.
223. How do you use Fabric shortcuts to access ADLS Gen2 data without moving it?
Create a shortcut in the lakehouse pointing to the ADLS container path; it appears as a folder, and data remains in place.
224. How do you convert CSV files to Delta format in Fabric?
Read CSV with Spark, write as Delta: `spark.read.csv("path").write.format("delta").save("Tables/target")`.
225. What is the “Fabric capacity smoothing” concept?
It allows bursts of compute that exceed the per‑second capacity, as long as average over a window stays within limits, preventing immediate throttling.
226. How do you use parameterized notebooks in a pipeline?
Define parameters in the notebook activity in Data Factory, and access them in the notebook using `dbutils.widgets.get()`.
227. How can you implement CI/CD for Fabric notebooks?
Connect workspace to Azure DevOps; notebooks are stored as JSON, can be versioned and deployed across environments via deployment pipelines.
228. What is the purpose of “Fabric workspace identity”?
A managed identity for the workspace that allows secure authentication to external resources without individual user credentials.
229. How do you schedule a notebook to run only on weekdays?
Use the schedule option in the notebook, or orchestrate via a Data Factory pipeline with a scheduled trigger and custom recurrence.
230. How do you debug a failed notebook run?
Check the run log in the monitoring hub, view the Spark UI, and examine error messages; fix and re‑run.
🔁 Integrated Scenarios (Power Apps + Fabric)
Scenario 1: Real‑time inventory app backed by Fabric
Use Fabric Real‑Time Analytics to ingest IoT data, create a lakehouse, and Power Apps canvas app reading from the SQL endpoint to display live stock levels.
Scenario 2: Model‑driven app for customer 360 powered by Fabric warehouse
Aggregate customer data from multiple sources via Data Factory into Fabric warehouse, build a semantic model, and use a model‑driven app with Dataverse virtual tables pointing to Fabric.
🎤 20 Viva / Job Interview Q&A (Expert)
“How would you design a solution that uses both Power Apps and Fabric to reduce operational costs?”
I’d build a canvas app for field workers to submit data, store it in Dataverse, then use Fabric data pipelines to move and aggregate data into a lakehouse for advanced analytics and reporting in Power BI.
No comments:
Post a Comment
Thanks for your valuable comment...........
Md. Mominul Islam