Practice Free SnowPro Core Exam Online Questions
Which of the following Snowflake capabilities are available in all Snowflake editions? (Select TWO)
- A . Customer-managed encryption keys through Tri-Secret Secure
- B . Automatic encryption of all data
- C . Up to 90 days of data recovery through Time Travel
- D . Object-level access control
- E . Column-level security to apply data masking policies to tables and views
A developer is granted ownership of a table that has a masking policy. The developer’s role is not able to see the masked data.
Will the developer be able to modify the table to read the masked data?
- A . Yes, because a table owner has full control and can unset masking policies.
- B . Yes, because masking policies only apply to cloned tables.
- C . No, because masking policies must always reference specific access roles.
- D . No, because ownership of a table does not include the ability to change masking policies
When reviewing the load for a warehouse using the load monitoring chart, the chart indicates that a high volume of Queries are always queuing in the warehouse
According to recommended best practice, what should be done to reduce the Queue volume? (Select TWO).
- A . Use multi-clustered warehousing to scale out warehouse capacity.
- B . Scale up the warehouse size to allow Queries to execute faster.
- C . Stop and start the warehouse to clear the queued queries
- D . Migrate some queries to a new warehouse to reduce load
- E . Limit user access to the warehouse so fewer queries are run against it.
Which Snowflake SQL statement would be used to determine which users and roles have access to a role called MY_ROLE?
- A . SHOW GRANTS OF ROLE MY_ROLE
- B . SHOW GRANTS TO ROLE MY_ROLE
- C . SHOW GRANTS FOR ROLE MY_ROLE
- D . SHOW GRANTS ON ROLE MY_ROLE
How should a virtual warehouse be configured if a user wants to ensure that additional multi-clusters are resumed with no delay?
- A . Configure the warehouse to a size larger than generally required
- B . Set the minimum and maximum clusters to autoscale
- C . Use the standard warehouse scaling policy
- D . Use the economy warehouse scaling policy
What is a responsibility of Snowflake’s virtual warehouses?
- A . Infrastructure management
- B . Metadata management
- C . Query execution
- D . Query parsing and optimization
- E . Permanent storage of micro-partitions
What is a best practice after creating a custom role?
- A . Create the custom role using the SYSADMIN role.
- B . Assign the custom role to the SYSADMIN role
- C . Assign the custom role to the PUBLIC role
- D . Add__CUSTOM to all custom role names
Which native data types are used for storing semi-structured data in Snowflake? (Select TWO)
- A . NUMBER
- B . OBJECT
- C . STRING
- D . VARCHAR
- E . VARIANT
Which features could be used to improve the performance of queries that return a small subset of rows from a large table? (Select TWO).
- A . Search optimization service
- B . Automatic clustering
- C . Row access policies
- D . Multi-cluster virtual warehouses
- E . Secure views
What are ways to create and manage data shares in Snowflake? (Select TWO)
- A . Through the Snowflake web interface (Ul)
- B . Through the DATA_SHARE=TRUE parameter
- C . Through SQL commands
- D . Through the enable__share=true parameter
- E . Using the CREATE SHARE AS SELECT * TABLE command