This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Descriptions contain codes like AB12345 embedded in text. The result must return the matched code text per row. Which option fits?
REGEXP_SUBSTR
REGEXP_INSTR
REGEXP_MATCHES
A report needs one JSON field per customer listing all product IDs in order. Which option aligns with that output?
JSON_OBJECTAGG
STRING_CONCAT_WS
JSON_ARRAYAGG
Similarity scores fluctuate across rows because vector magnitudes vary. The pipeline must make scores comparable across rows. What helps?
VECTOR_NORMALIZE
VECTOR_DISTANCE
CREATE VECTOR INDEX
A nightly job must store the current date as a partition key with no time component. Which choice avoids manual truncation?
GETDATE
CURRENT_DATE
SYSDATETIME
You must answer all questions before checking your work.
Was this page helpful?
Need help with this topic?
Want to try using Ask Learn to clarify or guide you through this topic?