A data provider wants to share data from multiple databases with a data consumer account.
How can this be accomplished?

• A. The data provider needs to create a secure view and grant the REFERENCE_USAGE privilege on each database referenced by the secure view.
• B. The data provider needs to create a secure view and must grant the REFERENCE_USAGE privilege on the database where the secure view is created.
• C. The data provider needs to create a secure view and grant the USAGE privilege on each database referenced by the secure view.
• D. The data provider needs to create a secure view and grant the REFERENCE_USAGE privilege to a database role to include objects from multiple databases in a share

An Administrator is evaluating a complex query using the EXPLAIN command. The Globalstats operation indicates 500 partitionsAssigned.
The Administrator then runs the query to completion and opens the Query Profile. They notice that the partitions scanned value is 429.
Why might the actual partitions scanned be lower than the estimate from the EXPLAIN output?

• A. In-flight data compression will result in fewer micro-partitions being scanned at the virtual warehouse layer than were identified at the storage layer.
• B. The GlobalStats partition assignment includes the micro-partitions that will be assigned for preservation of the query results.
• C. Runtime optimizations such as join pruning can reduce the number of partitions and bytes scanned during query execution.
• D. The EXPLAIN results always include a 10-15% safety factor in order to provide conservative estimates.

In general, the monthly billing for database replication is proportional to which variables? (Select TWO).

• A. The amount of table data in the primary database that changes as a result of data loading or DML operations
• B. The frequency of changes to the primary database as a result of data loading or DML operations
• C. The frequency of the secondary database refreshes from the primary database
• D. The number and size of warehouses defined in the primary account
• E. The number of times data moves across regions and/or cloud service providers between the primary and secondary database accounts

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

Which commands can be performed by a user with the ORGADMIN role but not the ACCOUNTADMIN role? (Select TWO).

• A. GRANT ROLE ORGADMIN TO USER <username>;
• B. SHOW REGIONS;
• C. SELECT SYSTEM$GLOBAL_ACCOUNT_SET_PARAMETER (
• D. SHOW ORGANIZATION ACCOUNTS;
• E. SHOW USERS;