최신Snowflake SnowPro Core Certification - COF-C01무료샘플문제

A. Temporary

B. Provisional

C. Translent

D. Permanent

A. Zero-copy clones objects inherit

B. Zero-copy coning is licensed as an additional Snowflake feature

C. At the instance/instance a clone is created, all micro-partitions in the original table and the clone are fully shared.

D. All zero-copy clone objects inherit the privileges of their original objects

A. True

B. False

A. The primary duster in the virtual warehouse

B. The database the Virtual Warehouse resides in

C. The queries currently being run by the Virtual Warehouse

D. The entire Virtual Warehouse

A. They should use the SYSADMIN role to perform administrative work on database objects

B. Their default role should be set to SYSTEMADMIN (the lower of the two)

C. They should only access and 'step into' the ACCOUNTADMIN role temporarily, as needed to complete a specific operation

D. They should ensure all database objects in the account are owned by the ACCOUNTADMIN role

E. They should not set up multi_Factor Authentication (MFA)-as administrator they may need to change the MFA settings and those enrolled in MFA are unable to do so

A. Premier

B. Standard

C. Business Critical Edition

D. Enterprise

A. True

B. False

A. True

B. False

A. you can only use it on internal Stages

B. All COPY INTO options are available fluting pipe creation

C. Snowpipe keeps track of which files it has loaded

D. Snowflake automatically manages the compute required to execute the Pipe's copy into commands

A. True

B. False

A. Database

B. Warehouses

C. Worksheets

D. Tables

A. Premier

B. Standard

C. Business Critical Edition

D. Enterprise

A. The exact query win ALWAYS return me precomputed result set for the RESULT_CACHE_ACTIVE = time period

B. The same exact query will return the precomputed results if the underlying data hasn't changed and the results were last accessed within the previous 24 hour period

C. The ''24 hour'' on the percomputed results gets renewed every time the exact query is executed

D. The same exact query will return the precomputed results even if the underlying data has changed as long as the results were last accessed within the previous

A. True

B. False