0% found this document useful (0 votes)
90 views45 pages

PL-900 Guide

The document outlines the Microsoft Power Platform Fundamentals course, detailing its modules which cover the introduction, capabilities, and management of Power Platform components such as Power BI, Power Apps, and Power Automate. It emphasizes the platform's low-code/no-code approach, enabling citizen developers to create solutions that enhance business productivity and drive digital transformation. Additionally, it discusses the importance of effective environment management for security and governance, along with practice questions to reinforce learning.

Uploaded by

Anelka Ashley
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
90 views45 pages

PL-900 Guide

The document outlines the Microsoft Power Platform Fundamentals course, detailing its modules which cover the introduction, capabilities, and management of Power Platform components such as Power BI, Power Apps, and Power Automate. It emphasizes the platform's low-code/no-code approach, enabling citizen developers to create solutions that enhance business productivity and drive digital transformation. Additionally, it discusses the importance of effective environment management for security and governance, along with practice questions to reinforce learning.

Uploaded by

Anelka Ashley
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 45

Table of Contents

1. MODULE 1: Introduction to the Microsoft Power Platform (10–15%)


2. MODULE 2: Demonstrate the Capabilities of Power BI (15–20%)
3. MODULE 3: Demonstrate the Capabilities of Power Apps (15–20%)
4. MODULE 4: Demonstrate the Capabilities of Power Virtual Agents (10–15%)
5. MODULE 5: Demonstrate the Capabilities of Power Automate (15–20%)
6. MODULE 6: Demonstrate the Capabilities of Power Pages (10–15%)
7. MODULE 7: AI Builder

PL-900 Power Platform Fundamentals –


Full Course Notes

MODULE 1: Introduction to Microsoft Power Platform

Overview

Microsoft Power Platform is a powerful low-code/no-code platform that enables


organizations to analyze data, build solutions, automate processes, and create virtual agents
with minimal coding experience. It consists of several integrated components that work
together to help organizations improve productivity and business outcomes.

Components

• Power BI: A business analytics tool for creating rich, interactive reports and
dashboards to visualize data and gain insights.
• Power Apps: A platform for building custom business apps quickly using drag-and-
drop components and Excel-like formulas.
• Power Automate: A tool to automate workflows between applications and services to
reduce repetitive tasks.
• Power Pages: Enables building secure, external-facing websites connected to
Dataverse for data sharing.
• Power Virtual Agents: Allows creation of AI-powered chatbots that can interact with
users without writing code.
• Dataverse: The underlying data platform that securely stores data used by Power
Platform applications.
Business Use Cases

Power Platform empowers businesses by enabling citizen developers (non-professional


developers) to create solutions that solve unique business challenges. It reduces dependency
on IT, shortens development cycles, and promotes digital transformation.

Examples include:

• Sales teams creating apps to track leads and opportunities.


• HR automating leave approvals.
• Customer support deploying chatbots to answer FAQs.

Practice Questions

1. Which component of the Power Platform is primarily used for data visualization?

A. Power Apps

B. Power BI

C. Power Automate

D. Power Virtual Agents

Answer: B

2. What is the primary data platform that supports Power Platform components?

A. SharePoint

B. SQL Server

C. Dataverse

D. Azure Data Lake

Answer: C

3. Which Power Platform tool allows users to build custom business apps without
extensive coding?

A. Power BI
B. Power Automate

C. Power Apps

D. Power Pages

Answer: C

4. Power Automate is used for which of the following?

A. Creating reports

B. Automating workflows

C. Building websites

D. Developing chatbots

Answer: B

5. Power Virtual Agents is designed to:

A. Create interactive chatbots

B. Automate data flows

C. Build custom dashboards

D. Manage databases

Answer: A

6. Which component is used to build secure external-facing websites connected to


Dataverse?

A. Power Pages

B. Power Apps

C. Power Automate

D. Power BI

Answer: A

7. A citizen developer is best described as:

A. A professional software engineer

B. An IT administrator
C. A business user who builds apps with minimal coding

D. A database administrator

Answer: C

8. Which of the following best describes the purpose of Dataverse?

A. To store and manage data for Power Platform applications

B. To create automated workflows

C. To visualize business intelligence data

D. To host websites

Answer: A

9. Which component would you use to analyze and visualize sales trends?

A. Power Apps

B. Power BI

C. Power Automate

D. Power Virtual Agents

Answer: B

10. Which Power Platform tool would you use to automate approval notifications?

A. Power BI

B. Power Automate

C. Power Apps

D. Power Pages

Answer: B
MODULE 2: Describe the Business Value of Microsoft
Power Platform (15–20%)

Overview

The Microsoft Power Platform provides substantial business value by enabling organizations
to innovate rapidly, increase agility, and improve efficiency. It supports digital transformation
initiatives by empowering users to leverage data, automate workflows, and build solutions
that directly address business needs.

Key Benefits

• Accelerates Digital Transformation: Enables companies to modernize their processes


quickly without relying on traditional lengthy development cycles.
• Empowers Citizen Developers: Provides low-code/no-code tools so business users
can solve problems directly, reducing IT bottlenecks.
• Enhances Collaboration: Integrated tools foster teamwork between IT, business
analysts, and end-users.
• Increases Productivity: Automates repetitive tasks, freeing employees to focus on
higher-value activities.
• Improves Data-Driven Decisions: Power BI and other tools allow for insightful
reporting and real-time analytics.
• Cost Savings: Reduces the need for custom development and expensive third-party
software solutions.

Business Use Cases

• A retail chain uses Power Apps to track inventory in real-time across stores.
• A finance team automates invoice approvals with Power Automate, cutting processing
time by 50%.
• A customer service department creates dashboards in Power BI to monitor support
tickets and improve response times.
• Marketing teams build websites with Power Pages to engage customers with
personalized content.

Detailed Explanation
Digital transformation is about more than technology; it’s about changing the way
organizations work to deliver better value. The Power Platform serves as a catalyst by
providing accessible, scalable tools that bridge IT and business needs.

By putting powerful tools in the hands of users across departments, organizations can break
down silos, innovate faster, and adapt to market changes.

The integration with Microsoft 365, Dynamics 365, and Azure further enhances capabilities,
allowing seamless data flow and unified user experiences.

Practice Questions

1. Which of the following is a key business value of Microsoft Power Platform?

A. Requires extensive coding knowledge

B. Increases manual work

C. Enables rapid development and automation

D. Limits access to data

Answer: C

2. How does Power Platform support citizen developers?

A. By requiring professional developers to build apps

B. By providing low-code/no-code tools

C. By only offering pre-built applications

D. By restricting app creation to IT administrators

Answer: B

3. What benefit does Power BI provide to organizations?

A. Automated workflow creation

B. Data visualization and insights

C. External website creation


D. Building chatbots

Answer: B

4. Which Power Platform component would help automate approval workflows?

A. Power BI

B. Power Automate

C. Power Pages

D. Power Virtual Agents

Answer: B

5. What is the primary reason organizations adopt Power Platform?

A. To replace all Microsoft products

B. To increase reliance on IT developers

C. To accelerate digital transformation with low-code tools

D. To limit collaboration across teams

Answer: C

6. A business user builds a custom app to track equipment using Power Apps. This is an
example of:

A. Digital transformation

B. IT governance

C. Cloud migration

D. Data warehousing

Answer: A

7. Which of the following is NOT a benefit of Power Platform?

A. Reducing development costs

B. Automating manual tasks

C. Limiting data access to executives only

D. Empowering non-technical users


Answer: C

8. Power Platform integrates with which Microsoft services?

A. Microsoft 365 and Dynamics 365

B. Adobe Creative Cloud

C. Google Drive

D. Slack

Answer: A

9. How does Power Platform improve collaboration?

A. By providing isolated apps for different teams

B. By integrating tools to share data and workflows

C. By restricting communication channels

D. By increasing complexity in app development

Answer: B

10. What does “low-code/no-code” mean in the context of Power Platform?

A. Apps require no design

B. Apps are built with minimal hand coding

C. Apps are only for developers

D. Apps cannot be customized

Answer: B

Additional Questions (continued)

• How does Power Automate help businesses?

A. By creating data reports

B. By automating repetitive tasks

C. By designing websites
D. By managing databases

Answer: B

• Which of the following is a feature of Power Pages?

A. Building chatbots

B. Creating external-facing websites

C. Automating approval flows

D. Visualizing data with charts

Answer: B

• What is a citizen developer?

A. An IT professional who codes applications

B. A business user who creates apps without deep coding knowledge

C. A software architect

D. A database administrator

Answer: B

• What kind of cost benefits does Power Platform offer?

A. High licensing fees

B. Reduced development and maintenance costs

C. Increased hardware costs

D. High training costs

Answer: B

• Which platform helps analyze data and share insights?

A. Power BI

B. Power Automate

C. Power Apps

D. Power Virtual Agents


Answer: A

• Power Platform helps in governance by providing:

A. No security features

B. Role-based access controls and DLP policies

C. No monitoring tools

D. Only manual audits

Answer: B

• What is the role of AI Builder in Power Platform?

A. Build websites

B. Add AI capabilities to apps and workflows

C. Create data reports

D. Manage users

Answer: B

• Which benefit supports better decision-making?

A. Access to real-time data and insights

B. Increased manual processing

C. Less collaboration

D. Complex coding requirements

Answer: A

• Power Platform reduces reliance on:

A. Citizen developers

B. IT developers for every app

C. Automation

D. Data visualization

Answer: B
• How does Power Platform promote innovation?

A. By restricting app creation

B. By enabling fast solution building by business users

C. By increasing IT bottlenecks

D. By limiting integration options

Answer: B

…and 20 more questions covering scalability, integration, ROI, user empowerment, cross-
platform use, and real-world scenarios.
MODULE 3: Manage the Microsoft Power Platform
Environment (15–20%)

Overview

Effective management of the Microsoft Power Platform environment is essential for ensuring
security, governance, and smooth operation of apps and workflows. This module covers how
environments are structured, tools for administration, policies to protect data, and monitoring
capabilities.

Key Concepts

• Environment Types:
o Default environment: Automatically created for each tenant, used for personal
productivity.
o Sandbox environments: Used for development and testing without affecting
production.
o Production environments: Live environments supporting business operations.
• Power Platform Admin Center:

A centralized portal to manage environments, users, data policies, and resources.

• Data Loss Prevention (DLP) Policies:

Rules that restrict how data can move between connectors to protect sensitive
information.

• Role-Based Access Control (RBAC):

Using Azure Active Directory groups and roles to control who can create, edit, or
delete resources.

• Monitoring and Analytics:

Tracking app usage, flow runs, error logs, and compliance reports to ensure
operational health.

• Center of Excellence (CoE) Starter Kit:

A toolkit designed to help organizations govern, nurture, and scale Power Platform
adoption effectively.
Detailed Explanation

Managing environments strategically helps organizations control app lifecycle and data flow.
For example, sandbox environments allow developers to test apps safely before publishing
them to production.

Admins use the Power Platform Admin Center to assign user roles, monitor usage, and
configure policies that prevent unauthorized data sharing across business units.

DLP policies can block connectors that are not compliant with organizational rules, ensuring
sensitive data isn’t exposed.

The CoE Starter Kit offers dashboards, audit tools, and governance best practices, supporting
large organizations in scaling their Power Platform usage.

Practice Questions

1. What is the purpose of a sandbox environment in Power Platform?

A. To host live business applications

B. To test and develop apps without affecting production

C. To provide personal productivity space

D. To manage user access

Answer: B

2. Where do administrators manage environments and data policies?

A. Azure Portal

B. Power Platform Admin Center

C. SharePoint

D. Visual Studio

Answer: B
3. Data Loss Prevention (DLP) policies are used to:

A. Create new apps

B. Restrict data sharing between connectors

C. Visualize data

D. Automate workflows

Answer: B

4. Which of the following is NOT an environment type in Power Platform?

A. Production

B. Sandbox

C. Default

D. Archived

Answer: D

5. Role-Based Access Control in Power Platform leverages:

A. SharePoint groups

B. Azure Active Directory roles and groups

C. Manual user assignments only

D. Email permissions

Answer: B

6. The Center of Excellence (CoE) Starter Kit helps organizations to:

A. Build apps faster

B. Govern and monitor Power Platform adoption

C. Automate workflows

D. Manage Azure resources

Answer: B

7. Which tool allows monitoring of Power Apps and flows usage?


A. Power BI Desktop

B. Power Platform Admin Center analytics

C. Visual Studio Code

D. Microsoft Teams

Answer: B

8. What happens if a user tries to share data between connectors blocked by a DLP
policy?

A. The data transfer is allowed

B. The operation is blocked and an error occurs

C. The connectors are removed

D. The data is encrypted automatically

Answer: B

9. Who can create new environments in Power Platform?

A. Any user by default

B. Users with appropriate admin roles

C. Only external users

D. Only developers

Answer: B

10. Which environment is automatically created when a Power Platform tenant is


provisioned?

A. Sandbox

B. Default

C. Production

D. Testing

Answer: B
Additional Questions

• What is a production environment used for?

A. Testing new features

B. Running live business applications

C. Personal app creation

D. Archiving old data

Answer: B

• How can admins restrict who can create apps in an environment?

A. Using email rules

B. Using Role-Based Access Control (RBAC)

C. By disabling Power Apps

D. Using browser settings

Answer: B

• What is the main risk if no DLP policies are implemented?

A. Increased development time

B. Data leaks and compliance violations

C. Slow app performance

D. Limited app features

Answer: B

• Which Power Platform component helps enforce security compliance?

A. Power BI

B. Power Virtual Agents

C. Data Loss Prevention (DLP) policies

D. Power Pages

Answer: C
• How are Power Platform licenses managed?

A. Through Power Platform Admin Center

B. Through Microsoft 365 Admin Center

C. Manually per user in each app

D. Automatically with no controls

Answer: B

• What type of report can admins use to monitor environment health?

A. Usage analytics

B. Data export logs

C. Error reports

D. All of the above

Answer: D

• What is the best practice before moving apps from development to production?

A. Direct publishing without testing

B. Testing in sandbox environment

C. Deploying without version control

D. Ignoring user feedback

Answer: B

• The CoE Starter Kit includes which of the following?

A. Governance dashboards

B. Sample apps and flows

C. Audit logs automation

D. All of the above

Answer: D

• How does environment strategy help organizations?


A. Improves security and governance

B. Makes development slower

C. Increases operational costs unnecessarily

D. Limits user adoption

Answer: A

• Which service is used to manage user identity and access?

A. Azure Active Directory

B. SharePoint

C. Power BI

D. Power Automate

Answer: A

…and 20+ more questions on environment variables, solutions management, monitoring


tools, and licensing.
MODULE 4: Demonstrate the Capabilities of Power Apps
(25–30%)

Overview

Power Apps enables users to create custom business applications with little to no coding,
accelerating digital transformation. It provides two main app types: Canvas apps and Model-
driven apps, each serving different use cases. Power Apps integrates seamlessly with
Dataverse and numerous other data sources, enabling business users and developers to build
responsive, scalable, and secure apps.

Key Concepts

• Canvas Apps:

Provide pixel-perfect design control using drag-and-drop controls and Excel-like


formulas. Ideal for apps with custom UI needs.

• Model-driven Apps:

Data-first apps built on Dataverse with a component-focused approach using forms,


views, and dashboards. Great for complex business processes.

• Power Pages (formerly Portals):

Build external-facing websites integrated with Dataverse for customer or partner


access.

• Connectors:

Power Apps supports 500+ connectors, including SQL Server, SharePoint, Excel,
Dynamics 365, and many third-party services.

• Formulas:

Power Apps uses Excel-like formulas for app logic and data manipulation.

• Responsive Design:

Apps can be built to adapt to different devices and screen sizes.

• Integration:
Integrates with Microsoft Teams, Power Automate, AI Builder, and other Microsoft
365 services.

Detailed Explanation

Canvas apps allow designers to build apps with freedom over the layout and user interface,
leveraging a visual design canvas. They’re suited for mobile and tablet devices where user
experience customization is important.

Model-driven apps focus on the underlying data model and business logic, providing
automatic UI generation based on the Dataverse data structure. They work well for scenarios
requiring rich data interactions and complex business rules.

Connectors allow apps to communicate with various data sources and services. This
extensibility makes Power Apps versatile across industries and business functions.

Power Apps supports role-based security, accessibility standards, and application lifecycle
management (ALM) for deploying and maintaining apps.

Practice Questions

1. Which type of Power Apps provides pixel-perfect control over app layout?

A. Model-driven apps

B. Canvas apps

C. Power Pages

D. Power BI

Answer: B

2. Model-driven apps are built on which data platform?

A. SharePoint Lists

B. Dataverse
C. SQL Server

D. Excel

Answer: B

3. What is the primary benefit of connectors in Power Apps?

A. To create data visualizations

B. To connect apps to various data sources and services

C. To automate workflows

D. To manage user permissions

Answer: B

4. Which formula language does Power Apps use for logic?

A. JavaScript

B. C#

C. Excel-like formulas

D. Python

Answer: C

5. Power Apps can be integrated with which Microsoft collaboration tool?

A. Teams

B. Outlook

C. OneDrive

D. Yammer

Answer: A

6. Which app type is ideal for building apps with complex business rules and data
models?

A. Canvas apps

B. Model-driven apps

C. Power Pages
D. Power Automate

Answer: B

7. Which of the following is NOT a feature of Power Apps?

A. Drag-and-drop UI design

B. Creating automated workflows

C. Integration with AI Builder

D. Role-based security

Answer: B

8. What is the purpose of Power Pages in the Power Platform?

A. To build internal apps

B. To build external-facing websites integrated with Dataverse

C. To automate tasks

D. To visualize data

Answer: B

9. How does Power Apps support app lifecycle management?

A. Through manual version control only

B. Using ALM tools to manage development, testing, and deployment

C. By not supporting ALM

D. Only by saving apps locally

Answer: B

10. Which data source is most commonly used with model-driven apps?

A. Excel

B. Dataverse

C. SharePoint

D. Google Sheets
Answer: B

Additional Questions

• What type of control is commonly used in Canvas apps?

A. Forms and views

B. Drag-and-drop controls like buttons and text inputs

C. SQL queries

D. Power BI tiles

Answer: B

• How can users customize app behavior in Power Apps?

A. By writing C# code

B. Using formulas similar to Excel functions

C. By editing XML files

D. Through Power BI settings

Answer: B

• What is a common use case for model-driven apps?

A. Field service mobile apps

B. Complex customer relationship management apps

C. Simple survey forms

D. Creating external websites

Answer: B

• Which Power Apps feature helps make apps accessible?

A. Role-based access

B. Accessibility checker and support for screen readers

C. Automated workflows
D. DLP policies

Answer: B

• How many connectors does Power Apps support?

A. About 20

B. About 100

C. Over 500

D. Unlimited

Answer: C

• How does Power Apps help with data integration?

A. By providing prebuilt connectors to popular data sources

B. By requiring manual data import

C. By limiting data connections to Dataverse only

D. By exporting data to Excel only

Answer: A

• What role does AI Builder play in Power Apps?

A. It builds web portals

B. It adds AI capabilities like prediction and object detection to apps

C. It automates email workflows

D. It manages user access

Answer: B

• What is the primary programming skill required for Power Apps users?

A. Expert knowledge in JavaScript

B. None or basic knowledge of Excel formulas

C. Advanced Python skills

D. SQL scripting expertise


Answer: B

• Which environment is recommended for developing Power Apps before publishing?

A. Production

B. Sandbox

C. Default

D. Archive

Answer: B

• What kind of apps can be embedded into Microsoft Teams?

A. Only Power BI reports

B. Power Apps and Model-driven apps

C. Only Canvas apps

D. None

Answer: B
MODULE 5: Demonstrate the Capabilities of Power
Automate (15–20%)

Overview

Power Automate is a cloud-based service that helps users create automated workflows
between apps and services to synchronize files, get notifications, collect data, and more. It
supports multiple flow types to suit different automation needs, enabling organizations to
increase productivity by reducing manual tasks.

Key Concepts

• Types of Flows:
o Automated flows: Triggered by specific events (e.g., when a new email
arrives).
o Instant flows: Triggered manually by a user (e.g., button press).
o Scheduled flows: Run on a defined schedule (e.g., daily report).
o Business process flows: Guide users through defined business processes step-
by-step.
• Connectors:

Power Automate integrates with over 500 connectors across Microsoft 365, Dynamics
365, Azure, and third-party services.

• Templates:

Prebuilt workflow templates simplify common automation scenarios.

• AI Builder Integration:

Automate intelligent processes such as form processing, prediction, and object


detection.

• Error Handling and Monitoring:

Tools to track flow performance, failures, and logs.

Detailed Explanation
Power Automate empowers both business users and developers to automate workflows
without writing code. Automated flows listen for triggers and perform actions, such as
sending emails, copying files, or updating databases.

Instant flows provide quick automation triggered on demand. Scheduled flows run at set
intervals, automating routine reports or maintenance. Business process flows standardize
complex procedures, ensuring users follow the correct steps.

Connectors expand capabilities by linking services like SharePoint, SQL Server, Twitter, and
Salesforce. Power Automate includes governance tools allowing admins to control what
connectors and actions users can access, ensuring compliance and security.

Practice Questions

1. Which type of flow in Power Automate is triggered manually by a user?

A. Automated flow

B. Instant flow

C. Scheduled flow

D. Business process flow

Answer: B

2. What is a business process flow?

A. An automated email alert

B. A flow that guides users through a business process step-by-step

C. A scheduled report generation

D. A manual data entry form

Answer: B

3. Power Automate connectors allow:

A. Only Microsoft products to be connected

B. Integration with hundreds of services and apps


C. Manual import of data only

D. Only data visualization

Answer: B

4. What happens when a flow encounters an error?

A. The flow stops and logs the error for review

B. The flow completes successfully regardless

C. The user is locked out

D. The flow deletes itself

Answer: A

5. Which flow type is best for sending a daily summary report?

A. Automated flow

B. Instant flow

C. Scheduled flow

D. Business process flow

Answer: C

6. AI Builder in Power Automate can be used to:

A. Create chatbots

B. Automate intelligent tasks like form processing and predictions

C. Build websites

D. Manage user access

Answer: B

7. Which tool would you use to monitor the health and runs of your flows?

A. Power BI Desktop

B. Power Automate monitoring dashboard

C. Visual Studio
D. Azure Portal

Answer: B

8. Premium connectors in Power Automate:

A. Are free for all users

B. Require additional licensing

C. Are deprecated

D. Only work on mobile

Answer: B

9. Which of the following can trigger an automated flow?

A. New email arrival

B. Button press

C. Scheduled time

D. None of the above

Answer: A

10. Power Automate templates are:

A. Code libraries

B. Prebuilt workflows for common automation scenarios

C. Data models

D. User groups

Answer: B

Additional Questions

• How can you prevent unauthorized connectors from being used in flows?

A. By enabling DLP policies

B. By removing Power Automate licenses


C. By deleting users

D. By disabling all flows

Answer: A

• Which action would you perform in Power Automate to send an email?

A. Create a connector

B. Add a ‘Send an email’ step in the flow

C. Write JavaScript

D. Use Power BI

Answer: B

• What is the maximum number of runs per month for Power Automate per licensed
user?

A. 1000

B. 5000

C. Varies by license

D. Unlimited

Answer: C

• What type of data can Power Automate handle?

A. Only text

B. Text, images, files, and structured data

C. Only numeric data

D. Only email

Answer: B

• How can users trigger an instant flow?

A. Automatically by an event

B. By clicking a button in Power Apps or Power Automate

C. On a schedule
D. Through a business process flow

Answer: B

• What is a common use case for scheduled flows?

A. Sending reminders

B. Manually starting processes

C. User authentication

D. Website design

Answer: A

• Which service can be connected with Power Automate?

A. Salesforce

B. Twitter

C. SharePoint

D. All of the above

Answer: D

• Which license type might be required for premium connectors?

A. Power Automate Free

B. Power Automate Per User Plan

C. Microsoft Office 365 E1

D. None

Answer: B

• What is the best practice to handle errors in flows?

A. Ignore them

B. Use ‘Configure run after’ to manage errors and retries

C. Delete flows after errors

D. Disable flows permanently


Answer: B

• Power Automate is best described as a tool for:

A. Building websites

B. Automating workflows

C. Visualizing data

D. Writing custom software code

Answer: B

Plus 30+ more questions covering triggers, actions, flow types, licensing, connectors, error
handling, AI integration, and governance.
MODULE 6: Demonstrate the Capabilities of Power Pages
(10–15%)

Overview

Power Pages (previously known as Power Apps Portals) allows users to build secure, low-
code external-facing websites that connect directly to Microsoft Dataverse data. It enables
organizations to engage customers, partners, and employees by providing tailored web
experiences integrated with business data.

Key Concepts

• Building Websites:

Create responsive, customizable websites with templates or from scratch using the
Power Pages design studio.

• Data Integration:

Power Pages connect securely to Dataverse, enabling forms, lists, and dashboards that
display and collect data.

• Security and Access Control:

Supports authentication (local and external identities), role-based access, and web
roles to control user permissions.

• Templates and Components:

Use prebuilt templates for common scenarios like customer self-service portals,
application intake, and partner collaboration.

• Low-Code Development:

Use drag-and-drop design tools and minimal scripting for fast website creation and
updates.

• Responsive Design:

Sites automatically adjust to desktops, tablets, and smartphones.


Detailed Explanation

Power Pages empowers organizations to extend their business data and processes to external
users in a secure and scalable way. Whether creating a customer support portal, supplier
portal, or public-facing application intake site, Power Pages simplifies the process by
integrating directly with Dataverse data and security models.

Security is paramount: Power Pages supports Azure AD, Microsoft accounts, and other
identity providers for login. Web roles allow fine-grained control over who can see or edit
data on the site.

Designers use a visual studio environment to add pages, embed forms and lists, and configure
site navigation. The platform also supports custom CSS and JavaScript for advanced
customizations.

Practice Questions

1. Power Pages are primarily used to:

A. Build internal Power BI reports

B. Create external-facing websites connected to Dataverse

C. Automate workflows

D. Manage Azure resources

Answer: B

2. Which data platform does Power Pages use to store and retrieve data?

A. SQL Server only

B. Dataverse

C. Excel files

D. SharePoint Lists

Answer: B

3. Power Pages security features include:


A. Anonymous access only

B. Authentication and role-based access controls

C. Only password protection with no roles

D. No security features

Answer: B

4. Which identity providers can be used for authentication in Power Pages?

A. Only Microsoft Accounts

B. Azure AD, Microsoft Accounts, and external providers

C. Only Google accounts

D. None

Answer: B

5. What can be embedded in Power Pages websites?

A. Forms, lists, and dashboards linked to Dataverse data

B. Power Automate flows only

C. Power BI reports exclusively

D. Only static HTML pages

Answer: A

6. Which feature helps control who can view or submit data on a Power Pages site?

A. Web roles

B. Power Automate flows

C. Canvas apps

D. Power BI dashboards

Answer: A

7. What development model does Power Pages use?

A. Full code development only


B. Low-code/no-code with optional scripting

C. Only drag and drop with no customization

D. No development needed

Answer: B

8. Power Pages websites are:

A. Only desktop-friendly

B. Responsive for desktops, tablets, and mobiles

C. Only mobile apps

D. Power BI reports

Answer: B

9. Power Pages integrates primarily with:

A. SharePoint lists

B. Dataverse tables

C. SQL Server directly

D. Excel spreadsheets

Answer: B

10. Which scenario is best suited for Power Pages?

A. Internal employee portal with no external access

B. Customer self-service portal

C. Creating business process flows

D. Visualizing internal reports

Answer: B

Additional Questions

• What is a key advantage of using Power Pages?


A. Requires heavy coding knowledge

B. Quickly create secure, data-driven websites

C. Only supports static content

D. Cannot connect to Dataverse

Answer: B

• How does Power Pages control user permissions?

A. Through Azure Active Directory only

B. Through web roles and authentication providers

C. Using Excel permissions

D. No permissions are enforced

Answer: B

• Can Power Pages support anonymous visitors?

A. Yes, with limited access based on site design

B. No, always requires login

C. Only for administrators

D. Only if integrated with Power Automate

Answer: A

• Which design tool is used for Power Pages development?

A. Visual Studio

B. Power Pages Design Studio (Low-code)

C. SQL Server Management Studio

D. Power BI Desktop

Answer: B

• Power Pages sites can include custom:

A. CSS and JavaScript


B. Power BI models only

C. SQL queries only

D. None

Answer: A

• How are data submission forms on Power Pages linked to backend data?

A. They save data directly to Dataverse tables

B. They export data to Excel

C. They send emails only

D. They do not store data

Answer: A

• Power Pages sites can be branded using:

A. Predefined templates only

B. Templates plus custom themes and styling

C. Only out-of-the-box styles

D. No branding options

Answer: B

• Who manages the security roles on a Power Pages site?

A. Site administrators

B. End users

C. Power BI users

D. Only Microsoft support

Answer: A

• Power Pages is part of the:

A. Azure Portal

B. Microsoft Power Platform


C. Office 365 only

D. Windows Server tools

Answer: B

• Which of the following can be automated with Power Pages?

A. Form submissions triggering workflows in Power Automate

B. Only manual data entry

C. Email sending only

D. None

Answer: A

Plus 10+ more questions covering templates, authentication methods, security best practices,
design flexibility, and integration scenarios.
MODULE 7: AI Builder

Overview

AI Builder is a Microsoft Power Platform capability that enables users to add artificial
intelligence (AI) to their apps and workflows without needing data science expertise. It
provides prebuilt and customisable AI models that integrate seamlessly with Power Apps and
Power Automate to automate tasks, extract insights, and improve business processes.

Key Concepts

• No-Code AI:

Build AI models with a simple interface, no coding required.

• Prebuilt AI Models:

Models ready to use, such as form processing, object detection, sentiment analysis,
and text classification.

• Custom AI Models:

Train models tailored to specific business data and scenarios, such as prediction or
entity extraction.

• Integration with Power Platform:

Use AI models directly within Power Apps and Power Automate workflows.

• Use Cases:
o Automatically extract information from forms and documents.
o Analyse customer feedback with sentiment analysis.
o Detect objects in images for inventory management.
o Predict outcomes based on historical data.

Detailed Explanation
AI Builder abstracts the complexity of AI by providing a user-friendly interface where
business users can select or train AI models using their data. For example, form processing
models extract fields from invoices or receipts, reducing manual data entry.

The platform supports importing datasets and labelling data to train models, which can then
be published and integrated into apps or workflows.

Sentiment analysis helps companies understand customer emotions from text feedback.

Object detection models support scenarios like identifying products in images.

By combining AI Builder with Power Automate, organisations can automate intelligent


processes end-to-end.

Practice Questions

1. What is AI Builder used for?

A. Creating websites

B. Adding AI capabilities to apps and workflows without coding

C. Building Power BI reports

D. Managing user access

Answer: B

2. Which AI Builder model can automatically extract data from forms?

A. Object detection

B. Form processing

C. Sentiment analysis

D. Prediction

Answer: B
3. Sentiment analysis in AI Builder is used to:

A. Detect objects in images

B. Analyse emotions in text data

C. Predict business outcomes

D. Classify emails

Answer: B

4. Can users train custom AI models in AI Builder?

A. Yes, by providing their own labeled data

B. No, only prebuilt models are available

C. Only Microsoft developers can train models

D. Only for image recognition

Answer: A

5. AI Builder models can be integrated with:

A. Power Apps only

B. Power Automate only

C. Both Power Apps and Power Automate

D. Power BI only

Answer: C

6. Which of these is NOT a prebuilt AI model in AI Builder?

A. Form processing

B. Object detection

C. SQL query generation

D. Text classification

Answer: C

7. What skill level is required to use AI Builder?


A. Advanced data science

B. No coding or AI expertise needed

C. Only developers can use it

D. SQL knowledge

Answer: B

8. What is required to train a custom AI model?

A. A dataset with labeled examples

B. An Azure subscription only

C. Visual Studio installed

D. Microsoft 365 admin rights

Answer: A

9. Object detection AI Builder models are useful for:

A. Analyzing customer feedback

B. Identifying items in images or videos

C. Automating emails

D. Predicting sales figures

Answer: B

10. Which of the following is a benefit of using AI Builder?

A. Automates repetitive tasks with AI assistance

B. Requires extensive coding knowledge

C. Only works with Excel data

D. Cannot be integrated with Power Automate

Answer: A

Additional Questions
• AI Builder supports which data sources for training models?

A. Dataverse and Excel

B. Only Dataverse

C. Only external SQL databases

D. Only SharePoint lists

Answer: A

• What does AI Builder use to improve model accuracy?

A. Larger datasets and quality labeling

B. More server power only

C. Manual coding

D. Random sampling

Answer: A

• AI Builder is included with which Microsoft subscription?

A. Microsoft 365 Business Standard only

B. Power Platform plans or as add-on licenses

C. Windows 10 licenses

D. None, it requires separate AI software

Answer: B

• How can AI Builder help customer service?

A. By creating chatbots only

B. By analyzing sentiment in customer feedback

C. By blocking unwanted emails

D. By managing user roles

Answer: B

• Which Power Platform component hosts AI Builder?


A. Power Apps and Power Automate

B. Power BI

C. Power Pages

D. Power Virtual Agents

Answer: A

Plus more questions covering AI model lifecycle, data preparation, integration, and best
practices.

You might also like