최신 COF-C02 무료덤프 - Snowflake SnowPro Core Certification

A. Enable auto-resume on the warehouse.

B. Scale-out with a multi-cluster warehouse.

C. Scale-up by resizing the warehouse.

D. Disable auto-suspend on the warehouse.

A. SECURITYADMIN

B. ORGADMIN

C. SYSADMIN

D. ACCOUNTADMIN

A. In the metadata of the target table for 14 days

B. In the metadata of the target table for 64 days

C. In the metadata of the pipe for 14 days

D. In the metadata of the pipe for 64 days

A. The SESSIONS view in ACCOUNT_USAGE

B. The ACCESS_HISTORY view in ACCOUNT_USAGE

C. The USERS view in ACCOUNT_USAGE

D. The LOGIN_HISTORY view in ACCOUNT_USAGE

A. Snowflake parameters

B. Micro-partitions

C. Persisted query results

D. Standard and secure view results

E. Query history

A. SECURITYADMIN

B. ORGADMIN

C. SYSADMIN

D. ACCOUNTADMIN

A. They can return multiple rows for each row received

B. They are a type of User-defined Function (UDF).

C. They call code that is stored inside of Snowflake.

D. They contain their own SQL code.

A. GRANT MODIFY ON WAREHOUSE MKTG__WH TO USER MKTG__LEAD;

B. GRANT OPERATE ON WAREHOUSE MKTG WH TO ROLE MARKETING;

C. ALLOW RESIZE ON WAREHOUSE MKTG__WH TO USER MKTG__LEAD;

D. GRANT MODIFY ON WAREHOUSE MKTG WH TO ROLE MARKETING;

A. Use the validation mode = return rows statement.

B. Load the data into a relational table.

C. Use the VALlDATlON_MODE - SQL statement.

D. Load the data into a CSV file.

A. If the select statement contains a large number of temporary tables or Common Table Expressions (CTEs)

B. When a large number of concurrent queries are run on the same warehouse

C. If the runtime of the executed query is very slow

D. When it is unknown how much compute power is needed

A. Through the DATA_SHARE=TRUE parameter

B. Through the enable__share=true parameter

C. Using the CREATE SHARE AS SELECT * TABLE command

D. Through SQL commands

E. Through the Snowflake web interface (Ul)

A. Credits will be charged only when a virtual warehouse consumes serverless compute services.

B. Credits will be charged only when running a Snowflake-provisioned compute warehouse COMPUTER_WH.

C. Credits will be charged whenever the Cloud Services layer is used.

D. Credits will be charged when the daily consumption of cloud services resources exceeds 10% of the daily warehouse usage.

A. CHECK_JSON

B. TO_VARIANT

C. FLATTEN

D. PARSE_JSON

A. Snowflake will first check the current schema, and them the PUBLIC schema of the current database.

B. Snowflake will first check the current schema, and then the schema the previous query used

C. Snowflake will resolve them according to the SEARCH_PATH parameter.

D. Snowflake will only check the schema the UDF belongs to.