最新的Snowflake SnowPro® Core Certification 2026 Exam (COF-C03) - COF-C03免費考試真題

A. Apply one masking policy at the schema level to every column in the schema.

B. Use a row access policy to filter rows based on the role, and apply masking functions in each query.

C. Use a network policy and masking functions to restrict access to the SALARY column.

D. Create a masking policy with conditional role logic and attach the policy to the SALARY column.

A. Iceberg

B. Transient

C. Permanent

D. External

A. External tables

B. Secure views

C. Materialized views

D. User-Defined Functions (UDFs)

A. At the beginning of each year

B. At the beginning of each day

C. At the beginning of each month

D. At the beginning of each week

A. Delete the account data for an organization.

B. View usage information for all accounts in an organization.

C. Select all the data in tables for all accounts in an organization.

D. Create an account for an organization.

E. Edit the account data for an organization.

A. ALTER STREAM

B. CREATE OR REPLACE STREAM

C. DROP STREM

D. DESCRIBE STREAM

A. Scoped file URL

B. File URL

C. Pre-signed URL

D. Scoped URL

A. ALTER FILE FORMAT my format SWAP TYPE WITH JSON;

B. CREATE OR REPLACE FILE FORMAT my format TYPE-JSON;

C. REPLACE FILE FORMAT my format TYPE-JSON;

D. ALTER FILE FORMAT my_format SET TYPE=JSON;

A. Directory table

B. Temporary table

C. Transient table

D. Permanent table

A. BINARY_AS_TEXT = TRUE

B. CAST or the :: operator in the COPY INTO statement

C. EMPTY_FIELD_AS_NULL = FALSE

D. SINGLE = TRUE

A. An individual column

B. An individual row

C. A file in a stage

D. A view

A. Track and control the credits consumed by the warehouse.

B. Monitor the real-time performance of all queries running on the warehouse.

C. Automatically adjust the settings of the warehouse based on the workload.

D. Schedule when the warehouse starts and stops.

A. To troubleshoot errors in a pipe execution

B. To determine if the pipe is suspended

C. To modify the configuration of a pipe

D. To list all staged files that include data unloaded from a pipe

E. To identify the name of a pipe

A. CREATE TABLE orders_restored CLONE orders AT (TIMESTAMP = > ' 2025-11-16 10:00:00 ' ::
TIMESTAMP);

B. CREATE TABLE orders_restored CLONE orders BEFORE (OFFSET = > -60*5);

C. CREATE TABLE orders_restored CLONE orders AT (TIMESTAMP = > ' 2025-11-16 15:00:00 ' ::TIMESTAMP);

D. CREATE TABLE orders_restored CLONE orders BEFORE (TIMESTAMP = > ' 2025-11-16 15:00:00' ::TIMESTAMP);