ExamGecko
Login
Home / Snowflake / SnowPro Core / List of questions
Ask Question

Snowflake SnowPro Core Practice Test - Questions Answers, Page 13

Add to Whishlist

List of questions

Question 121

Report Export Collapse

What is the maximum total Continuous Data Protection (CDP) charges incurred for a temporary table?

30 days
30 days
7 days
7 days
48 hours
48 hours
24 hours
24 hours
Suggested answer: D
Explanation:

For a temporary table, the maximum total Continuous Data Protection (CDP) charges incurred are for the duration of the session in which the table was created, which does not exceed 24 hours2.

Reference = [COF-C02] SnowPro Core Certification Exam Study Guide, Snowflake Documentation2

asked 23/09/2024
Audrey Buan
41 questions

Question 122

Report Export Collapse

What type of query benefits the MOST from search optimization?

A query that uses only disjunction (i.e., OR) predicates
A query that uses only disjunction (i.e., OR) predicates
A query that includes analytical expressions
A query that includes analytical expressions
A query that uses equality predicates or predicates that use IN
A query that uses equality predicates or predicates that use IN
A query that filters on semi-structured data types
A query that filters on semi-structured data types
Suggested answer: C
Explanation:

Search optimization in Snowflake is designed to improve the performance of queries that are selective and involve point lookup operations using equality and IN predicates.It is particularly beneficial for queries that access columns with a high number of distinct values1.

Reference = [COF-C02] SnowPro Core Certification Exam Study Guide, Snowflake Documentation

asked 23/09/2024
Christheo Van Rooyen
40 questions

Question 123

Report Export Collapse

Which of the following are characteristics of Snowflake virtual warehouses? (Choose two.)

Auto-resume applies only to the last warehouse that was started in a multi-cluster warehouse.
Auto-resume applies only to the last warehouse that was started in a multi-cluster warehouse.
The ability to auto-suspend a warehouse is only available in the Enterprise edition or above.
The ability to auto-suspend a warehouse is only available in the Enterprise edition or above.
SnowSQL supports both a configuration file and a command line option for specifying a default warehouse.
SnowSQL supports both a configuration file and a command line option for specifying a default warehouse.
A user cannot specify a default warehouse when using the ODBC driver.
A user cannot specify a default warehouse when using the ODBC driver.
The default virtual warehouse size can be changed at any time.
The default virtual warehouse size can be changed at any time.
Suggested answer: C, E
Explanation:

Snowflake virtual warehouses support a configuration file and command line options in SnowSQL to specify a default warehouse, which is characteristic C. Additionally, the size of a virtual warehouse can be changed at any time, which is characteristic E.These features provide flexibility and ease of use in managing compute resources2.

Reference = [COF-C02] SnowPro Core Certification Exam Study Guide, Snowflake Documentation

asked 23/09/2024
Tarnauceanu Diana
44 questions

Question 124

Report Export Collapse

Which command should be used to load data from a file, located in an external stage, into a table in Snowflake?

INSERT
INSERT
PUT
PUT
GET
GET
COPY
COPY
Suggested answer: D
Explanation:

The COPY command is used in Snowflake to load data from files located in an external stage into a table.This command allows for efficient and parallelized data loading from various file formats1.

Reference = [COF-C02] SnowPro Core Certification Exam Study Guide, Snowflake Documentation

asked 23/09/2024
Rodwell Shibambu
60 questions

Question 125

Report Export Collapse

The Snowflake Cloud Data Platform is described as having which of the following architectures?

Become a Premium Member for full access
  Unlock Premium Member

Question 126

Report Export Collapse

Which of the following is a data tokenization integration partner?

Become a Premium Member for full access
  Unlock Premium Member

Question 127

Report Export Collapse

What versions of Snowflake should be used to manage compliance with Personal Identifiable Information (PII) requirements? (Choose two.)

Become a Premium Member for full access
  Unlock Premium Member

Question 128

Report Export Collapse

What are supported file formats for unloading data from Snowflake? (Choose three.)

Become a Premium Member for full access
  Unlock Premium Member

Question 129

Report Export Collapse

The Snowflake cloud services layer is responsible for which tasks? (Choose two.)

Become a Premium Member for full access
  Unlock Premium Member

Question 130

Report Export Collapse

When publishing a Snowflake Data Marketplace listing into a remote region what should be taken into consideration? (Choose two.)

Become a Premium Member for full access
  Unlock Premium Member
Total 627 questions
Go to page: of 63
Open VPLUS File
Convert VPLUS to PDF

Related questions

What is a key feature of Snowflake architecture?
Which of the following indicates that it may be appropriate to use a clustering key for a table? (Select TWO).
How is unstructured data retrieved from data storage?
Which privilege must be granted to a share to allow secure views the ability to reference data in multiple databases?
A materialized view should be created when which of the following occurs? (Choose two.)
What happens when a virtual warehouse is resized?
How can a Snowflake user traverse semi-structured data?
When would Snowsight automatically detect if a target account is in a different region and enable cross-cloud auto-fulfillment?
A user needs to create a materialized view in the schema MYDB.MYSCHEM
User-level network policies can be created by which of the following roles? (Select TWO).