2.5 Build extended data types and enumerations for finance and operations apps

Question 1

Tables?

Answer 1

Contain rows and columns
Stored in db and work together to deliver data to the user in outputs such as forms and reports

Question 2

Table components?

Answer 2

Fields
Field groups
Indexes
Relations
Delete actions
State machines
Mappings
Methods
Events

Question 3

Table fields?

Answer 3

Make up the data in the table and can be base enumerations or EDTs

Question 4

Table field groups?

Answer 4

Logical groupings of physical database fields.
Can be used on forms and reports

Question 5

Table indexes?

Answer 5

Method for speeding up retrieval of data from a table

Question 6

Table relations?

Answer 6

Defines how a table relates to records in other tables

Question 7

Table delete actions?

Answer 7

Node is used on tables that are upgraded from AX versions.
It is used to detail what should happen when data in related table is deleted

Question 8

Table state machines?

Answer 8

Perform state transitions within the workflow without writing any additional code
Used with workflows

Question 9

Table mappings?

Answer 9

With a map you can associate a map field with a field in one or more tables
Enables to use the same field name to access fields with different names in different tables

Question 10

Table methods?

Answer 10

Pieces of code that are added to a table that can be run when certain events or changes in data occur

Question 11

Table events?

Answer 11

Pieces of code that are raised as preceding and succeeding operations around base method

Question 12

How should indexes be ordered in table?

Answer 12

Highest number of unique values to smallest number

Question 13

3 types of indexes?

Answer 13

Primary index (unique key to each record in table)
Clustered (organizes data for a table according to the order of the index)
Non-Clustered (quickly references data that is found in the clustered index by using a specified set of columns)

Question 14

Relation types?

Answer 14

Normal relation (relation with no conditions)
Field fixed relation (relation fields to restrict the records in the primary table)
Related field fixed relation (relation fields that restrict the records in the related table)
Foreign key relation (correspondence between foreign key field in the present table and the primary key field in another parent table)