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

Snowflake COF-R02 Practice Test - Questions Answers

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 1

Report
Export
Collapse

True or False: The user has to specify which cluster a query will run on in multi-clustering Warehouse.

A.
True
A.
True
Answers
B.
False
B.
False
Answers
Suggested answer: B

Explanation:

Reference: https://docs.snowflake.com/en/user-guide/warehouses-multicluster.html

Question 2

Report
Export
Collapse

Each incremental increase in Virtual Warehouse size (e,g. Medium to Large) generally results in what?

Select one.

A.
More micro-partitions
A.
More micro-partitions
Answers
B.
Better query scheduling
B.
Better query scheduling
Answers
C.
Double the numbers of servers In the compute duster
C.
Double the numbers of servers In the compute duster
Answers
D.
Higher storage costs
D.
Higher storage costs
Answers
Suggested answer: C

Question 3

Report
Export
Collapse

Which of the following statement is true of Snowflake?

Select one.

A.
It was built specifically for the cloud
A.
It was built specifically for the cloud
Answers
B.
it was built as an on-premises solution and then potted to the cloud
B.
it was built as an on-premises solution and then potted to the cloud
Answers
C.
It was designed as a hybrid database to allow customers to store data either on premises or in the cloud
C.
It was designed as a hybrid database to allow customers to store data either on premises or in the cloud
Answers
D.
It was built for Hadoop architecture
D.
It was built for Hadoop architecture
Answers
E.
It's based on an Oracle Architecture
E.
It's based on an Oracle Architecture
Answers
Suggested answer: A

Question 4

Report
Export
Collapse

The number of queries that a Virtual Warehouse can concurrently process is determined by:

Choose 2 answers

A.
The complexity of each query
A.
The complexity of each query
Answers
B.
The CONCURRENT_QUERY_UMIT parameter set on the Snowflake account
B.
The CONCURRENT_QUERY_UMIT parameter set on the Snowflake account
Answers
C.
The size of the data required for each query
C.
The size of the data required for each query
Answers
D.
The tool that s executing the query
D.
The tool that s executing the query
Answers
Suggested answer: A, C

Explanation:

Reference: https://docs.snowflake.com/en/user-guide/warehouses-overview.html

Question 5

Report
Export
Collapse

Which of the following statements would be used to export/unload data from Snowflake?

A.
COPY INTO @stage
A.
COPY INTO @stage
Answers
B.
EXPORT TO @stage
B.
EXPORT TO @stage
Answers
C.
INSERT INTO @stage
C.
INSERT INTO @stage
Answers
D.
EXPORT_TO_STAGE(stage = > @Wage, select = > 'select * from t1);
D.
EXPORT_TO_STAGE(stage = > @Wage, select = > 'select * from t1);
Answers
Suggested answer: A

Explanation:

Reference: https://docs.snowflake.com/en/user-guide/data-unload-considerations.html

Question 6

Report
Export
Collapse

True or False: It is possible to unload structured data to semi-structured formats such as JSON and parquet.

A.
True
A.
True
Answers
B.
False
B.
False
Answers
Suggested answer: A

Explanation:

Reference: https://docs.snowflake.com/en/user-guide/data-unload-prepare.html

Question 7

Report
Export
Collapse

What are the three layers that make up Snowflake’s architecture?

Choose 3 answer

A.
Compute
A.
Compute
Answers
B.
Tri-Secret Secure
B.
Tri-Secret Secure
Answers
C.
Storage
C.
Storage
Answers
D.
Cloud Services
D.
Cloud Services
Answers
Suggested answer: A, C, D

Explanation:

Reference: https://docs.snowflake.com/en/user-guide/intro-key-concepts.html

Question 8

Report
Export
Collapse

Which type of table corresponds to a single Snowflake session?

A.
Temporary
A.
Temporary
Answers
B.
Translent
B.
Translent
Answers
C.
Provisional
C.
Provisional
Answers
D.
Permanent
D.
Permanent
Answers
Suggested answer: A

Explanation:

Snowflake supports creating temporary tables for storing non-permanent, transitory data (e.g. ETL data, session-specific data). Temporary tables only exist within the session in which they were created and persist only for the remainder of the session.

https://docs.snowflake.com/en/user-guide/tables-temptransient.html#:~:text=Snowflake%20supports%20creating%20temporary%20tables,the%20remainder%20of%20the%20session.

Question 9

Report
Export
Collapse

True or False: It is possible to query data from an Internal or named External stage without loading the data into Snowflake.

A.
True
A.
True
Answers
B.
False
B.
False
Answers
Suggested answer: A

Question 10

Report
Export
Collapse

True or False: Snowflake allows its customers to directly access the micro-partition files that make up its tables.

A.
True
A.
True
Answers
B.
False
B.
False
Answers
Suggested answer: B
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