DEA-C01 exam

Each micro partition contains between 50 mb and 500 MB of uncompressed dataA . TRUE B. FALSEView AnswerAnswer: A Explanation What are Micro-partitions? All data in Snowflake tables is automatically divided into micro-partitions, which are contiguous units of storage. Each micro-partition contains between 50 MB and 500 MB of uncompressed...

CREATE OR REPLACE TABLE TIME_TRAVEL_SCHEMA.TIME_TRAVEL_TABLE (ID NUMBER) DATA_RETENTION_TIME_IN_DAYS =20; Later you dropped the schema. In this scenario what data retention value will be honored for the table, if we need to retrieve the table data A. 10 B. 20 C. 30View AnswerAnswer: A Explanation https://docs.snowflake.com/en/user-guide/data-time-travel.html#dropped-containers-and-object-retention-inh eritance Dropped Containers and Object...

; call sp1(); SELECT * FROM EMPLOYEE ORDER BY ID;A . 1 MOHAN 2 RON B. 1 MOHAN 2 RON 3 RANJAN C. 1 MOHAN 3 RANJAN D. 1 MOHANView AnswerAnswer: A Explanation https://docs.snowflake.com/en/sql-reference/transactions.html#scoped-transactions Scoped Transactions A stored procedure that contains a transaction can be called from within another transaction....

CREATE OR REPLACE TABLE TIME_TRAVEL_SCHEMA.TIME_TRAVEL_TABLE (ID NUMBER) DATA_RETENTION_TIME_IN_DAYS =20; Later you dropped the schema. In this scenario what data retention value will be honored for the table, if we need to retrieve the table data A. 10 B. 20 C. 30View AnswerAnswer: A Explanation https://docs.snowflake.com/en/user-guide/data-time-travel.html#dropped-containers-and-object-retention-inh eritance Dropped Containers and Object...

Which of the below mentioned compression techniques are applicable for CSV file format?A . GZIP B. BZ2 C. BROTLI D. ZSTD E. DEFLATE F. RAW_DEFLATE G. LZIPView AnswerAnswer: A, B, C, D, E, F Explanation https://docs.snowflake.com/en/sql-reference/sql/copy-into-table.html#type-csv Supported Values Notes AUTO Compression algorithm detected automatically, except for Brotli-compressed files, which cannot...

Let's say you have a schema name MY_SCHEMA. This schema contains two permanent tables as shown below CREATE TABLE MY_TABLE_A (C1 INT) DATA_RETENTION_TIME_IN_DAYS = 10; CREATE TABLE MY_TABLE_B (C1 INT); What will be the impact of running the following command? ALTER SCHEMA MY_SCHEMA SET DATA_RETENTION_TIME_IN_DAYS = 20; A. Data retention...

Which snowflake parameter limits the number of iterationsA . MAX_RECURSIONS B. MAX_ITERATIONS C. MAX_LOOPView AnswerAnswer: A Explanation Recursive CTE Considerations Potential for Infinite Loops In theory, constructing a recursive CTE incorrectly can cause an infinite loop. In practice, Snowflake prevents this by limiting the number of iterations that the recursive...

Snowpipe supports loading from both internal and external stageA . FALSE B. TRUEView AnswerAnswer: B Explanation Step 1: Create a Stage (If Needed) Snowpipe supports loading from the following stage types:

Which of the below transformations are supported by Snowflake while loading a table using the COPY statement?A . Column reordering B. Column renaming C. Column omission D. Casts E. Truncating text strings that exceed the target column lengthView AnswerAnswer: A, C, D, E Explanation Simple Transformations During a Load Snowflake...

You have an employee table and you want to view the explain results in a tabular form for the below query SELECT * FROM EMPLOYEE; Which of the options below can you use to do the same?A . SELECT * FROM TABLE( EXPLAIN_JSON( SYSTEM$EXPLAIN_PLAN_JSON( 'SELECT * FROM EMPLOYEES') ) );...