Explore Microsoft Dataverse Flashcards by Caroline Mckinlay

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.

How well did you know this?

Not at all

Perfectly

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

How well did you know this?

Not at all

Perfectly

Why is Dataverse deployed geographically?

Explore Microsoft Dataverse

To help customers comply with potential data residency.

How well did you know this?

Not at all

Perfectly

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.

How well did you know this?

Not at all

Perfectly

What are the 5 main parts of Dataverse?

Explore Microsoft Dataverse

Security
Logic
Data
Storage
Integration

How well did you know this?

Not at all

Perfectly

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.

How well did you know this?

Not at all

Perfectly

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.

How well did you know this?

Not at all

Perfectly

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.

How well did you know this?

Not at all

Perfectly

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.

How well did you know this?

Not at all

Perfectly

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.

How well did you know this?

Not at all

Perfectly

TRUE OR FALSE: Microsoft Dataverse is Cloud based.

Explore Microsoft Dataverse

TRUE
It is a cloud based colution

How well did you know this?

Not at all

Perfectly

What is the first step to using Dataverse?

Explore Microsoft Dataverse

Creating one or many cloud based instances of a standardized database.

How well did you know this?

Not at all

Perfectly

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.

How well did you know this?

Not at all

Perfectly

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 well did you know this?

Not at all

Perfectly

How can a business solution outside of Power Platform connect to Dataverse?

Explore Microsoft Dataverse

Using Dataverse APIs

How well did you know this?

Not at all

Perfectly

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. ## Footnote 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? ## Footnote 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? ## Footnote 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. ## Footnote Explore Microsoft Dataverse

FALSE *Dataverse defines both one-to-many and many-to-many.*

Where is **business logic/business rules** applied for Power Platform? ## Footnote Explore Microsoft Dataverse

At the data layer

Why are business rules applied at the data layer? ## Footnote 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? ## Footnote 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? ## Footnote 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* ## Footnote 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? ## Footnote 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? ## Footnote 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? ## Footnote 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? ## Footnote 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)