Snowflake snowpro-core practice test

In the Snowflake access control model, which entity owns an object by default?

• A. The user who created the object
• B. The SYSADMIN role
• C. Ownership depends on the type of object
• D. The role used to create the object

What is the default access of a securable object until other access is granted?

• A. No access
• B. Read access
• C. Write access
• D. Full access

A user created a new worksheet within the Snowsight UI and wants to share this with teammates.

How can this worksheet be shared?

• A. Create a zero-copy clone of the worksheet and grant permissions to teammates.
• B. Create a private Data Exchange so that any teammate can use the worksheet.
• C. Share the worksheet with teammates within Snowsight.
• D. Create a database and grant all permissions to teammates.

Which command is used to generate a zero-copy snapshot of any table, schema, or database?

• A. ALTER
• B. CREATE ... CLONE
• C. COPY INTO
• D. CREATE REPLICATION GROUP

Which sequence (order) of object privileges should be used to grant a custom role read-only access on a table?

• D. None

Which of the following objects can be directly restored using the UNDROP command? (Choose two.)

• A. Schema
• B. View
• C. Internal stage
• D. Table
• E. User
• F. Role

What is the default compression typo when unloading data from Snowflake?

• A. Brotli
• B. bzip2
• C. Zstandard
• D. gzip

Who can create network policies within Snowflake? (Choose two.)

• A. SYSADMIN only
• B. ORGADMIN only
• C. SECURITYADMIN or higher roles
• D. A role with the CREATE NETWORK POLICY privilege
• E. A role with the CREATE SECURITY INTEGRATION privilege

Which table function should be used to view details on a Directed Acyclic Graph (DAG) run that is presently scheduled or is executing?

• A. TASK_HISTORY
• B. TASK_DEPENDENTS
• C. CURRENT_TASK_GRAPHS
• D. COMPLETE_TASK_GRAPHS

What is used to extract the content of PDF files stored in Snowflake stages?

• A. FLATTEN function
• B. Window function
• C. HyperLogLog (HLL) function
• D. Java User-Defined Function (UDF)