PL-200 Learning Path 1 - Lesson 6-8

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 table, but he isn’t sure how.

He notices that a “Date” field is already inside the table, but he wants the field to have a custom name of “Date Confirmed”.

What would you recommend he do?

• Create a new table with the name “Date Confirmed”

• Use the built-in Date column within the table to store the date values, and rename the column to “Date Confirmed”

• Create a new Environment with the name “Date Confirmed”

When creating a column which data type display a fixed list of values that users can select a value from?

• Choice

• Image

• Lookup

• Rollup

What do you change to affect how values in date time columns are displayed for users in different countries?

• Behavior

• Data type

• Time zone adjustment

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

• One-to-one
  and
  Many-to-many

• One-to-many
  and
  One-to-one

• One-to-many
  and
  Many-to-many

How can you create a relationship between two tables?

• Create a customer column

• Create a global choice

• Create a lookup column

• Create a relationship role

You need to create a many-to-many relationship between two tables. How can you achieve this goal?

• Create a global choice

• Create a lookup column

• Create a connection role

• Enable the tables for connections

You have created and used a relationship in an app. You are unable to delete the relationship.

• A value has been selected in the lookup column in the app’s form

• The lookup column is on the form of the related table

• The relationship behavior is set to Referential, Restricted

• There is data in the table in the Many-to-one relationship

Which of the following statements is true about Calculation columns?

• Calculations are asynchronous and calculated based on a schedule

• Calculations are performed when you retrieve a row

• Calculations cannot be created for a text column

• Values in a calculation column can be edited by a user

Which of the following statements is true about rollup columns?

• Rollups are asynchronous and performed on a scheduled basis

• Rollups are asynchronous and performed as soon as you add a new row

• You cannot adjust the schedule of when a rollup calculation is calculated

• Rollups are synchronous and performed as soon as you restart Power Apps

Rollups can be performed on all the following column types except?

• Currency

• Date Time

• Single Line of Text

• Whole Number