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

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

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 361

Report
Export
Collapse

Which command is used to unload data from a Snowflake database table into one or more files in a Snowflake stage?

A.
CREATE STAGE
A.
CREATE STAGE
Answers
B.
COPY INTO <table>
B.
COPY INTO <table>
Answers
C.
COPY INTO <location>
C.
COPY INTO <location>
Answers
D.
CREATE PIPE
D.
CREATE PIPE
Answers
Suggested answer: C

Explanation:

TheCOPY INTO <location>command is used to unload data from a Snowflake database table into one or more files in a Snowflake stage1.

Question 362

Report
Export
Collapse

Which metadata table will store the storage utilization information even for dropped tables?

A.
DATABASE_STORAGE_USAGE_HISTORY
A.
DATABASE_STORAGE_USAGE_HISTORY
Answers
B.
TABLE_STORAGE_METRICS
B.
TABLE_STORAGE_METRICS
Answers
C.
STORAGE_DAILY_HISTORY
C.
STORAGE_DAILY_HISTORY
Answers
D.
STAGE STORAGE USAGE HISTORY
D.
STAGE STORAGE USAGE HISTORY
Answers
Suggested answer: B

Explanation:

TheTABLE_STORAGE_METRICSmetadata table stores the storage utilization information, including for tables that have been dropped but are still incurring storage costs2.

Question 363

Report
Export
Collapse

What does a masking policy consist of in Snowflake?

A.
A single data type, with one or more conditions, and one or more masking functions
A.
A single data type, with one or more conditions, and one or more masking functions
Answers
B.
A single data type, with only one condition, and only one masking function
B.
A single data type, with only one condition, and only one masking function
Answers
C.
Multiple data types, with only one condition, and one or more masking functions
C.
Multiple data types, with only one condition, and one or more masking functions
Answers
D.
Multiple data types, with one or more conditions, and one or more masking functions
D.
Multiple data types, with one or more conditions, and one or more masking functions
Answers
Suggested answer: A

Explanation:

A masking policy in Snowflake consists of a single data type, with one or more conditions, and one or more masking functions.These components define how the data is masked based on the specified conditions3.

Question 364

Report
Export
Collapse

What feature of Snowflake Continuous Data Protection can be used for maintenance of historical data?

A.
Access control
A.
Access control
Answers
B.
Fail-safe
B.
Fail-safe
Answers
C.
Network policies
C.
Network policies
Answers
D.
Time Travel
D.
Time Travel
Answers
Suggested answer: D

Explanation:

Snowflake's Time Travel feature is used for the maintenance of historical data, allowing users to access and restore data that has been changed or deleted within a defined period4.

Question 365

Report
Export
Collapse

A JSON file, that contains lots of dates and arrays, needs to be processed in Snowflake. The user wants to ensure optimal performance while querying the data.

How can this be achieved?

A.
Flatten the data and store it in structured data types in a flattened table. Query the table.
A.
Flatten the data and store it in structured data types in a flattened table. Query the table.
Answers
B.
Store the data in a table with a variant data type. Query the table.
B.
Store the data in a table with a variant data type. Query the table.
Answers
C.
Store the data in a table with a vai : ant data type and include STRIP_NULL_VALUES while loading the table. Query the table.
C.
Store the data in a table with a vai : ant data type and include STRIP_NULL_VALUES while loading the table. Query the table.
Answers
D.
Store the data in an external stage and create views on top of it. Query the views.
D.
Store the data in an external stage and create views on top of it. Query the views.
Answers
Suggested answer: B

Explanation:

Storing JSON data in a table with a VARIANT data type is optimal for querying because it allows Snowflake to leverage its semi-structured data capabilities.This approach enables efficient storage and querying without the need for flattening the data, which can be performance-intensive1.

Question 366

Report
Export
Collapse

For which use cases is running a virtual warehouse required? (Select TWO).

A.
When creating a table
A.
When creating a table
Answers
B.
When loading data into a table
B.
When loading data into a table
Answers
C.
When unloading data from a table
C.
When unloading data from a table
Answers
D.
When executing a show command
D.
When executing a show command
Answers
E.
When executing a list command
E.
When executing a list command
Answers
Suggested answer: B, C

Explanation:

Running a virtual warehouse is required when loading data into a table and when unloading data from a table because these operations require compute resources that are provided by the virtual warehouse23.

Question 367

Report
Export
Collapse

What does SnowCD help Snowflake users to do?

A.
Copy data into files.
A.
Copy data into files.
Answers
B.
Manage different databases and schemas.
B.
Manage different databases and schemas.
Answers
C.
Troubleshoot network connections to Snowflake.
C.
Troubleshoot network connections to Snowflake.
Answers
D.
Write SELECT queries to retrieve data from external tables.
D.
Write SELECT queries to retrieve data from external tables.
Answers
Suggested answer: C

Explanation:

SnowCD is a connectivity diagnostic tool that helps users troubleshoot network connections to Snowflake.It performs a series of checks to evaluate the network connection and provides suggestions for resolving any issues4.

Question 368

Report
Export
Collapse

A user with which privileges can create or manage other users in a Snowflake account? (Select TWO).

A.
GRANT
A.
GRANT
Answers
B.
SELECT
B.
SELECT
Answers
C.
MODIFY
C.
MODIFY
Answers
D.
OWNERSHIP
D.
OWNERSHIP
Answers
E.
CREATE USER
E.
CREATE USER
Answers
Suggested answer: D, E

Explanation:

A user with the OWNERSHIP privilege on a user object or the CREATE USER privilege on the account can create or manage other users in a Snowflake account56.

Question 369

Report
Export
Collapse

How is unstructured data retrieved from data storage?

A.
SQL functions like the GET command can be used to copy the unstructured data to a location on the client.
A.
SQL functions like the GET command can be used to copy the unstructured data to a location on the client.
Answers
B.
SQL functions can be used to create different types of URLs pointing to the unstructured data. These URLs can be used to download the data to a client.
B.
SQL functions can be used to create different types of URLs pointing to the unstructured data. These URLs can be used to download the data to a client.
Answers
C.
SQL functions can be used to retrieve the data from the query results cache. When the query results are output to a client, the unstructured data will be output to the client as files.
C.
SQL functions can be used to retrieve the data from the query results cache. When the query results are output to a client, the unstructured data will be output to the client as files.
Answers
D.
SQL functions can call on different web extensions designed to display different types of files as a web page. The web extensions will allow the files to be downloaded to the client.
D.
SQL functions can call on different web extensions designed to display different types of files as a web page. The web extensions will allow the files to be downloaded to the client.
Answers
Suggested answer: B

Explanation:

Unstructured data stored in Snowflake can be retrieved by using SQL functions to generate URLs that point to the data.These URLs can then be used to download the data directly to a client

Question 370

Report
Export
Collapse

Which Snowflake view is used to support compliance auditing?

A.
ACCESS_HISTORY
A.
ACCESS_HISTORY
Answers
B.
COPY_HISTORY
B.
COPY_HISTORY
Answers
C.
QUERY_HISTORY
C.
QUERY_HISTORY
Answers
D.
ROW ACCESS POLICIES
D.
ROW ACCESS POLICIES
Answers
Suggested answer: A

Explanation:

TheACCESS_HISTORYview in Snowflake is utilized to support compliance auditing. It provides detailed information on data access within Snowflake, including reads and writes by user queries.This view is essential for regulatory compliance auditing as it offers insights into the usage of tables and columns, and maintains a direct link between the user, the query, and the accessed data1.

References:[COF-C02] SnowPro Core Certification Exam Study Guide

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