A JSON document contains a city property with the scalar value London. Which function is the best fit for extracting that scalar value?
JSON_QUERYOPENJSONJSON_VALUEJSON_MODIFYMore Design and develop database solutions Questions
76 questions
Full Microsoft Certified: SQL AI Developer Associate Practice Test
All topics covered
All Microsoft Certified: SQL AI Developer Associate Questions
Browse by topic
Related Questions
A developer creates a primary key on an existing table. Which rule is enforced automatically for the...
A team wants multiple tables to draw numbers from the same ordered sequence. Which feature should th...
A report must show row values as they existed at 2026-02-01 12:00 UTC from a system-versioned tempor...
A database model uses SQL Graph. Which statement correctly describes node and edge tables?...
An engineer is partitioning a table in Azure SQL Database. Which filegroup can be used for the parti...
Educational Content — CertQnA practice questions are written against official exam objectives, covering the same domains tested on the real exam. All content is original and independent — not actual exam questions, not affiliated with any certification vendor. Learn more about our content policy
Discussion
Be the first to share your understanding of this concept
Sign in to join the discussion