COF-C02 무료 덤프문제 온라인 액세스

Which Snowflake function and command combination should be used to convert rows in a relational table to a single VARIANT column, and unload the rows Into a file in JSON format? (Select TWO).

• A.COPY
• B.PUT
• C.OBJECT CONSTRUCT
• D.GET
• E.EXPORT

What is a responsibility of Snowflake's virtual warehouses?

• A.Infrastructure management
• B.Query execution
• C.Permanent storage of micro-partitions
• D.Query parsing and optimization
• E.Metadata management

A user wants to create objects within a schema but wants to restrict other users ' ability to grant privileges on these objects What configuration should be used to create the schema?

• A.Use a regular (non-managed) schema
• B.Use a managed access schema
• C.Set the Def ault_DDL_collation parameter.
• D.Use a transient schema.

Which COPY INTO < location > command options impact the number of files generated? Select TWO.

• A.INCLUDE_QUERY_ID
• B.RECORD_DELIMITER
• C.MAX_FILE_SIZE
• D.DETAILED_OUTPUT
• E.SINGLE

Awarding a user which privileges on all virtual warehouses is equivalent to granting the user the global MANAGE WAREHOUSES privilege?

• A.MODIFY, MONITOR and OPERATE privileges
• B.ownership and usage privileges
• C.APPLYBUDGET and audit privileges
• D.MANAGE LISTING ADTOTOLFillment and resolve all privileges