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

（A）ALTER

（B）JOIN

（C）RENAME

（D）INSERT

（A）An unlimited amount of time

（B）The length of time specified in the expiration_time argument

（C）The remainder of the session

（D）The same length of time as the expiration period for the query results cache

（A）Transient

（B）Externa

（C）Temporary

（D）Permanent

（A）CREATE OR REPLACE STREAM

（B）DESCRIBE STREAM

（C）ALTER STREAM

（D）DROP STREM

（A）Syntax error

（B）Inefficient pruning

（C）Ambiguous column names

（D）Object does not exist or not authorized

（E）Queries too large to fit in memory

（A）Extracts the path of the flattened data

（B）Casts the values of the flattened data

（C）Retrieves a single instance of a repeating element in the flattened data

（D）Joins information outside the object with the flattened data

（A）GET

（B）TRANSFER

（C）COPY INTO

（D）PUT

（A）Role access policies

（B）External tokenization

（C）Internal tokenization

（D）Network policies

（A）If User2 has the sysadmin role they will be able to see the results.

（B）If User2 has the ACCOUNTADMIN role they will be able to see the results.

（C）User2 will be unable to view the result set of the query executed by User1.

（D）If User2 has the securityadmin role they will be able to see the results.

（A）Enable the data sharing feature in the account and validate the view.

（B）Use the CURRENT_ function to authorize users from a specific account to access rows in a base table.

（C）Use the CURRENT_ROLE and CURRENT_USER functions to validate secure views.

（D）Set the SIMULATED DATA SHARING CONSUMER session parameter to the name of the consumer account for which access is being simulated.

（A）Convert the rows in a relational table lo a single VARIANT column and then unload the rows into a file.

（B）Reorder the data columns according to a target table definition and then unload the rows into the table.

（C）Reorder the rows in a relational table and then unload the rows into a file

（D）Convert the rows in a source file to a single variant column and then load the rows from the file to a variant table.

（A）Migrate some queries to a new warehouse to reduce load

（B）Scale up the warehouse size to allow Queries to execute faster.

（C）Use multi-clustered warehousing to scale out warehouse capacity.

（D）Stop and start the warehouse to clear the queued queries

（E）Limit user access to the warehouse so fewer queries are run against it.

（A）User-Defined Table Functions (UDTFs)

（B）Worksheets

（C）Tables

（D）Secure views

（E）Stored procedures

（A）Create objects with ACCOUNTADMIN and do not reassign ownership.

（B）Create objects with a custom role and grant this role to SYSADMIN.

（C）Create objects with SYSADMIN.

（D）Use only MANAGED ACCESS SCHEMAS for66 objects owned by ACCOUNTADMIN.

（E）Create objects with SECURITYADMIN to ease granting of privileges later.

（A）The primary cluster in the virtual warehouse

（B）The Queries currently being run on the virtual warehouse

（C）The entire virtual warehouse

（D）The database in which the virtual warehouse resides