Design and develop database solutions Questions
Practice questions for Design and develop database solutions topic in Microsoft Certified: SQL AI Developer Associate. 76 questions covering this domain.
A developer needs to convert JSON text into a rowset that can be joined with relational tables. Which function should be used?
A developer needs a fuzzy matching function that returns an integer similarity score from 0 to 100 rather than a raw edit-distance count. Which functi...
A query must return a JSON array stored at a given path rather than a scalar. Which function should be used?
A query uses `ROW_NUMBER() OVER (ORDER BY LastName)`. Which condition makes the row numbering deterministic across executions?
A solution must preserve an immutable ledger where rows can be inserted but never updated or deleted. Which ledger table type should be used?
A developer creates a primary key on an existing table. Which rule is enforced automatically for the primary key columns?
A report must show row values as they existed at 2026-02-01 12:00 UTC from a system-versioned temporal table. Which clause should be used?
An engineer is partitioning a table in Azure SQL Database. Which filegroup can be used for the partition scheme?
A recursive common table expression might loop indefinitely because of bad source data. Which query option is used to limit the recursion depth?
A team wants multiple tables to draw numbers from the same ordered sequence. Which feature should they use?
A database model uses SQL Graph. Which statement correctly describes node and edge tables?
A developer needs a boolean-style predicate that checks whether a string matches a regular expression pattern. Which function should be used?
A developer wants to express a graph pattern across node and edge tables in a SQL Graph query. Which clause is used for this purpose?
A transaction consumes a value from `NEXT VALUE FOR` and then rolls back. What happens to the consumed sequence number?
An auditor wants proof that historical records were not tampered with after they were written. Which feature is designed for tamper-evidence rather th...
A query must return both the current rows and every historical version from a temporal table in one result. Which clause should be used?
A JSON document contains a `city` property with the scalar value `London`. Which function is the best fit for extracting that scalar value?
Which statement best describes how a nonrecursive common table expression behaves during execution?
A DML trigger must compare the old and new versions of rows affected by an `UPDATE`. Which logical tables are available inside the trigger?
A SQL Graph query must find the shortest path between two nodes through edge tables. Which feature should be used?
Sign in to see all 76 questions
Create a free account to browse all questions — completely free during our launch phase.