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

（A）Running a custom query

（B）Caching query results

（C）Running EXPLAIN and SHOW commands

（D）Cloning a database

（E）Running COPY commands

（A）view @file__stage

（B）show @file__stage

（C）verify @file__stage

（D）list @file__stage

（A）DELETE

（B）REMOVE

（C）MODIFY

（D）PURGE

（A）Use the ALTER VIEW command to update the view

（B）Materialize the view to perform the changes

（C）Recreate the view with the required changes

（D）Modify the columns in the underlying table

（A）Standard

（B）Virtual Private Snowflake (VPS)

（C）Business Critical

（D）Enterprise

（A）GRANT ADD SEARCH OPTIMIZATION ON SCHEMA <schema_name> TO ROLE <role>

（B）GRANT SEARCH OPTIMIZATION ON DATABASE <database_name> TO ROLE <role>

（C）GRANT SEARCH OPTIMIZATION ON SCHEMA <schema_name> TO ROLE <role>

（D）GRANT ADD SEARCH OPTIMIZATION ON DATABASE <database name> TO ROLE <role>

（A）Premium

（B）Standard

（C）Business Critical

（D）Enterprise

（A）Use the grant privilege ... TO share command to grant the necessary privileges.

（B）Recreate the object with a different name in the database before sharing.

（C）Use the automatic sharing feature for seamless access.

（D）Drop the object and then re-add it to the database to trigger sharing.

（A）display @my_stage

（B）view @my_stage

（C）show @my_stage

（D）list @my_stage

（A）Standard

（B）Business Critical

（C）Enterprise

（D）Virtual Private Snowflake

（A）A task allows a user to execute a set of SQL commands on a predefined schedule.

（B）A task can be called using a CALL statement to run a set of predefined SQL commands.

（C）A task can be executed using a SELECT statement to run a predefined SQL command.

（D）A task allows a user to execute a single SQL statement/command using a predefined schedule.

（A）Users with manage grants privilege

（B）Users with ORGADMIN role

（C）Users with sysadmin role

（D）Users with import share privilege

（E）Users with ACCOUNTADMIN role

（A）Warehouses that are multi-cluster can have nodes of different sizes.

（B）Warehouses are billed on a per-minute usage basis.

（C）Warehouses can only be used for querying and cannot be used for data loading.

（D）Warehouses can be started and stopped at any time.

（E）Warehouses can be resized at any time, even while running.

（A）.NET driver

（B）Snowflake classic web interface (Ul)

（C）SnowSQL

（D）Snowsight

（A）AVRO

（B）XML

（C）CSV

（D）Parquet

（E）JSON

（F）ORC

（A）Indexing

（B）Clustering

（C）Using INDEX__HINTS

（D）Fragmenting

（A）MODIFY

（B）CREATE

（C）OWNERSHIP

（D）USAGE

（A）A Materialized View cannot be defined with a JOIN

（B）A Materialized View cannot be joined with other tables

（C）A Materialized View can only reference up to two tables

（D）A Materialized View cannot support any aggregate functions

（A）Snowflake tables require that clustering keys be defined lo perform optimally.

（B）Snowflake tables are owned by a use.

（C）Snowflake tables arc logical representation of underlying physical data.

（D）Snowflake tables are the physical instantiation of data loaded into Snowflake.