> Osmosing

Author name: Abhay Krishnan

With over five years of data engineering experience at EY and Infosys, Abhay Krishnan specializes in building scalable data pipelines and cloud warehousing solutions. He is a certified SnowPro Core professional, alongside credentials in AWS and Azure. Abhay created this 50-day track to solve a problem he faced firsthand: the lack of a structured, free resource for Snowflake certification prep. Follow him on LinkedIn for more data engineering insights.

Day 25: Snowflake Encryption, Replication, Failover & Alerts

Sub-objective 2.2 closes with four features that protect data and keep it available. Encryption guards data at rest and in transit, and it is always on in every edition. Replication and failover copy data across regions for business continuity, with a sharp edition line you must know. Alerts and Notifications watch the account and tell

Day 25: Snowflake Encryption, Replication, Failover & Alerts Read More »

Day 24: Object Tagging, Data Classification & Trust Center in Snowflake

Sub-objective 2.2 lists three governance features that work together but answer different questions. Object tagging labels objects with metadata. Data classification auto-detects which columns hold sensitive data and tags them for you. Trust Center evaluates the whole account against security best practices. Two of these are direct C03 sample-question topics. Classification is sample question one,

Day 24: Object Tagging, Data Classification & Trust Center in Snowflake Read More »

Day 23: Snowflake Data Masking, Row Access & Privacy Policies

Sub-objective 2.2 lists three governance features that the exam treats as separate: dynamic data masking, row access policies, and privacy policies. They control what a querier actually sees in a result set. Masking hides values in a column. Row access policies remove whole rows. Privacy policies force queries to aggregate before they return anything. All

Day 23: Snowflake Data Masking, Row Access & Privacy Policies Read More »

Day 22: Snowflake Network Policies + Logging & Tracing with Event Tables

Today closes sub-objective 2.1 with two paired perimeter topics: network policies (who connects from where) and event-table logging (what code did once inside). One practice-doc question is wired in verbatim (Q17, session policies); the other four target network rules, precedence, IPv6 status, and event-table defaults. 📘 Today’s Concept Micro-Concept 1: Network Policies, the Perimeter Object

Day 22: Snowflake Network Policies + Logging & Tracing with Event Tables Read More »

Day 19: System Roles + Custom Roles + Secondary Roles

Yesterday covered RBAC and DAC at the model level. Today goes deeper into three things: the six system-defined roles, the custom-role pattern (rolls up to SYSADMIN), and the secondary-roles mechanism. Three facts trip up most candidates on the exam. ACCOUNTADMIN is not a superuser. SECURITYADMIN (not SYSADMIN) creates network policies. Database roles cannot be activated

Day 19: System Roles + Custom Roles + Secondary Roles Read More »