ExamGecko
Login
Home / Snowflake / COF-R02 / List of questions
Ask Question

Snowflake COF-R02 Practice Test - Questions Answers, Page 9

List of questions

Question 81

Report Export Collapse

Which of the following Snowflake features provide continuous data protection automatically? (Select TWO).

Internal stages
Internal stages
Incremental backups
Incremental backups
Time Travel
Time Travel
Zero-copy clones
Zero-copy clones
Fail-safe
Fail-safe
Suggested answer: C, E
Explanation:

Time travel and fail safe are the two continuous data protection features support the recovery of data automatically.

Snowflake provides powerful CDP features for ensuring the maintenance and availability of your historical data (i.e. data that has been changed or deleted):

Querying, cloning, and restoring historical data in tables, schemas, and databases for up to 90 days through Snowflake Time Travel.

Disaster recovery of historical data (by Snowflake) through Snowflake Fail-safe.

https://docs.snowflake.com/en/user-guide/data-availability.html

asked 23/09/2024
Ervin Loong
47 questions

Question 82

Report Export Collapse

Which of the following conditions must be met in order to return results from the results cache?

(Select TWO).

The user has the appropriate privileges on the objects associated with the query
The user has the appropriate privileges on the objects associated with the query
Micro-partitions have been reclustered since the query was last run
Micro-partitions have been reclustered since the query was last run
The new query is run using the same virtual warehouse as the previous query
The new query is run using the same virtual warehouse as the previous query
The query includes a User Defined Function (UDF)
The query includes a User Defined Function (UDF)
The query has been run within 24 hours of the previously-run query
The query has been run within 24 hours of the previously-run query
Suggested answer: A, E
asked 23/09/2024
Zied Nassr
40 questions

Question 83

Report Export Collapse

Which of the following are benefits of micro-partitioning? (Select TWO)

Micro-partitions cannot overlap in their range of values
Micro-partitions cannot overlap in their range of values
Micro-partitions are immutable objects that support the use of Time Travel.
Micro-partitions are immutable objects that support the use of Time Travel.
Micro-partitions can reduce the amount of I/O from object storage to virtual warehouses
Micro-partitions can reduce the amount of I/O from object storage to virtual warehouses
Rows are automatically stored in sorted order within micro-partitions
Rows are automatically stored in sorted order within micro-partitions
Micro-partitions can be defined on a schema-by-schema basis
Micro-partitions can be defined on a schema-by-schema basis
Suggested answer: A, D
Explanation:

https://docs.snowflake.com/en/user-guide/tables-clustering-micropartitions.html

asked 23/09/2024
Sanjay R Khiani
47 questions

Question 84

Report Export Collapse

What is the minimum Snowflake edition required to create a materialized view?

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

Materialized views require Enterprise Edition. To inquire about upgrading, please contact Snowflake Support

https://docs.snowflake.com/en/sql-reference/sql/create-materializedview.html#:~:text=Materialized%20views%20require%20Enterprise%20Edition,upgrading%2C%20please%20contact%20Snowflake%20Support.

asked 23/09/2024
Paul Pinero
36 questions

Question 85

Report Export Collapse

What happens to the underlying table data when a CLUSTER BY clause is added to a Snowflake table?

Data is hashed by the cluster key to facilitate fast searches for common data values
Data is hashed by the cluster key to facilitate fast searches for common data values
Larger micro-partitions are created for common data values to reduce the number of partitions that must be scanned
Larger micro-partitions are created for common data values to reduce the number of partitions that must be scanned
Smaller micro-partitions are created for common data values to allow for more parallelism
Smaller micro-partitions are created for common data values to allow for more parallelism
Data may be colocated by the cluster key within the micro-partitions to improve pruning performance
Data may be colocated by the cluster key within the micro-partitions to improve pruning performance
Suggested answer: D
asked 23/09/2024
Peter Keijer
42 questions

Question 86

Report Export Collapse

Which feature is only available in the Enterprise or higher editions of Snowflake?

Column-level security
Column-level security
SOC 2 type II certification
SOC 2 type II certification
Multi-factor Authentication (MFA)
Multi-factor Authentication (MFA)
Object-level access control
Object-level access control
Suggested answer: A
Explanation:

https://docs.snowflake.com/en/user-guide/intro-editions.html

asked 23/09/2024
Nuno Silva
41 questions

Question 87

Report Export Collapse

Which of the following are valid methods for authenticating users for access into Snowflake? (Select THREE)

SCIM
SCIM
Federated authentication
Federated authentication
TLS 1.2
TLS 1.2
Key-pair authentication
Key-pair authentication
OAuth
OAuth
OCSP authentication
OCSP authentication
Suggested answer: B, D, E
asked 23/09/2024
Jorge Pinto
32 questions

Question 88

Report Export Collapse

During periods of warehouse contention which parameter controls the maximum length of time a warehouse will hold a query for processing?

STATEMENT_TIMEOUT__IN__SECONDS
STATEMENT_TIMEOUT__IN__SECONDS
STATEMENT_QUEUED_TIMEOUT_IN_SECONDS
STATEMENT_QUEUED_TIMEOUT_IN_SECONDS
MAX_CONCURRENCY__LEVEL
MAX_CONCURRENCY__LEVEL
QUERY_TIMEOUT_IN_SECONDS
QUERY_TIMEOUT_IN_SECONDS
Suggested answer: B
Explanation:

The parameter STATEMENT_QUEUED_TIMEOUT_IN_SECONDS sets the limit for a query to wait in the queue in order to get its chance of running on the warehouse. The query will quit after reaching this limit. By default, the value of this parameter is 0 which mean the queries will wait indefinitely in the waiting queue

https://community.snowflake.com/s/article/Warehouse-Concurrency-and-Statement-Timeout-Parameters#:~:text=The%20parameter%20STATEMENT_QUEUED_TIMEOUT_IN_SECONDS%20sets%20the,indefinitely%20in%20the%20waiting%20queue.

asked 23/09/2024
Vicky Mukhy
37 questions

Question 89

Report Export Collapse

Which of the following indicates that it may be appropriate to use a clustering key for a table? (Select TWO).

The table contains a column that has very low cardinality
The table contains a column that has very low cardinality
DML statements that are being issued against the table are blocked
DML statements that are being issued against the table are blocked
The table has a small number of micro-partitions
The table has a small number of micro-partitions
Queries on the table are running slower than expected
Queries on the table are running slower than expected
The clustering depth for the table is large
The clustering depth for the table is large
Suggested answer: A, E
asked 23/09/2024
Pavel Tylich
43 questions

Question 90

Report Export Collapse

Which Snowflake object enables loading data from files as soon as they are available in a cloud storage location?

Pipe
Pipe
External stage
External stage
Task
Task
Stream
Stream
Suggested answer: A
Explanation:

Snowpipe enables loading data from files as soon as they’re available in a stage. This means you can load data from files in micro-batches, making it available to users within minutes, rather than manually executing COPY statements on a schedule to load larger batches.

https://docs.snowflake.com/en/user-guide/data-load-snowpipe-intro.html

asked 23/09/2024
Gift Thanyane
37 questions
Total 330 questions
Go to page: of 33
Open VPLUS File
Convert VPLUS to PDF

Related questions

A materialized view should be created when which of the following occurs? (Choose two.)
What is the default character set used when loading CSV files into Snowflake?
Which query profile statistics help determine if efficient pruning is occurring? (Choose two.)
A virtual warehouse's auto-suspend and auto-resume settings apply to which of the following?
Which of the following terms best describes Snowflake’s database architecture?
Which privilege is required for a role to be able to resume a suspended warehouse if auto-resume is not enabled?
What is the maximum total Continuous Data Protection (CDP) charges incurred for a temporary table?
Which of the following are best practices for loading data into Snowflake? (Choose three.)
A company's security audit requires generating a report listing all Snowflake logins (e.g.. date and user) within the last 90 days. Which of the following statements will return the required information?
What are the three layers that make up Snowflake’s architecture? Choose 3 answer