Study guide

13.1 Environment Types: Default, Sandbox, Production, Trial, Developer

Microsoft Power Platform Functional Consultant PL-200

Track your progress as you read

Finished sections get a check mark.

1 Chapter 1: Dataverse Tables, Relationships & Core Columns

1.1 Dataverse Table Types, Properties & Ownership 1.2 Table Relationships & Cascading Rules 1.3 Column Types, Formats, Primary Keys & Alternate Keys 1.4 Rollup, Calculated & Formula Columns with Power Fx

2 Chapter 2: Dataverse Data Management & Governance

2.1 Dataverse Search, Quick Find & Relevance Indexing 2.2 Auditing Configuration & Log Management 2.3 Duplicate Detection Rules & Settings 2.4 Bulk Record Operations, Data Import, Export & Templates

3 Chapter 3: Dataverse Security Model & Access Control

3.1 Business Units, Ownership Models & Modern BU Matrix 3.2 Security Roles, Privileges & Depth Levels 3.3 Teams Architecture: Owner, Access, and Microsoft Entra (AAD) Group Teams 3.4 Column-Level Security & Hierarchy Security Models

4 Chapter 4: Model-Driven App Fundamentals & Information Architecture

4.1 Model-Driven App Design, Site Map Navigation & Modern App Designer 4.2 Form Types: Main, Quick Create, Quick View & Card Forms 4.3 View Configuration, System Views, Personal Views & Filters

5 Chapter 5: Advanced Model-Driven App Components & Custom Pages

5.1 Custom Pages & Modern Commanding with Power Fx 5.2 Form Component Controls & Specialized UX Elements 5.3 Embedding Canvas Apps in Model-Driven Forms 5.4 Embedding Power BI Reports, Dashboards & Tiles

6 Chapter 6: Canvas Apps Structure, Formulas & Data Operations

6.1 Canvas App Architecture, Screens, Containers & Controls 6.2 Power Fx Formulas, Delegation & Data Source Limits 6.3 Variables (Context, Global), Collections & State Management 6.4 Triggering Power Automate Cloud Flows from Canvas Apps

7 Chapter 7: Power Pages Site Design, Navigation & Content

7.1 Power Pages Design Studio & Site Structure 7.2 Power Pages Templates, Styling & Responsive Layouts 7.3 Web Pages, Navigation Menus & Content Snippets

8 Chapter 8: Power Pages Data Integration, Forms & Web Roles

8.1 Power Pages Lists, Basic Forms & Advanced Forms 8.2 Table Permissions, Web Roles & Page Access Security 8.3 External Identity Providers & Authentication Configuration

9 Chapter 9: Power Automate Cloud Flow Fundamentals & Triggers

9.1 Cloud Flow Types: Automated, Instant, Scheduled & Desktop Overview 9.2 Dataverse Connector Triggers & Operational Filters 9.3 Standard Connectors, Custom Connectors & Connection References

10 Chapter 10: Cloud Flow Actions, Expressions & Logic Controls

10.1 Logic Controls: Conditions, Switches, Apply to Each & Do Until Loops 10.2 Variables, Data Operations & Dynamic Content Manipulation 10.3 Power Automate Expression Language (WDL / Functions) 10.4 Error Handling, Configure Run After & Scope Controls

11 Chapter 11: Business Process Flows & Guided Processes

11.1 Business Process Flow Architecture, Stages, Steps & Data Steps 11.2 Branching Rules & Multi-Entity Business Process Flows 11.3 BPF Action Steps, Workflows & Cloud Flow Execution 11.4 BPF Security Roles, Order & Process Lifecycle

12 Chapter 12: Classic Workflows, Business Rules & Modern Logic Extensibility

12.1 Classic Dataverse Workflows: Real-Time vs. Background (Async) 12.2 Business Rules: Scope & Actions 12.3 Low-Code Plug-ins in Dataverse: Automated vs. Instant 12.4 Troubleshooting Automations, Run History & Analytics

13 Chapter 13: Power Platform Environment Architecture & Security

13.1 Environment Types: Default, Sandbox, Production, Trial, Developer 13.2 Environment Governance, Groups, Routing & Capacity Management 13.3 Data Loss Prevention (DLP) Policies & Connector Classifications

14 Chapter 14: Application Lifecycle Management (ALM) & Solutions

14.1 Unmanaged vs. Managed Solutions & Solution Layering Mechanics 14.2 Solution Components, Dependencies, Publishers & Prefixes 14.3 Exporting, Importing, Upgrading & Patches 14.4 Solution Checker, App Checker & ALM Best Practices

15 Chapter 15: Enterprise Interoperability & Service Integration

15.1 Exchange / Server-Side Synchronization & Email Integration 15.2 SharePoint & OneDrive Document Management Integration 15.3 Microsoft Word & Excel Document Templates

16 Chapter 16: Copilot, AI Capabilities & Exam Strategy

16.1 Copilot Studio & Generative AI across Power Platform 16.2 AI Builder Prebuilt & Custom Models in Apps and Flows 16.3 PL-200 Exam Strategy, Time Management & Question Analysis

13.1 Environment Types: Default, Sandbox, Production, Trial, Developer

Key Takeaways Explain This Topic AI

Power Platform environments act as fully isolated governance and security containers with distinct Dataverse databases, regional data residency boundaries, and localized role-based access control.

The Default environment is automatically created for every Microsoft Entra tenant, cannot be deleted or disabled, grants all licensed users Maker permissions, and is intended strictly for personal citizen productivity—never enterprise ALM or mission-critical workloads.

Sandbox environments provide non-production isolation for development, testing, and UAT, supporting specialized Admin Mode controls, environment resets, and both Full (schema + all data) and Minimal (schema + customizations only) copy operations.

Production environments host live business workloads under Microsoft enterprise SLAs, benefit from up to 28 days of continuous automated backups, and require conversion to Sandbox before performing destructive lifecycle operations like Reset.

Developer environments (Power Apps Developer Plan) provide individual makers with a dedicated, isolated Dataverse instance featuring full premium connector capabilities for building and testing without consuming tenant capacity or sharing runtime workloads.

Last updated: August 2026

Power Platform Environment Types & Lifecycle Management

In the Microsoft Power Platform, an Environment is the foundational container that isolates and manages an organization's business data, relational database schema, canvas and model-driven applications, Power Automate cloud flows, Copilot Studio chatbots, custom connectors, and role-based security configurations. Every environment is bound to a specific geographical region (such as North America, Europe, or Asia-Pacific) to ensure strict data residency and compliance. For the PL-200 Functional Consultant certification, you must thoroughly understand the characteristics, boundaries, and governance constraints of all five environment types, as well as how to execute administrative lifecycle operations.

1. Environment Architecture & The Five Environment Types

Environments provide logical and physical boundaries within a Microsoft Entra ID tenant. Understanding when and where to deploy each environment type is central to architecting robust Application Lifecycle Management (ALM) pipelines and security boundaries. +-----------------------------------------------------------------------------------+

  • | POWER PLATFORM TENANT ENVIRONMENT TOPOLOGY |
  • | |
  • | +-----------------------------------------------------------------------------+ |
  • | | DEFAULT ENVIRONMENT: "<Tenant Name> (default)" | |
  • | | - Automatically provisioned; Cannot be deleted; All users are Makers | |
  • | | - Dedicated to personal productivity and Microsoft 365 integrations | |
  • | +-----------------------------------------------------------------------------+ |
  • | |
  • | +---------------------------+ +---------------------------+ +---------------+ |
  • | | SANDBOX ENVIRONMENT | | PRODUCTION ENVIRONMENT | | DEVELOPER | |
  • | | - Dev, Test, Staging, UAT | | - Live Enterprise Systems | | SANDBOX | |
  • | | - Admin Mode & Resets | | - 28-day Auto Backups | | - 1 Maker | |
  • | | - Full & Minimal Copy | | - Enterprise SLA Backed | | - Premium Conn| |
  • | +---------------------------+ +---------------------------+ +---------------+ |
  • | |
  • | +-----------------------------------------------------------------------------+ |
  • | | TRIAL ENVIRONMENTS | |
  • | | - Standard Trial: 30-day lifecycle, 1 GB cap, self-service provisioning | |
  • | | - Subscription Trial: Governed by commercial license term, multi-user test | |
  • | +-----------------------------------------------------------------------------+ |
  • +-----------------------------------------------------------------------------------+
  • 1. The Default Environment

Provisioning & Permanence: Automatically generated in the tenant's home region as soon as the first Power Platform or Microsoft 365 license is assigned. It is named <Tenant Name> (default) .

Undeletable: The Default environment cannot be deleted, disabled, or renamed out of its default role.

Implicit Access & Maker Permissions: Every user licensed with Microsoft 365, Office 365, or Power Apps is automatically added to the environment and assigned the Environment Maker security role. They can create canvas apps, cloud flows, and personal connections immediately.

Architectural Use Case: Designed exclusively for personal productivity (e.g., a manager building an automated flow to save personal email attachments to OneDrive or a team survey form). It must never be used for enterprise solutions, complex Dataverse customizations, multi-environment ALM, or critical departmental apps.

2. Sandbox Environments

Purpose: Non-production environments tailored for development, solution integration, quality assurance (QA), user acceptance testing (UAT), and pre-production staging.

Isolation Capabilities: Supports Admin Mode , allowing administrators to lock out end users and disable background automations during maintenance or deployment windows.

Destructive Lifecycle Support: Can be completely Reset (wiping all data and schema) or targeted by Copy operations without restrictions.

Backup Retention: Protected by continuous automated system backups retained for 7 days .

3. Production Environments

Purpose: Dedicated exclusively to permanent, live, operational business applications, mission-critical Dataverse databases, and production Power Automate automations.

SLA & High Availability: Backed by Microsoft's 99.9% uptime enterprise Service Level Agreement (SLA).

Extended Backup Retention: Benefits from continuous automated system backups retained for up to 28 days .

Protection Against Accidental Destruction: Production environments cannot be reset or overwritten by a restore directly without first converting the environment type to Sandbox in the Power Platform Admin Center (PPAC).

4. Trial Environments (Standard vs. Subscription-Based)

Standard (Self-Service) Trial:

Created by individual makers or administrators via the admin center or Power Apps studio.

Limited to a 30-day expiration window and a fixed 1 GB database storage cap .

Can be converted directly to a Production environment if the tenant possesses sufficient paid database capacity before the 30-day period lapses.

Subscription-Based Trial:

Provisioned when purchasing trial subscriptions of enterprise suites (such as Dynamics 365 Sales or Power Apps per-user trial licenses).

Does not expire in 30 days automatically; instead, its expiration date is tied directly to the commercial subscription license expiration and renewal terms.

Supports larger storage allocations and multi-user testing workloads.

5. Developer Environments (Power Apps Developer Plan)

Individual Isolation: Dedicated single-user environments created for developers and makers who sign up for the free Power Apps Developer Plan.

Feature Richness: Includes a fully functional Microsoft Dataverse database instance and unlocks all Premium Connectors (e.g., SQL Server, HTTP with Entra ID, Salesforce), custom connectors, low-code plug-ins, and model-driven app capabilities without requiring paid per-user licenses.

Governance & Sharing Restrictions: The creator is automatically assigned the System Administrator role. However, Developer environments cannot be used to run production workloads—apps and flows built inside a Developer environment cannot be shared with standard end users for day-to-day operations. They are designed strictly for building, testing, and exporting managed solutions into enterprise ALM pipelines.

Environment Type Dataverse Database Database Capacity Cost Backup Retention Admin Mode Support Reset & Overwrite Support Primary Purpose

  • Default Optional / Included Consumes Tenant Pool 7 Days No No (Cannot Reset) Citizen personal productivity
  • Sandbox Yes (Dedicated) 1 GB Minimum to create 7 Days Yes Yes Dev, Testing, Staging, UAT

Production Yes (Dedicated) 1 GB Minimum to create 28 Days No (Must convert) Must convert to Sandbox Live business applications

  • Standard Trial Yes (1 GB Cap) Independent (1 GB free) 7 Days Yes Yes Short-term 30-day evaluation
  • Subscription Trial Yes Bound to Trial License 7 Days Yes Yes Proof-of-concept testing
  • Developer Yes (Dedicated) Independent quota 7 Days No No (Owner managed) Learning, development, ALM export
  • 2. Environment Lifecycle Operations

Administrators manage the operational state of environments throughout the application development lifecycle. The Power Platform Admin Center (PPAC) exposes five core operations: +-----------------------------------------------------------------------------------+

  • | ENVIRONMENT LIFECYCLE OPERATIONS |
  • | |
  • | [BACKUP & RESTORE] ---> Continuous System Backups (7/28 days) + Manual Snapshots |
  • | - Restore overwrites existing or provisions target |
  • | |
  • | [COPY OPERATION] ---> Source (Prod/Sandbox) ===> Target (Sandbox/Trial only) |
  • | - FULL COPY: Schema + Solutions + All Record Data |
  • | - MINIMAL COPY: Schema + Solutions + Users ONLY (No Data)|
  • | |
  • | [ADMIN MODE] ---> Restricts login to Admins/Customizers; Disables flows |
  • | |
  • | [RESET] ---> Deletes Dataverse DB & recreates fresh (Sandbox only) |
  • | |
  • | [TYPE CONVERSION] ---> Production <=====> Sandbox (Requires 1 GB available DB) |
  • +-----------------------------------------------------------------------------------+
  • 1. Backup and Restore Operations

System (Automated) Backups: Continuous, transactional backups take place automatically in Azure storage. No administrative scheduling is necessary. Production environments maintain restore points for 28 days , while Sandbox and Trial environments retain restore points for 7 days .

Manual (On-Demand) Backups: Administrators can create manual backup snapshots prior to major solution deployments, data migrations, or schema refactoring. Manual backups are retained for up to 7 days and do not count against tenant storage capacity limits.

Restore Mechanics & Constraints:

Restores can be targeted to overwrite an existing Sandbox environment or provision a newly named environment.

The source and target environments must reside within the same Microsoft Entra tenant and identical geographical region .

When an environment is restored, it is automatically placed into Admin Mode to prevent external integrations or users from interacting with unverified data.

2. Copy Operations: Full Copy vs. Minimal Copy

A Copy operation replicates an entire environment (Source) into another existing environment (Target). The target environment must be a Sandbox or Trial environment —you cannot directly overwrite a Production environment.

Full Copy:

Replicates all database schema, metadata, solutions, users, security roles, system configurations, AND all application data rows/records (including attachments and audit logs).

Typically used for reproducing production issues in UAT, testing major database upgrades with real data volumes, or dry-running data migration scripts.

Minimal Copy:

Replicates all database schema, metadata, solutions, security roles, and user mappings, but zero business record data .

The target environment contains the complete data model, custom tables, business rules, and forms, but tables are empty of customer records.

Commonly used when provisioning fresh development or staging environments where developers need the exact solution architecture without copying sensitive or bulky production data.

Important

Target Environment Admin Mode Behavior: Both Full and Minimal Copy operations automatically place the target environment into Admin Mode upon completion. This safety feature disables asynchronous background processes (such as Power Automate flows and classic workflows) and sets the Target URL to prevent duplicate actions or accidental emails to real customers.

3. Reset Operation

A Reset operation completely erases the Dataverse database and associated application storage, reprovisioning a clean, empty Dataverse instance in its place.

Rules & Restrictions: Only Sandbox and Trial environments can be reset. If an organization needs to reset a Production environment, an administrator must first edit the environment properties in PPAC, change the environment type to Sandbox, and then execute the Reset command.

4. Delete and Soft-Delete Recovery

Deleting an environment permanently purges all custom solutions, apps, flows, and data, instantly releasing its database, file, and log capacity back into the organization's tenant pool.

The Default environment can never be deleted .

Recovery Window: Deleted environments enter a soft-delete state and can be recovered by a Power Platform Administrator or Global Administrator within 7 days via the PPAC "Recently deleted environments" interface.

5. Environment Type Conversion

Administrators can convert a Sandbox environment to Production or a Production environment to Sandbox at any time through PPAC.

Capacity Prerequisite: Converting an environment to Production or provisioning a new Dataverse database requires at least 1 GB of available Database capacity in the tenant storage pool.

3. Admin Mode & Maintenance Isolation

When preparing to import large enterprise solution packages, execute schema updates, or conduct bulk data migrations, functional consultants should place the Sandbox environment into Admin Mode . +-----------------------------------------------------------------------------+

  • | ADMIN MODE CONFIGURATION |
  • | |
  • | [X] Enable Admin Mode |
  • | |
  • | [X] Background Operations |
  • | - When DISABLED: Suspends AsyncService, Power Automate Flows, |
  • | Exchange email sync, and classic background workflows. |
  • | |
  • | Custom Message: "Environment under scheduled maintenance. Available at 9am"|
  • +-----------------------------------------------------------------------------+
  • Core Features of Admin Mode

Restricted User Access: Only users assigned the System Administrator or System Customizer security roles can sign in to the environment. Standard business users attempting to access the URL receive a clean maintenance message.

Background Operations Toggle: Administrators can uncheck Background Operations to suspend the Dataverse Asynchronous Processing Service ( AsyncService ). This stops all Power Automate cloud flows, classic background workflows, and server-side Exchange synchronization from executing during the deployment, preventing race conditions or false alerts.

Custom Sign-In Message: A custom banner or notification message can be authored to inform any authenticated administrative users of the ongoing maintenance window and expected completion time.

Tip

Post-Copy Verification Checklist: After performing an environment copy or restore, always verify environment variables, test connection references, and confirm integration endpoints before turning off Admin Mode and re-enabling Background Operations.