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
5 months ago
I agree with Pedro, CSV is the standard for data exports!
upvoted 0 times
...
Lili
5 months ago
Wait, is SaveAsWoid even a real function? Sounds weird.
upvoted 0 times
...
Talia
6 months ago
SaveAsHiml? Never heard of that one.
upvoted 0 times
...
Cornell
6 months ago
I thought it was A, SaveAsExcel. Seems like a better option.
upvoted 0 times
...
Pedro
6 months ago
Definitely D, SaveAsCsv is the way to go!
upvoted 0 times
...
Page
6 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
6 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
7 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
7 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
7 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
7 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
7 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
7 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
7 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
7 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
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
10 months ago
D) SaveAsCsv
upvoted 0 times
...
Ozell
11 months ago
C) SaveAsHiml
upvoted 0 times
...
Evelynn
11 months ago
B) SaveAsWoid
upvoted 0 times
...
Arletta
11 months ago
A) SaveAsExcel
upvoted 0 times
...
Carin
11 months ago
No, the 'Items Query' object is used for querying data, not for keeping a shopping list.
upvoted 0 times
...
Dana
11 months ago
D) SaveAsCsv
upvoted 0 times
...
Ben
11 months ago
C) SaveAsHiml
upvoted 0 times
...
Gayla
11 months ago
B) SaveAsWoid
upvoted 0 times
...
Cathrine
11 months 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
11 months ago
I always use CSV for exporting data, it's simple and widely supported.
upvoted 0 times
...
Chantay
11 months ago
Yeah, CSV is the most common and compatible format for exporting data.
upvoted 0 times
...
Sol
12 months 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
11 months ago
D) SaveAsCsv
upvoted 0 times
...
Nikita
11 months ago
C) SaveAsHiml
upvoted 0 times
...
Dona
11 months ago
B) SaveAsWoid
upvoted 0 times
...
Erin
12 months 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
12 months 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
1 year ago
I think we should use SaveAsCsv.
upvoted 0 times
...

Save Cancel