ExamGecko
Question list
Search
Search

List of questions

Search

Related questions











Question 53 - MB-820 discussion

Report
Export

You need to define the data types for the fields of the N on-conformity table.

Which two data types should you use? Each correct answer presents part of the solution.

NOTE: Each correct selection is worth one point.

A.

Integer for the N on-conformity Number field

Answers
A.

Integer for the N on-conformity Number field

B.

Date Time for the Non-Conformity Date field

Answers
B.

Date Time for the Non-Conformity Date field

C.

Char for the Non-Conformity Number field

Answers
C.

Char for the Non-Conformity Number field

D.

Date for the Non-Conformity Date field

Answers
D.

Date for the Non-Conformity Date field

E.

Code for the Non-Conformity Number field

Answers
E.

Code for the Non-Conformity Number field

Suggested answer: D, E

Explanation:

In Business Central, fields in tables are assigned specific data types that determine the kind of data they can store. For the Non-conformity table mentioned in the case study, the following data types should be used:

Date for the Non-Conformity Date field: This is because the Non-conformity Date field is required to store only the date when the non-conformity was recorded. The Date data type is appropriate for storing dates without times.

Code for the Non-Conformity Number field: The Non-conformity Number field is described to use alphanumeric values with a format that includes 'NC' and the year, like 'NC24-001'. In Business Central, the Code data type is used for fields that store alphanumeric keys. It is a text field with a limited length, which makes it suitable for number series that contain letters and numbers.

Other options are not suitable:

A) Integer for the Non-conformity Number field: This would not be appropriate because the Non-conformity Number includes alphanumeric characters and not just integers.

B) DateTime for the Non-Conformity Date field: This is not correct because there is no requirement to store the time alongside the date.

C) Char for the Non-Conformity Number field: Char data type is not typically used in Business Central for number series or identifiers. The Code data type is preferred for this purpose.

asked 05/10/2024
adnan ayyash
43 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first