ExamGecko
Search Search Login
Home Home / Snowflake / COF-C02

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

Question list
Search
Search
Open VPLUS File
Convert VPLUS to PDF

Related questions

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?
Which minimum Snowflake edition allows for a dedicated metadata store?
How can the outer array structure of a semi-structured file be removed?
Who can access the data published in a Data Exchange?
What are characteristics of the ownership privilege when it is granted on a regular Snowflake schema? (Select TWO).
What virtual warehouse configuration should be used when processing a large number of complex queries?
While preparing to unload data in Snowflake, the file format option can be specified in which commands? (Select TWO).
Which Query Profile metrics will provide information that can be used to improve query performance? (Select TWO).
How does the search optimization service improve query performance?
When unloading data, which combination of parameters should be used to differentiate between empty strings and NULL values? (Select TWO).

Question 161

Report
Export
Collapse

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

A.
The user who created the object
A.
The user who created the object
Answers
B.
The SYSADMIN role
B.
The SYSADMIN role
Answers
C.
Ownership depends on the type of object
C.
Ownership depends on the type of object
Answers
D.
The role used to create the object
D.
The role used to create the object
Answers
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

Question 162

Report
Export
Collapse

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

A.
Standard
A.
Standard
Answers
B.
Enterprise
B.
Enterprise
Answers
C.
Business Critical
C.
Business Critical
Answers
D.
Virtual Private Snowflake (VPC)
D.
Virtual Private Snowflake (VPC)
Answers
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.

Question 163

Report
Export
Collapse

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

A.
Compute resources
A.
Compute resources
Answers
B.
Query execution
B.
Query execution
Answers
C.
Authentication
C.
Authentication
Answers
D.
Data storage
D.
Data storage
Answers
E.
Metadata
E.
Metadata
Answers
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.

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?

A.
Row access policies
A.
Row access policies
Answers
B.
Data masking policies
B.
Data masking policies
Answers
C.
Data encryption
C.
Data encryption
Answers
D.
Role based access control
D.
Role based access control
Answers
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.

Question 165

Report
Export
Collapse

Which of the following accurately describes shares?

A.
Tables, secure views, and secure UDFs can be shared
A.
Tables, secure views, and secure UDFs can be shared
Answers
B.
Shares can be shared
B.
Shares can be shared
Answers
C.
Data consumers can clone a new table from a share
C.
Data consumers can clone a new table from a share
Answers
D.
Access to a share cannot be revoked once granted
D.
Access to a share cannot be revoked once granted
Answers
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

Question 166

Report
Export
Collapse

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

A.
Ensure all ACCOUNTADMIN roles use Multi-factor Authentication (MFA).
A.
Ensure all ACCOUNTADMIN roles use Multi-factor Authentication (MFA).
Answers
B.
All users granted ACCOUNTADMIN role must be owned by the ACCOUNTADMIN role.
B.
All users granted ACCOUNTADMIN role must be owned by the ACCOUNTADMIN role.
Answers
C.
The ACCOUNTADMIN role must be granted to only one user.
C.
The ACCOUNTADMIN role must be granted to only one user.
Answers
D.
Assign the ACCOUNTADMIN role to at least two users, but as few as possible.
D.
Assign the ACCOUNTADMIN role to at least two users, but as few as possible.
Answers
E.
All users granted ACCOUNTADMIN role must also be granted SECURITYADMIN role.
E.
All users granted ACCOUNTADMIN role must also be granted SECURITYADMIN role.
Answers
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.

Question 167

Report
Export
Collapse

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

A.
Standard
A.
Standard
Answers
B.
Enterprise
B.
Enterprise
Answers
C.
Business Critical
C.
Business Critical
Answers
D.
Virtual Private Snowflake
D.
Virtual Private Snowflake
Answers
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

Question 168

Report
Export
Collapse

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

A.
1 day
A.
1 day
Answers
B.
7 days
B.
7 days
Answers
C.
12 hours
C.
12 hours
Answers
D.
0 days
D.
0 days
Answers
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

Question 169

Report
Export
Collapse

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

A.
Data is live, ready-to-query, and can be personalized.
A.
Data is live, ready-to-query, and can be personalized.
Answers
B.
Data needs to be loaded into a cloud provider as a consumer account.
B.
Data needs to be loaded into a cloud provider as a consumer account.
Answers
C.
Data is not available for copying or moving to an individual Snowflake account.
C.
Data is not available for copying or moving to an individual Snowflake account.
Answers
D.
Data is available without copying or moving.
D.
Data is available without copying or moving.
Answers
E.
Data transformations are required when combining Data Marketplace datasets with existing data in Snowflake.
E.
Data transformations are required when combining Data Marketplace datasets with existing data in Snowflake.
Answers
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

Question 170

Report
Export
Collapse

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

A.
Whether or not it is also a secure view
A.
Whether or not it is also a secure view
Answers
B.
How often the underlying base table is queried
B.
How often the underlying base table is queried
Answers
C.
How often the base table changes
C.
How often the base table changes
Answers
D.
Whether the materialized view has a cluster key defined
D.
Whether the materialized view has a cluster key defined
Answers
E.
How often the materialized view is queried
E.
How often the materialized view is queried
Answers
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

Total 716 questions
Go to page: of 72
ExamGecko

Copyright @2023 ExamGecko | All right reserved

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