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 SC-200 Topic 1 Question 93 Discussion

Actual exam question for Microsoft's SC-200 exam
Question #: 93
Topic #: 1
[All SC-200 Questions]

You have an Azure subscription that uses Microsoft Defender XDR.

From the Microsoft Defender portal, you perform an audit search and export the results as a file named Filel.csv that contains 10,000 rows.

You use Microsoft Excel to perform Get & Transform Data operations to parse the AuditData column from Filel.csv. The operations fail to generate columns for specific JSON properties.

You need to ensure that Excel generates columns for the specific JSON properties in the audit search results.

Solution: From Defender, you modify the search criteria of the audit search to reduce the number of returned records, and then you export the results. From Excel, you perform the Get & Transform Data operations by using the new export.

Does this meet the requirement?

Show Suggested Answer Hide Answer
Suggested Answer: A

Contribute your Thoughts:

I believe the correct solution is to use Power Query in Excel to parse the JSON properties.
upvoted 0 times
...
Lisbeth
2 days ago
This solution seems reasonable. Reducing the number of records should make it easier for Excel to handle the JSON data.
upvoted 0 times
...
Tracey
14 days ago
I agree with you, Bernardo. Modifying the search criteria won't help generate columns for specific JSON properties.
upvoted 0 times
...
Bernardo
15 days ago
I think the solution provided in the question is not correct.
upvoted 0 times
...

Save Cancel