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 transient table with a retention time of 0 days.
• B. Create it as an external table, which will not incur Time Travel costs.
• C. Create it as a temporary table with a retention time of 0 days.
• D. Create it as a permanent table with a retention time of 0 days.

If the query matches the definition, will Snowflake always dynamically rewrite the query to use a materialized view?

• A. No, because the optimizer might decide against it.
• B. Yes, because materialized views are always faster.
• C. No, because joins are not supported by materialized views.
• D. No, because the materialized view may not be up-to-date.

A team is provisioning new lower environments from the production database using cloning. All production objects and references reside in the database, and do not have external references.
What set of object references needs to be re-pointed before granting access for usage?

• A. There are no object references that need to be re-pointed
• B. Sequences, storage integrations, views, secure views, and materialized views
• C. Sequences, views, secure views, and materialized views
• D. Sequences, views, and secure views

MY_TABLE is a table that has not been updated or modified for several days. On 01 January 2021 at 07:01, a user executed a query to update this table. The query ID is '8e5d0ca9-005e-44e6-b858-a8f5b37c5726'. It is now 07:30 on the same day.
Which queries will allow the user to view the historical data that was in the table before this query was executed? (Choose three.)

• A. SELECT * FROM my_table PRIOR TO STATEMENT '8e5d0ca9-005e-44e6-b858-a8f5b37c5726';
• B. SELECT * FROM my_table AT(OFFSET => -60*30);
• C. SELECT * FROM my_table AT(TIMESTAMP => '2021-01-01 07:00:00'::timestamp);
• D. SELECT * FROM TIME_TRAVEL('MY_TABLE', 2021-01-01 07:00:00);
• E. SELECT * FROM my_table WITH TIME TRAVEL(OFFSET => -60*30);
• F. SELECT * FROM my_table BEFORE(STATEMENT => '8e5d0ca9-005e-44e6-b858-a8f5b37c5726');

What session parameter can be used to test the integrity of secure views based on the account that is accessing that view?

• A. SIMULATED DATA SHARING CONSUMER
• B. MIMIC CONSUMER ACCOUNT
• C. TEST ACCOUNT ID
• D. PRODUCER TEST ACCT