Snowflake COF-C02 Practice Test - Questions Answers, Page 17
List of questions
Related questions
Question 161

In the Snowflake access control model, which entity owns an object by default?
Explanation:
In Snowflake's access control model, the default owner of an object is the role that was used to create the object.This role has the OWNERSHIP privilege on the object and can grant access to other roles1
Question 162

What is the minimum Snowflake edition required to use Dynamic Data Masking?
Explanation:
The minimum Snowflake edition required to use Dynamic Data Masking is the Enterprise edition.This feature is not available in the Standard edition2.
Question 163

Which services does the Snowflake Cloud Services layer manage? (Choose two.)
Explanation:
The Snowflake Cloud Services layer manages various services, including authentication and metadata management.This layer ties together all the different components of Snowflake to process user requests, manage sessions, and control access3.
Question 164

A company needs to allow some users to see Personally Identifiable Information (PII) while limiting other users from seeing the full value of the PII.
Which Snowflake feature will support this?
Explanation:
Data masking policies in Snowflake allow for the obfuscation of specific data within a field, enabling some users to see the full data while limiting others.This feature is particularly useful for handling PII, ensuring that sensitive information is only visible to authorized users1.
Question 165

Which of the following accurately describes shares?
Explanation:
Shares in Snowflake are named objects that encapsulate all the information required to share databases, schemas, tables, secure views, and secure UDFs.These objects can be added to a share by granting privileges on them to the share via a database role
Question 166

What are best practice recommendations for using the ACCOUNTADMIN system-defined role in Snowflake? (Choose two.)
Explanation:
Best practices for using the ACCOUNTADMIN role include ensuring that all users with this role use Multi-factor Authentication (MFA) for added security.Additionally, it is recommended to assign the ACCOUNTADMIN role to at least two users to avoid delays in case of password recovery issues, but to as few users as possible to maintain strict control over account-level operations4.
Question 167

What is the minimum Snowflake edition required for row level security?
Explanation:
Row level security in Snowflake is available starting with the Enterprise edition.This feature allows for the creation of row access policies that can control access to data at the row level within tables and views
Question 168

The is the minimum Fail-safe retention time period for transient tables?
Explanation:
Transient tables in Snowflake have a minimum Fail-safe retention time period of 0 days.This means that once the Time Travel retention period ends, there is no additional Fail-safe period for transient tables
Question 169

Which statements are correct concerning the leveraging of third-party data from the Snowflake Data Marketplace? (Choose two.)
Explanation:
When leveraging third-party data from the Snowflake Data Marketplace, the data is live, ready-to-query, and can be personalized.Additionally, the data is available without the need for copying or moving it to an individual Snowflake account, allowing for seamless integration with existing data
Question 170

What impacts the credit consumption of maintaining a materialized view? (Choose two.)
Explanation:
The credit consumption for maintaining a materialized view is impacted by how often the base table changes and whether the materialized view has a cluster key defined (D). Changes to the base table can trigger a refresh of the materialized view, consuming credits. Additionally, having a cluster key defined can optimize the performance and credit usage during the materialized view's maintenance.References:SnowPro Core Certification materialized view credit consumption
Question