Which of the following accurately describes shares?

• A.Tables, secure views, and secure UDFs can be shared
• B.Shares can be shared
• C.Data consumers can clone a new table from a share
• D.Access to a share cannot be revoked once granted

Comment: *

Name: *

Email: *

Verification: *

Which function unloads data from a relational table to JSON?

• A.TRUNC<ID_NUMBER, -6)
• B.TRUNC(ID_NUMBER, 5)
• C.ID_NUMBER*100
• D.TO_CHAR<ID NUMBER)

Comment: *

Name: *

Email: *

Verification: *

What effect does WAIT_FOR_COMPLETION = TRUE have when running an ALTER WAREHOUSE command and changing the warehouse size?

• A.The warehouse size does not change until the warehouse is suspended and restarted.
• B.The warehouse size does not change until all queries currently in the warehouse queue have completed.
• C.It does not return from the command until the warehouse has finished changing its size.
• D.The warehouse size does not change until all queries currently running in the warehouse have completed.

Comment: *

Name: *

Email: *

Verification: *

What does SnowCD help Snowflake users to do?

• A.Copy data into files.
• B.Manage different databases and schemas.
• C.Troubleshoot network connections to Snowflake.
• D.Write SELECT queries to retrieve data from external tables.

Comment: *

Name: *

Email: *

Verification: *

Which statement describes Snowflake tables?

• A.Snowflake tables arc logical representation of underlying physical data.
• B.Snowflake tables are the physical instantiation of data loaded into Snowflake.
• C.Snowflake tables require that clustering keys be defined lo perform optimally.
• D.Snowflake tables are owned by a use.

Comment: *

Name: *

Email: *

Verification: *