Snowflake ADA-C02 Value Pack (Frequently Bought Together)

Which actions are considered breaking changes to data that is shared with consumers in the Snowflake Marketplace? (Choose two.)

• A. Renaming a table
• B. Adding region availability to the listing
• C. Unpublishing the data listing
• D. Deleting data from a table
• E. Dropping a column from a table

A virtual warehouse report_wh is configured with AUTO_RESUME=TRUE and AUTO_SUSPEND=300. A user has been granted the role accountant.
An application with the accountant role should use this warehouse to run financial reports, and should keep track of compute credits used by the warehouse.
What minimal privileges on the warehouse should be granted to the role to meet the requirements for the application? (Choose two.)

• A. USAGE
• B. OPERATE
• C. MONITOR
• D. OWNERSHIP
• E. MODIFY

A team of developers created a new schema for a new project. The developers are assigned the role DEV_TEAM which was set up using the following statements:
USE ROLE SECURITYADMIN;
CREATE ROLE DEV_TEAM;
GRANT USAGE, CREATE SCHEMA ON DATABASE DEV_DB01 TO ROLE DEV_TEAM;
GRANT USAGE ON WAREHOUSE DEV_WH TO ROLE DEV_TEAM;
Each team member's access is set up using the following statements:
USE ROLE SECURITYADMIN;
CREATE ROLE JDOE_PROFILE;
CREATE USER JDOE LOGIN_NAME = 'JDOE' DEFAULT ROLE='JDOE_PROFILE';
GRANT ROLE JDOE_PROFILE TO USER JDOE;
GRANT ROLE DEV_TEAM TO ROLE JDOE_PROFILE;
New tables created by any of the developers are not accessible by the team as a whole.
How can an Administrator address this problem?

• A. Set up the new schema as a managed-access schema.
• B. Assign ownership privilege to DEV_TEAM on the newly-created schema.
• C. Set up future grants on the newly-created schemas.
• D. Assign usage privilege on the virtual warehouse DEV_WH to the role JDOE_PROFILE.

An Administrator loads data into a staging table every day. Once loaded, users from several different departments perform transformations on the data and load it into different production tables.
How should the staging table be created and used to MINIMIZE storage costs and MAXIMIZE performance?

• A. Create it as a permanent table with a retention time of 0 days.
• B. Create it as a transient table with a retention time of 0 days.
• C. Create it as an external table, which will not incur Time Travel costs.
• D. Create it as a temporary table with a retention time of 0 days.

When does auto-suspend occur for a multi-cluster virtual warehouse?

• A. When there has been no activity on any cluster for the specified period of time.
• B. After a specified period of time when an additional cluster has started on the maximum number of clusters specified for a warehouse.
• C. When the minimum number of clusters is running and there is no activity for the specified period of time.
• D. Auto-suspend does not apply for multi-cluster warehouses.