Question 23 of 103 from exam MB-500: Microsoft Dynamics 365: Finance and Operations Apps Developer

Question 23 of 103 from exam MB-500: Microsoft Dynamics 365: Finance and Operations Apps Developer

Question

HOTSPOT - You are creating entities that will have unmapped fields.

You need determine which types of unmapped fields to use.

Which field types should you use? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Hot Area:

Answer Area

Requirement Field type
Create a read-only field that fetches data directly from a view.
Computed
Virtual
Create a field that is computed by SQL Server.
Computed
Virtual
Create a field that is calculated row by row during read and
write operations by using X++ code. Computed
Virtual
Create a non-persisted field.
Computed
Virtual

Explanations

Answer Area

Requirement Field type
Create a read-only field that fetches data directly from a view.
Computed
Virtual
Create a field that is computed by SQL Server.
Computed
Virtual
Create a field that is calculated row by row during read and
write operations by using X++ code. Computed
Virtual
Create a non-persisted field.
Computed
Virtual

Box 1: Computed - Computed field: Value is generated by an SQL view computed column.

During read, data is computed by SQL and is fetched directly from the view.

Box 2: Computed - Box 3: Virtual - Virtual field: Is a non-persisted field.

Is controlled by custom X++ code.

Read and write happens through custom X++ code.

Virtual fields are typically used for intake values that are calculated by using X++ code and can't be replaced by computed columns.

Box 4: Virtual - Virtual field is a non-persisted field.

https://docs.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/data-entities/data-entity-computed-columns-virtual-fields