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
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Microsoft Exam DP-203 Topic 10 Question 81 Discussion

Actual exam question for Microsoft's DP-203 exam
Question #: 81
Topic #: 10
[All DP-203 Questions]

You are creating an Apache Spark job in Azure Databricks that will ingest JSON-formatted data.

You need to convert a nested JSON string into a DataFrame that will contain multiple rows.

Which Spark SQL function should you use?

Show Suggested Answer Hide Answer
Suggested Answer: A, B

the two types of activities that you can use to execute SP1 areStored ProcedureandLookup.

A Stored Procedure activity executes a stored procedure on an Azure SQL Database or Azure Synapse Analytics or SQL Server1.You can specify the stored procedure name and parameters in the activity settings1.

A Lookup activity retrieves a dataset from any data source that returns a single row of data with four columns2.You can use a query to execute a stored procedure as the source of the Lookup activity2.You can then store the values in the columns as pipeline variables by using expressions2.

https://learn.microsoft.com/en-us/azure/data-factory/transform-data-using-stored-procedure


by Annabelle at Dec 25, 2023, 07:35 PM

Limited Time Offer

25%

Off

Get Premium DP-203 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel
Rebecka
2 months ago
I'm not sure about explode. Maybe we should consider using extract instead.
upvoted 0 times
...
Elli
2 months ago
I agree with Ozell. Explode is the right Spark SQL function for this task.
upvoted 0 times
...
Ressie
2 months ago
I'm going to go with C) coalesce, because that's what I do with my socks when they go missing. Wait, what was the question again?
upvoted 0 times
Ronald
18 days ago
User 2: Oh, I see. Thanks for the tip!
upvoted 0 times
...
Chaya
25 days ago
User 1: You should actually use A) explode to convert nested JSON into multiple rows.
upvoted 0 times
...
Jolene
1 months ago
User 2: Oh, really? I thought it was D) extract. Thanks for clarifying!
upvoted 0 times
...
Elinore
1 months ago
User 1: No, the correct answer is A) explode.
upvoted 0 times
...
...
Ozell
2 months ago
I think we should use explode to convert the nested JSON string into multiple rows.
upvoted 0 times
...
Simona
2 months ago
Jokester
upvoted 0 times
...
Vincent
2 months ago
I'm not sure, but I think A) explode makes sense for this scenario.
upvoted 0 times
...
Elouise
2 months ago
I agree with Jade, because explode is used to create multiple rows from nested data.
upvoted 0 times
...
Jade
2 months ago
I think the answer is A) explode.
upvoted 0 times
...

Save Cancel