ARA-C01

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

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 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?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...

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.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?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.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 onlyA . TRUE B. FALSEView AnswerAnswer: B Explanation: Snowpipe supports loading from the following stage types:

Choose the different ways that you have to optimize query performanceA . Clustering a table B. Creating one or more materialized views C. Search Optimization D. VacuumingView AnswerAnswer: A,B,C Explanation: Please note that search optimization is still in preview mode. But this will be a powerful feature to optimize your...