- All Exams Instant Download
What will be the clustering depth of the table?
You have just created a table in snowflake. There are now rows in the table. What will be the clustering depth of the table?A . 0 B. 1 C. 2 D. 3View AnswerAnswer: A Explanation A table with no micro-partitions (i.e. an unpopulated/empty table) has a clustering depth of 0.
Each micro partition contains between 50 mb and 500 MB of uncompressed data
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...
An existing clustering key is copied in which of the below scenarios
An existing clustering key is copied in which of the below scenariosA . CREATE TABLE...CLONE B. CREATE TABLE...LIKE C. CREATE TABLE...AS SELECTView AnswerAnswer: A Explanation https://docs.snowflake.com/en/sql-reference/functions/system_estimate_search_optimization_costs.html#out put BuildCosts This object describes the predicted costs of building the search access path for the table. If search optimization has already been added...
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 system table will you use to get the total credit consumption over a specific time period?
Which system table will you use to get the total credit consumption over a specific time period?A . WAREHOUSE_METERING_HISTORY B. WAREHOUSE_CREDIT_USAGE_HISTORY C. WAREHOUSE_USAGE_HISTORYView AnswerAnswer: A Explanation The WAREHOUSE_METERING_HISTORY table in the ACCOUNT_USAGE Schema can be used to get the desired information. Run the below query to try this out. SELECT...
Snowpipe supports loading from both internal and external stage
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:
Each micro partition contains between 50 mb and 500 MB of uncompressed data
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...
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...
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...
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...
