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

During periods of warehouse contention which parameter controls the maximum length of time a warehouse will hold a query for processing?

• A.STATEMENT_QUEUED_TIMEOUT_IN_SECONDS
• B.STATEMENT_TIMEOUT__IN__SECONDS
• C.QUERY_TIMEOUT_IN_SECONDS
• D.MAX_CONCURRENCY__LEVEL

What metadata does Snowflake store for rows in micro-partitions? (Select TWO).

• A.Range of values
• B.Sorted values
• C.Distinct values
• D.Null values
• E.Index values

What is the recommended use for the COPY INTO < location > SINGLE = TRUE command?

• A.To load an individual file
• B.To unload a single file from a table into a stage
• C.To copy data and parse the results into single stages
• D.To load data without duplications

Which privilege must be granted by one role to another role, and cannot be revoked?

• A.MONITOR
• B.ALL
• C.OPERATE
• D.OWNERSHIP

Which of the following describes external functions in Snowflake?

• A.They are a type of User-defined Function (UDF).
• B.They can return multiple rows for each row received
• C.They call code that is stored inside of Snowflake.
• D.They contain their own SQL code.