Dataverse

What is the most comprehensive administrative portal for Microsoft Dataverse?

Classic Administration Center (Solution Explorer)

When deploying role based security in the Microsoft Dataverse, which product allows you to control access to tables for different users?

Dynamics 365

How do you make a column that is required?

Edit the column and change the Required dropdown.

What type of choice can only be used by the entity and field that they are created against, and cannot be reused on other entities?

Local choices

An environment in Dataverse cannot contain...

Many instances of Dataverse databases.

Which column type displays a list of options where more than one can be selected?

Multi Select Choice

When creating a table, what are the two types of relationships you can create?

One-to-many and Many-to-Many

Which table type is not a part of Dataverse?

Open

Which portal offers a quick way to add users and set permissions?

Power Apps Advanced Customization

Which administrative portal shows usage data?

Power Platform Admin Portal

Which portal offers a quick way to manage environments and users?

Power Platform Admin Portal

With a P2 license in Dataverse, you can use and access any table except for which of the following? a. Standard tables b. Restricted tables c. Certain tables that contain complex logic d. Custom tables

Restricted tables

Which of the following statements is true about rollup fields? a. Rollups are asynchronous and performed on a scheduled basis b. Rollups are asynchronous and performed as soon as you add a new record c. You cannot adjust the schedule of when a rollup calculation is calculated d. Rollups are synchronous and performed as soon as you restart Power Apps.

a. Rollups are asynchronous and performed on a scheduled basis

How can business rules be used in both canvas and model-driven apps?

To validate data and show error messages

How many apps can use the same table?

Unlimited

One of your co-workers has set up a Model-driven application using dataverse. The app captures information about computer hardware assets, including their price. Your coworker is concerned that users of the application are going to forget to populate the cost center if the part is expendable. How could this be prevented?

Use a Business Rule to make the cost center field required if the expendable field is true.

Your manager has built a solution using the Microsoft Dataverse using a few of the standard tables included out of the box. He wants to capture the date that new records are added to the Entity, but he isn't sure how. He notices that a "Date" field is already inside his Entity, but he wants the field to have a custom name of "Date Confirmed." What would you recommend he do?

Use the built-in Date column within the table to store the date values, but rename the column to "Date Confirmed."

When can't you create a choice in Dataverse?

When you edit an existing field

Which of the following is not a User Security role? a. Application Administrator b. Delegate c. Microsoft Dataverse User d. System Customizer

a. Application Administrator

Which of the following statements is true about business rules? a. Business rules can be created to enforce logic and data values regardless of how you enter data into a Microsoft Dataverse entity b. Business rules cannot be created to enforce logic and data values regardless of how data is entered in a Dataverse entity c. Business rules are not implemented when you save a record d. Business rules are not implemented when you edit a record

a. Business rules can be created to enforce logic and data values regardless of how you enter data into a Microsoft Dataverse entity

Which of the following statements about restricted tables is false? a. Customers can add restricted tables to Dataverse b. Restricted tables store and maintain product-specific configuration data for Dynamics 365 products that are typically not used outside of the Dynamics application c. The restricted table is accompanied by advanced logic that creates and maintains data in a specific way when it is used within a Dynamics 365 product d. Restricted tables require a specific Dynamics 365 product license or the Dynamics 365 plan

a. Customers can add restricted tables to Dataverse

Which of the following can be done in dataverse? a. Export data from a table b. Export data from one or more tables as zipped markdown files c. Load data from any file type into a table d. All of the above

a. Export data from a table

Which of the following can you use Excel for, with Microsoft Dataverse tables? a. Add and create new tables to store data b. Add, edit, or delete data c. Add and delete tables d. Create new entities and add data to the new table

b. Add, edit, or delete data

Which statement is not true about business rules for an entity? a. Business rules that are defined for an entity apply when you are using the entity with a canvas app b. Business rules that are defined for an entity do not apply when you are using a canvas app c. Business rules that are defined for an entity apply when you are using the entity with a model-driven app. d. Business rules that are defined for an entity apply when you are using the entity with Excel.

b. Business rules that are defined for an entity do not apply when you are using a canvas app.

Which of the following statements is true about calculation fields? a. Calculations are asynchronous and calculated based on a schedule b. Calculations are run as soon as you save a record c. Values in a calculation field can be edited by a user d. Calculations cannot be created for a text field

b. Calculations are run as soon as you save a record.

Which of the following is not a type of security role? a. User b. Global Security Role c. Environment Maker d. Delegate

b. Global Security role

Choices in Dataverse can contain all of the following except? a. Numbers b. Images c. Text d. Text and numbers

b. Images

Microsoft Dataverse supports all of the following relationships except which one? a. Many-to-Many b. One-to-One c. One-to-Many d. Many-to-One

b. One-to-one

Adding a user to Dataverse automatically assigns that user to all of the following roles except which one? a. Dataverse User b. Environment Maker c. System Customizer

c. System Customizer

Rollups can be performed on all the following field types except... a. Currency b. Whole Number c. Text d. Date

c. Text

Which of the following statements is not true about alternate keys? a. Alternate keys make it easier for users to work with data in Microsoft Dataverse b. Alternate keys improve database performance c. The primary key of a table is a GUID and meaningless to users, so an alternate key can help identify the key

c. The primary key of a table is a GUID and meaningless to users, so an alternate key can help identify the key.

Which of the following statements about changing entities is true? a. You can change the entities in an existing many-to-many relationship b. You cannot change the entities in a one-to-many relationship c. You cannot change the entities in a many-to-many relationship d. You cannot change the entities in a many-to-one relationship

c. You cannot change the entities in a many-to-many relationship

Being able to relate two entities (relational design) is important for all of the following except which one? a. More efficient storage b. Better data accuracy c. Better Reporting d. Easier to design

d. Easier to design

Security roles are used for all of the following except.... a. Limiting access to data b. Restricting access to an environment c. Restricting actions that users can perform on data d. Restricting printing

d. Restricting printing

Which of the following statements is true about users? a. You can't add users to access data in Dataverse b. Public users outside of your Azure Active Directory can access Dataverse data c. You can enable anonymous access to any data in Dataverse d. You can add users to access data in Dataverse from within your Azure Active Directory

d. You can add users to access data in Dataverse from within your Azure Active Directory

Which of the following statements is incorrect about business rules and licensing requirements? a. You can create business rules for an entity with a P1 license b. You can create business rules for an entity with a P2 license c. You can create business rules for an entity with a Dynamics 365 license d. You can create business rules for an entity with a Microsoft 365 license.

d. You can create business rules for an entity with a Microsoft 365 license

Which of the following statements is false? a. You can create many views of a table b. You can sort and filter the data in a view c. You can choose the fields that are available in a view and edit at any time d. You can create only two views for each table

d. You can create only two views for each table