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

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
4 months ago
I agree with Pedro, CSV is the standard for data exports!
upvoted 0 times
...
Lili
4 months ago
Wait, is SaveAsWoid even a real function? Sounds weird.
upvoted 0 times
...
Talia
4 months ago
SaveAsHiml? Never heard of that one.
upvoted 0 times
...
Cornell
4 months ago
I thought it was A, SaveAsExcel. Seems like a better option.
upvoted 0 times
...
Pedro
5 months ago
Definitely D, SaveAsCsv is the way to go!
upvoted 0 times
...
Page
5 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
5 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
5 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
5 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
5 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
5 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
5 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
5 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
5 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
6 months 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
11 months 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
9 months ago
D) SaveAsCsv
upvoted 0 times
...
Ozell
9 months ago
C) SaveAsHiml
upvoted 0 times
...
Evelynn
9 months ago
B) SaveAsWoid
upvoted 0 times
...
Arletta
9 months ago
A) SaveAsExcel
upvoted 0 times
...
Carin
9 months ago
No, the 'Items Query' object is used for querying data, not for keeping a shopping list.
upvoted 0 times
...
Dana
9 months ago
D) SaveAsCsv
upvoted 0 times
...
Ben
9 months ago
C) SaveAsHiml
upvoted 0 times
...
Gayla
10 months ago
B) SaveAsWoid
upvoted 0 times
...
Cathrine
10 months ago
A) SaveAsExcel
upvoted 0 times
...
...
Earleen
11 months 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
9 months ago
I always use CSV for exporting data, it's simple and widely supported.
upvoted 0 times
...
Chantay
10 months ago
Yeah, CSV is the most common and compatible format for exporting data.
upvoted 0 times
...
Sol
10 months ago
I agree, CSV is the way to go for exporting data.
upvoted 0 times
...
...
Yan
11 months ago
Ah, I got it! D) SaveAsCsv. Easy peasy, just like exporting my grocery list to a spreadsheet.
upvoted 0 times
Justine
10 months ago
D) SaveAsCsv
upvoted 0 times
...
Nikita
10 months ago
C) SaveAsHiml
upvoted 0 times
...
Dona
10 months ago
B) SaveAsWoid
upvoted 0 times
...
Erin
10 months ago
A) SaveAsExcel
upvoted 0 times
...
...
Glynda
11 months 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
10 months ago
Yeah, SaveAsWoid doesn't sound right. SaveAsCsv is the one you should use.
upvoted 0 times
...
Nana
11 months ago
I think the correct function is SaveAsCsv.
upvoted 0 times
...
...
German
11 months ago
I'm not sure, but I think SaveAsExcel could also work for exporting the query data.
upvoted 0 times
...
Darnell
11 months 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
11 months ago
I agree with Mendy, SaveAsCsv is the best option for exporting query data to a file.
upvoted 0 times
...
Mendy
12 months ago
I think we should use SaveAsCsv.
upvoted 0 times
...

Save Cancel