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 Exam MB-820 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:

Tiffiny
1 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
Cathrine
9 days ago
A) SaveAsExcel
upvoted 0 times
...
...
Earleen
1 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
Chantay
9 days ago
Yeah, CSV is the most common and compatible format for exporting data.
upvoted 0 times
...
Sol
27 days ago
I agree, CSV is the way to go for exporting data.
upvoted 0 times
...
...
Yan
1 months ago
Ah, I got it! D) SaveAsCsv. Easy peasy, just like exporting my grocery list to a spreadsheet.
upvoted 0 times
Justine
3 days ago
D) SaveAsCsv
upvoted 0 times
...
Nikita
4 days ago
C) SaveAsHiml
upvoted 0 times
...
Dona
9 days ago
B) SaveAsWoid
upvoted 0 times
...
Erin
23 days ago
A) SaveAsExcel
upvoted 0 times
...
...
Glynda
2 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
17 days ago
Yeah, SaveAsWoid doesn't sound right. SaveAsCsv is the one you should use.
upvoted 0 times
...
Nana
1 months ago
I think the correct function is SaveAsCsv.
upvoted 0 times
...
...
German
2 months ago
I'm not sure, but I think SaveAsExcel could also work for exporting the query data.
upvoted 0 times
...
Darnell
2 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
2 months ago
I agree with Mendy, SaveAsCsv is the best option for exporting query data to a file.
upvoted 0 times
...
Mendy
2 months ago
I think we should use SaveAsCsv.
upvoted 0 times
...

Save Cancel