Question 1181 · 1323 in bank
Which command removes a role from another role or a user in Snowflake?
Show answer
Answer: B
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
Which command removes a role from another role or a user in Snowflake?
Answer: B
In which hierarchy is tag inheritance possible?
Answer: D
The ORDERS table contains 12,000 rows. Which query will return 10 rows that are randomly sampled from the table every time the query is run?
Answer: D
True or False: It is best practice to define a clustering key on every table.
Answer: B
Answer: B It is not always best practice in Snowflake to define a clustering key on every table. Clustering keys are used to group related rows physically together in a table, which can improve query performance by minimizing the amount of data that needs to be scanned or skipped during query execution. However, clustering keys should be chosen carefully based on the access patterns of the table, and the type of queries that will be run against it. Defining a clustering key on every table may not always be necessary or beneficial. For example, in some cases, tables may be small or may not have well-defined access patterns, making clustering unnecessary. In other cases, tables may be loaded in a specific order or partitioned in a certain way that obviates the need for clustering. Therefore, it is not a best practice to define a clustering key on every table in Snowflake, but rather to carefully consider the access patterns and usage of each table, and to choose clustering keys judiciously based on those factors.
Source: Adapted from community discussion — SteveCrown
Which function will convert semi-structured data to a relational data representation?
Answer: B
What happens when a network policy includes values that appear in both the allowed and blocked IP address lists?
Answer: B
B. When a network policy includes values in both the allowed and blocked IP address lists, Snowflake applies the blocked IP address list first. https://docs.snowflake.com/en/user-guide/network-policies
Source: Adapted from community discussion — tidz
What triggers the automated maintenance of a table's clustering key after it has been defined?
Answer: D
For directory tables, what stage allows for automatic refreshing of metadata?
Answer: D
Which Snowflake object will consume credits during automatic background maintenance?
Answer: D
Which command is used to unload data from a Snowflake database table into one or more files in a Snowflake stage?
Answer: C
Keyboard:J Kmove between questionsA–Dselect an answerRshow or hide the answer← →change page
COF-C02 practice, question 1181. 1323 questions available.
Version 1.0.0. How we source questions