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

6 hours 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

2 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

...