ExamGecko
Home / Snowflake / COF-C02
Ask Question

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

Question list
Search

Question 231

Report
Export
Collapse

Which of the following are characteristics of security in Snowflake?

Account and user authentication is only available with the Snowflake Business Critical edition.
Account and user authentication is only available with the Snowflake Business Critical edition.
Support for HIPAA and GDPR compliance is available for UI Snowflake editions.
Support for HIPAA and GDPR compliance is available for UI Snowflake editions.
Periodic rekeying of encrypted data is available with the Snowflake Enterprise edition and higher
Periodic rekeying of encrypted data is available with the Snowflake Enterprise edition and higher
Private communication to internal stages is allowed in the Snowflake Enterprise edition and higher.
Private communication to internal stages is allowed in the Snowflake Enterprise edition and higher.
Suggested answer: C

Explanation:

One of the security features of Snowflake includes the periodic rekeying of encrypted data, which is available with the Snowflake Enterprise edition and higher2. This ensures that the encryption keys are rotated regularly to maintain a high level of security. References: [COF-C02] SnowPro Core Certification Exam Study Guide

asked 23/09/2024
Alemu, Fissha
38 questions

Question 232

Report
Export
Collapse

User INQUISITIVE_PERSON has been granted the role DATA_SCIENCE. The role DATA_SCIENCE has privileges OWNERSHIP on the schema MARKETING of the database ANALYTICS_DW.

Which command will show all privileges granted to that schema?

SHOW GRANTS ON ROLE DATA_SCIENCE
SHOW GRANTS ON ROLE DATA_SCIENCE
SHOW GRANTS ON SCHEMA ANALYTICS_DW.MARKETING
SHOW GRANTS ON SCHEMA ANALYTICS_DW.MARKETING
SHOW GRANTS TO USER INQUISITIVE_PERSON
SHOW GRANTS TO USER INQUISITIVE_PERSON
SHOW GRANTS OF ROLE DATA_SCIENCE
SHOW GRANTS OF ROLE DATA_SCIENCE
Suggested answer: B

Explanation:

To show all privileges granted to a specific schema, the commandSHOW GRANTS ON SCHEMA <schema_name>should be used3. In this case, it would beSHOW GRANTS ON SCHEMA ANALYTICS_DW.MARKETING. References: [COF-C02] SnowPro Core Certification Exam Study Guide

asked 23/09/2024
gdgd gdgd
25 questions

Question 233

Report
Export
Collapse

The bulk data load history that is available upon completion of the COPY statement is stored where and for how long?

In the metadata of the target table for 14 days
In the metadata of the target table for 14 days
In the metadata of the pipe for 14 days
In the metadata of the pipe for 14 days
In the metadata of the target table for 64 days
In the metadata of the target table for 64 days
In the metadata of the pipe for 64 days
In the metadata of the pipe for 64 days
Suggested answer: D

Explanation:

The bulk data load history available after a COPY statement is stored in the metadata of the pipe and is retained for 64 days1.

asked 23/09/2024
Colin Huisman
36 questions

Question 234

Report
Export
Collapse

For non-materialized views, what column in Information Schema and Account Usage identifies whether a view is secure or not?

CHECK_OPTION
CHECK_OPTION
IS_SECURE
IS_SECURE
IS_UPDATEABLE
IS_UPDATEABLE
TABLE_NAME
TABLE_NAME
Suggested answer: B

Explanation:

In the Information Schema and Account Usage, the column that identifies whether a view is secure or not isIS_SECURE2.

asked 23/09/2024
Daniel Yontz
44 questions

Question 235

Report
Export
Collapse

A company needs to read multiple terabytes of data for an initial load as part of a Snowflake migration. The company can control the number and size of CSV extract files.

How does Snowflake recommend maximizing the load performance?

Use auto-ingest Snowpipes to load large files in a serverless model.
Use auto-ingest Snowpipes to load large files in a serverless model.
Produce the largest files possible, reducing the overall number of files to process.
Produce the largest files possible, reducing the overall number of files to process.
Produce a larger number of smaller files and process the ingestion with size Small virtual warehouses.
Produce a larger number of smaller files and process the ingestion with size Small virtual warehouses.
Use an external tool to issue batched row-by-row inserts within BEGIN TRANSACTION and COMMIT commands.
Use an external tool to issue batched row-by-row inserts within BEGIN TRANSACTION and COMMIT commands.
Suggested answer: B

Explanation:

Snowflake's documentation recommends producing the largest files possible for data loading, as larger files reduce the number of files to process and the overhead associated with handling many small files.This approach can maximize the load performance by leveraging Snowflake's ability to ingest large files efficiently1.References:[COF-C02] SnowPro Core Certification Exam Study Guide

asked 23/09/2024
Arash Rind
42 questions

Question 236

Report
Export
Collapse

If a Snowflake user decides a table should be clustered, what should be used as the cluster key?

The columns that are queried in the select clause.
The columns that are queried in the select clause.
The columns with very high cardinality.
The columns with very high cardinality.
The columns with many different values.
The columns with many different values.
The columns most actively used in the select filters.
The columns most actively used in the select filters.
Suggested answer: D

Explanation:

When deciding on a clustering key for a table, Snowflake recommends using the columns that are most actively used in the select filters.This is because clustering by these columns can improve the performance of queries that filter on these values, leading to more efficient scans and better overall query performance2.References:[COF-C02] SnowPro Core Certification Exam Study Guide

asked 23/09/2024
Orenthial Johnson
31 questions

Question 237

Report
Export
Collapse

What is the MINIMUM Snowflake edition required to use the periodic rekeying of micro-partitions?

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

Explanation:

Periodic rekeying of micro-partitions is a feature that requires the Enterprise Edition of Snowflake or higher.This feature is part of Snowflake's comprehensive approach to encryption key management, ensuring data security through regular rekeying1.References:[COF-C02] SnowPro Core Certification Exam Study Guide

asked 23/09/2024
Armands Vestmanis
45 questions

Question 238

Report
Export
Collapse

What privilege should a user be granted to change permissions for new objects in a managed access schema?

Grant the OWNERSHIP privilege on the schema.
Grant the OWNERSHIP privilege on the schema.
Grant the OWNERSHIP privilege on the database.
Grant the OWNERSHIP privilege on the database.
Grant the MANAGE GRANTS global privilege.
Grant the MANAGE GRANTS global privilege.
Grant ALL privileges on the schema.
Grant ALL privileges on the schema.
Suggested answer: C

Explanation:

To change permissions for new objects in a managed access schema, a user should be granted the MANAGE GRANTS global privilege.This privilege allows the user to manage access control through grants on all securable objects within Snowflake2.References:[COF-C02] SnowPro Core Certification Exam Study Guide

asked 23/09/2024
Preety Koul
39 questions

Question 239

Report
Export
Collapse

A materialized view should be created when which of the following occurs? (Choose two.)

There is minimal cost associated with running the query.
There is minimal cost associated with running the query.
The query consumes many compute resources every time it runs.
The query consumes many compute resources every time it runs.
The base table gets updated frequently.
The base table gets updated frequently.
The query is highly optimized and does not consume many compute resources.
The query is highly optimized and does not consume many compute resources.
The results of the query do not change often and are used frequently.
The results of the query do not change often and are used frequently.
Suggested answer: B, E

Explanation:

A materialized view is beneficial when the query consumes many compute resources every time it runs (B), and when the results of the query do not change often and are used frequently (E).This is because materialized views store pre-computed data, which can speed up query performance for workloads that are run frequently or are complex

asked 23/09/2024
Reneus Martini
33 questions

Question 240

Report
Export
Collapse

Which privilege must be granted to a share to allow secure views the ability to reference data in multiple databases?

CREATE_SHARE on the account
CREATE_SHARE on the account
SHARE on databases and schemas
SHARE on databases and schemas
SELECT on tables used by the secure view
SELECT on tables used by the secure view
REFERENCE_USAGE on databases
REFERENCE_USAGE on databases
Suggested answer: D

Explanation:

To allow secure views the ability to reference data in multiple databases, the REFERENCE_USAGE privilege must be granted on each database that contains objects referenced by the secure view2. This privilege is necessary before granting the SELECT privilege on a secure view to a share.

asked 23/09/2024
NAKAYAMA HIROYUKI
33 questions
Total 716 questions
Go to page: of 72