ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam DP-500 All Questions

View all questions & answers for the DP-500 exam
Go to Exam

Exam DP-500 topic 1 question 117 discussion

Actual exam question from Microsoft's DP-500
Question #: 117
Topic #: 1
[All DP-500 Questions]

You are using an Azure Synapse Analytics serverless SQL pool to query network traffic logs in the Apache Parquet format.

A sample of the data is shown in the following table.



You need to create a Transact-SQL query that will return the source IP address.

Which function should you use in the select statement to retrieve the source IP address?

  • A. JSON_VALUE
  • B. CONVERT
  • C. FIRST_VALUE
  • D. FOR_JSON
Show Suggested Answer Hide Answer
Suggested Answer: A 🗳️
by Martin_Nbg at July 9, 2023, 10:42 a.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
Anchov
1 year, 8 months ago
Selected Answer: A
Agree with source supplied by Martin_Nbg
upvoted 1 times
...
KBelh
1 year, 9 months ago
none of the answers is correct. It should be Openrowset.
upvoted 1 times
...
Martin_Nbg
1 year, 11 months ago
Selected Answer: A
Correct, see https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/query-parquet-nested-types
upvoted 3 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel