Which function can be used with the COPY INTO
Which function can be used with the COPY INTO
The function that can be used with the COPY INTO <location> statement to convert rows from a relational table to a single VARIANT column, and to unload rows into a JSON file, is OBJECT_CONSTRUCT. OBJECT_CONSTRUCT creates a VARIANT object by converting individual columns into key-value pairs, which can then be easily written out as JSON.
D is correct D. USAGE: The USAGE privilege on a database allows users to access objects within the database, which is necessary for the users who will be accessing the shared secure view. This privilege is required to ensure that users can resolve references to objects in the database when querying the secure view.
Answer C