DEA-C01

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 joins are supported by Snowflake?A . INNER JOIN B. OUTER JOIN C. CROSS JOIN D. NATURAL JOIN E. SIDE JOINView AnswerAnswer: A, B, C, D Explanation https://docs.snowflake.com/en/user-guide/querying-joins.html#types-of-joins Snowflake supports the following types of joins: Inner join. Outer join. Cross join. Natural join.

Which one of the below is true about clustering depth?A . The smaller the average depth, the better clustered the table is with respect to the specified columns B. The larger the average depth, the better clustered the table is with respect to the specified columns C. The smaller the...

In which of the below use cases does Snowflake applies data egress charge?A . Unloading data from Snowflake B. Database replication C. External functions D. Loading data into SnowflakeView AnswerAnswer: A, B, C Explanation Data Transfer Billing Use Cases Snowflake currently applies data egress charges only in the following use...

Which are the valid options for the validation_mode parameter in the COPY commandA . RETURN_<n>_ROWS B. RETURN_ERROR C. RETURN_ERRORS D. RETURN_ALL_ERRORSView AnswerAnswer: A, C, D Explanation VALIDATION_MODE = RETURN_n_ROWS | RETURN_ERRORS | RETURN_ALL_ERRORS String (constant) that instructs the COPY command to validate the data files instead of loading them into...

Which of the below statements are true?A . ACCOUNT USAGE includes dropped objects but INFORMATION SCHEMA does not B. INFORMATION SCHEMA includes dropped objects but ACCOUNT USAGE does not C. BOTH includes dropped object D. BOTH does not include dropped objectView AnswerAnswer: A Explanation https://docs.snowflake.com/en/sql-reference/account-usage.html#differences-between-account-usage-and-information-schema Dropped Object Records Account usage...

For how many days does the COPY_HISTORY retain data loading historyA . 10 B. 15 C. 14View AnswerAnswer: C Explanation https://docs.snowflake.com/en/sql-reference/functions/copy_history.html#copy-history COPY_HISTORY This table function can be used to query Snowflake data loading history along various dimensions within the last 14 days. The function returns load activity for both COPY...

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

Which of the below standard API objects are supported by the Snowflake connector for PythonA . Connection B. Cursor C. SnowflakeConnection D. SnowflakeCursorView AnswerAnswer: A, B Explanation https://docs.snowflake.com/en/user-guide/python-connector.html#snowflake-connector-for-python The connector supports developing applications using the Python Database API v2 specification (PEP-249), including using the following standard API objects: Connection objects...