- All Exams Instant Download
CREATE OR REPLACE TABLE TIME_TRAVEL_SCHEMA.TIME_TRAVEL_TABLE (ID NUMBER) DATA_RETENTION_TIME_IN_DAYS =20;
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...
Snowflake does not prune micro-partitions based on a predicate with a subquery
Snowflake does not prune micro-partitions based on a predicate with a subqueryA . TRUE B. FALSEView AnswerAnswer: A Explanation Not all predicate expressions can be used to prune. For example, Snowflake does not prune micro-partitions based on a predicate with a subquery, even if the subquery results in a constant....
CREATE OR REPLACE TABLE TIME_TRAVEL_SCHEMA.TIME_TRAVEL_TABLE (ID NUMBER) DATA_RETENTION_TIME_IN_DAYS =20;
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...
CREATE OR REPLACE TABLE TIME_TRAVEL_SCHEMA.TIME_TRAVEL_TABLE (ID NUMBER) DATA_RETENTION_TIME_IN_DAYS =20;
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...
from employee where role = current_role();
from employee where role = current_role();A . Only users with the desired role will be able to retrieve results from the view B. Only users with the correct role assigned and SYSADMIN will be able to retrieve the results from the view C. The operation will error out since the...
Which of the below transformations are supported by Snowflake while loading a table using the COPY statement?
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...
Which of the below statements are true?
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...
It is a best practice to avoid binding data using Python's formatting function due to the risk of SQL injection.
It is a best practice to avoid binding data using Python's formatting function due to the risk of SQL injection.A . TRUE B. FALSEView AnswerAnswer: A Explanation Avoid SQL Injection Attacks Avoid binding data using Python’s formatting function because you risk SQL injection. For example: # Binding data (UNSAFE EXAMPLE)...
CREATE OR REPLACE TABLE TIME_TRAVEL_SCHEMA.TIME_TRAVEL_TABLE (ID NUMBER) DATA_RETENTION_TIME_IN_DAYS =20;
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 steps are required to create streams on shared tables?
Which of the below steps are required to create streams on shared tables?A . Enable change tracking B. Extend the data retention period for the table C. Enable search virtualization on the tableView AnswerAnswer: A, B Explanation This is an important topic, please read this section carefully https://docs.snowflake.com/en/user-guide/data-sharing-provider.html#enabling-data-consumers-to-create-tab le-streams-on-shared-tables Enabling...
