Explore Microsoft Dataverse Flashcards
What is Microsoft Dataverse?
Explore Microsoft Dataverse
A cloud based solution for hosting, managing and structuring data and business logic to support appd across Power Platform.
TRUE OR FALSE: Data stored in Dataverse can only be accessed in the same geographical local it is deployed in.
Explore Microsoft Dataverse
FALSE
Dataverse is available globally
Why is Dataverse deployed geographically?
Explore Microsoft Dataverse
To help customers comply with potential data residency.
What is makes Dataverse and traditional databases different?
Explore Microsoft Dataverse
Dataverse is the storing and management of data incorporated with the security, logic, analysis all in one place. It is a central data repository, whereas a traditional database is just for storage.
What are the 5 main parts of Dataverse?
Explore Microsoft Dataverse
Security
Logic
Data
Storage
Integration
Describe the Logic category of Dataverse.
Explore Microsoft Dataverse
Dataverse handles authentication with Microsoft Entra ID to allow for conditional access and multi-factor authentication. It supports authorization down to the row and column level and provides rich auditing capabilities.
Describe the Data category of Dataverse.
Explore Microsoft Dataverse
Dataverse allows you to easily apply business logic at the data level. Regardless of how a user interacts with the data, the same rules apply. These rules could be related to duplicate detection, business rules, workflows, or more.
Describe the Storage category of Dataverse.
Explore Microsoft Dataverse
Dataverse offers you the control to shape your data, allowing you to discover, model, validate, and report on your data. This control ensures your data looks the way you want regardless of how it is used.
Describe the Integration category of Dataverse.
Explore Microsoft Dataverse
Dataverse stores your physical data in the Azure cloud. This cloud-based storage removes the burden of worrying about where your data lives or how it scales. These concerns are all handled for you.
Describe the Security category of Dataverse.
Explore Microsoft Dataverse
Dataverse connects in different ways to support your business needs. APIs, webhooks, eventing, and data exports give you flexibility to get data in and out.
TRUE OR FALSE: Microsoft Dataverse is Cloud based.
Explore Microsoft Dataverse
TRUE
It is a cloud based colution
What is the first step to using Dataverse?
Explore Microsoft Dataverse
Creating one or many cloud based instances of a standardized database.
What is a standardized database (What makes it different from a regular database)?
It is a database with predefined columns commonly used across many organizations and businesses.
It includes the columns it thinks a business will need to start with.
What are the advantages of using Microsoft dataverse?
Explore Microsoft Dataverse
- You can access you data in the same place as your apps and workflows
- Its ease of creation/setup and management allows you to fous on bulding solutions without thinking about infrastructure, storage and integration
- It combines traditional database storage with Security, Logic, Data and Integration features
- It is cloud based, so it can be accessed anywhere as long as yo are connected to wifi
How can a business solution outside of Power Platform connect to Dataverse?
Explore Microsoft Dataverse
Using Dataverse APIs
What size can you extend a Dataverse database insance to?
Explore Microsoft Dataverse
4TB
Does Dataverse scale with lots of data?
Explore Microsoft Dataverse
Yes, Dataverse database tables can hold millions of items amd support complex data models.
What affects the amount of data available per Dataverse instance?
Explore Microsoft Dataverse
The number of and types of licenses associated with your Dataverse.
What is the structure of a Dataverse database ased on?
Explore Microsoft Dataverse
The defintions and schema in the Common Data Model
What is the key benefit of the Common Data Model?
Explore Microsoft Dataverse
It simplifies the integration and creation of different solutions, and allows you to use solutions provided by venders to have a premade schema.
What is a table in a database?
Explore Microsoft Dataverse
A logical structure of data containing rows and columns that define that data.
What are the three types of tables in Dataverse?
Explore Microsoft Dataverse
Standard
Managed
Custom
Describe the Standard table type in Dataverse.
Explore Microsoft Dataverse
Tables that are included with a Dataverse environment off that bat. Also known as “out-of-box” tables, these can be customized after the fact.
Includes premade tables like: Users, Task, Account, Contact, Business Unit etc.
Describe the Managed table type in Dataverse.
Explore Microsoft Dataverse
Tables that are not customizable and have been imported into the environment as part of a managed solution.
Describe the Custom table type in Dataverse.
Explore Microsoft Dataverse
Custom tables are unmanaged tables that are either imported from an unmanaged solution or are new tables created directly in the Dataverse environment.
What is a Column in a database?
Explore Microsoft Dataverse
A defintion of a part of a data set, that represents a property of that data.
Why create multiple tables defining different data in a solution?
Explore Microsoft Dataverse
So that data is not clumped together in a disorganized way. Splitting data up into respective tables allows for a more efficient solution with relationships between tables to show connections.
TRUE OR FALSE: One-to-many is the only table relationship allowed in Dataverse.
Explore Microsoft Dataverse
FALSE
Dataverse defines both one-to-many and many-to-many.
Where is business logic/business rules applied for Power Platform?
Explore Microsoft Dataverse
At the data layer
Why are business rules applied at the data layer?
Explore Microsoft Dataverse
So all data in the Dataverse abides by the rules, and the rules are in effect regardless of if he user interacts with the data in Dataverse or in a Power App.
How might an Pwer App use business rules?
Explore Microsoft Dataverse
To validate data and show error messages
To display/format data from dataverse
To hide/enable/disabled columns
Why are Business rules used?
Explore Microsoft Dataverse
To increase the accuracy and consistancy of data, and streamline forms/data presented to end users.
Give an example of what a Business Rule might do?
There are a couple of examples on the answer side
Explore Microsoft Dataverse
- Set a primary key for a table
- Have a column set to required
- Have a maximum number for a number property
- Have a maximum number o characters for a string value
- Make a column required (Or other potential logic) if another column has a specific value
What are Dataflows?
Explore Microsoft Dataverse
A self-service, cloud based, data preparation technology used to process data in Dataverse, Power BI workspaces or your organizations Azure Data Lake Storage Account (Or other data storage service).
How are Dataflows run?
Explore Microsoft Dataverse
They can be triggered by users or be set to run on a schedule (Like a job).
Where can Dataflows output their processed data to?
Explore Microsoft Dataverse
Almost any other Power Platform service, like Apps, Automate, Pages, BI, Dynamics 365, and Virtual Agents.
Though the destination need to be set in the Dataflow
What are the benefits of Dataflows?
Explore Microsoft Dataverse
- Decouples the data transformation layer from the modeling and visualizatins layer in a Pwer BI solution
- Data transformation code is in a central location, rather than spread out across mutliple artifacts
- Creation only needs Power Query Skills to write, no fancy code or IT experience needed
- Product Agnosticism, it can be used by many services
- Used Power Query which is a powerful data transformation tool
- Runs entirely on the cloud, so no extra infrastructure needed
- You do not need all Power Platform services to start using Dataflows, you only need one (e.g. PowerApps, Bi, Customer insights)
