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

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

List of questions

Question 141

Report Export Collapse

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

Compute Credits = 50 Credits Cloud Services = 10
Compute Credits = 50 Credits Cloud Services = 10
Compute Credits = 80 Credits Cloud Services = 5
Compute Credits = 80 Credits Cloud Services = 5
Compute Credits = 10 Credits Cloud Services = 9
Compute Credits = 10 Credits Cloud Services = 9
Compute Credits = 120 Credits Cloud Services = 10
Compute Credits = 120 Credits Cloud Services = 10
Compute Credits = 200 Credits Cloud Services = 26
Compute Credits = 200 Credits Cloud Services = 26
Suggested answer: B, D
asked 23/09/2024
Nisanka Mandara
43 questions

Question 142

Report Export Collapse

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

Data can be filtered by an optional where clause
Data can be filtered by an optional where clause
Incoming data can be joined with other tables
Incoming data can be joined with other tables
Columns can be reordered
Columns can be reordered
Columns can be omitted
Columns can be omitted
Row level access can be defined
Row level access can be defined
Suggested answer: C, D
asked 23/09/2024
Nicolas GARCIA
38 questions

Question 143

Report Export Collapse

What is a responsibility of Snowflake's virtual warehouses?

Infrastructure management
Infrastructure management
Metadata management
Metadata management
Query execution
Query execution
Query parsing and optimization
Query parsing and optimization
Management of the storage layer
Management of the storage layer
Suggested answer: C
asked 23/09/2024
István Balla
43 questions

Question 144

Report Export Collapse

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

Execute a COPY command
Execute a COPY command
Updating data
Updating data
Snowpipe
Snowpipe
AUTOMATIC__CLUSTERING
AUTOMATIC__CLUSTERING
Scaling up a warehouse
Scaling up a warehouse
Suggested answer: A, D
asked 23/09/2024
DIPESH JAISWAL
39 questions

Question 145

Report Export Collapse

What happens when a virtual warehouse is resized?

When increasing the size of an active warehouse the compute resource for all running and queued queries on the warehouse are affected
When increasing the size of an active warehouse the compute resource for all running and queued queries on the warehouse are affected
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.
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.
The warehouse will be suspended while the new compute resource is provisioned and will resume automatically once provisioning is complete.
The warehouse will be suspended while the new compute resource is provisioned and will resume automatically once provisioning is complete.
Users who are trying to use the warehouse will receive an error message until the resizing is complete
Users who are trying to use the warehouse will receive an error message until the resizing is complete
Suggested answer: B
asked 23/09/2024
Solange Castro
35 questions

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?

Yes, because a table owner has full control and can unset masking policies.
Yes, because a table owner has full control and can unset masking policies.
Yes, because masking policies only apply to cloned tables.
Yes, because masking policies only apply to cloned tables.
No, because masking policies must always reference specific access roles.
No, because masking policies must always reference specific access roles.
No, because ownership of a table does not include the ability to change masking policies
No, because ownership of a table does not include the ability to change masking policies
Suggested answer: A
asked 23/09/2024
martin lopez
36 questions

Question 147

Report Export Collapse

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

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

Question 148

Report Export Collapse

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

Informatica
Informatica
Power Bl
Power Bl
Adobe
Adobe
Data Robot
Data Robot
Suggested answer: D
Explanation:

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

asked 23/09/2024
Maher Khamessi
34 questions

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?

An FTP server with TLS encryption
An FTP server with TLS encryption
An HTTPS server with WebDAV
An HTTPS server with WebDAV
A Google Cloud storage bucket
A Google Cloud storage bucket
A Windows server file share on Azure
A Windows server file share on Azure
Suggested answer: C
asked 23/09/2024
Pawel Lenart
36 questions

Question 150

Report Export Collapse

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

Variant
Variant
Object
Object
Geometry
Geometry
Geography
Geography
Suggested answer: D
Explanation:

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

asked 23/09/2024
CRISTIAN FONSECA
44 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