ExamGecko
Login
Home / Snowflake / COF-C02
Ask Question

Snowflake COF-C02 Practice Test - Questions Answers, Page 17

Question list
Search
Open VPLUS File
Convert VPLUS to PDF

Related questions

How can the outer array structure of a semi-structured file be removed?
While preparing to unload data in Snowflake, the file format option can be specified in which commands? (Select TWO).
How can a data provider validate that a secure view is configured to display only the data the provider wishes to expose?
What are characteristics of the ownership privilege when it is granted on a regular Snowflake schema? (Select TWO).
A query containing a WHERE clause is running longer than expected. The Query Profile shows that all micro-partitions being scanned How should this query be optimized?
During periods of warehouse contention which parameter controls the maximum length of time a warehouse will hold a query for processing?
How does the search optimization service improve query performance?
What is a key feature of Snowflake architecture?
Which Snowflake object enables loading data from files as soon as they are available in a cloud storage location?
Which of the following indicates that it may be appropriate to use a clustering key for a table? (Select TWO).

Question 161

Report
Export
Collapse

In the Snowflake access control model, which entity owns an object by default?

The user who created the object
The user who created the object
The SYSADMIN role
The SYSADMIN role
Ownership depends on the type of object
Ownership depends on the type of object
The role used to create the object
The role used to create the object
Suggested answer: D

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

asked 23/09/2024
Jaroslaw Walaszek
37 questions

Question 162

Report
Export
Collapse

What is the minimum Snowflake edition required to use Dynamic Data Masking?

Standard
Standard
Enterprise
Enterprise
Business Critical
Business Critical
Virtual Private Snowflake (VPC)
Virtual Private Snowflake (VPC)
Suggested answer: B

Explanation:

The minimum Snowflake edition required to use Dynamic Data Masking is the Enterprise edition.This feature is not available in the Standard edition2.

asked 23/09/2024
Juliana Correa Zapat
26 questions

Question 163

Report
Export
Collapse

Which services does the Snowflake Cloud Services layer manage? (Choose two.)

Compute resources
Compute resources
Query execution
Query execution
Authentication
Authentication
Data storage
Data storage
Metadata
Metadata
Suggested answer: C, E

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.

asked 23/09/2024
Tim Pass
38 questions

Question 164

Report
Export
Collapse

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?

Row access policies
Row access policies
Data masking policies
Data masking policies
Data encryption
Data encryption
Role based access control
Role based access control
Suggested answer: B

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.

asked 23/09/2024
Emily Mangrum
34 questions

Question 165

Report
Export
Collapse

Which of the following accurately describes shares?

Tables, secure views, and secure UDFs can be shared
Tables, secure views, and secure UDFs can be shared
Shares can be shared
Shares can be shared
Data consumers can clone a new table from a share
Data consumers can clone a new table from a share
Access to a share cannot be revoked once granted
Access to a share cannot be revoked once granted
Suggested answer: A

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

asked 23/09/2024
tony Gentry
42 questions

Question 166

Report
Export
Collapse

What are best practice recommendations for using the ACCOUNTADMIN system-defined role in Snowflake? (Choose two.)

Ensure all ACCOUNTADMIN roles use Multi-factor Authentication (MFA).
Ensure all ACCOUNTADMIN roles use Multi-factor Authentication (MFA).
All users granted ACCOUNTADMIN role must be owned by the ACCOUNTADMIN role.
All users granted ACCOUNTADMIN role must be owned by the ACCOUNTADMIN role.
The ACCOUNTADMIN role must be granted to only one user.
The ACCOUNTADMIN role must be granted to only one user.
Assign the ACCOUNTADMIN role to at least two users, but as few as possible.
Assign the ACCOUNTADMIN role to at least two users, but as few as possible.
All users granted ACCOUNTADMIN role must also be granted SECURITYADMIN role.
All users granted ACCOUNTADMIN role must also be granted SECURITYADMIN role.
Suggested answer: A, D

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.

asked 23/09/2024
Tim Pass
38 questions

Question 167

Report
Export
Collapse

What is the minimum Snowflake edition required for row level security?

Standard
Standard
Enterprise
Enterprise
Business Critical
Business Critical
Virtual Private Snowflake
Virtual Private Snowflake
Suggested answer: B

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

asked 23/09/2024
Web Administrator
43 questions

Question 168

Report
Export
Collapse

The is the minimum Fail-safe retention time period for transient tables?

1 day
1 day
7 days
7 days
12 hours
12 hours
0 days
0 days
Suggested answer: D

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

asked 23/09/2024
Nardos Tadele
30 questions

Question 169

Report
Export
Collapse

Which statements are correct concerning the leveraging of third-party data from the Snowflake Data Marketplace? (Choose two.)

Data is live, ready-to-query, and can be personalized.
Data is live, ready-to-query, and can be personalized.
Data needs to be loaded into a cloud provider as a consumer account.
Data needs to be loaded into a cloud provider as a consumer account.
Data is not available for copying or moving to an individual Snowflake account.
Data is not available for copying or moving to an individual Snowflake account.
Data is available without copying or moving.
Data is available without copying or moving.
Data transformations are required when combining Data Marketplace datasets with existing data in Snowflake.
Data transformations are required when combining Data Marketplace datasets with existing data in Snowflake.
Suggested answer: A, D

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

asked 23/09/2024
Brandon Garner
27 questions

Question 170

Report
Export
Collapse

What impacts the credit consumption of maintaining a materialized view? (Choose two.)

Whether or not it is also a secure view
Whether or not it is also a secure view
How often the underlying base table is queried
How often the underlying base table is queried
How often the base table changes
How often the base table changes
Whether the materialized view has a cluster key defined
Whether the materialized view has a cluster key defined
How often the materialized view is queried
How often the materialized view is queried
Suggested answer: C, D

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

asked 23/09/2024
AXEL AXELOPOULOS
41 questions
Total 716 questions
Go to page: of 72

Copyright @2023 ExamGecko | All right reserved

Mail us: [email protected]
About us
Contact us
Convert VPLUS to PDF
Open VPLUS files Easily and Quickly
Privacy policy
Terms
Disclaimer
Refund policy
Copyright
Twitter X
Facebook
Medium