Microsoft MB-820 Exam - Topic 5 Question 22 Discussion

Actual exam question for Microsoft's MB-820 exam

Question #: 22
Topic #: 5

[All MB-820 Questions]

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.

AInteger for the N on-conformity Number field

BDate Time for the Non-Conformity Date field

CChar for the Non-Conformity Number field

DDate for the Non-Conformity Date field

ECode for the Non-Conformity Number field

Show Suggested Answer

Suggested Answer: D, E

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.

by Lilli at Sep 17, 2024, 10:44 AM

Limited Time Offer

25%

Off

Get Premium MB-820 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Santos

4 months ago

E doesn't make sense, it's not a standard data type.

upvoted 0 times

...

Lore

4 months ago

Wait, can we really use Date for the Non-Conformity Date?

upvoted 0 times

...

Arthur

4 months ago

Char for the Non-Conformity Number? That seems off.

upvoted 0 times

...

Malcom

4 months ago

I think B is the right choice for the date field too.

upvoted 0 times

...

Carry

5 months ago

A is definitely correct for the Non-Conformity Number!

upvoted 0 times

...

Leota

5 months ago

I think Date Time is the right choice for the Non-Conformity Date field. It captures the full timestamp, which could be important for tracking.

upvoted 0 times

...

Tasia

5 months ago

I remember practicing a similar question where Char was used for a number field. But I’m not sure if that applies here.

upvoted 0 times

...

Quentin

5 months ago

I'm a bit unsure about the date field. Is it better to use Date Time or just Date? I feel like I've seen both in practice questions.

upvoted 0 times

...

Osvaldo

5 months ago

I think we should definitely use Integer for the Non-Conformity Number field. It makes sense since it's a whole number.

upvoted 0 times

...

Theodora

5 months ago

I'm confident about the Integer for the N on-conformity Number, but I'm a bit unsure about the Non-Conformity Date field. Should I go with Date or DateTime?

upvoted 0 times

...

Winifred

5 months ago

Wait, is it Date or DateTime for the Non-Conformity Date field? I need to double-check the differences between those data types.

upvoted 0 times

...

Tamesha

5 months ago

Okay, let's see. Integer for the N on-conformity Number, and Date for the Non-Conformity Date. That seems logical to me.

upvoted 0 times

...

Shaquana

5 months ago

Hmm, not sure about the Non-Conformity Number field. Should I use Char or Code? I'll have to think that one through.

upvoted 0 times

...

Matthew

5 months ago

This looks straightforward. I'd go with Integer for the N on-conformity Number field and DateTime for the Non-Conformity Date field.

upvoted 0 times

...

Caprice

6 months ago

Ugh, I'm totally stumped on this question. All the options sound like technical jargon to me. I'm going to have to guess on this one and hope for the best. Wish me luck!

upvoted 0 times

...

Zona

1 year ago

Ah yes, the age-old debate: Integer vs. Char for a number field. I say we settle this with a game of rock-paper-scissors. Loser has to use Char.

upvoted 0 times

...

Curt

1 year ago

Dude, did you even read the question? It clearly says 'which two data types should you use?' Not 'which one data type should you use?'. A and D are the way to go, my friend.

upvoted 0 times

...