COF-C02 無料問題集「Snowflake SnowPro Core Certification」

（A）OPERATE

（B）MONITOR

（C）MODIFY

（D）USAGE

（A）GET

（B）COPY INTO <location>

（C）INSERT

（D）PUT

（A）Temporary table

（B）Transient table

（C）Secure view

（D）Materialized view

（A）ARRAY

（B）BINARY

（C）VARIANT

（D）VARCHAK

（E）TEXT

（A）ALTER TABLE AS SELECT FROM STREAM

（B）INSERT INTO TABLE SELECT FROM STREAM

（C）UPDATE TABLE FROM STREAM

（D）BEGIN COMMIT

（E）SELECT FROM STREAM

（A）Serverless query engine

（B）Multi-cluster shared data

（C）Shared-nothing

（D）Shared-disk

（A）They are a set of rules that define how data can be transferred between different Snowflake accounts within an organization.

（B）They are a set of rules that dictate how Snowflake accounts can be used between multiple users.

（C）They are a set of rules that control access to Snowflake accounts by specifying the IP addresses or ranges of IP addresses that are allowed to connect

（D）They are a set of rules that define the network routes within Snowflake.

（A）Returning a value is required in a stored procedure while returning values in a UDF is optional.

（B）Stored procedures can execute database operations while UDFs cannot.

（C）Values returned by a stored procedure can be used directly in a SQL statement while the values returned by a UDF cannot.

（D）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.

（A）USAGE on the specific tables in the database.

（B）USAGE on the database and the schema containing the tables to share

（C）OPEBATE on the database and the schema containing the tables to share.

（D）USAGE on the specific tables in the database.

（E）MODIFY on 1Mb specific tables in the database.

（A）Use the COPY Option SINGLE=TRUE .

（B）Use the get option SINGLE-TRUE.

（C）Use the copy option files=single.

（D）Use the GET option FILES-SINGLE.

（A）Filter using a limit keyword

（B）Filter using a where clause

（C）Cast using a SELECT statement

（D）Order using an ORDER BY clause

（A）Clustering of the data used by the query

（B）Changing a column that is not in the cached query

（C）Executing the RESULTS_SCAN() table function

（D）Stopping the virtual warehouse that the query is running against

（E）Removing a column from the query SELECT list

（A）Set the user's access to expire within a specified timeframe.

（B）Force an immediate password change.

（C）Set the number of minutes to unlock to 15 minutes.

（D）Set a default role for the user.

（E）Configure the user to be initially disabled.

（A）3500

（B）1500

（C）5000

（D）0

（A）Database role

（B）Account role

（C）Secondary role

（D）Custom role

（A）Object-level access control

（B）Column-level security to apply data masking policies to tables and views

（C）Automatic encryption of all data

（D）Up to 90 days of data recovery through Time Travel

（E）Customer-managed encryption keys through Tri-Secret Secure

（A）Micro-partitions have been reclustered since the query was last run

（B）The user has the appropriate privileges on the objects associated with the query

（C）The query has been run within 24 hours of the previously-run query

（D）The new query is run using the same virtual warehouse as the previous query

（E）The query includes a User Defined Function (UDF)

（A）A Query Profile automatically scales the virtual warehouse based on the query complexity.

（B）A Query Profile defines the hardware specifications of the virtual warehouse.

（C）A Query Profile can help users right-size virtual warehouses.

（D）A Query Profile can help determine the number of virtual warehouses available.

（A）GET_PRESIGNED_URL

（B）BUILD_STAGE_FILE_URL

（C）GET_ABSOLUTE_PATH

（D）BUILD SCOPED FILE URL