- All Exams Instant Download
What is the minimum Snowflake edition that customers planning on storing protected information in Snowflake should consider for regulatory compliance?
What is the minimum Snowflake edition that customers planning on storing protected information in Snowflake should consider for regulatory compliance?A . Standard B. Premier C. Enterprise D. Business Critical EditionView AnswerAnswer: D Explanation: Reference: https://docs.snowflake.com/en/user-guide/intro-editions.html
The Query History in the Snowflake Web Interface (UI) is kept for approximately:
The Query History in the Snowflake Web Interface (UI) is kept for approximately:A . 60 minutes B. 24 hours C. 14 days D. 30 days E. 1 yearView AnswerAnswer: C Explanation: Reference: https://docs.snowflake.com/en/sql-reference/account-usage/query_history.html
When reviewing a query profile, what is a symptom that a query is too large to fit into the memory?
When reviewing a query profile, what is a symptom that a query is too large to fit into the memory?A . A single join node uses more than 50% of the query time B. Partitions scanned is equal to partitions total C. An AggregateOperacor node is present D. The query...
What happens to the underlying table data when a CLUSTER BY clause is added to a Snowflake table?
What happens to the underlying table data when a CLUSTER BY clause is added to a Snowflake table?A . Data is hashed by the cluster key to facilitate fast searches for common data values B. Larger micro-partitions are created for common data values to reduce the number of partitions that...
Which statement about billing applies to Snowflake credits?
Which statement about billing applies to Snowflake credits?A . Credits are billed per-minute with a 60-minute minimum B. Credits are used to pay for cloud data storage usage C. Credits are consumed based on the number of credits billed for each hour that a warehouse runs D. Credits are consumed...
Which of the following DML commands isn’t supported by Snowflake?
Which of the following DML commands isn’t supported by Snowflake?A . UPSERT B. MERGE C. UPDATE D. TRUNCATE TABLEView AnswerAnswer: A Explanation: Reference: https://docs.snowflake.com/en/sql-reference/sql-dml.html
Credit Consumption by the Compute Layer (Virtual Warehouses) is based on: (Choose two.)
Credit Consumption by the Compute Layer (Virtual Warehouses) is based on: (Choose two.)A . Number of users B. Warehouse size C. Amount of data processed D. # of clusters for the WarehouseView AnswerAnswer: B,D Explanation: https://docs.snowflake.com/en/user-guide/credits.html#virtual-warehouse-credit-usage "Snowflake credits are charged based on the number of virtual warehouses you use, how...
True or False: Snowflake’s data warehouse was built from the ground up for the cloud in lieu of using an existing database or a platform, like Hadoop, as a base.
True or False: Snowflake’s data warehouse was built from the ground up for the cloud in lieu of using an existing database or a platform, like Hadoop, as a base.A . True B. FalseView AnswerAnswer: A Explanation: Snowflake's data warehouse was built from the ground up specifically for the cloud,...
What feature can be used to reorganize a very large table on one or more columns?
What feature can be used to reorganize a very large table on one or more columns?A . Micro-partitions B. Clustering keys C. Key partitions D. Clustered partitionsView AnswerAnswer: B Explanation: https://docs.snowflake.com/en/user-guide/tables-clustering-keys.html
In the query profiler view for a query, which components represent areas that can be used to help optimize query performance? (Select TWO)
In the query profiler view for a query, which components represent areas that can be used to help optimize query performance? (Select TWO)A . Bytes scanned B. Bytes sent over the network C. Number of partitions scanned D. Percentage scanned from cache E. External bytes scannedView AnswerAnswer: A,C
