A Snowflake customer is experiencing higher costs than anticipated while migrating their data warehouse workloads from on-premises to Snowflake. The migration workloads have been deployed on a single warehouse and are characterized by a large number of small INSERTs rather than bulk loading of large extracts. That single warehouse has been configured as a single cluster, 2XL because there are many parallel INSERTs that are scheduled during nightly loads.
How can the Administrator reduce the costs, while minimizing the overall load times, for migrating data warehouse history?

• A. There should be another 2XL warehouse deployed to handle a portion of the load queries.
• B. The INSERTS should be converted to several tables to avoid contention on large tables that slows down query processing.
• C. The 2XL warehouse should be changed to 4XL to increase the number of threads available for parallel load queries.
• D. The warehouse should be kept as a SMALL or XSMALL and configured as a multi-cluster warehouse to handle the parallel load queries.

An Administrator has a user who needs to be able to suspend and resume a task based on the current virtual warehouse load, but this user should not be able to modify the task or start a new run.
What privileges should be granted to the user to meet these requirements? (Select TWO).

• A. USAGE on the database and schema containing the task
• B. OWNERSHIP on the task
• C. OWNERSHIP on the database and schema containing the task
• D. EXECUTE TASK on the task
• E. OPERATE on the task

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 continuously writing data from a Snowflake table to external storage
• D. When accessing a Snowflake table that references data files located in cloud storage

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 loT 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? (Select TWO).

• A. 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.
• 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. Only TRANSIENT tables should be used to ensure referential integrity between the fact and dimension tables.
• E. Related data should not be placed together in the same schema. Facts and dimension tables should each have their own schemas.

A Snowflake Administrator needs to retrieve the list of the schemas deleted within the last two days from the DB1 database.
Which of the following will achieve this?

• A. SELECT * FROM SNOWFLAKE.ACCOUNT_USAGE.DATABASES;
• B. SELECT * FROM SNOWFLAKE.ACCOUNT_USAGE.SCHEMATA;
• C. SELECT * FROM DB1.INFORMATION_SCHEMA.SCHEMATA;
• D. SHOW SCHEMAS IN DATABASE DB1;