New Year Sale 2026! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

Microsoft MB-820 Exam - Topic 5 Question 24 Discussion

Actual exam question for Microsoft's MB-820 exam
Question #: 24
Topic #: 5
[All MB-820 Questions]

You are exporting data from Business Central.

You must export the data in a non-fixed length and width in CSV format.

You need to generate an XMLport to export the data in the required format

Which Format property value should you use?

Show Suggested Answer Hide Answer
Suggested Answer: B

When exporting data from Business Central and the requirement is for the data to be in a non-fixed length and width CSV format, the Format property of the XMLport should be set to VariableText (B). The VariableText format is designed for handling data exports where the fields are separated by a delimiter, such as a comma or tab, which is typical of CSV (Comma-Separated Values) files. This format allows for the flexibility needed when dealing with varying field lengths, as it does not enforce a fixed width for each field, making it ideal for CSV data exports. Setting the Format property to FixedText (C) would enforce a fixed width for each field, which is not suitable for CSV files, while the XML format (A) is used for exporting data in an XML structure, which is different from the CSV format requirements.


Contribute your Thoughts:

0/2000 characters
Katheryn
3 months ago
FixedText? No way, that's not right for this task.
upvoted 0 times
...
Latrice
3 months ago
100% agree with B, it fits the CSV format perfectly!
upvoted 0 times
...
Lucina
3 months ago
Wait, are we sure about VariableText? Seems odd.
upvoted 0 times
...
Kenneth
4 months ago
I thought XML would be the answer, but B makes sense.
upvoted 0 times
...
Dierdre
4 months ago
Definitely B, VariableText is the way to go!
upvoted 0 times
...
Noah
4 months ago
I’m confused about the differences between the options. I thought XML was for exporting, but I guess it depends on the format needed.
upvoted 0 times
...
Jonell
4 months ago
I practiced a similar question, and I feel like FixedText wouldn't work here. So, maybe it's B as well.
upvoted 0 times
...
Eden
4 months ago
I'm not entirely sure, but I remember something about XML being used for structured data. Could it be A?
upvoted 0 times
...
Regenia
5 months ago
I think the answer might be B, VariableText, since we need a non-fixed format for the CSV.
upvoted 0 times
...
Audry
5 months ago
I'm feeling pretty confident about this one. The question is asking for a non-fixed length and width format, so B. VariableText is the way to go.
upvoted 0 times
...
Heike
5 months ago
I think I know the answer, but I want to make sure I'm not missing anything. B. VariableText seems like the logical choice since the question specifically states the data needs to be in a non-fixed length and width format.
upvoted 0 times
...
Aleisha
5 months ago
Okay, I got this. The key is that the data needs to be exported in CSV format, which is a non-fixed length and width format. So the correct answer has to be B. VariableText.
upvoted 0 times
...
Pilar
5 months ago
Hmm, I'm a bit confused on this one. I'm not sure if VariableText is the correct format property to use. I'll need to double-check the documentation to make sure I understand the differences between the options.
upvoted 0 times
...
Alfred
5 months ago
I think the answer is B. VariableText seems like the right choice since the question mentions the data needs to be exported in a non-fixed length and width format.
upvoted 0 times
...
Filiberto
1 year ago
VariableText? More like VariableHeadache, am I right? Seriously though, that's the option I'm going with.
upvoted 0 times
Brianne
1 year ago
B) VariableText
upvoted 0 times
...
Elza
1 year ago
A) XML
upvoted 0 times
...
...
Leatha
1 year ago
I wonder if the exam question is trying to trick us with all this 'non-fixed' talk. But VariableText sounds like the safest bet.
upvoted 0 times
...
Ma
1 year ago
Hmm, non-fixed length and width in CSV format? Definitely not FixedText, that's for sure. VariableText is the way to go, I reckon.
upvoted 0 times
...
Casie
1 year ago
Ugh, another XMLport question. I always get those mixed up. But VariableText sounds like the right choice for this scenario.
upvoted 0 times
Darci
1 year ago
Let's go with VariableText then. It seems like the most suitable option for this task.
upvoted 0 times
...
Richelle
1 year ago
VariableText allows for more flexibility in the format of the exported data.
upvoted 0 times
...
Elenor
1 year ago
Yeah, I agree. XML might not be the best choice for this specific scenario.
upvoted 0 times
...
Gilma
1 year ago
I think VariableText is the way to go for exporting non-fixed length and width data.
upvoted 0 times
...
...
Tracey
1 year ago
I agree with Harley, XML is more suitable for this task because it allows for more flexibility in data structure.
upvoted 0 times
...
Harley
1 year ago
I disagree, I believe XML is the best option for exporting data in CSV format.
upvoted 0 times
...
Alberta
1 year ago
Wow, a CSV file with non-fixed length and width? That's quite a challenge! I think the VariableText option is the way to go here.
upvoted 0 times
Franklyn
1 year ago
Yes, VariableText allows for flexibility in the data export, making it ideal for this scenario.
upvoted 0 times
...
Rosenda
1 year ago
I agree, VariableText would be the best option for exporting non-fixed length and width data in CSV format.
upvoted 0 times
...
Jamika
1 year ago
C) FixedText
upvoted 0 times
...
Deane
1 year ago
B) VariableText
upvoted 0 times
...
Emiko
1 year ago
A) XML
upvoted 0 times
...
...
Norah
1 year ago
I think we should use VariableText for non-fixed length and width.
upvoted 0 times
...

Save Cancel