最新的Snowflake SnowPro Core Certification - COF-C02免費考試真題

A. Create a database and grant all permissions to teammates

B. Create a private Data Exchange so that any teammate can use the worksheet

C. Create a zero-copy clone of the worksheet and grant permissions to teammates

D. Share the worksheet with teammates within Snowsight

A. Explore databases and objects.

B. Write and run SQL queries.

C. Create dashboards.

D. Explore executed query performance.

A. Disable auto-suspend on the warehouse.

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

C. Scale-up by resizing the warehouse.

D. Enable auto-resume on the warehouse.

A. ARRAY

B. VARIANT

C. OBJECT

D. VARCHAR

A. Data expires from Fail-safe

B. Data is deleted from a table

C. Data is truncated from a table

D. Data expires from Time Travel

A. Radar charts

B. Column charts

C. Scorecards

D. Area charts

E. Bar charts

A. GET @~

B. LIST @~

C. SHOW @~

D. DESC @~

A. VARIANT

B. JSON

C. VARCHAR

D. BINARY

A. The warehouse size does not change until all queries currently in the warehouse queue have completed.

B. It does not return from the command until the warehouse has finished changing its size.

C. The warehouse size does not change until the warehouse is suspended and restarted.

D. The warehouse size does not change until all queries currently running in the warehouse have completed.

A. Data provider

B. Data consumer

C. Reader

D. Organization

A. An error will be received stating that the storage location for the stage must be identified when creating a stage with a directory table.

B. The command will fail to run because the name of the directory table is not specified.

C. A stage with a directory table that has metadata that must be manually refreshed will be created.

D. A stage with a directory table set to automatically refresh will be created.

A. USERADMIN

B. ACCOUNTADMIN

C. SYSADMIN

D. PUBLIC

E. Any role that has the global ATTACH POLICY privilege

A. Data storage

B. User authentication

C. Partition scanning

D. Infrastructure management

E. Dynamic data masking

A. Compute charges

B. Data storage charges

C. Cloud services charges

D. Data egress charges

A. Use the DESCRIBE STAGE command.

B. Use the GET_STAGE_LOCATION function.

C. Use the SHOW STAGES command.

D. Use the GET_ABSOLUTE_PATH function.

A. list @bronzestage;

B. select * from table(information_schema.stage_directory_file_registration_history(stage name=>'bronzestage1));

C. select metadata$filename from @bronzestage;

D. select * from directory(@bronzestage);