Microsoft Exam SC-200 Topic 1 Question 93 Discussion

Actual exam question for Microsoft's SC-200 exam

Question #: 93
Topic #: 1

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?

AYes

BNo

Show Suggested Answer

Suggested Answer: A

by Madelyn at Mar 21, 2025, 09:36 PM

Limited Time Offer

25%

Off

Get Premium SC-200 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Isaiah

9 days ago

I'm going to go with 'Yes' on this one. Limiting the data seems like a reasonable workaround, and the question didn't specify that we had to use the full 10,000 rows. Gotta work smart, not just hard!

upvoted 0 times

...

Norah

11 days ago

Ah, the age-old battle between data volume and data processing power. I wonder if the exam will provide a spreadsheet with the data already pre-processed...that would be cheating, right?

upvoted 0 times

...

Cecil

12 days ago

Well, if it works, it works! Sometimes the simple solutions are the best. I just hope the exam doesn't have a trick question hidden in there.

upvoted 0 times

...

Joye

14 days ago

I'm not sure that's the best approach. Shouldn't we be focusing on improving the Excel operations instead of limiting the data?

upvoted 0 times

...

Flo

17 days ago

I agree with Shenika. Using Power Query in Excel is the way to go to generate columns for specific JSON properties.

upvoted 0 times

...

Shenika

21 days ago

I believe the correct solution is to use Power Query in Excel to parse the JSON properties.

upvoted 0 times

...

Lisbeth

23 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

Pearly

4 days ago

User 1: Yes, that should work. Excel might have been overwhelmed with the large number of records before.

upvoted 0 times

...

Tracey

1 months ago

I agree with you, Bernardo. Modifying the search criteria won't help generate columns for specific JSON properties.

upvoted 0 times

...

Bernardo

1 months ago

I think the solution provided in the question is not correct.

upvoted 0 times

...