Explore Microsoft Dataverse

Question 1

What is Microsoft Dataverse?

Explore Microsoft Dataverse

Answer 1

A cloud based solution for hosting, managing and structuring data and business logic to support appd across Power Platform.

Question 2

TRUE OR FALSE: Data stored in Dataverse can only be accessed in the same geographical local it is deployed in.

Explore Microsoft Dataverse

Answer 2

FALSE
Dataverse is available globally

Question 3

Why is Dataverse deployed geographically?

Explore Microsoft Dataverse

Answer 3

To help customers comply with potential data residency.

Question 4

What is makes Dataverse and traditional databases different?

Explore Microsoft Dataverse

Answer 4

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.

Question 5

What are the 5 main parts of Dataverse?

Explore Microsoft Dataverse

Answer 5

Security
Logic
Data
Storage
Integration

Question 6

Describe the Logic category of Dataverse.

Explore Microsoft Dataverse

Answer 6

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.

Question 7

Describe the Data category of Dataverse.

Explore Microsoft Dataverse

Answer 7

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.

Question 8

Describe the Storage category of Dataverse.

Explore Microsoft Dataverse

Answer 8

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.

Question 9

Describe the Integration category of Dataverse.

Explore Microsoft Dataverse

Answer 9

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.

Question 10

Describe the Security category of Dataverse.

Explore Microsoft Dataverse

Answer 10

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.

Question 11

TRUE OR FALSE: Microsoft Dataverse is Cloud based.

Explore Microsoft Dataverse

Answer 11

TRUE
It is a cloud based colution

Question 12

What is the first step to using Dataverse?

Explore Microsoft Dataverse

Answer 12

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

Question 13

What is a standardized database (What makes it different from a regular database)?

Answer 13

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.

Question 14

What are the advantages of using Microsoft dataverse?

Explore Microsoft Dataverse

Answer 14

• 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

Question 15

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

Explore Microsoft Dataverse

Answer 15

Using Dataverse APIs

Question 16

What size can you extend a Dataverse database insance to?

Explore Microsoft Dataverse

Answer 16

4TB

Question 17

Does Dataverse scale with lots of data?

Explore Microsoft Dataverse

Answer 17

Yes, Dataverse database tables can hold millions of items amd support complex data models.

Question 18

What affects the amount of data available per Dataverse instance?

Explore Microsoft Dataverse

Answer 18

The number of and types of licenses associated with your Dataverse.

Question 19

What is the structure of a Dataverse database ased on?

Explore Microsoft Dataverse

Answer 19

The defintions and schema in the Common Data Model

Question 20

What is the key benefit of the Common Data Model?

Explore Microsoft Dataverse

Answer 20

It simplifies the integration and creation of different solutions, and allows you to use solutions provided by venders to have a premade schema.

Question 21

What is a table in a database?

Explore Microsoft Dataverse

Answer 21

A logical structure of data containing rows and columns that define that data.

Question 22

What are the three types of tables in Dataverse?

Explore Microsoft Dataverse

Answer 22

Standard
Managed
Custom

Question 23

Describe the Standard table type in Dataverse.

Explore Microsoft Dataverse

Answer 23

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.

Question 24

Describe the Managed table type in Dataverse.

Explore Microsoft Dataverse

Answer 24

Tables that are not customizable and have been imported into the environment as part of a managed solution.

Question 25

Describe the Custom table type in Dataverse.

Explore Microsoft Dataverse

Answer 25

Custom tables are unmanaged tables that are either imported from an unmanaged solution or are new tables created directly in the Dataverse environment.

Question 26

What is a Column in a database?

Explore Microsoft Dataverse

Answer 26

A defintion of a part of a data set, that represents a property of that data.

Question 27

Why create multiple tables defining different data in a solution?

Explore Microsoft Dataverse

Answer 27

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.

Question 28

TRUE OR FALSE: One-to-many is the only table relationship allowed in Dataverse.

Explore Microsoft Dataverse

Answer 28

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

Question 29

Where is business logic/business rules applied for Power Platform?

Explore Microsoft Dataverse

Answer 29

At the data layer

Question 30

Why are business rules applied at the data layer?

Explore Microsoft Dataverse

Answer 30

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.

Question 31

How might an Pwer App use business rules?

Explore Microsoft Dataverse

Answer 31

To validate data and show error messages
To display/format data from dataverse
To hide/enable/disabled columns

Question 32

Why are Business rules used?

Explore Microsoft Dataverse

Answer 32

To increase the accuracy and consistancy of data, and streamline forms/data presented to end users.

Question 33

Give an example of what a Business Rule might do?

There are a couple of examples on the answer side

Explore Microsoft Dataverse

Answer 33

• 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

Question 34

What are Dataflows?

Explore Microsoft Dataverse

Answer 34

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).

Question 35

How are Dataflows run?

Explore Microsoft Dataverse

Answer 35

They can be triggered by users or be set to run on a schedule (Like a job).

Question 36

Where can Dataflows output their processed data to?

Explore Microsoft Dataverse

Answer 36

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

Question 37

What are the benefits of Dataflows?

Explore Microsoft Dataverse

Answer 37

• 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)