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

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

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.)
Which minimum Snowflake edition allows for a dedicated metadata store?
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?
Which of the following Snowflake features provide continuous data protection automatically? (Select TWO).
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 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?
Which SQL command can be used to see the CREATE definition of a masking policy?
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?

Question 141

Report
Export
Collapse

In which scenarios would a user have to pay Cloud Services costs? (Select TWO).

A.
Compute Credits = 50 Credits Cloud Services = 10
A.
Compute Credits = 50 Credits Cloud Services = 10
Answers
B.
Compute Credits = 80 Credits Cloud Services = 5
B.
Compute Credits = 80 Credits Cloud Services = 5
Answers
C.
Compute Credits = 10 Credits Cloud Services = 9
C.
Compute Credits = 10 Credits Cloud Services = 9
Answers
D.
Compute Credits = 120 Credits Cloud Services = 10
D.
Compute Credits = 120 Credits Cloud Services = 10
Answers
E.
Compute Credits = 200 Credits Cloud Services = 26
E.
Compute Credits = 200 Credits Cloud Services = 26
Answers
Suggested answer: B, D

Question 142

Report
Export
Collapse

What transformations are supported in a CREATE PIPE ... AS COPY ... FROM (....) statement? (Select TWO.)

A.
Data can be filtered by an optional where clause
A.
Data can be filtered by an optional where clause
Answers
B.
Incoming data can be joined with other tables
B.
Incoming data can be joined with other tables
Answers
C.
Columns can be reordered
C.
Columns can be reordered
Answers
D.
Columns can be omitted
D.
Columns can be omitted
Answers
E.
Row level access can be defined
E.
Row level access can be defined
Answers
Suggested answer: C, D

Question 143

Report
Export
Collapse

What is a responsibility of Snowflake's virtual warehouses?

A.
Infrastructure management
A.
Infrastructure management
Answers
B.
Metadata management
B.
Metadata management
Answers
C.
Query execution
C.
Query execution
Answers
D.
Query parsing and optimization
D.
Query parsing and optimization
Answers
E.
Management of the storage layer
E.
Management of the storage layer
Answers
Suggested answer: C

Question 144

Report
Export
Collapse

Which of the following compute resources or features are managed by Snowflake? (Select TWO).

A.
Execute a COPY command
A.
Execute a COPY command
Answers
B.
Updating data
B.
Updating data
Answers
C.
Snowpipe
C.
Snowpipe
Answers
D.
AUTOMATIC__CLUSTERING
D.
AUTOMATIC__CLUSTERING
Answers
E.
Scaling up a warehouse
E.
Scaling up a warehouse
Answers
Suggested answer: A, D

Question 145

Report
Export
Collapse

What happens when a virtual warehouse is resized?

A.
When increasing the size of an active warehouse the compute resource for all running and queued queries on the warehouse are affected
A.
When increasing the size of an active warehouse the compute resource for all running and queued queries on the warehouse are affected
Answers
B.
When reducing the size of a warehouse the compute resources are removed only when they are no longer being used to execute any current statements.
B.
When reducing the size of a warehouse the compute resources are removed only when they are no longer being used to execute any current statements.
Answers
C.
The warehouse will be suspended while the new compute resource is provisioned and will resume automatically once provisioning is complete.
C.
The warehouse will be suspended while the new compute resource is provisioned and will resume automatically once provisioning is complete.
Answers
D.
Users who are trying to use the warehouse will receive an error message until the resizing is complete
D.
Users who are trying to use the warehouse will receive an error message until the resizing is complete
Answers
Suggested answer: B

Question 146

Report
Export
Collapse

A developer is granted ownership of a table that has a masking policy. The developer's role is not able to see the masked dat a. Will the developer be able to modify the table to read the masked data?

A.
Yes, because a table owner has full control and can unset masking policies.
A.
Yes, because a table owner has full control and can unset masking policies.
Answers
B.
Yes, because masking policies only apply to cloned tables.
B.
Yes, because masking policies only apply to cloned tables.
Answers
C.
No, because masking policies must always reference specific access roles.
C.
No, because masking policies must always reference specific access roles.
Answers
D.
No, because ownership of a table does not include the ability to change masking policies
D.
No, because ownership of a table does not include the ability to change masking policies
Answers
Suggested answer: A

Question 147

Report
Export
Collapse

Which of the following describes how clustering keys work in Snowflake?

A.
Clustering keys update the micro-partitions in place with a full sort, and impact the DML operations.
A.
Clustering keys update the micro-partitions in place with a full sort, and impact the DML operations.
Answers
B.
Clustering keys sort the designated columns over time, without blocking DML operations
B.
Clustering keys sort the designated columns over time, without blocking DML operations
Answers
C.
Clustering keys create a distributed, parallel data structure of pointers to a table's rows and columns
C.
Clustering keys create a distributed, parallel data structure of pointers to a table's rows and columns
Answers
D.
Clustering keys establish a hashed key on each node of a virtual warehouse to optimize joins at run-time
D.
Clustering keys establish a hashed key on each node of a virtual warehouse to optimize joins at run-time
Answers
Suggested answer: B

Question 148

Report
Export
Collapse

What is a machine learning and data science partner within the Snowflake Partner Ecosystem?

A.
Informatica
A.
Informatica
Answers
B.
Power Bl
B.
Power Bl
Answers
C.
Adobe
C.
Adobe
Answers
D.
Data Robot
D.
Data Robot
Answers
Suggested answer: D

Explanation:

https://docs.snowflake.com/en/user-guide/ecosystem-analytics.html

Question 149

Report
Export
Collapse

Which of the following is a valid source for an external stage when the Snowflake account is located on Microsoft Azure?

A.
An FTP server with TLS encryption
A.
An FTP server with TLS encryption
Answers
B.
An HTTPS server with WebDAV
B.
An HTTPS server with WebDAV
Answers
C.
A Google Cloud storage bucket
C.
A Google Cloud storage bucket
Answers
D.
A Windows server file share on Azure
D.
A Windows server file share on Azure
Answers
Suggested answer: C

Question 150

Report
Export
Collapse

Which data type can be used to store geospatial data in Snowflake?

A.
Variant
A.
Variant
Answers
B.
Object
B.
Object
Answers
C.
Geometry
C.
Geometry
Answers
D.
Geography
D.
Geography
Answers
Suggested answer: D

Explanation:

https://docs.snowflake.com/en/sql-reference/data-typesgeospatial.html#:~:text=have%20SRID%3D4326.-,Geospatial%20Object%20Types,Point

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