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

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

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?
True or False: Snowpipe via REST API can only reference External Stages as source.
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.)

Question 161

Report
Export
Collapse

When is the result set cache no longer available? (Select TWO)

A.
When another warehouse is used to execute the query
A.
When another warehouse is used to execute the query
Answers
B.
When another user executes the query
B.
When another user executes the query
Answers
C.
When the underlying data has changed
C.
When the underlying data has changed
Answers
D.
When the warehouse used to execute the query is suspended
D.
When the warehouse used to execute the query is suspended
Answers
E.
When it has been 24 hours since the last query
E.
When it has been 24 hours since the last query
Answers
Suggested answer: C, E

Question 162

Report
Export
Collapse

Which of the following describes external functions in Snowflake?

A.
They are a type of User-defined Function (UDF).
A.
They are a type of User-defined Function (UDF).
Answers
B.
They contain their own SQL code.
B.
They contain their own SQL code.
Answers
C.
They call code that is stored inside of Snowflake.
C.
They call code that is stored inside of Snowflake.
Answers
D.
They can return multiple rows for each row received
D.
They can return multiple rows for each row received
Answers
Suggested answer: A

Explanation:

External functions are user-defined functions that are stored and executed outside of Snowflake.

External functions make it easier to access external API services such as geocoders, machine learning models, and other custom code running outside of Snowflake. This feature eliminates the need to export and reimport data when using third-party services, significantly simplifying your data pipelines.

https://docs.snowflake.com/en/sql-reference/externalfunctions.html#:~:text=External%20functions%20are%20user%2Ddefined,code%20running%20outside%20of%20Snowflake.

Question 163

Report
Export
Collapse

What are ways to create and manage data shares in Snowflake? (Select TWO)

A.
Through the Snowflake web interface (Ul)
A.
Through the Snowflake web interface (Ul)
Answers
B.
Through the DATA_SHARE=TRUE parameter
B.
Through the DATA_SHARE=TRUE parameter
Answers
C.
Through SQL commands
C.
Through SQL commands
Answers
D.
Through the enable__share=true parameter
D.
Through the enable__share=true parameter
Answers
E.
Using the CREATE SHARE AS SELECT * TABLE command
E.
Using the CREATE SHARE AS SELECT * TABLE command
Answers
Suggested answer: C, D

Question 164

Report
Export
Collapse

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?

A.
SELECT LAST_SUCCESS_LOGIN, LOGIN_NAMEFROM ACCOUNT_USAGE.USERS;
A.
SELECT LAST_SUCCESS_LOGIN, LOGIN_NAMEFROM ACCOUNT_USAGE.USERS;
Answers
B.
SELECT EVENT_TIMESTAMP, USER_NAMEFROM table(information_schema.login_history_by_user())
B.
SELECT EVENT_TIMESTAMP, USER_NAMEFROM table(information_schema.login_history_by_user())
Answers
C.
SELECT EVENT_TIMESTAMP, USER_NAMEFROM ACCOUNT_USAGE.ACCESS_HISTORY;
C.
SELECT EVENT_TIMESTAMP, USER_NAMEFROM ACCOUNT_USAGE.ACCESS_HISTORY;
Answers
D.
SELECT EVENT_TIMESTAMP, USER_NAMEFROM ACCOUNT_USAGE.LOGIN_HISTORY;
D.
SELECT EVENT_TIMESTAMP, USER_NAMEFROM ACCOUNT_USAGE.LOGIN_HISTORY;
Answers
Suggested answer: D

Question 165

Report
Export
Collapse

Which semi-structured file formats are supported when unloading data from a table? (Select TWO).

A.
ORC
A.
ORC
Answers
B.
XML
B.
XML
Answers
C.
Avro
C.
Avro
Answers
D.
Parquet
D.
Parquet
Answers
E.
JSON
E.
JSON
Answers
Suggested answer: D, E

Explanation:

Semi-structured JSON, Parquet

https://docs.snowflake.com/en/user-guide/data-unloadprepare.html#:~:text=Supported%20File%20Formats,-The%20following%20file&text=Delimited%20(CSV%2C%20TSV%2C%20etc.)

Question 166

Report
Export
Collapse

What is the purpose of an External Function?

A.
To call code that executes outside of Snowflake
A.
To call code that executes outside of Snowflake
Answers
B.
To run a function in another Snowflake database
B.
To run a function in another Snowflake database
Answers
C.
To share data in Snowflake with external parties
C.
To share data in Snowflake with external parties
Answers
D.
To ingest data from on-premises data sources
D.
To ingest data from on-premises data sources
Answers
Suggested answer: A

Explanation:

https://docs.snowflake.com/en/sql-reference/external-functions.html

Topic 3, Exam pool C

Question 167

Report
Export
Collapse

A user created a new worksheet within the Snowsight Ul and wants to share this with teammates How can this worksheet be shared?

A.
Create a zero-copy clone of the worksheet and grant permissions to teammates
A.
Create a zero-copy clone of the worksheet and grant permissions to teammates
Answers
B.
Create a private Data Exchange so that any teammate can use the worksheet
B.
Create a private Data Exchange so that any teammate can use the worksheet
Answers
C.
Share the worksheet with teammates within Snowsight
C.
Share the worksheet with teammates within Snowsight
Answers
D.
Create a database and grant all permissions to teammates
D.
Create a database and grant all permissions to teammates
Answers
Suggested answer: C

Question 168

Report
Export
Collapse

What is the purpose of multi-cluster virtual warehouses?

A.
To create separate data warehouses to increase query optimization
A.
To create separate data warehouses to increase query optimization
Answers
B.
To allow users the ability to choose the type of compute nodes that make up a virtual warehouse cluster
B.
To allow users the ability to choose the type of compute nodes that make up a virtual warehouse cluster
Answers
C.
To eliminate or reduce Queuing of concurrent queries
C.
To eliminate or reduce Queuing of concurrent queries
Answers
D.
To allow the warehouse to resize automatically
D.
To allow the warehouse to resize automatically
Answers
Suggested answer: C

Explanation:

https://docs.snowflake.com/en/user-guide/warehousesmulticluster.html#:~:text=Multi%2Dcluster%20warehouses%20enable%20you,during%20peak%20and%20off%20hours.

Question 169

Report
Export
Collapse

Which statements are true concerning Snowflake's underlying cloud infrastructure? (Select THREE),

A.
Snowflake data and services are deployed in a single availability zone within a cloud provider's region.
A.
Snowflake data and services are deployed in a single availability zone within a cloud provider's region.
Answers
B.
Snowflake data and services are available in a single cloud provider and a single region, the use of multiple cloud providers is not supported.
B.
Snowflake data and services are available in a single cloud provider and a single region, the use of multiple cloud providers is not supported.
Answers
C.
Snowflake can be deployed in a customer's private cloud using the customer's own compute and storage resources for Snowflake compute and storage
C.
Snowflake can be deployed in a customer's private cloud using the customer's own compute and storage resources for Snowflake compute and storage
Answers
D.
Snowflake uses the core compute and storage services of each cloud provider for its own compute and storage
D.
Snowflake uses the core compute and storage services of each cloud provider for its own compute and storage
Answers
E.
All three layers of Snowflake's architecture (storage, compute, and cloud services) are deployed and managed entirely on a selected cloud platform
E.
All three layers of Snowflake's architecture (storage, compute, and cloud services) are deployed and managed entirely on a selected cloud platform
Answers
F.
Snowflake data and services are deployed in at least three availability zones within a cloud provider's region
F.
Snowflake data and services are deployed in at least three availability zones within a cloud provider's region
Answers
Suggested answer: D, E, F

Question 170

Report
Export
Collapse

Which snowflake objects will incur both storage and cloud compute charges? (Select TWO)

A.
Materialized view
A.
Materialized view
Answers
B.
Sequence
B.
Sequence
Answers
C.
Secure view
C.
Secure view
Answers
D.
Transient table
D.
Transient table
Answers
E.
Clustered table
E.
Clustered table
Answers
Suggested answer: D, E
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