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

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

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 51

Report
Export
Collapse

What privileges are required to create a task?

A.
The global privilege create task is required to create a new task.
A.
The global privilege create task is required to create a new task.
Answers
B.
Tasks are created at the Application level and can only be created by the Account Admin role.
B.
Tasks are created at the Application level and can only be created by the Account Admin role.
Answers
C.
Many Snowflake DDLs are metadata operations only, and create task DDL can be executed without virtual warehouse requirement or task specific grants.
C.
Many Snowflake DDLs are metadata operations only, and create task DDL can be executed without virtual warehouse requirement or task specific grants.
Answers
D.
The role must have access to the target schema and the create task privilege on the schema itself.
D.
The role must have access to the target schema and the create task privilege on the schema itself.
Answers
Suggested answer: D

Explanation:

All tasks in a simple tree must have the same task owner (i.e. a single role must have the OWNERSHIP privilege on all of the tasks in the tree). All tasks in a simple tree must exist in the same schema.

https://docs.snowflake.com/en/user-guide/tasks-intro.html#creating-tasks

Question 52

Report
Export
Collapse

True or False: Some queries can be answered through the metadata cache and do not require an active Virtual Warehouse.

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

Explanation:

Some aggregate queries are answered thru micro partitions metadata only not requiring any VW spin ups.

Question 53

Report
Export
Collapse

When scaling out by adding clusters to a multi-cluster warehouse, you are primarily scaling for improved:

A.
Concurrency
A.
Concurrency
Answers
B.
Performance
B.
Performance
Answers
Suggested answer: A

Explanation:

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

Question 54

Report
Export
Collapse

True or False: You can query the files in an External Stage directly without having to load the data into a table.

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

Explanation:

Reference: https://docs.snowflake.com/en/user-guide/tables-external-intro.html

External tables are read-only, therefore no DML operations can be performed on them; however, external tables can be used for query and join operations. Views can be created against external tables.

Question 55

Report
Export
Collapse

True or False: An active warehouse is required to run a COPY INTO statement.

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

Question 56

Report
Export
Collapse

True or False: AWS Private Link provides a secure connection from the Customer’s on-premise data center to the Snowflake.

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

Explanation:

Reference: https://docs.snowflake.com/en/user-guide/admin-security-privatelink.html

Question 57

Report
Export
Collapse

True or False: Snowflake’s Global Services Layer gathers and maintains statistics on all columns in all micro-partitions.

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

Explanation:

Snowflake is a single, integrated platform delivered as-a-service. It features storage, compute, and global services layers that are physically separated but logically integrated.

Question 58

Report
Export
Collapse

Which of the following statements is true of Snowflake?

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 ported to the cloud
B.
It was built as an on-premises solution and then ported 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

Explanation:

Reference: https://www.stitchdata.com/resources/snowflake/

Question 59

Report
Export
Collapse

What is the minimum Snowflake edition that provides multi-cluster warehouses and up to 90 days of Time Travel?

A.
Standard
A.
Standard
Answers
B.
Premier
B.
Premier
Answers
C.
Enterprise
C.
Enterprise
Answers
D.
Business Critical Edition
D.
Business Critical Edition
Answers
Suggested answer: C

Explanation:

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

Question 60

Report
Export
Collapse

Which of the following statements are true about Schemas in Snowflake? (Choose two.)

A.
A Schema may contain one or more Databases
A.
A Schema may contain one or more Databases
Answers
B.
A Database may contain one or more Schemas
B.
A Database may contain one or more Schemas
Answers
C.
A Schema is a logical grouping of Database Objects
C.
A Schema is a logical grouping of Database Objects
Answers
D.
Each Schema is contained within a Warehouse
D.
Each Schema is contained within a Warehouse
Answers
Suggested answer: B, C

Explanation:

Reference: https://docs.snowflake.com/en/user-guide/data-sharing-mutiple-db.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