Independence Day Deal! Unlock 25% OFF Today – Limited-Time Offer - 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
2 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
Ozell
21 hours ago
C) SaveAsHiml
upvoted 0 times
...
Evelynn
3 days ago
B) SaveAsWoid
upvoted 0 times
...
Arletta
4 days ago
A) SaveAsExcel
upvoted 0 times
...
Carin
5 days ago
No, the 'Items Query' object is used for querying data, not for keeping a shopping list.
upvoted 0 times
...
Dana
8 days ago
D) SaveAsCsv
upvoted 0 times
...
Ben
12 days ago
C) SaveAsHiml
upvoted 0 times
...
Gayla
17 days ago
B) SaveAsWoid
upvoted 0 times
...
Cathrine
26 days ago
A) SaveAsExcel
upvoted 0 times
...
...
Earleen
2 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
14 days ago
I always use CSV for exporting data, it's simple and widely supported.
upvoted 0 times
...
Chantay
26 days ago
Yeah, CSV is the most common and compatible format for exporting data.
upvoted 0 times
...
Sol
1 months ago
I agree, CSV is the way to go for exporting data.
upvoted 0 times
...
...
Yan
2 months ago
Ah, I got it! D) SaveAsCsv. Easy peasy, just like exporting my grocery list to a spreadsheet.
upvoted 0 times
Justine
20 days ago
D) SaveAsCsv
upvoted 0 times
...
Nikita
21 days ago
C) SaveAsHiml
upvoted 0 times
...
Dona
26 days ago
B) SaveAsWoid
upvoted 0 times
...
Erin
1 months 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
1 months ago
Yeah, SaveAsWoid doesn't sound right. SaveAsCsv is the one you should use.
upvoted 0 times
...
Nana
2 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
3 months ago
I think we should use SaveAsCsv.
upvoted 0 times
...

Save Cancel
az-700  pass4success  az-104  200-301  200-201  cissp  350-401  350-201  350-501  350-601  350-801  350-901  az-720  az-305  pl-300  

Warning: Cannot modify header information - headers already sent by (output started at /pass.php:70) in /pass.php on line 77