SnowPro-Core 무료 덤프문제 온라인 액세스

Which of the following are benefits of micro-partitioning? (Select TWO)

• A.Micro-partitions can reduce the amount of I/O from object storage to virtual warehouses
• B.Rows are automatically stored in sorted order within micro-partitions
• C.Micro-partitions can be defined on a schema-by-schema basis
• D.Micro-partitions are immutable objects that support the use of Time Travel.
• E.Micro-partitions cannot overlap in their range of values

Which SQL commands, when committed, will consume a stream and advance the stream offset? (Choose two.)

• A.UPDATE TABLE FROM STREAM
• B.BEGIN COMMIT
• C.INSERT INTO TABLE SELECT FROM STREAM
• D.SELECT FROM STREAM
• E.ALTER TABLE AS SELECT FROM STREAM

By default, which role has access to the SYSTEM$GLOBAL_ACCOUNT_SET_PARAMETER function?

• A.SYSADMIN
• B.ACCOUNTADMIN
• C.SECURITYADMIN
• D.ORGADMIN

What is the difference between a stored procedure and a User-Defined Function (UDF)?

• A.Values returned by a stored procedure can be used directly in a SQL statement while the values returned by a UDF cannot.
• B.Stored procedures can execute database operations while UDFs cannot.
• C.Multiple stored procedures can be called as part of a single executable statement while a single SQL statement can only call one UDF at a time.
• D.Returning a value is required in a stored procedure while returning values in a UDF is optional.

Which user object property requires contacting Snowflake Support in order to set a value for it?

• A.DISABLED
• B.MINS TO UNLOCK
• C.MINS TO BYPASS NETWORK POLICY
• D.MINS TO BYPASS MFA