QUESTION: 57

Which of the following DML commands isn't supported by Snowflake?

UPSERT
MERGE
UPDATE
TRUNCATE TABLE

Answer(s): A

Reference:

https://docs.snowflake.com/en/sql-reference/sql-dml.html

Reveal Solution Next Question

QUESTION: 58

Which of the following statements is true of zero-copy cloning?

Zero-copy clones increase storage costs as cloning the table requires storing its data twice
All zero-copy clone objects inherit the privileges of their original objects
Zero-copy cloning is licensed as an additional Snowflake feature
At the instance/instant a clone is created, all micro-partitions in the original table and the clone are fully shared

Answer(s): D

Reference:

https://community.snowflake.com/s/question/0D50Z00009D8VOd/zero-copy-cloning-base-data

Reveal Solution Next Question

QUESTION: 59

True or False: When a user creates a role, they are initially assigned ownership of the role and they maintain ownership until it is transferred to another user.

True
False

Answer(s): B

Reference:

https://docs.snowflake.com/en/user-guide/security-access-control-overview.html

Reveal Solution Next Question

QUESTION: 60

The Query History in the Snowflake Web Interface (UI) is kept for approximately:

60 minutes
24 hours
14 days
30 days
1 year

Answer(s): C

Reference:

https://docs.snowflake.com/en/sql-reference/account-usage/query_history.html

Reveal Solution Next Question

Free SnowPro Core Exam Braindumps (page: 16)

QUESTION: 57

Reference:

QUESTION: 58

Reference:

QUESTION: 59

Reference:

QUESTION: 60

Reference:

SnowPro Core Discussions & Posts