Intro, Dataverse and Powerapps Flashcards
In Microsoft Power Platform, what are the 4 key products?
Power Apps, Power Automate, Power BI, Power Virtual Agents
What Power Platform product is used to deliver insights for analyzing data?
PowerBI
How many connectors are there in Power Platforms?
Over 600
Which Power Platform feature enables you to connect app, data and devices in cloud?
Connectors
A client likes the idea of implementing a Microsoft Power Platform solution, but is concerned about the ability to interact with a custom API. How should you respond?
Microsoft Power Platform offers the ability to create custom connectors for this purpose
What is the key feature of Power Apps?
It provides low code environment for building custom apps.
What does Power Automate do?
Power Automate creates automated workflows between applications and services.
What are the two types of operations that can be used after establishing a data source and configuring the connector?
Triggers and Actions
What makes Power Platform accessible to a broad audience?
Low code
What is the name of the business analytics service that delivers insights for analyzing data?
Power BI (Business Intelligence)
Which Microsoft Power Platform enables the creation of web and mobile applications?
Power apps
What is Power Virtual Agents?
Power Virtual Agents is a no-code interface for chatbot creation
Which feature allows you to add intelligence to Power Apps?
AI builder
What are the two types of data sources?
Tabular Data and Function- based data
What types of operations used for connectors?
Actions and Triggers
What is the key feature of Power Automate?
Let users create automated workflows between applications and services.
What is Power Platform’s main advantage over competitors?
Great cross compatibility
What does AI Builder do?
Enables adding AI to workflows and apps without writing code.
What is Microsoft Dataverse?
Scalable data service for storing and managing data from multiple sources.
Which products use Triggers?
Power Automate
Which products use Actions?
Power Automate, Power Apps
What is used to store and manage data used by business applications?
Microsoft Dataverse
Which platform provides a rapid low code development environment for building custom apps for business needs?
Power Apps
Name one benefit of using Power Platform
- Cost savings
- Increased performance and efficiency
- Improved business agility
- Library of applications for day-to-day operations
What are custom connectors?
Custom connectors are built to connect to specific APIs
What are triggers and actions?
Triggers start workflows and actions are what happen in the workflow.
What are bridges that connect data sources to your apps, workflows, or dashboards?
Connectors
What are data sources?
Data sources are where the data comes from.
How many types of data sources exist?
There are two types: tabular, which are structured tables, and function-based, which use functions to interact with the data.
What are data loss prevention policies?
Policies to prevent users from unintentionally exposing organizational data.
How does Microsoft help with compliance and data privacy?
Microsoft offers a wide range of tools and resources such as certifications and attestations.
What does Power apps contain
services, connectors, and a scalable data service and app platform (Microsoft Dataverse)
Which 3 features enable Microsoft Power Platform to be leveraged to its full potential
AI Builder , Microsoft Dataverse, Connectors
How can connectors be classified?
- Business
- Non-Business
- Blocked
What does API stand for?
Application Programming Interface
How is data protected in Microsoft Power Platform?
Data in transit is TLS encrypted
Which platform enables anyone to create powerful chatbots using a guided, no-code graphical interface, without the need for data scientists or developers?
Power Virtual Agents
What is TLS encryption?
TLS encryption scrambles your message/data
What is accessibility in Microsoft Power Platform?
Making sure all kinds of users can use it
What allows you to connect an app with data?
connector
How do Power apps work with APIs?
These connectors will call specific functions in the service of the API to return the corresponding data.
What app will assist users with vision, hearing and other impairments in MS Power Platform
An accessible canvas app
What is the bridge from your data source to your app or workflow which allows information to be conveyed back and forth?
Data Connectors
What is the name of a data source that returns data in a structured table format? The data from this can be created, deleted or edited.
A tabular data source
Connections established between customers and Microsoft data centers are ……..?
encrypted
What are 3 different approaches to creating custom connectors?
Using a blank custom connector
From an OpenAPI definition
From a Postman collection
what is required for accessing the server endpoints
TLS 1:2 or higher
What are the examples of Tabular data source?
Microsoft DataVerse, SharePoint and SQL server.
Which type of Data source offers actions such as ability to send emails, update permissions or create a calendar event?
Function-based Data source
Examples of Standard connectors
SharePoint, Outlook , Youtube
Examples of Premium connectors
SQL server, Survey Monkey, Mail Chimp.
A connector which is used to notify users when specific customer types are added is…
Dynamics 365 apps such as Customer Service.
What is Microsoft Dataverse?
A low-code data platform that allows users to store, manage, and model data for business applications
What is used in Power Automate to prompt a flow to begin?
Triggers
What types of data can be stored in Microsoft Dataverse?
Dataverse supports a wide range of data types, including text, numbers, dates etc
What are some key features of Microsoft Dataverse?
- Data modeling
- Data integration
- Data security
- Automation
- Reporting and analytics
How can Microsoft Dataverse be used in business applications?
To build custom business applications, automate workflows, create chatbots, and more.
What are some benefits of using Microsoft Dataverse?
- Increased productivity
- Improved data security
- Streamlined workflows
- Better insights through analytics.
What are the three types of tables in Dataverse?
Standard, managed, and custom.
What are standard tables in Dataverse?
Pre-existing tables in Dataverse. Account, Business Unit, Contact, and User tables are examples.
What are managed tables in Dataverse?
Tables that are imported into the environment as part of a managed solution are not customizable.
What are custom tables in Dataverse?
Imported tables from an unmanaged solution or created directly in the Dataverse environment and can be fully customized.
Why is it important to use standard tables and columns when possible?
Because they are pre-existing and meet most needs. This can simplify data storage and management.
What operations can be used in both Power Automate and Power Apps?
Actions
What is the importance of splitting data into tables?
To build efficient and scalable solutions.
What is a one-to-many relationship between tables?
Parent-child relationships, where the child rows have a foreign key that matches the parent key.
What are the benefits of using standard tables in Microsoft Dataverse?
Proven, scalable, and extendable data storage solutions.
What type of connectors can be used in different platforms such as Power Apps, Power Automate and Azure Logic Apps?
Custom connectors.
What are environments in Dataverse?
They are used to store, manage, and share business data, apps, and flows.
Can environments be created for different geographical locations?
Yes, you can set up an environment based on a geographical location.
What are the three different ways of creating Custom connectors?
- Using a blank custom connector
- From an OpenAPI definiton
- From a Postman collection
What is the relationship between environments and Microsoft Azure Active Directory (Azure AD)?
Each environment is created by an Azure AD tenant, and it’s associated with a specific group of users.
How many databases can be provisioned in each environment?
You can provision one Microsoft Dataverse database for use within each environment
Are the items you create in an environment location-bound?
Yes, any items created in an environment, including connections etc are bound to that environment’s location.
What is the benefit of creating multiple Environments for solution development?
You can set up one environment for development, another for testing, and another for production use.
What are Instances in Microsoft Dataverse?
An instance of Microsoft Dataverse is a database that stores data for a specific environment.
How many instances of Microsoft Dataverse are in each environment?
Each environment can have zero or one instance of Microsoft Dataverse.
Who can create a Data Loss Prevention Policy?
A tenant Admin or the Environment Admin
What kind of rule in Microsoft Dataverse enforce data validation and logic across apps, simplifying development?
Business rules
Why do we need DLP Policies?
To prevent Data leakage and control access to audience
Where are Business Rules enforced in Microsoft Dataverse?
At the data layer, applied regardless of where the data is accessed (app, API, etc).
How can Connectors be classified in the context of DLP policies?
Business, Non-Business or Blocked
What are Canvas apps?
Canvas apps are more flexible and let you design custom interfaces
What are Model-Driven apps?
Model-driven apps use pre-built components
What can Model-Driven apps do with business rules that canvas apps can’t?
Show/hide columns, enable/disable columns, and create business recommendations based on intelligence.
How can Business Rules ensure data accuracy and simplify development?
By enforcing rules and logic at the data layer, the rule is tied to the data, not the app.
What is the name of the Dataverse space where you can change administrative options, such as creating new instances of a database?
Administer
What makes Microsoft Power Platform accessible and inclusive to users with vision, hearing and other impairments?
Accessible Canvas Apps
What is Power Apps Studio?
It’s the web interface you use to build your app
What is the first step in creating your Canvas app?
Choose the format of your app: Mobile or Tablet.
What does Dataverse use to handle authentication to allow for conditional access and multi-factor authentication?
Azure Active Directory (Azure AD)
5 features of Microsoft Dataverse
Security, Logic, Data, Storage, Integration
Which category of features does Dataverse provide for detecting duplicates, business rules and workflows?
Logic
Where does DataVerse store the physical data?
In the Azure cloud
What is the cloud based solution for storing and working with your business data?
Microsoft Dataverse
What are the 3 types of tables in Dataverse?
Standard, Managed and Custom
What is the missing word in “Power Apps can create three types of apps: canvas, model-driven, and _____”
Portals
How can you connect to MS DataVerse from any business solution?
Through connectors and APIs.
Currently, how many are AI models available in Power Apps?
4 - Prediction, Form processor, Object detector, Text classification
Is the scalability with Dataverse high or low?
High ; can store upto 4TB for each instance
What are the most common relationships between the tables?
One-to-many, Many-to-many
Dataverse is used as platform for long running and batch processing. True or False?
False, it supports Quick Response for Multiple Users
What is the standard table design on which the MS DataVerse database is based?
Common Data model
What are 3 the sections in Admin Centre?
Environments, Data Policies, Data Integration
What are the three types of tables?
Standard, Managed and Custom
Examples of Standard tables are ..
Account, Business unit, Contact, Task and User tables
Tables that aren’t customizable and imported as part of managed solution are called …
Managed Tables
Tables directly created in the Dataverse environment are ..
Custom Tables
What type of tables can be customized with appropriate privileges?
Standard
Custom
Types of most common relationships that MS DataVerse supports are ..
One-to-many
Many-to-many
One-to-many relationships are also called ……
Parent-child relationship
eg: Invoice(parent)-Items(child)
________ allow you to manage user access, security settings and the storage associated with the database.
Dataverse Environments
Where can you administer MS DataVerse?
Microsoft Power platform Admin Center
What can be used to modernize the inefficient or legacy business processes?
Power Apps
What are the different types of Power Apps?
Canvas and Model-driven
Example of solutions that can be built using Power Apps
Vehicle inspection forms
Status reports
Purchasing processes
Inventory Management
Power Apps can be used by users with little background in computer science and coding as well as seasoned developers, TRUE or FALSE ?
TRUE
What are the four available models in Power Apps?
Prediction
Form Processor
Object detector
Text classification
How has Power Apps improved the use of AI for building and training a model?
By providing a wizard-based interface.
What is an example of a ready to use component?
AI Business Card reader
Which AI model of Power Apps extracts text from an image?
Form processor model
Which AI model of Power Apps identifies objects from a picture taken and provides a count of number of objects present?
Object Detector model
Which AI model of Power Apps categorizes text by its meaning and makes analysis easier.
Text Classification Model
A collection of components or tools designed to develop a strategy for adopting and supporting MS Power platform is
Centre of Excellence
How does Power Apps help in security and administration?
1.Creating and managing environments
2. Monitoring licenses
3. Working with Data Loss Prevention policies
4. Managing Dataverse Data integration projects.
What does Power apps use to automate administrative duties and permissions management of all apps?
By the use of PowerShell cmdlet
(cmdlet stands for command-let)
What is the web interface that is used to build an app?
Power Apps Studio
Can you change the chosen App format in the Power Apps Studio?
No
What is used to display rows from the table of data in Power Apps studio?
The Gallery control
Forms enable a user to view detailed information, to save new records and edit existing ones. TRUE or FALSE?
TRUE
Which of the following can be a data source for a model-driven app?
a) Microsoft Dataverse
b) SQL
c) SharePoint
d) all of these answers
a) Model-driven apps can only use Microsoft Dataverse as a data source.
Which scenario would be suitable for a canvas app?
A - to build a database for your business.
B - to build a puzzle game app to sell through the Apple and Google Play stores.
C - to build a mobile app for your salespeople to update customer data.
D - to build a commercial app for your customers.
C - to build a mobile app for your salespeople to update customer data.
Canvas apps are used for business applications connected to an existing business data source such as a CRM.
What is Power Fx?
A - part of the Power Platform that allows you to build websites
B - the formulas used in Microsoft Excel
C - a low-code expression language like Excel used to build Power Apps
D - a programming language
C - a low-code expression language like Excel used to build Power Apps
Power Fx is a low-code expression language made up of formulas very similar to the formulas in E
When should you use a model-driven app instead of a canvas app?
A - to build an app connected to SharePoint
B - to build a task based app connected to an existing business system
C - when you need a mobile app
D - when you need a new data source for your business application
D - when you need a new data source for your business application
Model-driven apps start with a data model built on Microsoft Dataverse. You use a model-driven app when you need a new data source, or your existing data source is no longer serving you well.
What are the three design phases of Model-driven apps
1) Model your business data
2) Define your business processes
3) Build the app
What is a Model-driven app design?
A component focused approach to app development
