Foundational Components

Question 1

What is a Power Platform environment?

Answer 1

A Power Platform environment is a container for a business’s apps, data, and storage. It can have its own Microsoft Dataverse database (though optional) and is linked to a specific geographical location for data residency and compliance.

Question 2

Under which directory are Power Platform environments created?

Answer 2

Power Platform environments are created under the Azure Active Directory (AAD)

Question 3

Why is it important to create separate environments for each phase of the Software Development Life Cycle (SDLC)?

Answer 3

Creating separate environments for development, testing, and production helps maintain proper governance, version control, and reduces the risk of issues affecting live production systems.

Question 4

Can external users access Power Platform environments? If so, how?

Answer 4

Yes, external users can access Power Platform environments if administrators grant them access.

Question 5

What role does geographical location play in Power Platform environments?

Answer 5

Geographical location determines where the environment’s data is stored, which is important for data residency and compliance with local regulations.

Question 6

Name two key features of the Power Platform Admin Portal.

Answer 6

Data Integration – Connects Microsoft Dataverse to third-party data sources such as Salesforce, SQL Server, etc.

Admin Centers – Provides access to admin centers that impact Power Platform, including security, compliance, and environment settings.

Question 7

What are two key features of the Power Apps Maker Portal?

Answer 7

Environment Information – View and manage apps, data, and resources within a specific environment.

Solutions – Access, create, and manage solutions, which are packages of apps, flows, and customizations for a particular environment.

Question 8

What is a Managed Environment in Power Platform?

Answer 8

A Managed Environment is a premium feature that provides enhanced control, security, and governance for Power Platform environments.

Question 9

Name two features enabled by Managed Environments.

Answer 9

Pipeline Creation – Enables deployment pipelines for app versioning.

Data Policies – Allows administrators to apply data policies to ensure compliance and security.

Question 10

What is Microsoft Dataverse?

Answer 10

Microsoft Dataverse is a cloud-based solution that stores data, business logic, and security. It supports data storage, logic, and integration for Power Platform applications.

Question 11

Name the five core components of Dataverse.

Answer 11

Security – Uses Azure Active Directory (AAD) for authentication and Role-Based Access Control (RBAC) for permissions.

Logic – Applies business rules and logic at the data level.

Data – Stores and analyzes structured and relational data.

Storage – Physically stores data in Azure’s cloud infrastructure.

Integrations – Supports integration using APIs, webhooks, and event-driven architecture.

Question 12

What is the maximum storage capacity for a single Dataverse database?

Answer 12

Each Dataverse database can store up to 4 TB of data.

Question 13

What is the Common Data Model (CDM) in Dataverse?

Answer 13

The Common Data Model (CDM) defines a shared structure for data across different applications and systems, ensuring consistency and reusability.

Question 14

Name and describe the three types of Dataverse tables.

Answer 14

Standard Tables – Pre-built tables that can be customized.

Managed Tables – Pre-built, locked (immutable) tables that cannot be customized.

Custom Tables – Fully customizable tables that users can create and modify as needed.

Question 15

How are relationships established between tables in Dataverse?

Answer 15

Relationships are established by creating links between columns in different tables, enabling relational data modeling.

Question 16

Why is it important to create business logic at the data layer in Dataverse?

Answer 16

Creating business logic at the data layer ensures consistent validation, workflows, and calculations across all applications, reducing the need for app-level logic.

Question 17

What is a Data Flow in Power Platform?

Answer 17

A Data Flow is a cloud-based tool that extracts, transforms, and loads (ETL) data into Dataverse or Azure Data Lake.

Question 18

Which tool is used to clean and transform data before loading it into Dataverse?

Answer 18

Power Query is used to clean and shape data before loading it into Dataverse or other destinations.

Question 19

What is a connector in Power Platform?

Answer 19

A connector is a bridge that links Power Platform apps to external data sources, enabling data integration and interaction with external systems.

Question 20

What are the two types of data sources available for connectors?

Answer 20

Tabular Sources – Return data in table format (e.g., SQL Server, Excel).

Function Sources – Use functions to interact with and modify the data source (e.g., APIs).

Question 21

How are connectors categorized, and what is the difference between them?

Answer 21

Connectors are categorized as standard and premium.

Standard connectors are available with standard Power Platform licenses.

Premium connectors require additional licensing for access to more advanced data sources.

Question 22

What is the role of triggers and actions in Power Automate?

Answer 22

Triggers initiate a flow based on an event (e.g., “When a new email arrives”).

Actions perform operations like creating a record, updating data, or sending a notification.

Question 23

What is a custom connector?

Answer 23

A custom connector allows users to access APIs that aren’t natively supported by Power Platform. Users can define the connector’s authentication, endpoints, and actions.

Question 24

How many connectors are currently available in Power Platform?

Answer 24

There are over 1,000 connectors available for Power Platform.