Microsoft SC-200 Exam - 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

Dannie

9 months ago

Not sure if that’s enough to fix the JSON issue.

upvoted 0 times

...

Jaclyn

9 months ago

I think it’s a solid approach, yes.

upvoted 0 times

...

Kenneth

10 months ago

Reducing records should help with parsing!

upvoted 0 times

...

Marsha

10 months ago

Definitely meets the requirement, I agree!

upvoted 0 times

...

Lacey

10 months ago

Wait, can you really fix it just by reducing records?

upvoted 0 times

...

Tom

10 months ago

I believe that reducing the number of records should help, but I’m not confident it’s a complete solution for the JSON parsing issue.

upvoted 0 times

...

Javier

10 months ago

I feel like modifying the search criteria could help, but I wonder if the issue is more about how Excel handles JSON rather than just the number of records.

upvoted 0 times

...

Clay

11 months ago

I think we practiced a similar question where limiting the data helped, but I can't recall if it was specifically about JSON properties.

upvoted 0 times

...

Luis

11 months ago

I remember something about reducing the dataset size helping with parsing issues, but I'm not sure if it guarantees the JSON properties will be extracted correctly.

upvoted 0 times

...

Felix

11 months ago

This is a good reminder to always test the data export and transformation process before the exam. I'll make sure I have a solid plan for handling large datasets like this.

upvoted 0 times

...

Yun

11 months ago

The solution seems straightforward enough. I'll give it a try and see if I can get the Excel operations to work as expected.

upvoted 0 times

...

Asuncion

12 months ago

I'm a bit confused about the JSON properties in the audit search results. I'll need to review the documentation to understand how to properly extract that information in Excel.

upvoted 0 times

...

France

12 months ago

Reducing the number of records returned seems like a good strategy to avoid the Excel parsing issues. I'll make sure to double-check the search criteria before exporting the data.

upvoted 0 times

...

Paulina

12 months ago

This looks like a tricky one. I'll need to carefully review the steps to make sure I understand the problem and the proposed solution.

upvoted 0 times

...

Isaiah

1 year 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

Kayleigh

1 year ago

User2: Agreed, limiting the data makes sense

upvoted 0 times

...

Helene

1 year ago

User1: Yes

upvoted 0 times

...

Norah

1 year 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

...