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

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

Question list
Search
Search
Open VPLUS File
Convert VPLUS to PDF

Related questions

A materialized view should be created when which of the following occurs? (Choose two.)
A sales table FCT_SALES has 100 million records. The following Query was executed SELECT COUNT (1) FROM FCT__SALES; How did Snowflake fulfill this query?
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?
Which minimum Snowflake edition allows for a dedicated metadata store?
Which of the following Snowflake features provide continuous data protection automatically? (Select TWO).
Which database objects can be shared with the Snowflake secure data sharing feature? (Choose two.)
What is the MINIMUM Snowflake edition required to use the periodic rekeying of micro-partitions?
What is a responsibility of Snowflake’s virtual warehouses?
Which TABLE function helps to convert semi-structured data to a relational representation?
How should a virtual warehouse be configured if a user wants to ensure that additional multi-clusters are resumed with no delay?

Question 81

Report
Export
Collapse

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

A.
Internal stages
A.
Internal stages
Answers
B.
Incremental backups
B.
Incremental backups
Answers
C.
Time Travel
C.
Time Travel
Answers
D.
Zero-copy clones
D.
Zero-copy clones
Answers
E.
Fail-safe
E.
Fail-safe
Answers
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

Question 82

Report
Export
Collapse

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

(Select TWO).

A.
The user has the appropriate privileges on the objects associated with the query
A.
The user has the appropriate privileges on the objects associated with the query
Answers
B.
Micro-partitions have been reclustered since the query was last run
B.
Micro-partitions have been reclustered since the query was last run
Answers
C.
The new query is run using the same virtual warehouse as the previous query
C.
The new query is run using the same virtual warehouse as the previous query
Answers
D.
The query includes a User Defined Function (UDF)
D.
The query includes a User Defined Function (UDF)
Answers
E.
The query has been run within 24 hours of the previously-run query
E.
The query has been run within 24 hours of the previously-run query
Answers
Suggested answer: A, E

Question 83

Report
Export
Collapse

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

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

Explanation:

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

Question 84

Report
Export
Collapse

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

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

Question 85

Report
Export
Collapse

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

A.
Data is hashed by the cluster key to facilitate fast searches for common data values
A.
Data is hashed by the cluster key to facilitate fast searches for common data values
Answers
B.
Larger micro-partitions are created for common data values to reduce the number of partitions that must be scanned
B.
Larger micro-partitions are created for common data values to reduce the number of partitions that must be scanned
Answers
C.
Smaller micro-partitions are created for common data values to allow for more parallelism
C.
Smaller micro-partitions are created for common data values to allow for more parallelism
Answers
D.
Data may be colocated by the cluster key within the micro-partitions to improve pruning performance
D.
Data may be colocated by the cluster key within the micro-partitions to improve pruning performance
Answers
Suggested answer: D

Question 86

Report
Export
Collapse

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

A.
Column-level security
A.
Column-level security
Answers
B.
SOC 2 type II certification
B.
SOC 2 type II certification
Answers
C.
Multi-factor Authentication (MFA)
C.
Multi-factor Authentication (MFA)
Answers
D.
Object-level access control
D.
Object-level access control
Answers
Suggested answer: A

Explanation:

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

Question 87

Report
Export
Collapse

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

A.
SCIM
A.
SCIM
Answers
B.
Federated authentication
B.
Federated authentication
Answers
C.
TLS 1.2
C.
TLS 1.2
Answers
D.
Key-pair authentication
D.
Key-pair authentication
Answers
E.
OAuth
E.
OAuth
Answers
F.
OCSP authentication
F.
OCSP authentication
Answers
Suggested answer: B, D, E

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?

A.
STATEMENT_TIMEOUT__IN__SECONDS
A.
STATEMENT_TIMEOUT__IN__SECONDS
Answers
B.
STATEMENT_QUEUED_TIMEOUT_IN_SECONDS
B.
STATEMENT_QUEUED_TIMEOUT_IN_SECONDS
Answers
C.
MAX_CONCURRENCY__LEVEL
C.
MAX_CONCURRENCY__LEVEL
Answers
D.
QUERY_TIMEOUT_IN_SECONDS
D.
QUERY_TIMEOUT_IN_SECONDS
Answers
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.

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).

A.
The table contains a column that has very low cardinality
A.
The table contains a column that has very low cardinality
Answers
B.
DML statements that are being issued against the table are blocked
B.
DML statements that are being issued against the table are blocked
Answers
C.
The table has a small number of micro-partitions
C.
The table has a small number of micro-partitions
Answers
D.
Queries on the table are running slower than expected
D.
Queries on the table are running slower than expected
Answers
E.
The clustering depth for the table is large
E.
The clustering depth for the table is large
Answers
Suggested answer: A, E

Question 90

Report
Export
Collapse

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

A.
Pipe
A.
Pipe
Answers
B.
External stage
B.
External stage
Answers
C.
Task
C.
Task
Answers
D.
Stream
D.
Stream
Answers
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

Total 330 questions
Go to page: of 33
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