Practice Free SnowPro Core Exam Online Questions
During periods of warehouse contention which parameter controls the maximum length of time a warehouse will hold a query for processing?
- A . STATEMENT_TIMEOUT__IN__SECONDS
- B . STATEMENT_QUEUED_TIMEOUT_IN_SECONDS
- C . MAX_CONCURRENCY__LEVEL
- D . QUERY_TIMEOUT_IN_SECONDS
Which pages are included in the Activity area of Snowsight? (Select TWO).
- A . Contacts
- B . Sharing settings
- C . Copy History
- D . Query History
- E . Automatic Clustering History
What is the minimum Snowflake edition that has column-level security enabled?
- A . Standard
- B . Enterprise
- C . Business Critical
- D . Virtual Private Snowflake
Which of the following are characteristics of security in Snowflake?
- A . Account and user authentication is only available with the Snowflake Business Critical edition.
- B . Support for HIPAA and GDPR compliance is available for UI Snowflake editions.
- C . Periodic rekeying of encrypted data is available with the Snowflake Enterprise edition and higher
- D . Private communication to internal stages is allowed in the Snowflake Enterprise edition and higher.
Which of the following are characteristics of security in Snowflake?
- A . Account and user authentication is only available with the Snowflake Business Critical edition.
- B . Support for HIPAA and GDPR compliance is available for UI Snowflake editions.
- C . Periodic rekeying of encrypted data is available with the Snowflake Enterprise edition and higher
- D . Private communication to internal stages is allowed in the Snowflake Enterprise edition and higher.
Which account__usage views are used to evaluate the details of dynamic data masking? (Select TWO)
- A . ROLES
- B . POLICY_REFERENCES
- C . QUERY_HISTORY
- D . RESOURCE_MONIT ORS
- E . ACCESS_HISTORY
Which of the following are benefits of micro-partitioning? (Select TWO)
- A . Micro-partitions cannot overlap in their range of values
- B . Micro-partitions are immutable objects that support the use of Time Travel.
- C . Micro-partitions can reduce the amount of I/O from object storage to virtual warehouses
- D . Rows are automatically stored in sorted order within micro-partitions
- E . Micro-partitions can be defined on a schema-by-schema basis
Using variables in Snowflake is denoted by using which SQL character?
- A . @
- B . &
- C . $
- D . #
The is the minimum Fail-safe retention time period for transient tables?
- A . 1 day
- B . 7 days
- C . 12 hours
- D . 0 days
The is the minimum Fail-safe retention time period for transient tables?
- A . 1 day
- B . 7 days
- C . 12 hours
- D . 0 days