Deal of The Day! 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 1 Question 21 Discussion

You have a query object named Items Query. You write code using an Items Query query variable. You need to export the Items Query query data to a file. Which SaveAs function should you use?
B) SaveAsWoid
A) SaveAsExcel
C) SaveAsHiml
D) SaveAsCsv

Microsoft MB-820 Exam - Topic 1 Question 21 Discussion

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

You have a query object named Items Query. You write code using an Items Query query variable. You need to export the Items Query query data to a file. Which SaveAs function should you use?

Show Suggested Answer Hide Answer
Suggested Answer: B

The property InherentPermissions is used to automatically grant permissions to the table object it is applied to, but setting it to Rl (which seems to be a typo and should likely be 'RL' for Read and Insert permissions) is not sufficient in this scenario. The issues reported by the users suggest that they need more than just read and insert permissions on MyTable. Since users are unable to post sales orders, they likely need Modify, Delete, or Execute permissions on certain tables or objects related to the sales order process. Additionally, the inability to access the list page created in MyTable could be due to lacking Read permissions on other related objects or pages. Therefore, merely setting InherentPermissions = RL on MyTable does not comprehensively address the users' permission issues, especially when considering the principle of least privilege. A more tailored approach to permissions, potentially involving adjustments to the app's code or configuration to ensure proper permissions are applied where necessary, would be needed.


Contribute your Thoughts:

0/2000 characters
Novella
10 months ago
I agree with Pedro, CSV is the standard for data exports!
upvoted 0 times
...
Lili
10 months ago
Wait, is SaveAsWoid even a real function? Sounds weird.
upvoted 0 times
...
Talia
10 months ago
SaveAsHiml? Never heard of that one.
upvoted 0 times
...
Cornell
11 months ago
I thought it was A, SaveAsExcel. Seems like a better option.
upvoted 0 times
...
Pedro
11 months ago
Definitely D, SaveAsCsv is the way to go!
upvoted 0 times
...
Page
11 months ago
I thought SaveAsWoid was for something else entirely, but I can't remember what. I think it's between SaveAsCsv and SaveAsHiml.
upvoted 0 times
...
Julio
11 months ago
I feel like SaveAsExcel might be used for spreadsheets, but I can't recall if it's the best option here.
upvoted 0 times
...
Kirk
12 months ago
I practiced a similar question last week, and I believe SaveAsCsv is the right choice for exporting query data.
upvoted 0 times
...
Aron
12 months ago
I think I remember something about exporting data, but I'm not sure if it's SaveAsCsv or SaveAsExcel.
upvoted 0 times
...
Frank
12 months ago
Okay, let me break this down step-by-step. The question is asking about exporting data from an Items Query object, so the SaveAsCsv option makes the most sense to me.
upvoted 0 times
...
Stevie
12 months ago
I'm confused by the options here. None of them seem to match the function name mentioned in the question. I'll have to review my notes to figure this out.
upvoted 0 times
...
Carman
12 months ago
Ah, I know this one! The correct answer is SaveAsCsv. That's the best way to export data from a query object.
upvoted 0 times
...
Edgar
12 months ago
I'm a bit unsure about this one. The options don't seem to match the question very well. I'll have to think it through carefully.
upvoted 0 times
...
Earleen
12 months ago
Hmm, this looks straightforward. I think I'll go with SaveAsExcel since that's the most common way to export data.
upvoted 0 times
...
Celestine
1 year ago
Hmm, this is a tricky one. I think the key is understanding what the S&OP process is trying to achieve - balancing supply and demand. So if there are unresolved conflicts, it's probably going to lead to one side taking precedence over the other.
upvoted 0 times
...
Tiffiny
1 year ago
Forget the query, I'm more interested in the 'Items Query' object. Is that where I keep my shopping list?
upvoted 0 times
Carla
1 year ago
D) SaveAsCsv
upvoted 0 times
...
Ozell
1 year ago
C) SaveAsHiml
upvoted 0 times
...
Evelynn
1 year ago
B) SaveAsWoid
upvoted 0 times
...
Arletta
1 year ago
A) SaveAsExcel
upvoted 0 times
...
Carin
1 year ago
No, the 'Items Query' object is used for querying data, not for keeping a shopping list.
upvoted 0 times
...
Dana
1 year ago
D) SaveAsCsv
upvoted 0 times
...
Ben
1 year ago
C) SaveAsHiml
upvoted 0 times
...
Gayla
1 year ago
B) SaveAsWoid
upvoted 0 times
...
Cathrine
1 year ago
A) SaveAsExcel
upvoted 0 times
...
...
Earleen
1 year ago
C) SaveAsHiml? Is that some kind of ancient hieroglyphic file format? I think I'll stick with the good ol' CSV.
upvoted 0 times
Janessa
1 year ago
I always use CSV for exporting data, it's simple and widely supported.
upvoted 0 times
...
Chantay
1 year ago
Yeah, CSV is the most common and compatible format for exporting data.
upvoted 0 times
...
Sol
1 year ago
I agree, CSV is the way to go for exporting data.
upvoted 0 times
...
...
Yan
1 year ago
Ah, I got it! D) SaveAsCsv. Easy peasy, just like exporting my grocery list to a spreadsheet.
upvoted 0 times
Justine
1 year ago
D) SaveAsCsv
upvoted 0 times
...
Nikita
1 year ago
C) SaveAsHiml
upvoted 0 times
...
Dona
1 year ago
B) SaveAsWoid
upvoted 0 times
...
Erin
1 year ago
A) SaveAsExcel
upvoted 0 times
...
...
Glynda
1 year ago
B) SaveAsWoid? Really? I'm pretty sure that's not a real function. Who came up with these answer choices?
upvoted 0 times
Nana
1 year ago
Yeah, SaveAsWoid doesn't sound right. SaveAsCsv is the one you should use.
upvoted 0 times
...
Nana
1 year ago
I think the correct function is SaveAsCsv.
upvoted 0 times
...
...
German
1 year ago
I'm not sure, but I think SaveAsExcel could also work for exporting the query data.
upvoted 0 times
...
Darnell
1 year ago
Hmm, I think the answer is D) SaveAsCsv. Exporting to a CSV file seems like the most logical choice for this scenario.
upvoted 0 times
...
Shawana
1 year ago
I agree with Mendy, SaveAsCsv is the best option for exporting query data to a file.
upvoted 0 times
...
Mendy
2 years ago
I think we should use SaveAsCsv.
upvoted 0 times
...

Save Cancel