COF-R02 無料問題集「Snowflake SnowPro Core Recertification」

（A）Is available to all Snowflake Editions

（B）Restricts or enables access to specific IP addresses

（C）Is only available to customers with Business Critical Edition

（D）Is activated using an "ALTER DATABASE" command

（A）False

（B）True

（A）Each Snowflake account must be hosted in a different cloud vendor and region

（B）All Snowflake accounts must be hosted in the same cloud vendor and region

（C）Each Snowflake account can be hosted in a different cloud vendor and region.

（D）Each Snowflake account can be hosted in a different cloud vendor, but must be in the same region.

（A）60 minutes

（B）1 year

（C）30 days

（D）14 days

（E）24 hours

（A）Stored procedure

（B）Task

（C）External table

（D）Masking policy

（A）Customer managed keys (Tri-secret secure)

（B）Native support for geospatial data

（C）Extended time travel

（D）Automated index management

（E）Database replication and failover

（A）Compute layer

（B）Storage layer

（C）Cloud infrastructure layer

（D）Cloud services layer

（A）SECURITYADMIN

（B）SYSADMIN

（C）ACCOUNTADMIN

（D）ORGADMIN

（A）False

（B）True

（A）json_extract_path_text()

（B）object_construct()

（C）flatten

（D）parse_json()

（A）Geometry

（B）Geography

（C）Object

（D）Variant

（A）A Warehouse can be configured to auto-resume when new queries are submitted

（B）Customers can change the size of the Warehouse after creation

（C）A Warehouse can be resized while running

（D）A Warehouse can be configured to suspend after a period of inactivity

（A）The cloned views and the stored procedures will reference the cloned tables in the cloned database.

（B）An error will occur, as views with qualified references cannot be cloned.

（C）The stored procedures and views will refer to tables in the source database.

（D）An error will occur, as stored objects cannot be cloned.

（A）When reducing the size of a warehouse the compute resources are removed only when they are no longer being used to execute any current statements.

（B）Users who are trying to use the warehouse will receive an error message until the resizing is complete

（C）When increasing the size of an active warehouse the compute resource for all running and queued queries on the warehouse are affected

（D）The warehouse will be suspended while the new compute resource is provisioned and will resume automatically once provisioning is complete.

（A）SELECT AVG(ORDER_QTY) FROM SALES;

（B）SELECT MIN(ORDER_AMT) FROM SALES;

（C）SELECT SUM (ORDER_AMT) FROM SALES;

（D）SELECT ORDER_AMT * ORDER_QTY FROM SALES;

（A）SELECT EVENT_TIMESTAMP, USER_NAME
FROM table(information_schema.login_history_by_user())

（B）SELECT LAST_SUCCESS_LOGIN, LOGIN_NAME
FROM ACCOUNT_USAGE.USERS;

（C）SELECT EVENT_TIMESTAMP, USER_NAME
FROM ACCOUNT_USAGE.LOGIN_HISTORY;

（D）SELECT EVENT_TIMESTAMP, USER_NAME
FROM ACCOUNT_USAGE.ACCESS_HISTORY;