A materialized view in Snowflake is a database object derived from a query specification, stored for later use, and can significantly speed up expensive aggregations on large data sets. Materialized views store the result of their underlying query, reducing the need to recompute the result each time the view is accessed. This makes them ideal for improving the performance of read-heavy, aggregate-intensive queries.
References:
Snowflake Documentation: Using Materialized Views

The correct answers are B. Enable replication and C. Create an account .
The ORGADMIN role is an organization-level role in Snowflake. It is used to manage organization-wide operations, including account management and enabling cross-account or cross-region capabilities such as replication.
Why B is correct:
ORGADMIN can enable replication for the organization. Replication is an organization-level capability because it can involve multiple accounts and regions.
Why C is correct:
ORGADMIN can create Snowflake accounts within the organization.
Why the other options are incorrect:
A). Creating a share is an account-level data sharing task, not a default organization-level ORGADMIN task.
D). Creating a resource monitor is an account-level resource management task, typically handled by account- level administrative roles such as ACCOUNTADMIN.
E). Creating a reader account is an account-level secure data sharing task, not the primary default ORGADMIN responsibility in this answer set.
Official Snowflake documentation reference:
Snowflake documentation describes ORGADMIN as the organization administrator role used to manage organization-level operations, including creating accounts and enabling replication.
Reference: Snowflake Documentation - Organization administrator role; Snowflake Documentation - Creating accounts; Snowflake Documentation - Replication and failover; SnowPro Core Study Guide - Snowflake Account and Resource Management.

Multi-Factor Authentication (MFA) provides increased login security for users connecting to Snowflake.
Snowflake's MFA is powered by Duo Security service, which adds an additional layer of security during the login process.

The useful calculation is based on BYTES_SCANNED and PERCENTAGE_SCANNED_FROM_CACHE.
These metrics help estimate how much scanned data came from the warehouse cache. A low cache percentage on a query that scans many bytes may indicate that warehouse cache optimization could help.
Corrected note: the original options had OCR errors. The best matching valid answer is B .
Reference: Snowflake Documentation - QUERY_HISTORY view; Warehouse cache; Query performance monitoring.
==

first run SHOW FILE FORMATS
then SELECT * FROM TABLE(RESULT_SCAN(LAST_QUERY_ID(-1)))
https://docs.snowflake.com/en/sql-reference/functions/result_scan#usage-notes