A company has enabled replication between accounts and is ready to replicate data across Regions within the same cloud service provider.
The primary database object is: PROD_AWS_EAST. Location: AWS_EAST.
The secondary database object is: PROD_AWS_WEST. Location: AWS_WEST.
What command and account location are required to refresh the data?
An Administrator must configure a Snowflake virtual warehouse for a new use case with these details:
B. etween 50 and 100 concurrent users will run reports.
C. osts must be minimized according to the number of users active at a particular time.
The virtual warehouse must automatically suspend and resume based on user activity.
Which configuration meets these requirements?
What are the minimum grants needed on the database, schema, and table to correctly create and manage a stream?
An Administrator receives data from a Snowflake partner. The partner shares a dataset containing multiple secure views. The Administrator wants to configure access so that only specific roles can view specific secure views.
How can this be achieved?
Which information must be obtained from the Identity Provider (IdP) to enable federated authentication in Snowflake?
Choose two
A Snowflake customer is incurring higher-than-expected costs while migrating data-warehouse workloads from on premises to Snowflake. The migration workloads run on one warehouse and consist of many small INSERT statements rather than bulk-loading large extracts. That warehouse is configured as a single 2XL cluster because many parallel INSERT statements are scheduled during nightly loads.
How can the Administrator lower costs while minimizing the overall time required to load data-warehouse history?
If a query matches the definition, will Snowflake always dynamically rewrite the query to use a materialized view?
In which scenario does using an external table simplify a data pipeline?
Under what condition does auto-suspend take place for a multi-cluster virtual warehouse?
A Snowflake organization, MYORG, contains two Snowflake accounts:

ACCOUNT1 has a database named PROD_DB and has the ORGADMIN role enabled. Management wants PROD_DB replicated to ACCOUNT2.