- All Exams Instant Download
What may be the issue?
One of your joins is taking a lot of time. The query profile view looks like this. What may be the issue? A . This may be an "exploding join" issue. The query has provided a condition where records from one table match multiple records from another table resulting in...
Secure views cannot take advantage of the internal optimizations which require access to the underlying data in the base tables for the view.
Secure views cannot take advantage of the internal optimizations which require access to the underlying data in the base tables for the view.A . TRUE B. FALSEView AnswerAnswer: A Explanation: Some of the internal optimizations for views require access to the underlying data in the base tables for the view....
Which of the below select query will fail for this table?
You have created a table as below CREATE TABLE SNOWFLAKE (FLAKE_ID INTEGER, UDEMY_COURSE VARCHAR); Which of the below select query will fail for this table?A . SELECT * from snowflake; B. SELECT * from Snowflake; C. SELECT * from "snowflake"; D. SELECT * FROM "SNOWFLAKE";View AnswerAnswer: C Explanation: Try it...
What is the most optimal solution that you will suggest to the business team?
You have a very large table which is already clustered on columns that are used to retrieve data from the table by a business group. The base table data does not change much. Another business group came to you and requested for a relatively small subset of data from the...
When unloading from a snowflake table to an internal or external stage, the COPY INTO command supports which of the below ones?
When unloading from a snowflake table to an internal or external stage, the COPY INTO command supports which of the below ones?A . String truncation B. Reordering columns C. Casts D. Join E. Omission of columnsView AnswerAnswer: A,B,C,D,E Explanation: Unloading operation is more flexible than the load operation. All the...
The kafka connector creates one pipe for each partition in a Kafka topic.
The kafka connector creates one pipe for each partition in a Kafka topic.A . TRUE B. FALSEView AnswerAnswer: A Explanation: The connector creates one pipe for each partition in a Kafka topic. The format of the pipe name is: SNOWFLAKE_KAFKA_CONNECTOR_<connector_name>_<PIPE_table_name>_<partition_number> https://docs.snowflake.com/en/user-guide/kafka-connector-manage.html#dropping-pipes
How do you validate the data that is unloaded using COPY INTO command
How do you validate the data that is unloaded using COPY INTO commandA . After unloading, load the data into a relational table and validate the rows B. Load the data into a CSV file to validate the rows C. Use validation_mode='RETURN_ROWS'; with COPY commandView AnswerAnswer: C Explanation: Validating Data...
What may be the cause of this?
One of your query is taking a long time to finish, when you open the query profiler you see that lot of data is spilling to the remote disk(Bytes spilled to remote storage). What may be the cause of this?A . The amount of memory available for the servers used...
With default settings, how long will a query run on snowflake
With default settings, how long will a query run on snowflakeA . Snowflake will cancel the query if it runs more than 48 hours B. Snowflake will cancel the query if it runs more than 24 hours C. Snowflake will cancel the query if the warehouse runs out of memory...
How will you resume it?
You have created a TASK in snowflake. How will you resume it?A . No need to resume, the creation operation automatically enables the task B. ALTER TASK mytask1 RESUME; C. ALTER TASK mytask1 START;View AnswerAnswer: B Explanation: It is important to remember that a Task that has just been created...
