In which scenario will use of an external table simplify a data pipeline?

• A. When accessing a Snowflake table from an external database within the same region
• B. When accessing a Snowflake table from a relational database
• C. When accessing a Snowflake table that references data files located in cloud storage
• D. When continuously writing data from a Snowflake table to external storage

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. SECURITYADMIN, SYSADMIN, and ACCOUNTADMIN can alter or drop table XYZ.
• B. PROD_WORKING_OWNER, ACCOUNTADMIN, and SYSADMIN can alter or drop table XYZ.
• C. Because ACCOUNTADMIN created the table, only the ACCOUNTADMIN role can alter or drop table XYZ.
• D. Only the PROD_WORKING_OWNER role can alter or drop table XYZ.

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. MONITOR
• B. USAGE
• C. MODIFY
• D. OPERATE
• E. OWNERSHIP

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 DATA_RETENTION_TIME_IN_DAYS should be kept at the account level and never used for lower level containers (databases and schemas).
• C. 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.
• D. The fact and dimension tables should have the same DATA_RETENTION_TIME_IN_DAYS.
• E. Related data should not be placed together in the same schema. Facts and dimension tables should each have their own schemas.