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
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
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.
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 common query issues can be identified using the Query Profile? (Choose two.)
A. Data classification
B. Exploding joins
C. Unions
D. Inefficient pruning
E. Data masking
What happens when a database is cloned?
A. It does not retain any privileges granted on the source object.
B. It replicates all granted privileges on the corresponding source objects.
C. It replicates all granted privileges on the corresponding child objects.
D. It replicates all granted privileges on the corresponding child schema objects.
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 does a Query Profile provide in Snowflake?
A. A multi-step query that displays each processing step in the same panel.
B. A pre-computed data set derived from a query specification and stored for later use.
C. A graphical representation of the main components of the processing plan for a query.
D. A collapsible panel in the operator tree pane that lists nodes by execution time in descending order for a query.
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 SNOWPRO-CORE exam preparations and Snowflake certification application, do not hesitate to visit our Vcedump.com to find your solutions here.