When cloning a database, what is cloned with the database? (Choose two.)

• A.Privileges on the database
• B.Privileges on the schemas within the database
• C.Future child objects within the database
• D.Only schemas and tables within the database
• E.Existing child objects within the database

Comment: *

Name: *

Email: *

Verification: *

Which statement MOST accurately describes clustering in Snowflake?

• A.The clustering key must be included in the COPY command when loading data into Snowflake.
• B.The database ACCOUNTADMIN must define the clustering methodology for each Snowflake table.
• C.Clustering is the way data is grouped together and stored within Snowflake micro-partitions.
• D.Clustering can be disabled within a Snowflake account.

Comment: *

Name: *

Email: *

Verification: *

What command is used to load files into an Internal Stage within Snowflake?

• A.PUT
• B.TRANSFER
• C.COPY INTO
• D.INSERT

Comment: *

Name: *

Email: *

Verification: *

A Snowflake user has been granted the create data EXCHANGE listing privilege with their role.
Which tasks can this user now perform on the Data Exchange? (Select TWO).

• A.Modify listings properties.
• B.Delete provider profiles.
• C.Submit listings for approval/publishing.
• D.Rename listings.
• E.Modify incoming listing access requests.

Comment: *

Name: *

Email: *

Verification: *

True or False: It is possible to unload structured data to semi-structured formats such as JSON and parquet.

• A.True
• B.False

Comment: *

Name: *

Email: *

Verification: *