Snowflake SnowPro Core Recertification - COF-R02 Exam Questions

A. Streams B. Secure User-Defined Functions (UDFs) C. Sequences D. External tables E. Files

A. 16 B. 128 C. 32 D. 4

A. True B. False

A. The global privilege create task is required to create a new task. B. Tasks are created at the Application level and can only be created by the Account Admin role. C. Many Snowflake DDLs are metadata operations only, and create task DDL can be executed without virtual warehouse requirement or task specific grants. D. The role must have access to the target schema and the create task privilege on the schema itself.

A. Use the PARSE_JSON function to ensure structured data will be unloaded into the VARIANT data type. B. When unloading semi-structured data, it is recommended that the STRIP_OUTER_ARRAY option be used. C. By using the SINGLE = TRUE parameter, a single file up to 5 GB in size can be exported to the storage layer. D. The OBJECT_CONSTRUCT function can be used to convert relational data to semi-structured data. E. Use the ENCODING file format option to change the encoding from the default UTF-8.

A. SQL commands B. All of the above C. Data integration tools D. The Snowflake Web Interface (UI)

A. A Data Exchange allows groups of accounts to share data privately among the accounts. B. The sharing of data in a Data Exchange is bidirectional. An account can be a provider for some datasets and a consumer for others. C. If an account is enrolled with a Data Exchange, it will lose its access to the Snowflake Marketplace. D. Data Exchange functionality is available by default in accounts using the Enterprise edition or higher. E. A Data Exchange allows accounts to share data with third, non-Snowflake parties.

A. Enterprise B. Business Critical Edition C. Premier D. Standard

A. Automatically uses the last Stage created B. Automatically creates a File Format object C. Automatically encrypts files D. Automatically compresses files using Gzip

A. Larger micro-partitions are created for common data values to reduce the number of partitions that must be scanned B. Data is hashed by the cluster key to facilitate fast searches for common data values C. Smaller micro-partitions are created for common data values to allow for more parallelism D. Data may be colocated by the cluster key within the micro-partitions to improve pruning performance

A. AVRO B. ORC C. JSON D. Parquet E. CSV F. XML

A. Duo Mobile B. Okta Verify C. Microsoft Authenticator D. Google Authenticator

A. External stages B. Data encryption C. Fail-safe D. Time Travel E. Tri-Secret Secure