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

Snowflake COF-C02 Practice Test - Questions Answers, Page 41

Question list
Search
Search
Open VPLUS File
Convert VPLUS to PDF

Related questions

A query containing a WHERE clause is running longer than expected. The Query Profile shows that all micro-partitions being scanned How should this query be optimized?
Which minimum Snowflake edition allows for a dedicated metadata store?
How can the outer array structure of a semi-structured file be removed?
Who can access the data published in a Data Exchange?
What are characteristics of the ownership privilege when it is granted on a regular Snowflake schema? (Select TWO).
What virtual warehouse configuration should be used when processing a large number of complex queries?
While preparing to unload data in Snowflake, the file format option can be specified in which commands? (Select TWO).
Which Query Profile metrics will provide information that can be used to improve query performance? (Select TWO).
How can a data provider validate that a secure view is configured to display only the data the provider wishes to expose?
How does the search optimization service improve query performance?

Question 401

Report
Export
Collapse

What happens when a Snowflake user changes the data retention period at the schema level?

A.
All child objects will retain data for the new retention period.
A.
All child objects will retain data for the new retention period.
Answers
B.
All child objects that do not have an explicit retention period will automatically inherit the new retention period.
B.
All child objects that do not have an explicit retention period will automatically inherit the new retention period.
Answers
C.
All child objects with an explicit retention period will be overridden with the new retention period.
C.
All child objects with an explicit retention period will be overridden with the new retention period.
Answers
D.
All explicit child object retention periods will remain unchanged.
D.
All explicit child object retention periods will remain unchanged.
Answers
Suggested answer: B

Explanation:

When the data retention period is changed at the schema level, all child objects that do not have an explicit retention period set will inherit the new retention period from the schema4.

Question 402

Report
Export
Collapse

Which Snowflake function will parse a JSON-null into a SQL-null?

A.
TO_CHAR
A.
TO_CHAR
Answers
B.
TO_VARIANT
B.
TO_VARIANT
Answers
C.
TO_VARCHAR
C.
TO_VARCHAR
Answers
D.
STRIP NULL VALUE
D.
STRIP NULL VALUE
Answers
Suggested answer: D

Explanation:

TheSTRIP_NULL_VALUEfunction in Snowflake is used to convert a JSON null value into a SQL NULL value1.

Question 403

Report
Export
Collapse

While working with unstructured data, which file function generates a Snowflake-hosted file URL to a staged file using the stage name and relative file path as inputs?

A.
GET_PRESIGNED_URL
A.
GET_PRESIGNED_URL
Answers
B.
GET_ABSOLUTE_PATH
B.
GET_ABSOLUTE_PATH
Answers
C.
BUILD_STAGE_FILE_URL
C.
BUILD_STAGE_FILE_URL
Answers
D.
BUILD SCOPED FILE URL
D.
BUILD SCOPED FILE URL
Answers
Suggested answer: C

Explanation:

TheBUILD_STAGE_FILE_URLfunction generates a Snowflake-hosted file URL to a staged file using the stage name and relative file path as inputs2.

Question 404

Report
Export
Collapse

Which Snowflake database object can be used to track data changes made to table data?

A.
Tag
A.
Tag
Answers
B.
Task
B.
Task
Answers
C.
Stream
C.
Stream
Answers
D.
Stored procedure
D.
Stored procedure
Answers
Suggested answer: C

Explanation:

AStreamobject in Snowflake is used for change data capture (CDC), which records data manipulation language (DML) changes made to tables, including inserts, updates, and deletes3.

Question 405

Report
Export
Collapse

What transformations are supported when loading data into a table using the COPY INTO <table> command? (Select TWO).

A.
Column reordering
A.
Column reordering
Answers
B.
Column omission
B.
Column omission
Answers
C.
JOIN function
C.
JOIN function
Answers
D.
FLATTEN function
D.
FLATTEN function
Answers
E.
GROUP BY function
E.
GROUP BY function
Answers
Suggested answer: A, B

Explanation:

TheCOPY INTO <table>command in Snowflake supports column reordering and column omission as part of its data transformation capabilities during the load process45.

Question 406

Report
Export
Collapse

Which Snowflake table objects can be shared with other accounts? (Select TWO).

A.
Temporary tables
A.
Temporary tables
Answers
B.
Permanent tables
B.
Permanent tables
Answers
C.
Transient tables
C.
Transient tables
Answers
D.
External tables
D.
External tables
Answers
E.
User-Defined Table Functions (UDTFs)
E.
User-Defined Table Functions (UDTFs)
Answers
Suggested answer: B, D

Explanation:

In Snowflake,permanent tablesandexternal tablescan be shared with other accounts using Secure Data Sharing.Temporary tables, transient tables, and UDTFs are not shareable objects

Question 407

Report
Export
Collapse

Which object can be used with Secure Data Sharing?

A.
View
A.
View
Answers
B.
Materialized view
B.
Materialized view
Answers
C.
External table
C.
External table
Answers
D.
User-Defined Function (UDF)
D.
User-Defined Function (UDF)
Answers
Suggested answer: A

Explanation:

Viewscan be used with Secure Data Sharing in Snowflake.Materialized views, external tables, and UDFs are not typically shared directly for security and performance reasons2.

Question 408

Report
Export
Collapse

How can a Snowflake administrator determine which user has accessed a database object that contains sensitive information?

A.
Review the granted privileges to the database object.
A.
Review the granted privileges to the database object.
Answers
B.
Review the row access policy for the database object.
B.
Review the row access policy for the database object.
Answers
C.
Query the ACCESS_HlSTORY view in the ACCOUNT_USAGE schema.
C.
Query the ACCESS_HlSTORY view in the ACCOUNT_USAGE schema.
Answers
D.
Query the REPLICATION USAGE HISTORY view in the ORGANIZATION USAGE schema.
D.
Query the REPLICATION USAGE HISTORY view in the ORGANIZATION USAGE schema.
Answers
Suggested answer: C

Explanation:

To determine which user has accessed a database object containing sensitive information, a Snowflake administrator can query theACCESS_HISTORYview in theACCOUNT_USAGEschema, which provides information about access to database objects3.

Question 409

Report
Export
Collapse

Which type of loop requires a BREAK statement to stop executing?

A.
FOR
A.
FOR
Answers
B.
LOOP
B.
LOOP
Answers
C.
REPEAT
C.
REPEAT
Answers
D.
WHILE
D.
WHILE
Answers
Suggested answer: B

Explanation:

TheLOOPtype of loop in Snowflake Scripting does not have a built-in termination condition and requires aBREAKstatement to stop executing4.

Question 410

Report
Export
Collapse

Which Snowflake function is maintained separately from the data and helps to support features such as Time Travel, Secure Data Sharing, and pruning?

A.
Column compression
A.
Column compression
Answers
B.
Data clustering
B.
Data clustering
Answers
C.
Micro-partitioning
C.
Micro-partitioning
Answers
D.
Metadata management
D.
Metadata management
Answers
Suggested answer: C

Explanation:

Micro-partitioning is a Snowflake function that is maintained separately from the data and supports features such as Time Travel, Secure Data Sharing, and pruning.It allows Snowflake to efficiently manage and query large datasets by organizing them into micro-partitions1.

Total 716 questions
Go to page: of 72
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