- All Exams Instant Download
While loading data into a table from stage, which are the valid copyOptions
While loading data into a table from stage, which are the valid copyOptionsA . CONTINUE B. SKIP_FILE C. SKIP_FILE_<NUM> D. SKIP_FILE_<NUM>% E. ABORT_STATEMENT F. ERROR_STATEMENTView AnswerAnswer: A,B,C,D,E Explanation:
What is the data size limit for loading into a variant column?
What is the data size limit for loading into a variant column?A . 16 MB(Compressed) B. 1 GB(Compressed) C. 32 GB D. 10 MB - 100 MB compressedView AnswerAnswer: A
Which mode will you use for the warehouse?
You will be using a multi cluster warehouse. You will statically control the available resources (i.e. servers) and you have large numbers of concurrent user sessions and/or queries and the numbers do not fluctuate significantly. Which mode will you use for the warehouse?A . Maximized B. Auto-Scale C. MinimizedView AnswerAnswer:...
Below are the rest APIs provided by Snowpipe
Below are the rest APIs provided by SnowpipeA . insertFiles B. insertReport C. loadDataView AnswerAnswer: A,B Explanation: Endpoint: insertFiles Informs Snowflake about the files to be ingested into a table. A successful response from this endpoint means that Snowflake has recorded the list of files to add to the table....
Which command below will load data from result_scan to a table?
Which command below will load data from result_scan to a table?A . CREATE OR REPLACE TABLE STORE_FROM_RESULT_SCAN AS select * from table(result_scan(last_query_id())); B. CREATE OR REPLACE TABLE STORE_FROM_RESULT_SCAN AS select * from result_scan(last_query_id()); C. INSERT INTO STORE_FROM_RESULT_SCAN select * from result_scan(last_query_id());View AnswerAnswer: A Explanation: RESULT_SCAN is a system defined table...
Why is this happening?
You ran the below query. I have a warehouse with auto suspend set at 5 seconds SELECT * FROM INVENTORY; The query profile looks like as below. Please see below 'Percentage scanned from cache' is 0% You ran the query again before 5 seconds has elapsed and the query profile...
While using joins, non-equality join predicates might result in significantly slower processing speeds and should be avoided if possible.
While using joins, non-equality join predicates might result in significantly slower processing speeds and should be avoided if possible.A . TRUE B. FALSEView AnswerAnswer: A Explanation: non-equality JOINS are usually slower compared to equality joins. This is a very important thing to remember when you work on snowflake.
Which of the below objects cannot be replicated from one region to the other?
Which of the below objects cannot be replicated from one region to the other?A . File Formats B. Sequences C. Pipes D. Views E. Materialized views F. StreamsView AnswerAnswer: C,F Explanation: As of today(27-Nov-2020), below objects cannot be replicated
The endpoint insertFiles of SnowPipe rest API is used to inform Snowflake about the files to be ingested into a table. Select the two statements for this end point.
The endpoint insertFiles of SnowPipe rest API is used to inform Snowflake about the files to be ingested into a table. Select the two statements for this end point.A . The post can contain at most 5000 files. B. Each file path given must be <= 1024 bytes long when...
Loading data using snowpipe REST API is supported for external stage only
Loading data using snowpipe REST API is supported for external stage onlyA . TRUE B. FALSEView AnswerAnswer: B Explanation: Snowpipe supports loading from the following stage types:
