DEA-C01 exam

Time travel cannot be disabled for an account, but it can be disabled for individual databases, schemas and tables by specifying DATA_RETENTION_TIME_IN_DAYS with a value of 0 for the objectA . TRUE B. FALSEView AnswerAnswer: A Explanation https://docs.snowflake.com/en/user-guide/data-time-travel.html#enabling-and-disabling-time-travel Enabling and Disabling Time Travel No tasks are required to enable Time...

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

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:

Snowflake charges a per-byte fee when users transfer data from your snowflake account into cloud storages in another region on the same cloud platform or into cloud storage in another cloud platformA . TRUE B. FALSEView AnswerAnswer: A Explanation https://docs.snowflake.com/en/user-guide/billing-data-transfer.html#understanding-snowflake-data-transfer-billing Cloud providers apply data egress charges in either of the...

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

Which of the below statements are true for API integration object?A . Only Snowflake users who have the ACCOUNTADMIN role or who have a role with the global CREATE INTEGRATION privilege can execute CREATE API INTEGRATION. B. Only Snowflake roles with OWNERSHIP or USAGE privileges on the API integration can...

Time travel cannot be disabled for an account, but it can be disabled for individual databases, schemas and tables by specifying DATA_RETENTION_TIME_IN_DAYS with a value of 0 for the objectA . TRUE B. FALSEView AnswerAnswer: A Explanation https://docs.snowflake.com/en/user-guide/data-time-travel.html#enabling-and-disabling-time-travel Enabling and Disabling Time Travel No tasks are required to enable Time...