What is the recommended way to obtain a cloned table with the same grants as the source table?
A. Clone the table with the COPY GRANTS command.
B. Use an ALTER TABLE command to copy the grants.
C. Clone the schema then drop the unwanted tables.
D. Create a script to extract grants and apply them to the cloned table.
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.
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.
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.
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.
How does the Snowflake search optimization service improve query performance?
A. It improves the performance of range searches.
B. It defines different clustering keys on the same source table.
C. It improves the performance of all queries running against a given table.
D. It improves the performance of equality searches.
Which view can be used to determine if a table has frequent row updates or deletes?
A. TABLES
B. TABLE_STORAGE_METRICS
C. STORAGE_DAILY_HISTORY
D. STORAGE_USAGE
Which file function provides a URL with access to a file on a stage without the need for authentication and authorization?
A. GET_RELATIVE_PATH
B. GET_PRESIGNED_URL
C. BUILD_STAGE_FILE_URL
D. BUILD_SCOPED_FILE_URL
What are the main differences between the account usage views and the information schema views? (Choose two.)
A. No active warehouse is needed to query account usage views but one is needed to query information schema views.
B. Account usage views do not contain data about tables but information schema views do.
C. Account usage views contain dropped objects but information schema views do not.
D. Data retention for account usage views is 1 year but is 7 days to 6 months for information schema views, depending on the view.
E. Information schema views are read-only but account usage views are not.
What is used to extract the content of PDF files stored in Snowflake stages?
A. FLATTEN function
B. Window function
C. HyperLogLog (HLL) function
D. Java User-Defined Function (UDF)
What is used to extract the content of PDF files stored in Snowflake stages?
A. FLATTEN function
B. Window function
C. HyperLogLog (HLL) function
D. Java User-Defined Function (UDF)
Which operation will produce an error in Snowflake?
A. Inserting duplicate values into a PRIMARY KEY column
B. Inserting a NULL into a column with a NOT NULL constraint
C. Inserting duplicate values into a column with a UNIQUE constraint
D. Inserting a value to FOREIGN KEY column that does not match a value in the column referenced
Which URL type should be used to get a permanent URL to a file in a stage?
A. File URL
B. Pre-signed URL
C. Saved URL
D. Scoped URL
Nowadays, the certification exams become more and more important and required by more and more enterprises when applying for a job. But how to prepare for the exam effectively? How to prepare for the exam in a short time with less efforts? How to get a ideal result and how to find the most reliable resources? Here on Vcedump.com, you will find all the answers. Vcedump.com provide not only Snowflake exam questions, answers and explanations but also complete assistance on your exam preparation and certification application. If you are confused on your COF-C02 exam preparations and Snowflake certification application, do not hesitate to visit our Vcedump.com to find your solutions here.