Pass exam with ADA-C02 Top Exam Collection for sure one-shot

What are benefits of using Snowflake organizations? (Choose two.)

• A. Administrators can monitor and understand usage across all accounts in the organization.
• B. User administration is simplified across all accounts within the organization.
• C. Administrators have the ability to create accounts in any available cloud provider or region.
• D. Administrators can change Snowflake account editions on-demand based on need.
• E. Administrators can simplify data movement across all accounts within the organization.

What role or roles should be used to properly create the object required to setup OAuth 2.0 integration?

• A. Any role with GRANT USAGE on SECURITY INTEGRATION
• B. ACCOUNTADMIN and SYSADMIN
• C. ACCOUNTADMIN only
• D. ACCOUNTADMIN and SECURITYADMIN

A Snowflake Administrator needs to set up Time Travel for a presentation area that includes facts and dimensions tables, and receives a lot of meaningless and erroneous IoT data. Time Travel is being used as a component of the company's data quality process in which the ingestion pipeline should revert to a known quality data state if any anomalies are detected in the latest load. Data from the past 30 days may have to be retrieved because of latencies in the data acquisition process.
According to best practices, how should these requirements be met? (Choose two.)

• A. Only TRANSIENT tables should be used to ensure referential integrity between the fact and dimension tables.
• B. The fact and dimension tables should have the same DATA_RETENTION_TIME_IN_DAYS.
• C. The DATA_RETENTION_TIME_IN_DAYS should be kept at the account level and never used for lower level containers (databases and schemas).
• D. Related data should not be placed together in the same schema. Facts and dimension tables should each have their own schemas.
• E. The fact and dimension tables should be cloned together using the same Time Travel options to reduce potential referential integrity issues with the restored data.

The following SQL command was executed:
Use role SECURITYADMIN;
Grant ownership
On future tables
In schema PROD.WORKING
To role PROD_WORKING_OWNER;
Grant role PROD_WORKING_OWNER to role SYSADMIN;
Use role ACCOUNTADMIN;
Create table PROD.WORKING.XYZ (value number);
Which role(s) can alter or drop table XYZ?

• A. Only the PROD_WORKING_OWNER role can alter or drop table XYZ.
• B. SECURITYADMIN, SYSADMIN, and ACCOUNTADMIN can alter or drop table XYZ.
• C. PROD_WORKING_OWNER, ACCOUNTADMIN, and SYSADMIN can alter or drop table XYZ.
• D. Because ACCOUNTADMIN created the table, only the ACCOUNTADMIN role can alter or drop table XYZ.

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