Question 751 · 1323 in bank
A custom role owns multiple tables. If this role is dropped from the system, who becomes the owner of these tables?
Show answer
Answer: D
SnowPro Core Certification1,323 questions across 133 pages are complete and free, with no account or card.
1323 questions in this bank
Free access · progress saved on this device
A custom role owns multiple tables. If this role is dropped from the system, who becomes the owner of these tables?
Answer: D
Which function produces a lateral view of a VARIANT column?
Answer: B
Snowflake strongly recommends that all users with what type of role be required to use Multi-Factor Authentication (MFA)?
Answer: B
What does it mean when the sample function uses the Bernoulli sampling method?
Answer: A
BERNOULLI (or ROW): Includes each row with a probability of p/100. Similar to flipping a weighted coin for each row. SYSTEM (or BLOCK): Includes each block of rows with a probability of p/100. Similar to flipping a weighted coin for each block of rows. This method does not support fixed-size sampling. Sampling method is optional. If no method is specified, the default is BERNOULLI.
Source: Adapted from community discussion — [Removed]
What are characteristics of Snowflake network policies? (Choose two.)
Answer: AC
Which function should be used to find the query ID of the second query executed in a current session?
Answer: D
Positive numbers start with the first query executed in the session. For example: LAST_QUERY_ID(1) returns the first query. LAST_QUERY_ID(2) returns the second query. LAST_QUERY_ID(6) returns the sixth query. Etc. Negative numbers start with the most recently-executed query in the session. For example: LAST_QUERY_ID(-1) returns the most recently-executed query (equivalent to LAST_QUERY_ID()). LAST_QUERY_ID(-2) returns the second most recently-executed query. Etc.
Source: Adapted from community discussion — bibisa
A role is created and owns 2 tables. This role is then dropped. Who will now own the two tables?
Answer: D
A user can't own a table. Ownership of any objects owned by the dropped role is transferred to the *role* that executes the DROP ROLE command.
Source: Adapted from community discussion — uncle_benz
How is the hierarchy of database objects organized in Snowflake?
Answer: A
Which role can execute the SHOW ORGANIZATION ACCOUNTS command successfully?
Answer: C
Which data types in Snowflake are synonymous for FLOAT? (Choose two.)
Answer: BE
Keyboard:J Kmove between questionsA–Dselect an answerRshow or hide the answer← →change page
COF-C02 practice, question 751. 1323 questions available.
Version 1.0.0. How we source questions